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: 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
Post: New distribution of random generator for sysbench - Zipf
May 9, 2012 By 3 Comments
… high IO load. That’s why I was looking for alternatives, and Zipfian distribution seems decent one. This distribution has a…
Comment: ext4 vs xfs on SSD
May 8, 2012 By 23 Comments
sandeep, I am not aware about alternative in ext4. There is a patch for MySQL which can do somewhat similar on any filesystem (this comes with Percona XtraDB Cluster)
Post: Load management Techniques for MySQL
May 6, 2012 By 3 Comments
One of the very frequent cases with performance problems with MySQL is what they happen every so often or certain times. Investigating them we find out what the cause is some batch jobs, reports and other non response time critical activities are overloading the system causing user experience to …
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…
Post: Testing Samsung SSD SATA 256GB 830 - not all SSD created equal
April 25, 2012 By 10 Comments
… from a pricing point our customers are looking for cheaper alternatives. SATA SSD is an options. There is many products based… it before, that’s why I am looking for comparable alternatives. Samsung 830 256GB looked like a good product, that’s…
Comment: Percona Toolkit 2.1 with New Online Schema Change Tool
April 22, 2012 By 9 Comments
… help and information. I just made the MySQL, apache2 and php updates available to Debian Squeeze avalable on DotDeb.org, and…
Comment: Alternatives of PHP ?
April 11, 2012 By 28 Comments
You could try WebDNA: it is lighter than php and mysql and is also much faster (resilient in-memory …
