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

learn more… | top users | synonyms

2
votes
2answers
7k 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 ...
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 ...
1
vote
2answers
919 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 ...
0
votes
2answers
133 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 ...
0
votes
2answers
336 views

MySQL's InnoDb performance downfall

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 # ...
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
2answers
1k 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) ...
0
votes
2answers
161 views

mysql error InnoDB: 13

mysql not started @ server boot automatically but I can start manually as long as log as user "mysql" by using "/etc/init.d/mysql.server" the error I got on the log is InnoDB: Operating system error ...
4
votes
1answer
931 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 ...
3
votes
1answer
378 views

High CPU on MySql Fusion-io server

I've just finished reading this old Q&A which had some really good detailed information on a similar setup to ours, though unfortunately our problem (now) is not with replication. MySQL ...
3
votes
1answer
96 views

InnoDB erratic performance

I'm doing some tests with a really simple InnoDB table (named Test) with the following structure: Id int(10) unsigned NOT NULL AUTO_INCREMENT UserId int(10) NOT NULL Body varchar(512) COLLATE ...
2
votes
1answer
135 views

mysql Innodb engine disappear

I had to change the tmpdir directory from /tmp to /db/tmp/ folder due to the fact I didn't have enough space. When I changed my path and I ran SHOW ENGINES; I got below result; ARCHIVE MRG_MYISAM ...
2
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
vote
1answer
248 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 ...
1
vote
1answer
38 views

Innodb tables not showing

If I run query show table in mysql console, the innodb tables will be listed. But when I tried a query like select * from tablename, it says table does not exist. How can I fix this issue and make ...
1
vote
1answer
158 views

Does adding a foreign key constraint in MySQL cause a table rebuild?

I need to alter a large table in order to add a foreign key. Does adding the constraint cause the table to be rebuilt? The referenced table already exists and has an index on the column.
1
vote
1answer
350 views

Issue with percona-xtrabackup-2.0.0 hotbackup on MyIsam tables

I am trying to implement hot backup for MyIsam tables with "percona-xtrabackup-2.0.0" and getting the following error? As the all tables are MyIsam I doubt am I using the correct package ? Backup ...
1
vote
1answer
140 views

Can I use a newer InnoDB plugin in Ubuntu MySQL?

The MySQL that comes with Ubuntu 10.04.2 is 5.1.41, which is distributed by MySQL with InnoDB 1.0.5. But for some reason Ubuntu ships it with InnoDB 1.0. Can I install InnoDB 1.0.5 (or newer?)
1
vote
1answer
103 views

MySQL - Best Engine(s) for 2 Tables - One running heavy updates, 1 keeping a 15 minute log

I have a system where users are submitting work to my server frequently. With 1500 active at one time, it's about 6000 units of work being submitted per minute. I've been using one large table to ...
1
vote
1answer
203 views

What will happen if MySQL cannot write to InnoDB log?

What happens to MySQL if the partition that contains InnoDB's log files (innodb_log_group_home_dir) becomes full, read-only or otherwise unwritable? If this did happen, what recovery process would ...
0
votes
1answer
15 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 ...
0
votes
1answer
93 views

mysql server mostly stops working when binlog disabled

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

Restore InnoDB to different machine

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

mysql: unknown option '--skip-innodb'

In trying to disable innodb by adding this to mysql config [mysql] skip-innodb But I get the error shown in title.. I also tried to change [mysql] to [mysqld] with no luck. SHOW ENGINES: ...
0
votes
1answer
447 views

innobackupex - after restoring - quit without updating PID file

After restoring a backup the server can't start.. command line tar -izxf /var/bak/db/2013-11-16-2300_mysql.tar.gz -C /var/bak/db_import innobackupex --defaults-file=/var/ini/my.cnf --use-memory=1G ...
0
votes
1answer
423 views

MySQL tmp tables: how to clean up diskspace after killing a copying to tmp table process?

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

Get mysql database from raw files

My root access linux server has crashed and I cannot SSH into it or interact with it. I can, however tell the online console to do a network boot to a "rescue system" which allows me to access the ...
0
votes
1answer
463 views

Issue with InnoDB engine while enabling and [ skip-innodb ] - [ERROR] Plugin 'InnoDB' init function returned error

