… of the buffer pool is the same – 30GB. So now we explore the IO-bound scenario. Percona Server 5.5 outperforms MySQL in about 2x times….6.11 demonstrate notable drops in performance. What can be the reason for that? Below is a chart with top mutexes for each… mysqld mysqld [.] ut_delay(unsigned long) So basically most of the time 5.6.11 spent in LRU_scan. I tried to…
Post: MySQL 5.6 Compatible Percona Toolkit 2.2 Released
March 25, 2013 By 2 Comments
… all the standard MySQL options built-in, like other tools: –user, –host, –port, –password, –socket, –defaults-file. So now the command line is what you expect: pt-stalk -h dhb1 -u me. pt-stalk –no-stalk is no longer magical… little differently. This magic is gone now: both tools run forever by default, so specify –iterations or –run-time to limit how long…
Post: Benchmarking Percona Server TokuDB vs InnoDB
May 7, 2013 By 32 Comments
…), which is not so good for InnoDB. So let’s see what results we have. The results are in TPS (more is better) and we start with empty tables. Now, before looking at the graph…=32 –mysql_table_engine=tokudb –oltp_auto_inc=on –max-time=18000 –report-interval=10 –max-requests=0 –num-threads=32…
Post: Percona Live MySQL Conference and Expo 2013: It feels like 2007 again
March 21, 2013 By Leave a Comment
… is going to kill MySQL and the whole Internet”) and just a lot of drama and politics. And now, after all this time some 6 or 7 years later, it feels like a MySQL Renaissance. All of the major MySQL… say that the greatest part of the conference is not talks, but what happens in between them — in the conference center halls and behind the curtains…
Post: Percona Live MySQL Conference 2013 wrap-up
April 29, 2013 By Leave a Comment
…time and energy into development of MySQL with an engineering team of over 200 developers The release process is…was the first of what I hope are many such events where all members of the …the Hyatt Santa Clara, and the Santa Clara Convention Center, to name just a few. Please mark your calendars now…
Post: What is exec_time in binary logs?
January 31, 2011 By 2 Comments
… the following in the output: “exec_time=0″ What is the exec_time? It seems to be the query’s execution time, but it is not. In most cases, the exec_time… for replay. Now suppose that you have also set log_slave_updates on the replica. When the statement executes in the replication thread, it…
Post: MySQL Life Cycle. Your Feedback is needed.
November 18, 2011 By 6 Comments
… update MySQL the same date as release would hit the web. Since that time I matured and so did MySQL ecosystem. MySQL is powering a lot more demanding and business critical applications now… system is important for you ? Finally I’d like to know What is the Oldest Platform/Operating system are you running MySQL on now ? Do…
Post: Top 5 MySQL wishes - what is next ?
July 4, 2007 By 1 Comment
… is also a good overlap among people wishes which shows there are some things which are really needed badly. The great question now is what will happen next ? Will there be any action taken to target wishes which make the most sense… will there any true action taking ? What I would like to see is MySQL taking a time to discuss and prioritize these internally…
Post: What's the recommended MySQL version?
August 15, 2011 By 24 Comments
…The answer is different for each case. (There are other qualifying questions I’d ask too, but this is the…what‘s the bottom line? For new applications, I’ve said use MySQL 5.5 without hesitation for many months now, and now…
Post: Is disk Everything for MySQL Performance ?
April 25, 2008 By 7 Comments
…would need at least 50 outstanding requests all the time to fully utilize them. So for example … also be different. Now let me come to filesystem layout issues This is where a lot …performance. I tend to advice different things depending on what is the most important. Assuming you have fixed amount …
