…’ll be leading a Webinar titled, “Using MySQL 5.6 Performance Schema to Troubleshoot Typical Workload Bottlenecks.” In this Webinar I will… Schema, focusing on new features that have been added in MySQL 5.6, go over the configuration and spend most time…
Comment: Webinar: MySQL 5.6 Performance Schema
May 16, 2013 By 5 Comments
Hi Zoe, yes – all of our MySQL webinars are recorded and available for viewing afterward. You’ll find this one here: http://www.percona.com/webinars/using-mysql-56-performance-schema-troubleshoot-typical-workload-bottlenecks
Comment: Webinar: MySQL 5.6 Performance Schema
May 16, 2013 By 5 Comments
….percona.com/sites/default/files/presentations/Webinar-Using-MySQL-5.6-Performance-Schema-To-Troubleshoot-Typical-Workload-Bottlenecks.pdf I’m Percona…
Post: Troubleshooting MySQL Memory Usage
March 21, 2012 By 5 Comments
… the most painful troubleshooting tasks with MySQL is troubleshooting memory usage. The problem usually starts like this – you have configured MySQL to use reasonable… MySQL in wild. I also wanted to share some troubleshooting techniques I use. Plot Memory Usage First I would like to see MySQL…
Post: Troubleshooting MySQL Upgrade Performance Regressions
February 15, 2012 By Leave a Comment
… it without side load. Setting up 2 MySQL Servers side by side (for example with MySQL Sandbox) can especially be helpful. Once you have spotted the query which performs differently between MySQL Server versions you should: Check Query Plan Run EXPLAIN to… helps to know whenever it is the problem in stick MySQL changes between versions on Percona enhancements. Before reporting bug to…
Post: Getting MySQL Core file on Linux
August 26, 2011 By 1 Comment
Core file can be quite helpful to troubleshoot MySQL Crashes yet it is not always easy to get, especially … dumped by setuid processes (and MySQL Server is most commonly ran changing user from “root” to “mysql“). Before you embark on enabling…/sbin/mysqld[0x516a61] The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains information that should help you…
Page: Consulting for MySQL
July 31, 2006 By
…. MySQL Replication Advanced MySQL Replication consulting including chained and circular replication, bi-directional replication, troubleshooting MySQL Replication performance problems. MySQL Operations and Administration Assistance with MySQL Server installation and configuration, working out Operations practices – MySQL Security, MySQL Upgrades, Backup…
Post: Distro Packages, Pre-built Binaries or Compile Your Own MySQL
September 4, 2012 By 7 Comments
… be as easy as stopping MySQL, updating symlinks or your my.cnf basedir, starting MySQL and running mysql_upgrade. Unlike package managers, you… properly with MySQL? A paradigm shift like this can save your team tons of hours spent on planning, testing, troubleshooting (rinse and… to easily switch between appropriate versions if called for when troubleshooting for problems and not spend too much time on switching…
Post: Two Types of MySQL Users
May 10, 2010 By 5 Comments
… are ready to take a risks and spend sleepless nights troubleshooting issues as they come across. There are also people here… and write them, they may even hack on MySQL. So this fraction of MySQL Community looks a lot larger than it is… this – you might think most relevant players in MySQL community participated in MySQL Users Conference over the years. This is about 2000…
Post: Fighting MySQL Replication Lag
September 22, 2008 By 7 Comments
… already wrote about it. There are many aspects of managing mysql replication lag such as using proper hardware and configuring it… result in low hanging fruit troubleshooting MySQL Replication Lag First fact you absolutely need to remember is MySQL Replication is single threaded, which…
