… MySQL uses a lot of different timeout variables at different stages. For example when connection is just being established connect_timeout is used. When server waits for another query to be sent to it wait_timeout (or interactive_timeout for applications which specified they are interactive…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…MySQL manual, especially the option … insert_idblogpercona.commanual interactive_timeoutblogpercona.commanual join_…wait_no_slaveblogpercona.commanual Rpl_semi_sync_master_wait_pos_backtraverseblogpercona.commanual Rpl_semi_sync_master_wait….commanual ssl_verify_server_certblogpercona.commanual Ssl_…
Comment: Database problems in MySQL/PHP Applications
November 6, 2006 By 13 Comments
…socket = /tmp/mysql.sock #tmpdir =/mysql_tmp/ # Here follows entries for some specific programs # The MySQL server [mysqld] port = 3306 socket = /tmp/mysql.sock …query-time=5 log-slow-queries=/apps/log/slow-query interactive_timeout=300 wait_timeout=300 thread_cache = 40 max_connections=500 query_…
Comment: Too many connections? No problem!
March 24, 2010 By 28 Comments
… names in mysql server so you have to check the source to figure out what’s what. To change global wait_timeout and interactive_timeout one would set global_system_variables.net_wait_timeout and global_system_variables.net_interactive_timeout however each thread has…
Comment: What to tune in MySQL Server after installation
December 7, 2006 By 118 Comments
… GB ram All servers are on same gig network. All my tables are MyIsam. Following is out of mytop MySQL on localhost… max_user_connections = 300 max_connect_errors = 99 wait_timeout=10 interactive_timeout = 10 #set-variable=wait_timeout=3000 # Try number of CPU’s*2 for…
Comment: MySQL Server Memory Usage
September 1, 2006 By 21 Comments
… 70 10 mysql conf: [mysqld] server-id=5908 port=3309 socket=/tmp/mysql.sock pid-file=/var/run/mysql/mysql.pid datadir=/db/disk2/mysql/data…-queries=/var/log/mysql/slow-queries.log max_connections=650 open_files_limit=6144 max_connect_errors=10000 interactive_timeout=3600 wait_timeout=3600 key…
Comment: Why MySQL could be slow with large tables ?
June 20, 2007 By 141 Comments
…_size=32M query_cache_type=1 max_connections=1500 interactive_timeout=25 wait_timeout=10 connect_timeout=5 thread_cache_size=60 key_buffer=750M… character-set-server=utf8 default-collation=utf8_unicode_ci set-variable=max_connections=1500 log_slow_queries=/var/log/mysql-slow.log…
Comment: Too many connections? No problem!
March 15, 2012 By 28 Comments
…develop in PHP with MYSQL, these are MYSQL values: datadir=/data/mysql socket=/data/mysql/mysql.sock max_connections = 600 wait_timeout = 60 interactive_timeout=1800 skip-name-…=12M server-id = 1 log-bin=/data/mysql/drbd expire_logs_days = 5 max_binlog_size = 100M [client] socket=/data/mysql/mysql….
Comment: Choosing innodb_buffer_pool_size
March 30, 2010 By 39 Comments
… i am having. I’ve just inherited a WebRT Ticketing MySQL DB which is 123GB is size, there is a lot… (> 100) wait_timeout (< 28800) interactive_timeout ( 64M) tmp_table_size (> 128M) max_heap_table_size (> 128M) innodb_buffer_pool_size (>= 123G) The server itself has…
