InnoDB is the main ACID-compliant Storage Engine used in MySQL.

learn more… | top users | synonyms

2
votes
1answer
8k views

Server crashed, some MySQL databases are broken. Trying to recover with InnoDB recovery, but ibdata1 seems corrupt

I've a problem. Some days ago my root server crashes after a power outage. I realised that the MySQL server won't start. In the logs I find out that an error occured with InnoDB's ibdata1. I've ...
0
votes
2answers
1k views

Troubleshooting MySQL Performance Issues

Environment: 1 physical machine 8GB RAM some older Core2Duo CPU 1 HDD Windows Vista 64 bit 1 Virtual Machine 16 GB RAM 2 vCPUs Windows 7 64bit Both machines running MySQL 5.5.28 (64Bit) with ...
0
votes
0answers
18 views

InnoDB causing mysqld to crash on Amazon Linux AMI

This Amazon Linux server is running a single WordPress site that is constantly crashing. The way to resolve it seems to be to run service mysqld restart and it resumes operation until it crashes ...
1
vote
1answer
28 views

MySQL keeps crashing at unknown intervals

Version: '5.1.73' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source distribution 160130 08:29:38 mysqld_safe Number of ...
1
vote
1answer
2k views

Recover mysql database innodb 'table doesn't exist'

Our server crashed last week and we lost a lot of information. We were able to recover .frm files for the tables, ib_logfile0, ib_logfile1 and ibdata1 but no .ibd. I've tried the ...
0
votes
1answer
42 views

Mysql innodb_buffer_pool_size in relation to innodb_buffer_pool_instances

I run a virtual server with an Owncloud installation on it. Now Owncloud has the problem that the way it's developed at the moment, each file upload causes a little MySql overhead. So is very ...
3
votes
1answer
2k views

InnoDB “log sequence in the future!” crashing, won't start

I stopped mysql only to find that it wouldn't come back up, /etc/init.d/mysql start only outputs . . . . . . failed. I've narrowed it down to an issue with InnoDB. The database starts when ...
-1
votes
2answers
2k views

Cannot drop index from MySQL INNODB table with foreign keys/references

I'm about to drop an index from a mySQL INNODB table. There are references defined already. When I try to alter it, it says: #1025 - Error on rename of 'X/#sql-2a5f_219828' to 'X' (errno: 150) ...
1
vote
2answers
1k views

large number of InnoDB tables plus SHOW TABLE STATUS

We've got several hundred InnoDB tables in a database, and we use phpMyAdmin to manage them. Unfortunately, phpMyAdmin does a SHOW TABLE STATUS query whenever the list of tables is shown, and this ...
1
vote
2answers
1k views

How can I lower MySQL single-page reads?

My innodb buffer pool size is 8GB and my database is 6GB in size but I see this: Innodb_buffer_pool_reads 263.5k - The number of logical reads that InnoDB could not satisfy from buffer pool and had ...
0
votes
0answers
18 views

InnoDB file per tablespace

I am using following syntax to create innodb table: create table InnoDB_Test(a INT) DATA DIRECTORY='/var/log/storage/MySQL' INDEX DIRECTORY='/var/log/storage/MySQL' engine=InnoDB; I want to create ...
0
votes
1answer
25 views

how to prevent Innob db spiking at 97% Disk I/O Utilization

Our database(InnobDb) is spiking at 99% I/O at random times. After the spike it goes down to about 2% until it spikes agian. There are not some "super" queries that are running in these intervals. We ...
9
votes
5answers
7k views

Modifying columns of very large mysql tables with little or no downtime

I periodically need to make changes to tables in mysql 5.1, mostly adding columns. Very simple with the alter table command. But my tables have up to 40 million rows now and they are growing fast... ...
0
votes
0answers
6 views

Unable to enable Barracuda in MySQL 5.5 [duplicate]

How do you enable Barracuda on MySQL 5.5 running on Ubuntu 14? I recently did a fresh install of Ubuntu 14, and after I install mysql-server I tried to enable Barracuda. In Ubuntu 12, all I had to ...
3
votes
1answer
4k views

