… running the query, and if the query fails, then you know from the error code …to use a patched binary, we can use MySQL Proxy, packet sniffing, or other techniques to get more information than the slow log… plan. This is where you need to really know how to write queries and how EXPLAIN works. At…
Post: Announcing Percona Server for MySQL version 5.5.29-30.0
February 26, 2013 By Leave a Comment
Percona is glad to announce the release of Percona Server for MySQL version 5.5.29-30.0 on February 26th, 2013… slow_query_log_timestamp_precision variable was set to microseconds. Bug fixed #887928 (Laurynas Biveinis). Writing bitmap larger than 4GB would cause write to fail. Also a write…
Post: SHOW INNODB STATUS walk through
July 17, 2006 By 40 Comments
…log entries 1 MySQL thread id 9697561, query id 188161264 localhost root update insert into child values(2,2) Foreign key constraint fails…
Post: Announcing Percona Server for MySQL version 5.1.67-14.4
March 8, 2013 By Leave a Comment
…MySQL version 5.1.67-14.4[/caption] Percona is glad to announce the release of Percona Server for MySQL…to innodb_max_changed_pages. Bug fixed #1105726 (Laurynas Biveinis). Writing bitmap larger than 4GB would cause write to fail. Also a write…
Post: Automation: A case for synchronous replication
September 19, 2012 By 2 Comments
…to MySQL Replication based solution. With MySQL Replication you have to have one Master node which handles traffic. You may be able to…to stop writes to the master at once, switch to the Slave properly (ensuring it is cought up completely) to…
Comment: Database problems in MySQL/PHP Applications
November 6, 2006 By 13 Comments
…log-slow-queries=/apps/log/slow…fails to # connect), the slave will create a master.info file, and any later # change in this file to…log-bin # Point the following paths to different dedicated disks #tmpdir = /tmp/ #log-update = /path-to-dedicated-directory/hostname tmpdir =/mysql… = 2M write_buffer = …
Post: MySQL Crash Recovery
July 30, 2006 By 30 Comments
… system extremely slow and also…to use innodb-safe-binlog option in MySQL 4.1 so your Innodb log and binary log are synchronized. In MySQL…MySQL to fail with wierd error messages. In MySQL…to MySQL Crash Recovery – Restoring data from backup, corrupted Innodb tablespace recovery etc but I should write…
Post: What to tune in MySQL Server after installation
September 29, 2006 By 118 Comments
…MySQL Server straight after installation, assuming it was installed with default settings. I’m surprised how many people fail to… misc needs. innodb_log_file_size Very important for write intensive workloads especially for … may slow things down as its maintenance may get expensive. Values from 32M to…
Comment: A (prototype) lower impact slow query log
September 28, 2012 By 12 Comments
…_log_file_open() of extended_slow_query_log_notify() at line 64, inside write_to_log() nr_thds_using_fd guard. There’s another race if write_to_log… fail with EXDEV, and no file rotation would be taking place at all). However, the log folder needs to be only writable by mysql to…
Post: Percona Server 5.1.47-rel11.0
June 21, 2010 By 13 Comments
… to place the double-write…slow_query_log option to use microsecond precision for the slow query log‘s timestamps (issue #358412). Added the –use_global_log_slow_control option to control slow-query logging…fails to compile with CFLAGS=-DUNIV_DEBUG #569156 CentOS 5: mysql-server conflicts with MySQL…
