I am considering changing web-applications from VB6 to PhP/MySQL/Apache/InnoDB. Do you think you can show a …
Comment: Side load may massively impact your MySQL Performance
May 15, 2012 By 7 Comments
http://bugs.mysql.com/bug.php?id=45015 (InnoDB buffer pool can be severely affected by table scans)
Comment: Testing Fusion-io ioDrive2 Duo
May 14, 2012 By 12 Comments
Rob, That seems a little on high level. The feedback I am getting from our customers is that with some negotiations you should be able to drive price down for ~20%
Comment: How to convert MySQL's SHOW PROFILES into a real profile
May 10, 2012 By 10 Comments
There is this bug report: http://bugs.mysql.com/bug.php?id=61328
Comment: Moving Subtrees in Closure Table Hierarchies
May 2, 2012 By 7 Comments
… because you’re “walking the path”. I’m using MySQL, PHP or Coldfusion (I have to do it in both languages…
Comment: Announcement of Percona XtraDB Cluster 5.5.20 GA release
May 1, 2012 By 10 Comments
Hi, I use percona server 5.5.20, I would be testing xtradb cluster with three nodes. I …
Comment: Testing STEC SSD MACH16 200GB SLC
April 26, 2012 By 7 Comments
… sec granularity. it is a type on ‘20 sec’ – it should be every ‘20 min’. I do not know about capacitors – usually…
Comment: Testing STEC SSD MACH16 200GB SLC
April 26, 2012 By 7 Comments
… graph doesn’t show stall every 20 sec, maybe it’s just a typo? (every 20 sec, there is small drop). One…
Comment: What does Using filesort mean in MySQL?
March 15, 2012 By 27 Comments
… use index in the following scenario: CREATE TABLE table1 ( id bigint(20) NOT NULL AUTO_INCREMENT, a varchar(100) DEFAULT NULL, b…
Comment: COUNT(*) vs COUNT(col)
April 3, 2012 By 41 Comments
… limit 10,20; OR Just fire a single query and get all the data and then get the count at PHP end…
