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

learn more… | top users | synonyms

1
vote
2answers
2k 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
2answers
885 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
420 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
167 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 ...
-1
votes
2answers
50 views

Removed ib files to make mysql start but now it does not recognize tables

I had problem starting innodb and read somewhere that deleting ib_logfile0,ib_logfile1 files works. It worked and mysql started again and when I use "Show tables" it shows all tables of my database ...
3
votes
1answer
601 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
98 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
9k 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 ...
2
votes
1answer
140 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 ...
1
vote
1answer
16 views

How to exclude specific table from innodb buffer pool?

Here's my situation. I have one really large table that holds about 90 GB of data. I've utilized DATA DIRECTORY to place that table on another drive, as I rarely use the table and don't want it ...
1
vote
1answer
105 views

How to tune MySQL server when big peak of usage is expected

I'm having pretty big issues trying to tune my MySQL server. I was expecting a lot of people on my website after buying a tv ads between 5pm and 6pm, I have more or less 300 persons at the time on the ...
1
vote
1answer
3k 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
43 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
207 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
402 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
142 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
108 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
208 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
51 views

MariaDB refuse to start after VServer reboot

After I rebooted my VServer, MariaDB refuses to start. This are the error messages: # systemctl status mysql.service ● mysql.service - LSB: Start and stop the mysql database server daemon Loaded: ...
0
votes
1answer
273 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 ...
0
votes
1answer
17 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
69 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
189 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
552 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
602 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
603 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
422 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
356 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
297 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
708 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, ...
-1
votes
1answer
93 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 ...
2
votes
0answers
189 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 ...
2
votes
0answers
4k 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
186 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
611 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
459 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
492 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
180 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
288 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
414 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
22 views

InnoDB table takes more than 1 second for insert query

during an insertion it takes about an second for sometimes (not always) in MySQL 5.6.17-log which is causing performance issue How to over come this issue current set of parameters for innodb ...
0
votes
0answers
78 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 ...
0
votes
0answers
24 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
0answers
109 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
0answers
27 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
0answers
347 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
212 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
359 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
636 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
300 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 ...