MySQL (MariaDB) crashes frequently

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 ...
0
votes
0answers
78 views

InnoDB settings - mysql tuner results after running for awhile

Newbie as far as InnoDB goes, but I installed MySQLTuner awhile back and according to this it looks like I need to adjust my settings, but can someone chime in with some deeper understanding of all ...
0
votes
1answer
75 views

MariaDB won't start - fails to check integrity

I have a MariaDB installed with brew in my macbook. Worked fine till today. All of a sudden it wound not start: -> mysql.server start Starting MySQL ERROR! also, if I issue mysql -uroot or any ...
0
votes
3answers
43 views

Mysql master slave replication fail PID error

I have Master on 5.6 & Slave on 5.5, this will be the test ENV to check if 5.6 can replicate on 5.5 on PROD. I am getting this below error when starting mysql ERROR! MySQL server PID file ...
5
votes
1answer
1k views

MySQL and large pages/hugetlb performance gain in numbers?

MySQL has large page/hugetlb support for InnoDB. And there's plenty of posts (example) on the topic. But does anyone have examples of what performance changes they saw ? I have seen other database ...
-1
votes
1answer
64 views

mySQL keeps crashing with a specific Wordpress theme enabled

nice people ;) I have a problem with my server after I setup a new theme on one of my wordpress sites. At first mySQL started to crash once in a while, then it became more and more often and now you ...
0
votes
3answers
66 views

moving live innodb db from one server to another

I need to move an innodb db from one server to another - it is also going from mysql > mariadb. I want to ensure there are no problems at all and with that I will be using mysqldump to export and ...
0
votes
0answers
25 views

After update and reboot mysql do not start on debian Wheezy

I've been rebooting my VM and I had before a mysql update and I can't start mysql server tail -f /var/log/mysql.err InnoDB: You can disable Linux Native AIO by setting innodb_use_native_aio = 0 in ...
0
votes
1answer
123 views

Unusually high RDS MySQL memory

could use your help in understanding this. I'm running an RDS MySQL instance (db.m3.large on SSD) with 100GB of storage. I'm a little freaked out that my memory is 50% there: I must be doing ...
0
votes
2answers
802 views

MySQL fails to start with one config line change - innodb_buffer_pool_size = 1G

My curent config works great but my innodb_buffer_pool_size is too small as the database is very large. All I am changing in my MySQL.cnf is innodb_buffer_pool_size = 1G to ...
3
votes
3answers
8k views

1286 - Unknown storage engine 'InnoDB'

I am trying to use roundcube and it recently just broke. I don't know if this is due to a MySQL update that happened recently or not but in phpMyAdmin I get the following error if I try and view a ...
1
vote
1answer
19 views

Examine MySQL INNODB folder

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; ...
0
votes
1answer
30 views

Why mysql don't start in ubuntu server?

I edit mysql config for remote connect, I paste there bind_address = 0.0.0.0 After it i tryed to restart (sudo /etc/init.d/mysql restart or start) but I see fail of it in both commands. in logs ...
2
votes
1answer
642 views

MySQL innodb recovery from datafiles

Last night, my MySQL server crashed and now I have several databases, which data I'm unable to recover. According to errorlog, the coruptions in tablespaces happend quite a while ago (few months), ...
0
votes
1answer
6k views

MySQL failed to start. Error 1053. Windows Server 2008 R2

I did a server restart for my web server and on restart, MySQL won't start. If I use taskmanager to kill mysqld.exe and try the start from services console, it gets about 50% through the startup, ...
0
votes
2answers
16k views

Optimal MySQL my.cnf setting for large Magento site on a dedicated server

Our dedicated server is running a large Magento store with a MySQL database approximately 250MB in size. The server spec is listed as having 5 Xeon 2Ghz processors (4MB cache) and 12GB of memory. ...
0
votes
2answers
562 views

InnoDB: mmap(68878336 bytes) failed; errno 12

