… VB6 to PhP/MySQL/Apache/InnoDB. Do you think you can show a program where row-locks are used by one user…
Post: Benchmarking single-row insert performance on Amazon EC2
May 16, 2012 By 11 Comments
… the MySQL configuration. MySQL Configuration I used Percona Server 5.5.22-55 for the tests. Following is the configuration that I used: ## InnoDB… and MySQL. Now as far as the benchmark itself is concerned, I made no code changes to iiBench, and used the version available here. But I changed the table to use range partitioning. I defined a…
Comment: Multi Column indexes vs Index Merge
May 10, 2012 By 30 Comments
… secs. I dont understand why MySQL uses index merge after a couple of mins when previously it was using a single index. I….customize_access, FileTbl.fromdate, FileTbl.todate,LinksTbl2.main_version_id,LinksTbl2.major_version,LinksTbl2.minor_version, LinksTbl2.target, LinksTbl2.item_desc FROM LinksTbl2…
Comment: ext4 vs xfs on SSD
May 3, 2012 By 23 Comments
… we don’t use RHEL/CentOS, because they come with generally outdated software and it’s hard to use newer versions or upgrade. At the time I ran the benchmark above, we were using Linux 2.6…’ll be on kernel 3.x (depending what ‘x’ we use then, we’re currently on 3.0). But I agree…
Post: Zero-Downtime Schema Changes In MySQL
May 3, 2012 By 2 Comments
…_x table why ? The first question sounds like a potential MySQL bug. Are you sure this is really happening? I would…. Are you using the 2.0 version of this tool? It was completely rewritten in version 2.1. Q: qw() as use of () is deprecated That sounds like you’re using an old version of the tool. Q: Old version…
Post: Announcement of Percona XtraDB Cluster 5.5.23
May 14, 2012 By 11 Comments
… and feedback. I am happy to announce next version Percona XtraDB Cluster 5.5.23, which comes…. List of changes: Fixes merged from upstream (Codership-mysql) Support for MyISAM, now changes to MyISAM tables… error handling New SST wsrep_sst_method=skip, useful when you start all nodes from the same …
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… need to know it is not MySQL problem, might be even not problem with your MySQL configuration, queries and hardware, even though… too much system resources. Here are some specific techniques to use. Do push concurrency too high Many developers will test script…
Comment: Benchmarking single-row insert performance on Amazon EC2
May 16, 2012 By 11 Comments
… version you used is http://tokutek.com/downloads/iiBench-1.0.3.1.tar.gz One of the advantages of the newer version of iiBench (the python version that Mark wrote http://bazaar.launchpad.net/~mdcallag/mysql-patch/mytools/annotate/head…
Comment: Percona Replication Manager, a solution for MySQL high availability with replication using Pacemaker
May 16, 2012 By 94 Comments
… see, Yves fixed this in his the last version on gitub. But in my MySQL – installation a “SHOW SLAVE STATUS” will ALWAYS produce a completely output. Maybe not initial, but if you use the… tmpfile, not for the content “Slave_SQL_Running: Yes” is used for to say that this server is a slave, but…
Comment: How to load large files safely into InnoDB with LOAD DATA INFILE
May 10, 2012 By 28 Comments
Jack, Baron, maybe you’re using different replication strategies. I can well imagine that row-based … even be differences based on the database engine and/or MySQL version. Regards, Stefan
