June 20, 2013

Post: MySQL Slow query log in the table

May 31, 2007 By 1 Comment

…MySQL 5.1 get MySQL slow query log logged in mysql.slow_log table instead of the file as you had in…can do SELECT * FROM (SELECT * FROM slow_log ORDER BY start_time DESC LIMIT 100) l ORDER BY start_time which shows last queries in…

Filed Under: Insight for DBAs Tagged With:

Post: Should we give a MySQL Query Cache a second chance ?

April 10, 2011 By 64 Comments

…in MySQL have very large number of queries doing updates through primary key and use primary key for selects. I believe in such cases we can…in the MySQL Query Cache ? How many hits did we get for this query…

Filed Under: Insight for DBAs, MySQL

Post: InnoDB Full-text Search in MySQL 5.6: Part 2, The Queries!

March 4, 2013 By 7 Comments

…in MySQL 5.6: Part 2, The Queries![/caption] This is part 2 in a 3 part series. In…I look at these results from that persepctive, I can understand the how…In theory, yes. In practice, not even close. I tried one more Boolean search, this time looking for someone’s full name, which I…

Filed Under: Insight for DBAs, Insight for Developers, MySQL Tagged With: , , , , ,

Post: Shard-Query EC2 images available

May 11, 2011 By 2 Comments

…in size. This will give us some interesting information about how Shard-Query will perform on each database. To do the size comparison, I…mysql> use ontime1; Database changed mysql…in our query response times and throughput. Setting up a cluster using the AMI images You can easily test Shard-Query…

Filed Under: MySQL

Post: DROP TABLE and stalls: Lazy Drop Table in Percona Server and the new fixes in MySQL

June 22, 2012 By 33 Comments

…how Lazy Drop Table and the new DROP Table in MySQL >= 5.5.23 work, I would like to mention quickly, that how drop table in MySQL…last access time…queries were captured in the slow log by setting long_query_time to 0. Then for analysis purposes the queries in…

Filed Under: Benchmarks, Insight for DBAs, MySQL

Post: Distro Packages, Pre-built Binaries or Compile Your Own MySQL

September 4, 2012 By 7 Comments

…times not only by our support and consulting customers, but widely from different forums and blogs – how should I install MySQL…can simply yum -y install Percona-Server-server or apt-get…MySQL‘s default behavior i.e. disabling and totally disallowing use of query…

Filed Under: MySQL

Post: MySQL 5.6.10 Optimizer Limitations: Index Condition Pushdown

March 14, 2013 By 2 Comments

…time to execute than the same “SELECT one_indexed_column” query in MySQL…MySQL 5.6 release, and get advantage of the latest integrated tools that MySQL provides with its last GA release? Then I…

Filed Under: Events and Announcements, Insight for Developers, MySQL Tagged With: , ,

Post: Index Condition Pushdown in MySQL 5.6 and MariaDB 5.5 and its performance impact

March 12, 2012 By 12 Comments

I have been working with Peter in preparation for the talk comparing the optimizer enhancements in MySQL 5.6 and MariaDB 5.5. We are taking a look at and benchmarking optimizer enhancements one by one. So in… new optimizer enhancement Index Condition Pushdown (ICP). Its available in both MySQL 5.6 and MariaDB 5.5 Now let’s take…

Filed Under: Benchmarks, Insight for DBAs, MySQL Tagged With: , , , , , , ,

Post: Time for Zero Administration effort at MySQL ?

January 8, 2012 By 4 Comments

…in most cases, in fact I would argue in 95% cases you can get…time however I am happy many more options got exposed over last few years. Majority of options in MySQL…MySQL would use the same sort_buffer_size whenever there is only one query…

Filed Under: MySQL

Post: How Percona does a MySQL Performance Audit

November 24, 2008 By 17 Comments

…in a hardware component, and you never know ahead of time. In either case, the point to know here is that we can…in our book, High Performance MySQL 2nd Edition (it’s not in the first edition). From this I get…

Filed Under: Insight for Developers Tagged With:
« Older Posts
Newer Posts »