The screenshots explain everything, first I try to start it, and it won't, so I check the status, then I check the logs. After following a number of previous suggestions that I founder around ...
2
votes
0answers
156 views

MySQL (InnoDB) - processes waiting on futex

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 ...
4
votes
7answers
7k views

Is there any equivalent of mysqlhotcopy for InnoDB?

Currently I'm using mysqldump to make backups which is slow, but OKish. The big problem is restoring database, which takes a few days. The dump is around 7GB gzipped, so it's not a tiny database, but ...
5
votes
1answer
172 views

How to drop an 8 GB InnoDB table smoothly without global locks

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. ...
0
votes
0answers
246 views

Creating my.cnf leads to error with innodb

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 ...
0
votes
2answers
59 views

MyISAM Throughput spike at 12000 record insert

I am testing database performance with bulk record inserts. Both systems are identical apart from storage engine **Database 1000 4000 12000** MySQL_InnoDB 60.95330976 ...
19
votes
6answers
13k views

MySQL InnoDB - innodb_file_per_table cons?

By default MySQL InnoDB stores all tables of all DBs in one global file. You can change this by setting innodb_file_per_table in the config, which then creates one data file for each table. I am ...
17
votes
5answers
7k views

What is the difference between InnoDB and MyISAM?

I am using MySQL as my database for my current web project. I am new to MySQL. Please explain to me the difference between InnoDB and MyISAM.
2
votes
3answers
5k views

How to detect if InnoDB has pool size big enough?

I found out how much the innodb pool size has allocated memory from show innodb status but I couldn't figure out how much actually it uses. Maybe it needs more or I can take some memory off from it? ...
2
votes
3answers
97 views

Innodb statistics

We're running InnoDB as a MySQL engine and using phpMyadmin to administer our database. Under Status → Query statistics, phpMyadmin gives us the following: We would like to know where these figures ...
7
votes
3answers
16k views

Simpler way to convert all tables from InnoDB to MyISAM

Previously, I use this: USE dbname; ALTER TABLE tablename ENGINE=MYISAM; I'm looking for simpler way to convert all tables in a database, rather than writing every table name one by one
1
vote
2answers
3k views

InnoDB recovery

My MySQL server run to crash due to (page file write error). I did a disk diagnosis but no errors found. I restarted MySQL server. It scanned the bin log like for 1-2 hours and recorded log as below: ...
0
votes
2answers
5k views

MySQL server crashes InnoDB

Today we got some DB crash. The DB is InnoDB. At firstin log: 120404 10:57:40 InnoDB: ERROR: the age of the last checkpoint is 9433732, InnoDB: which exceeds the log group capacity 9433498. InnoDB: ...
2
votes
2answers
846 views

No changes made but MySQL InnoDB overloading CPU

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 ...
16
votes
5answers
3k views

How do you choose a MySQL database engine

In particular, how do you choose between MyISAM and InnoDB, when neither is missing a required feature (e.g. you don't need foreign keys). Does it always come down to trying both and measuring? Or ...
0
votes
1answer
16 views

innodb files in wrong directory

I have created a database called TEST with innodb tables. When I look in the /var/lib/mysql/TEST directory I see a .frm file for each table. However, there are no .ibd files in that directory. The ...
4
votes
1answer
1k views

innodb memory usage mysql

I have a small vps, with only 256mb of ram, with maximum burst up to 512mb. When I configure my vps without innodb, it only uses 130 mb of ram, so that is no problem for me. But when I turn on innodb, ...
1
vote
1answer
2k views

Reducing memory usage of MySQL

Conclusion: if you really want to use little memory out-of-the-box drop MySQL and use PostgreSQL: it has a ~30Mo memory footprint, i.e. more than 10x less than MySQL; the migration was quite easy be ...
0
votes
0answers
182 views

MySQL/Percona Server sudden CPU usage spikes

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 ...
7
votes
1answer
4k views

How to disable keys in MySQL InnoDB tables?

Is it possible to disable keys in InnoDB tables? If yes, how? If not, why?