I am considering changing web-applications from VB6 to PhP/MySQL/Apache/InnoDB. Do you think you can show a program where row-locks are used by one user to lock records…
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…? I’m new to Fusion-IO and I am going to do some testing with a couple of MySQL servers with ioDrive2 cards…
Comment: Learning about MySQL Table Fragmentation
May 18, 2012 By 19 Comments
… have set files_per_table variable. i executed the following query to know the fragmentation SELECT TABLE_SCHEMA, TABLE_NAME, CONCAT(ROUND… 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.
Post: Introducing Zend DBi as a MySQL Replacement on IBM i
May 8, 2012 By Leave a Comment
… it works on MySQL, with no need to rewrite applications, management scripts, or anything else. There is no difference in query syntax, client-server protocol, or data storage on disk. Anything that runs on MySQL will run identically…
Post: Announcement of Percona XtraDB Cluster 5.5.23
May 14, 2012 By 11 Comments
… merged from upstream (Codership-mysql) Support for MyISAM, now changes to MyISAM tables are replicated to other nodes Improvements to XtraBackup SST methods, better….04, they are coming soon. If you want to know more how to migrate to XtraDB Cluster, we will be giving a free webinar…
Comment: Benchmarking single-row insert performance on Amazon EC2
May 16, 2012 By 11 Comments
… this partitioning, however since you’ll have to look in each of the ten partitions to query one of the indexes. If you… will be 100 disk seeks to answer a random query, assuming you can get each index query down to one disk seek.) I claim…/~mdcallag/mysql-patch/mytools/annotate/head%3A/bench/ibench/iibench.py) is that it measures query performance too, so if you fail to…
Post: Testing Fusion-io ioDrive
May 3, 2012 By 1 Comment
… performance is getting closer to PCIe cards. It really makes sense to test it under MySQL workload, but before getting to that, let me… with throughput 350-400 MiB/sec. Random reads, async: Interesting to see that there is quite unstable throughput in range 450… and show them in timeline (from 0 to 1800 sec): I am not sure how to explain it, that with 4 and 8…
Comment: ext4 vs xfs on SSD
May 3, 2012 By 23 Comments
… to assert that XFS is the way to go for MySQL, but I’m not sure how frequently they benchmark XFS vs ext4, and how much of their recommendation comes from the days of ext2/ext3. So I decided to use sysbench and plot some graphs to…-2x-faster-than-xfs.html So we built all our MySQL DBs with ext4, and it’s been working great for…
