…-wait-timeout which set innodb_lock_wait_timeout because that now conflicts, or is at least confused with, lock_wait_timeout (introduced in MySQL… pt-query-digest –output json format in future releases after receiving real-world feedback. In summary, Percona Toolkit 2.2 for MySQL is…
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… happening inside MySQL client library so you never know when real network read will happen. As net_write_timeout and net_read_timeout are…
Post: How to Monitor MySQL with Percona's Nagios Plugins
February 22, 2012 By 11 Comments
…: Alert only on things that reliably indicate a real problem. Do not alert on a threshold that… and timeouts, applications often don’t handle or log this error appropriately. The pmp-check-mysql-status plugin… increase in a variable such as Queries and alert on a queries-per-second threshold. (I don’t…
Post: Percona XtraDB Cluster: Multi-node writing and Unexpected deadlocks
August 17, 2012 By 17 Comments
…(this is where deadlocks and lock wait timeouts can happen). By the time the …mysql> insert into autoinc (j) values (‘node2′ ); Query OK, 1 row affected (0.00 sec) node2 mysql> insert into autoinc (j) values (‘node2′ ); Query…hands-on? I will walk you through real examples on this and a lot …
Post: Top 5 Wishes for MySQL
June 29, 2007 By 10 Comments
… MySQL to do so. What is really bad is Parallel query. Reporting with group by over 10.000.000 of rows in real… Queries on MySQL because subqueries optimizer weakness. I’m saying about XA which were released in MySQL 5.0 without consistent work with MySQL… include support for query timeouts, parallel query execution, CONNECT BY support and various performance related features. I’m not sure if MySQL got back…
Post: Apache PHP MySQL and Runaway Scripts
May 20, 2008 By 20 Comments
… Apache Slot, MySQL Connection and other resources. I had discussion today who was thinking Apache would kill the script after “Timeout” specified… run checking “/Server-Status” checking if script dies after specified timeout. As the next step I pressed “STOP” button in the… with sleep() function is wrong and if I would use real MySQL queries this would be counted to max_execution_time and so…
Post: PHP Large result sets and summary tables.
July 6, 2007 By 8 Comments
… of swap space) like crazy. Why ? Because by default mysql_query uses mysql_store_result C library call and buffers all result set… checking If you use buffered query the only real call you can get errors is when you run mysql_query , mysql_fetch_row simply reads… to catch errors. Connection can timeout If you do not fetch data for long enough MySQL Server may think client is dead…
Post: The Math of Automated Failover
September 18, 2012 By 9 Comments
…various timeouts to know the difference between just transient errors or performance problem and real problem… are self imposed. Developer added bad query to the application and the box is…availability solutions for MySQL such as Clustrix, Tungsten Replicator, PRM, Percona XtraDB Cluster, MySQL and …
Post: Percona XtraDB Cluster Feature 2: Multi-Master replication
January 19, 2012 By 22 Comments
…, as it regularly happens with regular MySQL replication if you imprudently write to … replication named “virtually synchronous replication”, not real “synchronous replication” The described behavior of…usually DEADLOCK and LOCK TIMEOUT errors happen in response on particular query, but not on COMMIT….
Post: InnoDB vs MyISAM vs Falcon benchmarks - part 1
January 8, 2007 By 117 Comments
… In real life workload results are likely to be very different. The schema and queries …MySQL 5.1.14-beta sources for MyISAM / InnoDB and MySQL 5.1.14-falcon bitkeeper tree bk://mysql.bkbits.net/mysql…=1500 –table-cache=512 –net_read_timeout=30 –net_write_timeout=30 –backlog=128 MyISAM / InnoDB:…
