… the following error message: SQLSTATE[HY000] [1135] Can’t create a new thread (errno 11); if you are not out of available memory… accepting 1200 simultaneous connections without running into a “can’t create thread” error at 1024. (root@revolution 23:53:20)# cat /proc… hits 1024 simultaneous connections, we’ll start hitting “can’t create thread.” If this restart came about as part of a MySQL…
Post: MySQL Connection Timeouts
April 19, 2011 By 4 Comments
… it it needs to create a new socket for incoming connection and create a new thread or take one out of the thread cache. From this point on MySQL processes network communication in multiple threads and… on mutex or doing any other work such as launching new thread takes a lot of time you can have the listen…
Post: DROP TABLE and stalls: Lazy Drop Table in Percona Server and the new fixes in MySQL
June 22, 2012 By 33 Comments
…give up remainder of the thread‘s time slice (this is going to let other threads do things on … of all before running the benchmark, 30 tables were created and populated with 1000 rows, the tables all … the QPS over 5 second periods with the new DROP TABLE implementation (MysQL version >= 5.5.23) …
Comment: MySQL Server Memory Usage
September 1, 2006 By 21 Comments
…status’, ’105′ ‘Com_show_ndb_status’, ’0′ ‘Com_show_new_master’, ’0′ ‘Com_show_open_tables’, ’0′ ‘Com_show…Table_locks_immediate’, ’895966639′ ‘Table_locks_waited’, ’20096′ ‘Threads_cached’, ’0′ ‘Threads_connected’, ’260′ ‘Threads_created‘, ’124272′ ‘Threads_running’, ’3′ ‘Uptime’, ’4433556′ # top 18…
Post: Recovering from a bad UPDATE statement
October 19, 2012 By 5 Comments
…:10:42 server id 1 end_log_pos 532 Query thread_id=1 exec_time=0 error_code=0 SET TIMESTAMP… the new version of @1, old version of @2 to the new version of @2, etc. Reverse the entries row entries and create new UPDATE statements that filter on the new version and…
Comment: How to calculate a good InnoDB log file size
June 1, 2010 By 38 Comments
…_files_in_group = 2 innodb_log_buffer_size = 8M innodb_thread_concurrency = 8 innodb_flush_log_at_trx_commit = 1 innodb… not found: creating new InnoDB: Doublewrite buffer created InnoDB: Creating foreign key constraint system tables InnoDB: Foreign key constraint system tables created 100601 9:08…
Post: The new cool MySQL patch has landed! Check your queries performance!
October 31, 2007 By 16 Comments
… single connection. # Thread_id: 4 MICROTIME RESOLUTION QUERY TIMING This is the original functionality offered by Microslow patch. The new edition is… by the slave’s SQL thread. This patch allows you to change that behavior with the new parameter –log-slow-slave-statements… Tmp_table will be set. Sometimes that table must be created on disk instead of in memory, in such case Disk…
Post: How to create/restore a slave using GTID replication in MySQL 5.6
February 8, 2013 By 7 Comments
… will see how to create/restore new slaves from a master using GTID. How to set up a new slave The first thing…-7059-11e2-9a24-08002762b8af:1-14″; slave1> start slave io_thread; slave1> show slave status\G [...] Slave_IO_Running: Yes Slave_SQL… our new friends. Xtrabackup still doesn’t support it but we are working on it. I will update this post and create…
Comment: Replaying database load with Percona Playback
October 29, 2012 By 9 Comments
… automatically. Whenever it sees a new thread id in the slow log, it opens a new mysql client thread, and uses that to replay the statements executed for a given thread id. So, if you have 5 distinct thread… it sees the quit command for a thread, playback tears down the corresponding thread it created. By default it tries to replay the…
Post: Moving Subtrees in Closure Table Hierarchies
February 14, 2011 By 18 Comments
… developers find they need to store hierarchical data, such as threaded comments, personnel org charts, or nested bill-of-materials. Sometimes… adding a single new node. When you insert a subtree, you’re inserting multiple nodes, and you want to create new paths for each one, as many new paths as the number of ancestors of the new location times the…
