… VB6 to PhP/MySQL/Apache/InnoDB. Do you think you can show a program where row-locks are used by one user…
Comment: Load management Techniques for MySQL
May 10, 2012 By 3 Comments
Another option for using a dedicated slave is to write all batch jobs to use Gearman MySQL UDF interface to apply update transactions to the master (but having the batch job only use the slave… yet, you could use Percona MySQL Cluster to have a dedicated master for all batch job processing and use Gearman Workers to apply…
Post: Zero-Downtime Schema Changes In MySQL
May 3, 2012 By 2 Comments
… written to the bin-log and thus isn’t replicated, why ? without any replication filters or relevant args, the replication breaks reliably on the __tmp_x table why ? The first question sounds like a potential MySQL bug. Are you sure this is… the tool that disables binary logging at all. Are you using the 2.0 version of this tool? It was completely…
Post: Introducing Zend DBi as a MySQL Replacement on IBM i
May 8, 2012 By Leave a Comment
… users who want to continue running IBM i and MySQL. That’s why we’re happy to announce that we have assisted Zend to introduce Zend DBi as a drop-in replacement for MySQL… i platform and switch to Oracle’s MySQL on another platform, it will work seamlessly. Why is Percona involved? Because providing quality…
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…
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… instance and MySQL. Now as far as the benchmark itself is concerned, I made no code changes to iiBench, and used the… and “INSERTs Per Second” on the y-axis. The reason why I have chosen to show “millions of rows” on the…
Post: Announcement of Percona XtraDB Cluster 5.5.23
May 14, 2012 By 11 Comments
… and improvements. List of changes: Fixes merged from upstream (Codership-mysql) Support for MyISAM, now changes to MyISAM tables are replicated… methods, better error handling New SST wsrep_sst_method=skip, useful when you start all nodes from the same sources (i…
Comment: Multi Column indexes vs Index Merge
May 10, 2012 By 30 Comments
… the same mysql prod instance . The first SQL query executed in 0.03 secs whereas the second SQL query when using index merge executes in 3.8 secs. I dont understand why MySQL uses index merge after a couple of mins when previously it was using a single index. I…
Post: Webinar: MySQL and SSD
May 8, 2012 By Leave a Comment
Just as a reminder – tomorrow, May-9, 2012, at 11am PDT I will be giving a free webinar “MySQL and SSD”. This is the same talk I gave on Percona Live MySQL Conference, so if you were there – you probably will find nothing new. Otherwise, you are welcome to join!
Post: Percona Server 5.1.62-13.3 released!
April 26, 2012 By Leave a Comment
… available here and from the Percona Software Repositories). Based on MySQL 5.1.62, including all the bug fixes in it… the mysqlbinlog utility that allows the changing names of the used databases in both Row-Based and Statement-Based replication. This was possible before by using tools like grep, awk and sed but only for SBR…