In production server as of now we are running with MyIsam tables only, hence we have disabled the innodb engine with skip-innodb option. But now onwards we need to enable the innodb engine as well for ...
0
votes
1answer
365 views

installing mysql innodb engine on redhat box

I'm using SL6.1 on an X86-64 server box. For whatever reasons, it looks like the stock RHEL-anything is not going to be including the mysql innodb engine anytime in the foreseeable future: ...
0
votes
1answer
302 views

Mysql : Cannot create Index:

Hi all we are having trouble to create/drop index(s) on a table I keep getting the following error: ERROR 1280 (42000): Incorrect index name '<>' Now the table has the following: 1. PRIMARY ...
0
votes
1answer
261 views

A Most Puzzling MySQL Problem: Queries Sporadically Slow

This is the most puzzling MySQL problem that I've encountered in my career as an administrator. Can anyone with MySQL mastery help me a bit on this?: Right now, I run an application that queries my ...
0
votes
1answer
614 views

MySQL ibdata1 permissions error on cloned EC2 instance

I am trying to get a Rails app running on a cloned EC2 instance and am running into some permissions issues with my ibdata1 file. On the original instance, everything behaves as expected. However, ...
2
votes
0answers
3k views

Temporary MySQL Error: 1286 Unknown storage engine 'InnoDB'

I operate a cPanel/WHM server on CentOS 5.8 which is running MySQL 5.5.24. It seems that ever other week or so, some clients websites exhibit the following error: SQLSTATE[42000]: Syntax error or ...
1
vote
0answers
44 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 ...
1
vote
0answers
138 views

mariadb 5.5.36 with innodb plugin

I installed mariadb 5.5.36 on a win32 system. Everything runs fine except innodb requests are 2 x slower than an identical MySQL installation. So I want to switch back to original innodb plugin to ...
1
vote
0answers
480 views

MySQL 5.5 : Cannot drop database : Lost connection to MySQL server during query

After a huge crash of my mysql database, I've made a recovery, all is ok except one schema. In phpMyAdmin, this schema doest not cotains any tables, but we i ask mysql to drop the schema (drop ...
1
vote
0answers
416 views

InnoDB restore from ibdata: “mysql post-start process terminated with status 1”

I discovered way too late that the backup script for our MySQL databases wasn't working properly. Namely, when the disk on the server had already started to fail, and I logged in via SSH and got a ...
1
vote
0answers
427 views

mysqld service crashes on restart, after importing mysqldump #innodb

I have 2 mysql servers. Let's call them server01 & server02. Both have the same configuration: mysqladmin Ver 8.42 Distrib 5.1.61, for redhat-linux-gnu on x86_64 [client] ...
1
vote
0answers
153 views

Simple UPDATE query with (sometime) long query times

I run a dedicated MySQL server (2 cores, 16GB RAM) serving 100-200 requests per second. It is getting sluggish during peak traffic and I have a hard time optimizing the server. So I'm looking for some ...
1
vote
0answers
273 views

Mysql innoDB corruption after server crash

Yesterday my server died because an outage in the data center. Today it's back up, but having some problems with mysql. First of all my mysql server was not able to start. For this reason I deleted ...
1
vote
0answers
398 views

MySQL InnoDB: Assertion failure ibuf0ibuf.c line 4185 unrecoverable data crash

I get this assertion failure on MySQL 5.5.15 version. Here are the MySQL server errors: 110927 21:56:51 InnoDB: Assertion failure in thread 1126107456 in file ibuf0ibuf.c line 4185 InnoDB: Failing ...
0
votes
0answers
112 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
0answers
117 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 ...
0
votes
0answers
277 views

How to restore a corrupted MySQL master database from a slave database?

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

MySQL 5.6 Create Table VERY slow

I recently upgraded my MySQL server from 5.1 to 5.6 (running on CentOS 6.x). Ever since the upgrade, when I try to perform certain table tasks the queries take a REALLY long time. This is really ...
0
votes
0answers
203 views

MySQL Tables Disappearing

We're having some issues of tables "magically" disappearing. Here is the log file leading to the point of what seems to be the point of the table disappearing: 131103 9:08:39 InnoDB: Error: table ...
0
votes
0answers
191 views

Import large InnoDB table dump

i've a mysqldump ( 1.5G large ) of a table I need to import. The server i bought, which is clean and not under load, takes > 2hours to import it. I read many tweaks i can use to speed up the import ...