… = /var/lib/mysql tmpdir = /tmp skip-locking key_buffer = 384M max_allowed_packet = 1M table_cache = 512 sort_buffer_size = 2M read_buffer…_at_trx_commit = 1 #innodb_thread_concurrency = 8 [mysqldump] quick max_allowed_packet = 16M [mysql] no-auto-rehash [isamchk] key_buffer = 256M sort…
Post: New SpecJAppServer results at MySQL and Sun.
November 12, 2008 By Leave a Comment
… ? Now lets look at Java Settings: JDBC Pool (for EJBs): max-pool-size=100 steady-pool-size=50 cachePrepStmts=true prepStmtCacheSize…] sql-mode = IGNORE_SPACE transaction-isolation = READ-COMMITTED max_allowed_packet = 1M max_connections=300 max_connect_errors=100 table_cache = 6000 read_rnd_buffer…
Post: MySQL 5.6.7-RC in tpcc-mysql benchmark
October 8, 2012 By 22 Comments
… = 50 max_connections = 2000 max_prepared_stmt_count=500000 max_connect_errors = 10 table_open_cache = 2048 max_allowed_packet = 16M binlog_cache_size = 16M max_heap…_insert_buffer_size = 8M myisam_sort_buffer_size = 8M myisam_max_sort_file_size = 10G myisam_repair_threads = 1 myisam_recover…
Comment: What to tune in MySQL Server after installation
October 8, 2012 By 118 Comments
…-bdb default-time-zone=America/Caracas max_connections = 1000 wait_timeout = 60 thread_concurrency = 2 max_allowed_packet = 1M [Slow Querys] #log-slow-queries… = 1 log-bin=/data/mysql/drbd expire_logs_days = 5 max_binlog_size = 100M [client] socket=/data/mysql/mysql.sock [Server... = 1 log-bin=/data/mysql/drbd expire_logs_days = 5 max_binlog_size = 100M [client] socket=/data/mysql/mysql.sock The…
Post: Aligning IO on a hard disk RAID – the Benchmarks
June 9, 2011 By 13 Comments
… back_log = 50 max_connections = 2500 max_connect_errors = 10 table_cache = 2048 max_allowed_packet = 16M binlog_cache_size = 16M max_heap_table_size = 64M…_insert_buffer_size = 8M myisam_sort_buffer_size = 8M myisam_max_sort_file_size = 10G myisam_repair_threads = 1 myisam_recover…
Comment: table_cache negative scalability
April 14, 2010 By 23 Comments
… MyISAM tables to InnoDB fix or help the os ulimit max open tables issue? Thanks for your help! Server info: Server… = 100 max_connections = 400 table_cache = 20000 open_files_limit = 40000 max_binlog_size = 500M max_allowed_packet = 20M tmp_table_size = 100M max_heap_table…
Comment: table_cache negative scalability
April 14, 2010 By 23 Comments
… MyISAM tables to InnoDB fix or help the os ulimit max open tables issue? Thanks for your help! Server info: Server… = 100 max_connections = 400 table_cache = 20000 open_files_limit = 40000 max_binlog_size = 500M max_allowed_packet = 20M tmp_table_size = 100M max_heap_table…
Comment: Why MySQL could be slow with large tables ?
June 20, 2007 By 141 Comments
…_limit=1M query_cache_size=32M query_cache_type=1 max_connections=1500 interactive_timeout=25 wait_timeout=10 connect_timeout… key_buffer=750M join_buffer=10M max_heap_table_size=50M tmp_table_size=64M max_allowed_packet=16M table_cache=1800 record_buffer=10M sort_buffer_size=24M read_buffer_size=9M max_connect_errors…
Comment: MySQL Connection Timeouts
January 24, 2013 By 4 Comments
…=”STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION” max_connections=10000 query_cache_size=128M table_cache=256 tmp…_time = 2 wait_timeout = 1000 max_allowed_packet = 16M back_log = 200 myisam_max_sort_file_size=100G myisam_max_extra_sort_file_size=100G…
Comment: MySQL Server Memory Usage
December 20, 2012 By 21 Comments
…=0 slave-skip-errors = 1062 back_log = 75 # skip-innodb max_connections = 600 #thread_stack= 150M key_buffer = 256M key_buffer… connect_timeout = 60 tmp_table_size = 192M max_heap_table_size = 192M max_allowed_packet = 64M #max_connect_errors = 10000 read_rnd_buffer_size = 8M…
