…timeout which set innodb_lock_wait_timeout because that now conflicts, or is at least confused with, lock_wait_timeout… a problem finding queries to run and compare. pt-query-digest is simpler pt-query-digest 2….specify –iterations or –run-time to limit how long they run. There are more changes in …
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
… log_tcblogpercona.commanual log_tc_sizeblogpercona.commanual log_warningsblogpercona.commanual long_query_timeblogpercona.commanual low_priority_updatesblogpercona.commanual lower_case_file_systemblogpercona….commanual query_cache_limitblogpercona.commanual query_cache_min_res_unitblogpercona.commanual query_cache_sizeblogpercona.commanual query_cache_typeblogpercona.commanual query_cache_wlock_invalidateblogpercona.commanual query_prealloc…
Post: MySQL net_write_timeout vs wait_timeout and protocol notes
July 8, 2007 By 1 Comment
… being established connect_timeout is used. When server waits for another query to be sent to it wait_timeout (or interactive_timeout for applications… long delays between queries. If query is being read or result set is being sent back, much shorter net_read_timeout and net_write_timeout…
Post: How to debug long-running transactions in MySQL
March 8, 2011 By 6 Comments
… very long time without committing, and has modified data, then other transactions could block and fail with a lock wait timeout. The… figure out what the long-running transaction is doing. The most obvious is if it’s a long-running query. If that’s the case, then you’ll see the query in the processlist, and…
Post: Worse than DDOS
August 18, 2008 By 5 Comments
… sure default_socket_timeout has proper value or set it per session. Set Curl Timeouts Set both TIMEOUT and CONNECT_TIMEOUT as these apply to different connection stages and just setting timeout is not enough… in curl module (or mysql – waiting on long query to come back) – this is our query if it is waiting on the session…
Comment: Database problems in MySQL/PHP Applications
November 6, 2006 By 13 Comments
…_length=2048 long-query-time=5 log-slow-queries=/apps/log/slow-query interactive_timeout=300 wait_timeout=300 thread_cache = 40 max_connections=500 query_cache… #innodb_flush_log_at_trx_commit = 1 #innodb_lock_wait_timeout = 50 [mysqldump] quick max_allowed_packet = 16M [mysql] no-auto…
Comment: New Forum Categories: Help Wanted, For Hire
March 5, 2013 By 1 Comment
…_cache = 1024 thread_cache_size = 8 query_cache_size = 128M join_buffer_size = 8M long_query_time=300 key_buffer_size = 500M concurrent…_concurrency=16 innodb_buffer_pool_size = 4500M innodb_lock_wait_timeout=60 innodb_log_buffer_size = 32M innodb_log_file_size…_cache = 1024 thread_cache_size = 8 query_cache_size = 128M join_buffer_size = 8M long_query_time=300 key_buffer_size = 500M concurrent…
Post: Wishes for new "Pure PHP" MySQL driver
October 28, 2006 By 17 Comments
… would like to see how many connections and queries page generated and how long they took – I will place this information in… me. Arrays in Prepared Statements Dealing with certain types of queries, ie queries with IN is so painful with prepared statements – I… for many applications. Query Timeouts Make it easy to specify timeouts for connects and query execution so page would not timeout but you would rather…
Comment: MySQL Server Memory Usage
December 20, 2012 By 21 Comments
… = 65536 query_alloc_block_size = 131072 default-storage-engine = InnoDB #thread_concurrency = 32 innodb_buffer_pool_size = 4096M innodb_lock_wait_timeout = 120 innodb_use_sys_malloc = 0 long_query_time = 8 #log-slow-queries = /var/log/mysql-slow-query.log # Default to…
Comment: Why MySQL could be slow with large tables ?
June 20, 2007 By 141 Comments
… SCSI RAID: [mysqld] long_query_time=5 skip-bdb skip-innodb skip-locking query_cache_limit=1M query_cache_size=32M query_cache_type=1 max_connections=1500 interactive_timeout=25 wait_timeout=10 connect_timeout=5…
