From mboxrd@z Thu Jan 1 00:00:00 1970 Return-Path: X-Spam-Checker-Version: SpamAssassin 3.2.5 (2008-06-10) on sa.int.altlinux.org X-Spam-Level: X-Spam-Status: No, score=-1.9 required=5.0 tests=AWL,BAYES_00 autolearn=ham version=3.2.5 From: Sergey V Turchin To: sisyphus@lists.altlinux.org Date: Fri, 12 Oct 2012 15:14:47 +0400 Message-ID: <2002380.TqKDOfqK4Z@summoner.localdomain> User-Agent: KMail/4.9.2 (Linux/3.5.6-std-def-alt1; KDE/4.9.1; i686; ; ) In-Reply-To: <20121012111211.GE23097@osdn.org.ua> References: <20121011181239.GJ28064@osdn.org.ua> <31410381.N4mvKRo4MY@summoner.localdomain> <20121012111211.GE23097@osdn.org.ua> MIME-Version: 1.0 Content-Type: multipart/signed; boundary="nextPart1753845.UPCz5hRXXK"; micalg="pgp-sha1"; protocol="application/pgp-signature" Subject: Re: [sisyphus] =?utf-8?b?STog0YLQtdGB0YLQvtCy0LDRjyDRgdCx0L7RgNC60LAg?= =?utf-8?q?MySQL-5=2E5?= X-BeenThere: sisyphus@lists.altlinux.org X-Mailman-Version: 2.1.12 Precedence: list Reply-To: ALT Linux Sisyphus discussions List-Id: ALT Linux Sisyphus discussions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Fri, 12 Oct 2012 11:16:32 -0000 Archived-At: List-Archive: List-Post: --nextPart1753845.UPCz5hRXXK Content-Type: multipart/mixed; boundary="nextPart13514507.C4C9o1WbDi" Content-Transfer-Encoding: 7Bit This is a multi-part message in MIME format. --nextPart13514507.C4C9o1WbDi Content-Transfer-Encoding: base64 Content-Type: text/plain; charset="utf-8" T24gMTIg0L7QutGC0Y/QsdGA0Y8gMjAxMiAxNDoxMjoxMSBNaWNoYWVsIFNoaWdvcmluIHdyb3Rl Ogo+IE9uIEZyaSwgT2N0IDEyLCAyMDEyIGF0IDAzOjA2OjM1UE0gKzA0MDAsIFNlcmdleSBWIFR1 cmNoaW4gd3JvdGU6Cj4gPiA+INCt0YLQviDQv9GA0LXQtNGD0L/RgNC10LbQtNC10L3QuNC1INCx 0YvQu9C+INC6INC/0L7Qu9GM0LfQvtCy0LDRgtC10LvRj9C8IElubm9EQgo+ID4gPiDQv9C+INC/ 0L7QstC+0LTRgyDQstGL0L3QvtGB0LAt0LLQvdC+0YHQsC3QstGL0L3QvtGB0LAg0LXRkSDQsiDQ v9C70LDQs9C40L0uCj4gPiAKPiA+INCn0YLQviDQv9C+INGN0YLQvtC80YMg0L/QvtCy0L7QtNGD INC80L7QttC10YIg0L/QvtC90LDQtNC+0LHQuNGC0YzRgdGPINC/0YDQsNCy0LjRgtGMCj4gPiDQ siB+Ly5sb2NhbC9zaGFyZS9ha29uYWRpL215c3FsLmNvbmYgPwo+IAo+INCf0YDQvtCy0LXRgNGM LCDQv9C+0LbQsNC70YPQudGB0YLQsArQp9GC0L4g0LjQvNC10L3QvdC+PyDQndC1INGB0LvQvtC8 0LDQtdGC0YHRjyDQu9C4INGDINC80LXQvdGPINC/0L7Rh9GC0L7QstCw0Y8g0L/RgNC+0LPRgNCw 0LzQvNCwPwoKPiAo0Lgg0L/QvtC60LDQttC4INGB0L7RgdGC0LDQsiDQutCw0YLQsNC70L7Qs9Cw LCDQs9C00LUg0Y3RgtC+0YIg0Y3QutC30LXQvNC/0LvRj9GAINGF0YDQsNC90LjRgiDRgdCy0L7Q uCDQsdCw0LfRiyDQtNCw0L3QvdGL0YUpLgrQnNC+0LbQtdGCIG15c3FsLmNvbmYg0LvRg9GH0YjQ tSDQv9C+0LrQsNC30LDRgtGMPyDQodC8LiDQsNGC0YLQsNGHLgoKLS0gClJlZ2FyZHMsIFNlcmdl eS4gICAgICAgQUxUIExpbnV4LCBodHRwOi8vd3d3LmFsdGxpbnV4LnJ1Lw== --nextPart13514507.C4C9o1WbDi Content-Disposition: attachment; filename="mysql.conf" Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset="UTF-8"; name="mysql.conf" # # Global Akonadi MySQL server settings, # These settings can be adjusted using $HOME/.config/akonadi/mysql-loca= l.conf # # Based on advice by Kris K=C3=B6hntopp # [mysqld] # strict query parsing/interpretation # TODO: make Akonadi work with those settings enabled # sql_mode=3Dstrict_trans_tables,strict_all_tables,strict_error_for_div= ision_by_zero,no_auto_create_user,no_auto_value_on_zero,no_engine_subst= itution,no_zero_date,no_zero_in_date,only_full_group_by,pipes_as_concat= # sql_mode=3Dstrict_trans_tables # DEBUGGING: # log all queries, useful for debugging but generates an enormous amoun= t of data # log=3Dmysql.full # log queries slower than n seconds, log file name relative to datadir = (for debugging only) # log_slow_queries=3Dmysql.slow # long_query_time=3D1 # log queries not using indices, debug only, disable for production use= # log_queries_not_using_indexes=3D1 # # mesure database size and adjust innodb_buffer_pool_size # SELECT sum(data_length) as bla, sum(index_length) as blub FROM inform= ation_schema.tables WHERE table_schema not in ("mysql", "information_sc= hema"); # NOTES: # Keep Innob_log_waits and keep Innodb_buffer_pool_wait_free small (see= show global status like "inno%", show global variables) #expire_logs_days=3D3 #sync_bin_log=3D0 # Use UTF-8 encoding for tables character_set_server=3Dutf8 collation_server=3Dutf8_general_ci # use InnoDB for transactions and better crash recovery default_storage_engine=3Dinnodb # memory pool InnoDB uses to store data dictionary information and othe= r internal data structures (default:1M) innodb_additional_mem_pool_size=3D1M # memory buffer InnoDB uses to cache data and indexes of its tables (de= fault:128M) # Larger values means less I/O innodb_buffer_pool_size=3D80M # Create a .ibd file for each table (default:0) innodb_file_per_table=3D1 # Write out the log buffer to the log file at each commit (default:1) innodb_flush_log_at_trx_commit=3D2 # Buffer size used to write to the log files on disk (default:1M for bu= iltin, 8M for plugin) # larger values means less I/O innodb_log_buffer_size=3D1M # Size of each log file in a log group (default:5M) larger means less I= /O but more time for recovery. innodb_log_file_size=3D8M # # error log file name, relative to datadir (default:hostname.err) log_error=3Dmysql.err # print warnings and connection errors (default:1) log_warnings=3D2 # Convert table named to lowercase lower_case_table_names=3D1 # Maximum size of one packet or any generated/intermediate string. (def= ault:1M) max_allowed_packet=3D32M # Maximum simultaneous connections allowed (default:100) max_connections=3D256 # The two options below make no sense with prepared statements and/or t= ransactions # (make sense when having the same query multiple times) # Memory allocated for caching query results (default:0 (disabled)) query_cache_size=3D0 # Do not cache results (default:1) query_cache_type=3D0 # Do not use the privileges mechanisms skip_grant_tables # Do not listen for TCP/IP connections at all skip_networking # The number of open tables for all threads. (default:64) table_cache=3D200 # How many threads the server should cache for reuse (default:0) thread_cache_size=3D3 # wait 365d before dropping the DB connection (default:8h) wait_timeout=3D31536000 [client] default-character-set=3Dutf8 --nextPart13514507.C4C9o1WbDi-- --nextPart1753845.UPCz5hRXXK Content-Type: application/pgp-signature; name="signature.asc" Content-Description: This is a digitally signed message part. -----BEGIN PGP SIGNATURE----- Version: GnuPG v2.0.18 (GNU/Linux) iEYEABECAAYFAlB3+6cACgkQ+zBIrxwqPwhLfACgoQv8H1ex4iSEskx5cjQGDCcQ xAMAniCTbD8penKPAgPO8+ZqCoQI4YLS =5c9r -----END PGP SIGNATURE----- --nextPart1753845.UPCz5hRXXK--