… VB6 to PhP/MySQL/Apache/InnoDB. Do you think you can show a program where row-locks are used by one user to lock… do this for us. I am sure there are many in this situation.
Comment: Testing Fusion-io ioDrive - now with driver 3.1
May 18, 2012 By 2 Comments
… benchmarks. They are very informative. One question: when you configure MySQL, what portion of it resides on the Fusion-IO card… new to Fusion-IO and I am going to do some testing with a couple of MySQL servers with ioDrive2 cards (two in each…
Comment: Learning about MySQL Table Fragmentation
May 18, 2012 By 19 Comments
… innodb tables in my production database and i have set files_per_table variable. i executed the following query to know the… table could not be defragmented. is there any other way to defragment innodb tables? thanks Kuldeep
Comment: How SHOW SLAVE STATUS relates to CHANGE MASTER TO
May 18, 2012 By 21 Comments
Is there any option to save the result of show slave status in a table like insert into temp show slave status;
Comment: Benchmarking single-row insert performance on Amazon EC2
May 17, 2012 By 11 Comments
Aaron, No particular reasons, it doesn’t matter if you have 4 1G or 2 2GB log files, as they are all concatenated together by InnoDB and written to in a circular fashion.
Comment: ext4 vs xfs on SSD
May 18, 2012 By 23 Comments
Benoit, nice little script you’ve got there; using it!
Comment: Percona Server 5.5.23-25.3 released!
May 17, 2012 By 2 Comments
@ James Ubuntu Precise (12.04 LTS) will be officially supported with the next Percona Server releases. Percona Server 5.5.24-26.0 is currently scheduled for release in the first week of June.
Post: Zero-Downtime Schema Changes In MySQL
May 3, 2012 By 2 Comments
… MySQL bug. Are you sure this is really happening? I would be extremely surprised for such a bug to be happening. In reply to… in the server and the tool, so there is no code in the tool that disables binary logging at all. Are you using… was completely rewritten in version 2.1. Q: qw() as use of () is deprecated That sounds like you’re using an old version…
Comment: Joining many tables in MySQL - optimizer_search_depth
May 12, 2012 By 5 Comments
Bartosz, You are right this is due to an optimizer inefficiency. But till the time the optimizer is not efficient enough we would have to use workarounds. In fact hints tend to be used a lot because although mostly optimizer makes good choices but sometimes it doesn’t.
Post: Load management Techniques for MySQL
May 6, 2012 By 2 Comments
… experience to degrade. The first thing you need to know it is not MySQL problem, might be even not problem with your MySQL configuration, queries and hardware, even though fixing these does help in many… consume too much system resources. Here are some specific techniques to use. Do push concurrency too high Many developers will test script…
