Consider the following situation.
I currently have an Ubuntu installation installed in my Virtual Machine. This installation has mysql installed in it.
Data for the mysql-server can be found under;
...

Currently troubleshooting a MySQL server spending a lot of time in futex syscalls. All databases are InnoDB and seeing high load on my 16 core machine, and slightly more than half of CPU time is in ...

I got access to an existing mysqld server (5.5.35 from Debian Wheezy) with existing data in production use. I found no existing configuration file in /etc/my.cnf or /etc/mysql/my.cnf. So I copied the ...

I've got some trouble with Percona Server 5.5: suddenly abnormous MySQL CPU usage caused the system
to become unresponsive as it was eating up all CPU with a large number of threads.
It's a 24 core ...

Few days back due to electricity outage, client's system got restarted, resulted in DB rollback.
But due to this roll back, we lost around 2k existing records from various tables.( which were already ...

Performance was a little slower than I'd like on a mysql server, and we don't use replication and don't need point-in-time restores. So one recommended way to improve performance seems to be turning ...

I haven't changed any scripts or settings what so ever. Now I have CPU load at least 4 times higher. Mysqld is taking around 360 %CPU according to TOP. It's Debian, I'm running some MyISAM tables but ...

I ran into an InnoDB issue that only seemed to get worse as I tried to fix it. Started with InnoDB: Unable to lock ./ibdata1, error: 11, I moved and then copied it back. I soon had an ib_logfile issue ...

I recently discovered that the master db in a setup I'm running became corrupted. The slave was getting all of the data correctly so I have a solid backup. What I'd like to do is use replication to ...

I currently have backups that were taken with Percona XtraBackup of all my mySQL databases.
My specific scenario is that I want to restore a month old InnoDB database snapshot to my local machine for ...

We run a large forum with lots of reads and writes, particularly to the posts and topics tables which are both innodb.
Last week I started doing 12 hourly backups with innobackupex because mysqldump ...

I'm trying to configure a MySQL production server using InnoDb and I can not get the performance I want out of it. I've used Percona tools to give me the following configurations:
[mysql]
# CLIENT #
...

I have recently upgraded my CPanel server from mySQL 5.5 to mySQL 5.6 as it now supports full-text searches for InnoDB. Now, I'm not so great at mySQL so I was wondering is there anything special I ...

I recently migrated an old server running MySQL to a new VPS running MariaDB 5.5. I don't have too much running on the server (just a few PHP sites) and free memory seems to be OK, but the DB keeps ...

I have a database table, with 300,000 rows and 113.7 MB in size. I have my database running on Ubuntu 13.10 with 8 Cores and 8GB of RAM. As things are now, the MySQL server uses up an average of 750% ...

MySQL version: 5.1.63.
I am about to DROP a bigger ~8 GB InnoDB table. Last week I dropped a four times bigger table on another machine and a global lock kicked in that took us down for ~90 seconds. ...

i ran out of disk space while running an alter table on a large table. I restarted MySQL afterwards and checked the MySQL tmp dir. A show status like '%tmp%' lists 5 tmp files and 4 tmp tables. A df ...

A hard disk failure has left me trying to restore mysql from copy of "data" folder
I had dumps of "most" content but am missing some
Data folder has idbdata1 / log files / folders of .frm files
So, ...