June 19, 2013

Post: MySQL 5.6.10 Optimizer Limitations: Index Condition Pushdown

March 14, 2013 By 2 Comments

… of one of the nicest features of the newer MySQL optimizer: the Index Condition Pushdown Optimization, or ICP, which we have previously…, which means you need more manual care and tuning now. MySQL is conservative about “Using index” -in most cases it will be the… to be prepared for the MySQL 5.6 release, and get advantage of the latest integrated tools that MySQL provides with its last…

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

Page: Consulting for MySQL

July 31, 2006 By

…application needs using MySQL Replication, Active-Passive clustering, DRBD, MySQL Cluster, Load balancing and other tools. MySQL Replication Advanced MySQL Replication consulting …solution ? We can help with fine tuning MySQL build in Full Text Search indexing or help you with selecting and …

Filed Under:

Post: The ultimate tool for generating optimal my.cnf files for MySQL

August 18, 2008 By 34 Comments

… quite a few “tuning primers” and “my.cnf generators” and “sample my.cnf files” online. The ultimate tool for generating an optimal….cnf is not a tool. It’s a human with many years of experience, deep knowledge of MySQL and the full application… end-all of performance. Tuning your server settings has far less impact on performance than tuning your schema, indexing, queries and — you guessed…

Filed Under: Insight for DBAs Tagged With: ,

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

March 11, 2013 By 7 Comments

… schema, so they are popular for use with tools like Mondrian and also for data mining.  I … 1: Default config for MySQL 5.5 and MySQL 5.6, no tuning at all Config 2: MySQL 5.6 with …pool and the other secondary indexes have been pushed out of the buffer pool. mysql> select * from information_schema….

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

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

March 4, 2013 By 7 Comments

…. We are using MySQL 5.5.30 and MySQL 5.6.10 with no configuration tuning other than to …token_size to 1, dropped/rebuilt the InnoDB index, and tried again. mysql: SELECT id, full_name, MATCH(full_name… Playback) that can help you with this. These tools are free and open source, please use them. You…

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

Post: How Percona does a MySQL Performance Audit

November 24, 2008 By 17 Comments

…work with systems that are at any level of tuning, from completely untuned to a system that’s …here are the lowest common denominator. We often use tools to gather a lot of the data for …for default users in the mysql.* tables, running mk-duplicate-key-checker to find redundant indexes, and so on. As…

Filed Under: Insight for Developers Tagged With:

Post: MySQL Slow query log in the table

May 31, 2007 By 1 Comment

… incompatible with our slow query analyses patch and tools Fixing this is not trivial while staying 100% … table based slow query log in production while tuning one of the systems. It is pretty nice … to have indexes would be quite handy I also should tell log table implementation in MySQL is well …

Filed Under: Insight for DBAs Tagged With:

Post: Read Buffers, mmap, malloc and MySQL Performance

September 12, 2007 By 8 Comments

… together with strace) are great tools for MySQL Performance analyses. Too many people end tuning on plans and indexes while there well could be… done to speed things up here ? Of course you can tune you malloc settings so more buffers are allocated from the… you could just grab one having allocation very quick. Also MySQL should get smarter in terms of which buffer size should…

Filed Under: Insight for DBAs Tagged With: , ,

Post: Heikki Tuuri Innodb answers - Part I

October 26, 2007 By 19 Comments

… for ability to create physically sorted indexes with Innodb (with index built by sort) this is… tuning. PZ: I also like self tuning in theory. But I really like to have tools to…static MYSQL_SYSVAR_ULONG(thread_concurrency, srv_thread_concurrency, PLUGIN_VAR_RQCMDARG, “Helps in performance tuning in…

Filed Under: Insight for Developers Tagged With: ,

Post: Paul McCullagh answers your questions about PBXT

November 20, 2009 By 2 Comments

…(1.0.09) supports the MySQL Backup API which was originally implemented in MySQL 6.0. This feature is now…in PBXT, and can it be tuned? PBXT uses 16K pages for the index data and (approximately) 32K pages for…bad thing because it provides DBA’s with the tools they need. My goal for PBXT in this regard…

Filed Under: Insight for Developers, MySQL Tagged With: , , , , ,
« Older Posts