… with queries from TPC-H benchmarks, particularly comparing MySQL 6.0.4-alpha with 5.1. MySQL 6.0 is interesting here, as there…find is Baron’s bug with no mention in MySQL 6.0 manual. No mentions about Using MRR also, but I guess…37 0.61 130224.59 4.92 65112.30 2.46 240.73 0.30 0.56 0.55 29.49 Device…
Post: SHOW INNODB STATUS walk through
July 17, 2006 By 40 Comments
… processing and all kinds of other things. In MySQL 5 number of Innodb performance counters were exported and … for at least 20-30 seconds. If averages are calculated for last 0 or 1 second they are … better to use global counters and get averages manually. They are still however quite helpful if you’…
Post: Why MySQL could be slow with large tables ?
June 9, 2006 By 139 Comments
…mysql> select count(pad) from large where val between 1 and 100; +————+ | count(pad) | +————+ | 314008 | +————+ 1…table was scanned in less than 5 minutes. Now if we … We’ll need to perform 30 millions of random row reads… it is good idea to manually split query into several, …
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…cases): vmstat 5 5 iostat -dx 5 5 If …mysql 3172 3137 78 Nov19 ? 1-11:17:30 /usr/libexec/mysqld –defaults-file=/etc/my.cnf –basedir=/usr –datadir=/var/db/mysql –user=mysql…doing this the manual way.) The result looks like this: …
Post: Apache PHP MySQL and Runaway Scripts
May 20, 2008 By 20 Comments
… is not 0 (NORMAL) Check connection handling manual for details. The testing I did was as …5.2.5 and Apache 2.0.59. Results were a bit surprising: Running “TightLoop” script terminated after 30…(spending this time on MySQL time) one is doing single query another 1000 queries 1 second length each…
Post: Make your file system error resilient
August 24, 2011 By 8 Comments
…-29c3ac1f4b32 Filesystem magic number: 0xEF53 Filesystem revision #: 1 (dynamic) Filesystem features: has_journal ext_attr … it to be back in 5 minutes yet it takes 30+ because it has to check file…just check it manually as needed, same as you would every so often check MySQL tables for corruption…
Post: Finding your MySQL High-Availability solution – The questions
October 16, 2009 By 36 Comments
…list the most common ones: – MySQL replication with manual failover – Master-Master with MMM manager -…questions, I might have missed some. 1. What level of HA do you… Heartbeat/SAN (depends on SAN) 99.5% to 99.9% Heartbeat/DRBD 99… for Linux, also reduce by about 30% (very dependent on hardware) the …
