… reliably on the __tmp_x table why ? The first question sounds like a potential MySQL bug. Are you sure this … question, the 2.1 version of the tool does NOT have any features to disable the binary log; my … tool that disables binary logging at all. Are you using the 2.0 version of this tool? It was …
Post: Benchmarking single-row insert performance on Amazon EC2
May 16, 2012 By 11 Comments
…MySQL configuration. MySQL Configuration I used Percona Server 5.5.22-55 for the tests. Following is the configuration that I used…(11) NOT NULL, `customerid` int(11) NOT NULL, `productid` int(11) NOT NULL, `price` float NOT NULL, PRIMARY … on the y-axis. The reason why I have chosen to show “millions…
Post: Joining many tables in MySQL - optimizer_search_depth
April 20, 2012 By 6 Comments
… a bit better performance but I decided against using this as I did not want to risk likehood of execution plans changing… wondering if 0 is automatic selection why do we have value of 62 being default in MySQL 5.5 which can produce… if we assume MySQL users do not join lots of tables (less than 7) when using 0 as default value would not impact them…
Post: Win Free MySQL Conference Tickets!
March 14, 2012 By 2 Comments
… should not miss if you’re at all interested in MySQL. We really want you to be there — and that’s why we… retweet us when we mention this contest Tweet “My favorite #MySQL conference session” with a link to your favorite “Like” your… in the contest: SkySQL Webyog Tokutek If you don’t use social media such as Twitter and Facebook, you can still…
Post: Percona Announces New Relic Partnership
April 10, 2012 By 2 Comments
… they should use New Relic. I even wrote it in the new edition of High Performance MySQL. Why? Simple. People who use New Relic… to the best solution for them, even if that means NOT using Percona, I do that. I am, personally, very happy that…
Post: Testing Samsung SSD SATA 256GB 830 - not all SSD created equal
April 25, 2012 By 10 Comments
… most popular. I do not particularly like its write performance – I wrote about it before, that’s why I am looking for…), and recently I switched to use async IO mode. There are two reasons for that. First, MySQL/InnoDB uses async writes, so this… the same as my talk on Percona Live MySQL Conference 2012, if you did not attend my talk – you are welcome to…
Comment: What does Using filesort mean in MySQL?
March 15, 2012 By 27 Comments
… in MySQL manual but could not find a reason why MySQL does not use index in the following scenario: CREATE TABLE table1 ( id bigint(20) NOT NULL…? On mysql manual I notice that the above query satisfies all conditions required for MySQL to use an index but it does not. I just see this note: With EXPLAIN SELECT … ORDER BY, you can check whether MySQL…
Comment: INSERT ON DUPLICATE KEY UPDATE and summary counters.
March 23, 2012 By 46 Comments
What can you say about http://bugs.mysql.com/bug.php?id=52020 Can you please explain how …) It is reasonable not to release Lock 1, but why MySQL tries to create Lock 3? Why can’t it use Lock 1 instead of…
Comment: Which Linux distribution for a MySQL database server? A specific point of view.
March 15, 2012 By 37 Comments
… the people use what they like. But why the package maintainers don’t just write sane install and init scripts for MySQL? The… the ‘check_for_crashed_tables’ function (found in /usr/share/mysql/debian-start.inc.sh) which, among other things, does nasty…+ of tables it has to be disabled in order to not let the server suffer from I/O overload for a…
Comment: Getting MySQL Core file on Linux
April 19, 2012 By 1 Comment
… but adjusting to my environment (and also puppetising) and could not get things to work as expected. It seems there is… been using the mysql had full access to the directory I was trying to dump to but the core dump did not appear… catch other people too. I’m not sure if this is documented, or entirely why this is the case but it does…
