June 19, 2013

Post: Working on "High Performance MySQL, Second Edition", how you can help?

August 31, 2007 By 20 Comments

…’re working on major rewrite of High Performance MySQL book – the most famous book about MySQL Performance on the market… which is getting old… MySQL Performance topic to the market. Me and Vadim have great internals insight and a lot of practical experience in MySQL Scaling and Performance Tuning… angle plus being author of large amount of popular MySQL tools such as MySQL Toolkit he is surely the man for the job…

Filed Under: Events and Announcements Tagged With:

Post: Followup on performance metrics: slides, video

July 11, 2011 By 6 Comments

… extract an amazing amount of information about a system’s performance, scalability, queueing, and more by just measuring request arrivals and… this into a more complete description of how to analyze MySQL’s performance and scalability through nothing more than TCP/IP packet…, I believe that a set of powerful tools and techniques is emerging from this research. Stay tuned — there is more to come.

Filed Under: MySQL

Post: Which Linux distribution for a MySQL database server? A specific point of view.

December 8, 2011 By 38 Comments

…performance improvements, however these days it is rarely important to MySQL…tune, start/stop MYSQL, upgrade MySQL, 10x start/stop MySQL, upgrade MySQL, downgrade MySQL, upgrade MySQL, install a security fix for something, 20x start/stop MySQL, upgrade MySQL… Ubuntu. Both use tool called dpkg for …

Filed Under: Insight for DBAs, MySQL

Post: Heikki Tuuri Innodb answers - Part I

October 26, 2007 By 19 Comments

…: I favor self tuning. PZ: I also like self tuning in theory. But I really like to have tools to steer the database… in 5.1: static MYSQL_SYSVAR_ULONG(thread_concurrency, srv_thread_concurrency, PLUGIN_VAR_RQCMDARG, “Helps in performance tuning in heavily concurrent environments… you’re scaling out you can get better performance by using couple of MySQL Servers on single node. You can make them…

Filed Under: Insight for Developers Tagged With: ,

Page: Presentations

May 3, 2006 By

… Talk about Mercurial version systems, comparison with similar tools and basic usage patterns Download Query Optimization Web Tuesday…MySQL Settings which should be tuned for optimal MySQL performance giving some advice of selecting prover values for them. Download MySQL Performance CookBook MySQL…

Filed Under:

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

March 11, 2013 By 7 Comments

… than the data. Very little tuning was done. The goal was to see how MySQL 5.6 performs out-of-the-box as… a star schema, so they are popular for use with tools like Mondrian and also for data mining.  I wrote an… the MySQL 5.6 server, rebooted and verified again.  Same issue.  This was very different from MySQL 5.5.30, which performs significantly…

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

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

March 4, 2013 By 7 Comments

…will be exactly identical to the same query when performed against InnoDB data, OR that the results returned …like. We are using MySQL 5.5.30 and MySQL 5.6.10 with no configuration tuning other than to … 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: SHOW INNODB STATUS walk through

July 17, 2006 By 40 Comments

…MySQL Performance. To start with basics SHOW INNODB STATUS is command which prints out a lot of internal Innodb performance… INNODB STATUS can also be used as debugging tool. Next section you will find in SHOW INNODB … than allocated buffer pool size so you can tune it down. Even if free pages is zero…

Filed Under: Insight for DBAs Tagged With:

Comment: Impact of logging on MySQL’s performance

February 10, 2009 By 8 Comments

Interesting your point to Cary Millsap blog. I think his Book on Oracle Performance Optimization is one of the best books on performance tuning. It surely taught me a lot when… And a lot of principles are general being it Oracle or MySQL just tools (or lack of tools) is different.

Filed Under: Benchmarks

Post: MySQL Slow query log in the table

May 31, 2007 By 1 Comment

… table based slow query log in production while tuning one of the systems. It is pretty nice… you require. Doing so however may affect your performance – updating table with a lot of indexes may …guess over time we would have more tools provided with these and similar features if not by MySQL than by …

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