… going down. Then we did some R&D on Percona MYSQL server and found that Percona need some configuration setting regarding… – 2.2.15 (CentOS) PHP Version – 5.3.3 MySQL – 5.1.66 [Percona XtraDB Cluster (GPL) (5.5.30)] (InnoDB Engine) PHP My Admin – 5.3.3 Hardware: Node:2 CPU = Quard Core RAM = 12 GB HDD = 1 TB IP…
Comment: Investigating MySQL Replication Latency in Percona XtraDB Cluster
May 17, 2013 By 13 Comments
Post: Implications of Metadata Locking Changes in MySQL 5.5
February 1, 2013 By 9 Comments
…a bug: http://bugs.mysql.com/bug.php?id=67647 Metadata locking…+—————+——-+ | Variable_name | Value | +—————+——-+ | Open_tables | 30 | | Opened_tables | 1 | +—————+——-+ 2 rows in set (0…. key) ENGINE=InnoDB; When using MySQL 5.1 the second CREATE would just…
Post: Apache PHP MySQL and Runaway Scripts
May 20, 2008 By 20 Comments
…PHP 5.2.5 and Apache 2.0.59. Results were a bit surprising: Running “TightLoop” script terminated after 30… limitation in practice when you’re using MySQL with PHP as you can have single runaway …spending this time on MySQL time) one is doing single query another 1000 queries 1 second length each…
Post: Heikki Tuuri answers to Innodb questions, Part II
November 4, 2007 By 13 Comments
… that 5.1.X will be better, but still not sure. HT: 5.0.xx, where xx >= 30 should be better than 4.1.xx. PZ: I should note MySQL 5.0 vs 4.1 has a… it was only recently found and fixed: http://bugs.mysql.com/bug.php?id=29560 Concerning a switch to Oracle’s main…
Post: MySQL File System Fragmentation Benchmarks
March 21, 2008 By 28 Comments
…1 10 100 1000 10000; do ./benchmark.php $i 10000000; mysql -e’drop database test1′; mysql -e’create database test1′; done; tables: 1…in background and flushing 1000 pages each 30 seconds is not big overhead for this …1. In the process list I could see some single value insert statements taking over 5 …
Comment: Yasufumi Kinoshita joins Percona
November 3, 2008 By 8 Comments
…and has tracked down a serious bug in InnoDB-5.0.30 rw-lock implementation. To Kevin Burton I …reports on InnoDB and InnoDB Plugin: http://bugs.mysql.com/search.php?search_for=&bug_type%5B%5D=Server%3A… are today working towards the release of InnoDB Plugin 1.0.2. The InnoDB Plugin contains major new …
Comment: Announcing Percona XtraDB Cluster 5.5.29-23.7.1
February 3, 2013 By 8 Comments
…–r– 1 root root 9496400 Jan 30 18:44 Percona-XtraDB-Cluster-client-5.5.29-23.7.1….5.5.29-23.7.1.387.rhel5.x86_64 mysql-server conflicts with Percona-XtraDB-Cluster-server-5.5.29-23.7.1.387.rhel5.x86_64 Complete! (1, [u’Please report this error in http://bugs.centos.org/set_project.php…
Post: Content delivery system design mistakes
February 11, 2007 By 9 Comments
…I helped dealing with performance problems (part MySQL related and part related to LAMP in general) of…. It especially hurts not to have one if 30 thumbnails are loaded per page if you do … PHP script which means many megabytes for large files. Partial file sending happily was added in lighttpd 1.5 …
Comment: Using MyISAM in production
June 20, 2006 By 36 Comments
… RAID 5 S/W: RedHat linux 2.4 Application: Java jetty server with Hibernate MySQL version = 4.1.19 … freeze times, even simple ‘SELECT 1‘ from our DB monitoring takes 30-40 seconds we captured some system …forum and here is the link http://forums.mysql.com/read.php?21,85701,96186#msg-96186 Thanks in …
Post: Goal driven performance optimization
December 22, 2008 By Leave a Comment
…if it takes you 30 seconds to generate …now HTML takes 0.5 seconds to generates …type=’search’ and wtime>1; +———-+—————–+——————+——————+——————+——————+ | count(*) | avg(wtime) | cpu_ratio | mysql_… of time optimizing PHP code but because it…
