June 19, 2013

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

…’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…

Post: Followup on performance metrics: slides, video

… 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.

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

performance improvements, however these days it is rarely important to MySQLtune, 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 …

Post: Heikki Tuuri Innodb answers - Part I

…: 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…

Page: Presentations

… 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

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

… 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…

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

…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…

Post: SHOW INNODB STATUS walk through

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…

Comment: Impact of logging on MySQL’s performance

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.

Post: MySQL Slow query log in the table

… 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 …