Oracle Linux had a lot of engineering hours inside it to drive the performance to new levels. But currently oracle Linux 6.4 comes with a dated version of MySQL, version 5.1.69. So how can you upgrade to 5.6 without losing your data?
First, make a backup just in case Murphy’s Law has a tort waiting for you.
Remove the old files. The rpm -qa | grep -i ^mysql command will show you the packages to be removed. Then rpm -e mysql-server-5.1.69-1.el6_4.x85_64 mysql-libs-5.1.69-1.el6_4.x86_64 and mysql-5.1.69-1.el6_4.x85_64 to remove them.
Just read Ronald Bradford's post on an unnecessary 3am (emergency) call. I sympathize! Running out of disk space makes for some weird MySQL behaviour, and in fact whenever I encounter weird behaviour I verify disk space.
But here's a trick I've been using for years to avoid such cases and to be able to recover quickly. It helped me on such events as running out of disk space during ALTER TABLEs or avoiding purging of binary logs when slave is known to be under maintenance.
Help, the database is on fire. Well, it probably is but the solution may also be easy. Here are a few steps for the part-time MySQL DBA/sysadmin/developer. Total time to address this solution was 2 minutes, the inability to not go back to sleep, not priceless.
First, access to the DB server is possible, and also the mysql command line client. If you are getting “Too Many Connections” read Why GRANT ALL is bad.
Given the message “the database is on fire”, the likely cause is rogue SQL.
The following simple INFORMATION_SCHEMA statement will identify and also verify tables that have no rows. These may be candidate tables to remove from your data model.
mysql --defaults-file=.my.cnf -N -e "select CONCAT('SELECT "',table_schema,'.',table_name,'" AS tbl, COUNT(*) AS cnt FROM ',table_schema,'.',table_name,';') as cmd from information_schema.tables where table_schema not in ('mysql','performance_schema','information_schema') and table_rows=0;" | mysql --defaults-file=.my.cnf -N
Davi Arnut will be speaking at MySQL Connect and is a great presenter. Do not miss this rare chance to hear him.
What are your speaking about at your session?
How InnoDB organizes and stores table data.
Who would benefit most from attending your session?
DBAs and developers interested in learning more about the finer details of how InnoDB organizes and stores data — and what are the implications of that.
One longstanding complaint I have heard for the past several years, and still hear today, is that
title="Amazon Relational Database Service (RDS)" href="http://aws.amazon.com/rds/">Amazon’s Relational Database Service (RDS) does not allow the configuration flexibility as running MySQL in an ec2 instance. While true, this ignores the consistent work that Amazon has done to provide access to the most important configuration variables needed to tune a MySQL instance (after all, how relevant is it for a customer to set
class="alignleft wp-image-17543" style="margin: 3px 9px;" alt="ibdata1 file" src="http://www.mysqlperformanceblog.com/wp-content/uploads/2013/08/ibdata1-file-300x276.jpg" width="180" height="166" />We receive this question about the ibdata1 file in MySQL very often in
title="Percona Support" href="http://www.percona.com/products/mysql-support" target="_blank">Percona Support.