… web-applications from VB6 to PhP/MySQL/Apache/InnoDB. Do you think you can show a program where row-locks are used…/committed? A example of a program is worth a 1000 instructions. Please do this for us. I am sure there are many in this…
Post: Benchmarking single-row insert performance on Amazon EC2
May 16, 2012 By 11 Comments
…s the instance type with highest memory available, and memory is what…query cache on write heavy workload. OK, so that was all about the configuration of the EC2 instance and MySQL…s take a look at the graphs have a better view of the whole picture. Note, in…are write mostly or that rely a lot on write…
Comment: Benchmarking single-row insert performance on Amazon EC2
May 16, 2012 By 11 Comments
…a partition gets bigger and bigger, then we start a new partition, and Inno starts catching up and the performance starts getting better…mysql-patch/mytools/annotate/head%3A/bench/ibench/iibench.py) is that it measures query…
Post: Introducing Zend DBi as a MySQL Replacement on IBM i
May 8, 2012 By Leave a Comment
… Zend DBi. It is basically a renamed build of MySQL for IBM i. It’s a 100% compatible drop-in replacement. Everything works on Zend… 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…
Post: Load management Techniques for MySQL
May 6, 2012 By 3 Comments
…MySQL is what they happen every so often or certain times. Investigating them we find out what…MySQL problem, might be even not problem with your MySQL configuration, queries and hardware, even though fixing these does help in…
Post: Testing Intel SSD 520
May 1, 2012 By 7 Comments
…small hiccups in throughput and response times even for small…MySQL workloads on these cards to understand it better. If you are interested more in SSD and MySQL questions – I will be giving a webinary “MySQL…
Comment: Joining many tables in MySQL - optimizer_search_depth
May 12, 2012 By 6 Comments
… particular queries but surely cannot be an all-around answer to inefficiencies of the optimizer, that should be doing a good job in… to be built into the (application’s) logic which is simply a nightmare for developers in case of migration or major change in data profiles.
Post: Zero-Downtime Schema Changes In MySQL
May 3, 2012 By 2 Comments
…What about manual aborting a…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 really happening? I would be extremely surprised for such a bug to be happening. In…
Comment: Multi Column indexes vs Index Merge
May 10, 2012 By 30 Comments
… the same SQL query with a couple of mins gap on the same mysql prod instance . The first SQL query executed in 0.03 secs whereas the second SQL query… (FileTbl.deactive!=1) AND (LinksTbl2.converted_from_id IS NULL OR LinksTbl2.converted_from_id=0) ORDER BY LinksTbl2.tstamp DESC…
Comment: How to load large files safely into InnoDB with LOAD DATA INFILE
May 9, 2012 By 28 Comments
…-affirm this statement about replication? I’ve observed things differently in MySQL 5.5 (vanilla version). “The big LOAD DATA INFILE clogs… happen without a hitch and the LOAD DATA can happen asynchronously on all boxes. Yes, it’s a pain, but it’s better than replication…
