… there is approximately 12GB of data in the largest table. You can find the individual SSB …than InnoDB when the database is cold, but the opposite is true when the database is hot. SSB …datadir=/mnt/mysql56/data basedir=/usr/local/mysql socket=/var/lib/mysql/mysql.sock user=justin innodb_buffer_pool_…
Post: 5 Percona Toolkit Tools for MySQL That Could Save Your Day: April 3 Webinar
March 22, 2013 By Leave a Comment
… Tools for MySQL That Could Save Your Day.” In this presentation you’ll learn how to perform typical but challenging MySQL database administration… seconds How to run ALTER TABLE on your largest tables without downtime REGISTER NOW for this MySQL webinar DOWNLOAD Percona Toolkit for MySQL
Post: MySQL performance on EC2/EBS versus RDS
August 4, 2011 By 11 Comments
… well when you don’t need high concurrency from your MySQL database. When you do, the limitations on the core counts and… is your effective ceiling in today’s largest EC2 instances. That is concurrency inside the database, not at the application level. You… is a chance that will cause MySQL to perform slowly or unpredictably. For write-heavy databases, you are generally bound by either…
Post: Shard-Query turbo charges Infobright community edition (ICE)
May 6, 2011 By 23 Comments
… kit which helps improve the performance of queries against a MySQL database by distributing the work over multiple machines and/or multiple… loading the raw data from the BTS into a single database table called ontime_stage. Then, the airport information was extracted… contains the flight numbers and air carrier hierarchies. Only the largest air carriers must register and report ontime information with the…
Post: Upgrading MySQL
January 5, 2010 By 24 Comments
…. The largest amount of potential issues happens when you upgrade to different major version, especially if you skip over one. MySQL 5…. MySQL always was very good maintaining on disk binary compatibility between version and so you can run MySQL 5.0 database with MySQL 5… different MySQL version, unless you have very detailed automated QA. So what you can do is get the backup of the database…
Post: Percona Welcomes MySQL 5.6!
February 25, 2013 By Leave a Comment
… Oracle MySQL, MySQL 5.6 is fully supported by our MySQL Consulting, MySQL Support, MySQL Server Development, and MySQL Remote DBA teams: Our MySQL Consulting Team and MySQL… customers backing up and restoring MySQL 5.6 databases in standard configuration successfully with the current version. The largest focus of our development…
Post: MySQL at Facebook, present and future
April 25, 2011 By Leave a Comment
Harrison Fisk, from the Facebook database team, will be in New York City delivering the closing … future plans for MySQL inside Facebook’s environment. As you probably know, Facebook is one of the largest users of MySQL, with their own set of patches, and the Facebook team is very open about how they use MySQL…
Post: MySQL on Amazon RDS part 1: insert performance
March 15, 2011 By 37 Comments
Amazon’s Relational Database Service (RDS) is a cloud-hosted MySQL solution. I’ve had some clients hitting performance limitations on … get on normal EC2 servers with EBS. I benchmarked the largest available RDS instance, which is listed as “High-Memory Quadruple…
Post: Finding out largest tables on MySQL Server
February 4, 2008 By 27 Comments
Finding largest tables on MySQL instance is no brainier in MySQL 5.0+ thanks to Information Schema but I still wanted … the query so it works whatever database you have active. It does not work with MySQL before 5.0 still of course…
Post: Identifying the load with the help of pt-query-digest and Percona Server
December 29, 2011 By 3 Comments
…atomically, not just for new connections as in MySQL. This is very helpful for measurement as …the queries and shows the top queries with largest impact – longest sum of run time which typically …its run. The “Databases” section of the output also shows the name of the databases where this query…
