June 19, 2013

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

September 4, 2012 By 7 Comments

…and consulting customers, but widely from different forums and blogs – how should I install MySQL on my server and what pros and cons does…with handling integration hence my personal choice. Not all environment is created equal and I hope I‘ve provided a perspective. Now, how do you prefer your MySQL…

Filed Under: MySQL

Post: MySQL 5.6.10 Optimizer Limitations: Index Condition Pushdown

March 14, 2013 By 2 Comments

…mysql> SELECT * FROM cast_info WHERE role_id = 1 and note like ‘%Jaime%’; On a table like this: CREATE…MySQL 5.6 query optimization improvements in a practical way, with real-life examples? Do you want to know a…

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

Post: Why not make a tool to improve existing configurations?

February 10, 2012 By 4 Comments

…MySQL Configuration Wizard have submitted feedback such as “I‘d love to input my existing server settings and get suggestions on how…creating a starting my.cnf, my old blog…

Filed Under: Insight for DBAs, MySQL

Post: Identifying the load with the help of pt-query-digest and Percona Server

December 29, 2011 By 3 Comments

…with all the data points you need to attack the right query in the right way. But vanilla MySQL… is doing a full scan … section shows how this …CREATE TABLE `wp_blog_one `.`wp_terms`\G # SHOW TABLE STATUS FROM `wp_blog_one ` LIKE ‘wp_term_taxonomy’\G # SHOW CREATE TABLE `wp_blog… conclusion, I can make…

Filed Under: Insight for DBAs, MySQL

Post: MySQL 5.6 vs MySQL 5.5 and the Star Schema Benchmark

March 11, 2013 By 7 Comments

…blog post is not a definitive conclusion about innodb_old_blocks_pct or innodb_old_blocks_time. It does highlight how a…MySQL 5.6.10 was doing more IO as a consequence.  To confirm that this was indeed the problem I decided to compare performance with a…: 0 PAGES_CREATE_RATE: 0 * PAGES_CREATE_RATE: …

Filed Under: MySQL Tagged With: , , , , ,

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

March 4, 2013 By 7 Comments

… actually possible to do this in a single blog post) than what …First, MyISAM, with MySQL 5.5, on the SEO data set: mysql: SELECT …creating one of these stopword tables, it simply mentions the table engine and the column name/type, so I… how your application behaves as a result of a major MySQL version…

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

Post: Knowing what pt-online-schema-change will do

November 1, 2012 By 1 Comment

…do something wrong, a bug fixed in v2.1.2. First, the tool does create the new table, even with –dry-run: Starting a…blog post (Baron blogged…with the MySQL server (privileges, etc.), or other oddities, there is a good likelihood that a…

Filed Under: Insight for DBAs, Percona Software Tagged With:

Post: Multi Range Read (MRR) in MySQL 5.6 and MariaDB 5.5

March 21, 2012 By 10 Comments

…Created_tmp_tables 1 1 1 1 1 Handler_mrr_init N/A 0 0 1 1 Handler_mrr_rowid_refills N/A…MySQL 5.6 are reporting high numbers for Innodb_rows_read, which is completely in line with how the counters behave with…

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

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

June 22, 2012 By 33 Comments

…blog post I am going to give a high level picture of how Lazy Drop Table works and how the new DROP Table works in MySQL… of DROP TABLE, but do they make enough difference. I feel that the buffer … created and populated with 1000 rows, the tables all had a very simple structure: CREATE TABLE t_x(i…

Filed Under: Benchmarks, Insight for DBAs, MySQL

Post: MySQL-Memcached or NOSQL Tokyo Tyrant - part 1

October 15, 2009 By 16 Comments

…a challenge faced by almost everyone how do…blogs on bigdbahead.com and is writing this on the mysqlperformanceblog is saying you may not want to use a database. Heresy I… I took the simple app I created…I am still getting a really solid # of hits in memcached, but the # of writes in MySQL coupled with…

Filed Under: Benchmarks, Cloud and NoSQL, MySQL Tagged With: , ,
« Older Posts
Newer Posts »