… from VB6 to PhP/MySQL/Apache/InnoDB. Do you think you can show a program where row-locks are used by one user…
Comment: Multi Column indexes vs Index Merge
May 10, 2012 By 30 Comments
…why MySQL uses index merge after a couple of mins when previously it was using…| const | PRIMARY,namespace_ix | PRIMARY | 4 | const | 1 | Using filesort | | 1 | SIMPLE | LinksTbl2 | index_merge | … | 4,1 | NULL | 294 | Using intersect(prjid_ix,item_desc); Using where | | 1 | SIMPLE | PersonTbl2 | eq_…
Post: Load management Techniques for MySQL
May 6, 2012 By 3 Comments
… 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… concurrency to where it does not overload the system. Unless it is really time critical process I would not use more than…
Post: Zero-Downtime Schema Changes In MySQL
May 3, 2012 By 2 Comments
…while interupted? The tool doesn’t clean up the temporary table or triggers. It is designed to be resumable…table why ? The first question sounds like a potential MySQL bug. Are you sure this is really happening? …2.1. Q: qw() as use of () is deprecated That sounds like you’re using an old version of …
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: InnoDB's gap locks
May 7, 2012 By 15 Comments
… sec) root@localhost:test 14:35:22>delete from t where i=25; Query OK, 1 row affected (0.00 sec… inserting mysql tables in use 1, locked 1 LOCK WAIT 2 lock struct(s), heap size 1216, 1 row lock(s) MySQL thread…
Comment: How to change innodb_log_file_size safely
May 2, 2012 By 14 Comments
… on my site on a Debian Squeeze system where I have to edit: /etc/mysql/my.cnf Also make sure that innodb… not move them). The end result was: I could only use mysqldump to import all the data into a clean/fresh…
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… names of the used databases in both Row-Based and Statement-Based replication. This was possible before by using tools like grep…
Comment: Benchmarking single-row insert performance on Amazon EC2
May 16, 2012 By 11 Comments
… iibench is slightly incorrect. The correct URL for version you used is http://tokutek.com/downloads/iiBench-1.0.3.1… python version that Mark wrote http://bazaar.launchpad.net/~mdcallag/mysql-patch/mytools/annotate/head%3A/bench/ibench/iibench.py) is…
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…
