…: 85 Commit_transactions: 0 Rollback_transactions: 0 mysql> SHOW TABLE_STATISTICS LIKE ‘hosting2%’; +——————————–+———–+————–+————————-+ | Table | Rows_read | Rows_changed | Rows_changed_x_#….com CEO, Matt Heatton, has published it on his blog.
Post: MySQL 5.6.10 Optimizer Limitations: Index Condition Pushdown
March 14, 2013 By 2 Comments
… of the newer MySQL optimizer: the Index Condition Pushdown Optimization, or ICP, which we have previously discussed on our blog. It was the following query in particular that had this surprising outcome: mysql> SELECT * FROM cast_info WHERE role_id = 1 and note like ‘%Jaime%’; On a table like this: CREATE TABLE `cast…
Post: How to Monitor MySQL with Percona's Nagios Plugins
February 22, 2012 By 11 Comments
… highlight a couple of threshold-based alerts later in this blog post, and explain the need to be careful with them…’t owned by MySQL, you won’t have any problems until you try to create or drop a table, or the database… down for a system reboot. The pmp-check-mysql-pidfile plugin verifies that MySQL‘s PID file exists. Evidence of contention in…
Post: Two Types of MySQL Users
May 10, 2010 By 5 Comments
… other meetings, they read blogs and write them, they may even hack on MySQL. So this fraction of MySQL Community looks a lot… this – you might think most relevant players in MySQL community participated in MySQL Users Conference over the years. This is about 2000… Innodb ? By the fact you can have transactions with MyISAM tables but they would not actually roll back ? Replication which can…
Post: Percona's Sessions at the O'Reilly MySQL Conference and Expo
April 7, 2011 By Leave a Comment
…just realized that we haven’t blogged a list of our sessions at the O’Reilly MySQL Conference and Expo (#mysqlconf) …with MySQL The Aspersa System Administrator’s Toolkit Percona Server and XtraBackup: painless operations Forecasting MySQL Performance and Scalability Summary tables, aggregate tables …
Post: MySQL Life Cycle. Your Feedback is needed.
November 18, 2011 By 6 Comments
… web. Since that time I matured and so did MySQL ecosystem. MySQL is powering a lot more demanding and business critical applications… a bit more confusing. Per this table RHEL4 is Supported all the way to MySQL 5.5 yet it does not seems… your feedback on this matter either as comments to this blog posts or as direct email to my initials @percona.com…
Post: Distro Packages, Pre-built Binaries or Compile Your Own MySQL
September 4, 2012 By 7 Comments
… consulting customers, but widely from different forums and blogs – how should I install MySQL on my server and what pros and cons… be as easy as stopping MySQL, updating symlinks or your my.cnf basedir, starting MySQL and running mysql_upgrade. Unlike package managers, you… query cache or increasing maximum total number of indexes per table from 64, or maybe your engineering mantra simply wants to…
Post: Dot-Org Pavilion at the Percona Live MySQL Conference
February 8, 2012 By Leave a Comment
…-post from my personal blog. Are you involved with an open-source project that’s interesting to MySQL users, such as Nginx… have a free expo hall booth in the Percona Live MySQL Conference in April. Please submit your applications now, and tell… O’Reilly’s as we can.) It’s a free table in the expo hall where people who participate in a…
Post: What's required to tune MySQL?
July 27, 2011 By 4 Comments
…’t something you should expect to deliver huge wins. If MySQL is actually badly configured, you can hurt its performance significantly… population. This blog‘s articles often illustrate extreme cases, so keep in mind that the vast majority of MySQL installations don’t… The server configuration The workload The queries The schema design (table design, data types, indexing, etc) The data itself All of…
Post: Identifying the load with the help of pt-query-digest and Percona Server
December 29, 2011 By 3 Comments
… gather more data about the underlying tables involved and the query execution plan used by MySQL. The end result might be that…+ # Tables # SHOW TABLE STATUS FROM `wp_blog_one ` LIKE ‘wp_terms’\G # SHOW 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_one…
