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

learn more… | top users | synonyms

1
vote
2answers
3k views

innodb recovery from .ibd files

My website has crashed a few days ago. The hosting company says some innodb database crashed. They sent a MySql data folder. I tried to restore the database, but phpmyadmin is only showing MyISAM ...
2
votes
2answers
1k views

MySQL InnoDB ext3 block size

I'm looking for recommendations for ext3 filesystem block size for MySQL 5.6 using InnoDB. Running a CentOS 5.4 VM in VMware ESXi 5, VMFS 5 datastore on NetApp FibreChannel LUNs (which have 4k chunk ...
1
vote
2answers
4k views

Unknown table engine 'InnoDB' error

When I start my mysql it gives the following error on the log file. My default engine is MyIsam and I am using Innodb for a set of DB s only. 120604 12:24:49 mysqld_safe mysqld from pid file ...
3
votes
2answers
476 views

MySql Data Loss - post mortem analysis - RackSpace Cloud Server

After a recent 'emergency migration' of a RS cloud server, the mysql databases on our server snapshot image proved to be days out of date from the backup date. And yet files that were uploaded ...
0
votes
2answers
232 views

What causes “InnoDB: Corruption of an index tree” error

Today I experienced this error a second time in two weeks and I wonder why that is? Is it more a hardware- or software-related thing? (e.g. what should I check?) That DB server didn't have any ...
2
votes
2answers
386 views

Mysqld InnoDB crash

my MySQL server just crashed and I cannot restart/recover it. I've tried: /etc/init.d/mysql restart Stopping MySQL database server: mysqld. Starting MySQL database server: mysqld . . . . . . . . . . ...
-2
votes
1answer
130 views

Mysql server setup configuration [closed]

We have a new centos 6.2 setup. Below is the configuration file. The machine is going to be fully innodb and it has 8Gb ram. What else must I include in the .cnf? I know one major thing is the ...
3
votes
2answers
3k views

Why is MySQL is using so many temporary tables?

Can any configuration mistake lead to creating too many temp tables by mysql..mysql tuner shows Current max_heap_table_size = 200 M Current tmp_table_size = 200 M Of 17158 temp tables, 30% were ...
3
votes
1answer
2k views

Is it safe to modify innodb_data_file_path value for mysql 5?

I recently experienced data corruption after changing the value of this parameter in my.cnf from : innodb_data_file_path = ibdata1:10M:autoextend:max:128M to : innodb_data_file_path = ...
7
votes
2answers
14k views

How big is too big for ibdata file?

My ibdata file is very large, at least it seems to me to be very large. Is this excessive or not that bad? -rw-rw---- 1 mysql mysql 15G Apr 18 10:11 ibdata1
2
votes
3answers
90 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 ...
14
votes
4answers
30k views

Unknown/unsupported storage engine: InnoDB | MySQL Ubuntu

I recently upgraded from the previous LTS Ubuntu to Precise and now mysql refuses to start. It complains of the following when I attempt to start it: ╰$ sudo service mysql restart stop: Unknown ...
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: ...
4
votes
2answers
1k views

Disk I/O utilization up to 100% after tuning InnoDB-related MySQL configuration

I have added following lines to "my.conf": query_cache_size=128M innodb_buffer_pool_size=512M innodb_flush_method=O_DIRECT After that Disk utilization started raising, reached 100% and holds ...
0
votes
1answer
863 views

Safe conversion from one InnoDB(ibdata) file to innodb file per table

I have MySQL database with tables on InnoDB engine. But server is configured to use only one file ibdata0 without parameter innodb_file_per_table. I want to change this without making dump and restore ...
1
vote
1answer
151 views

MySQL in VMWare Ubuntu 11.10 64bit, Configuration

Can anyone suggest an optimal setting for what I'm doing? (Note that this is a one time job, after finishing my code, I'll put this back to development setting.) I am setting up a 64bit Ubuntu 11.10 ...
2
votes
3answers
6k views

Increase InnoDB buffer pool size

I am having difficulty setting the buffer pool size and log file size for MySql InnoDB. I am far from a MySql expert but have been reading around and it seems that to change this I just add these ...
0
votes
1answer
634 views

MySQL, check & enable binary logs

I am running MySQL 5.1.47 on CentOS. How do I check if binary logging for InnoDB is active? How do I enable binary logging if they are not enabled? Just run? mysqld --log-bin
1
vote
2answers
850 views

Mysql 5.5 Defragmentation not reducing the fragmentation percent

We are running OPTIMIZE TABLE , but not seeing any fragmentation reduction. They are as high as 120% to 200%. Am calculating the fragmentation % using this: Data_Free / (Data_Length + Index_Length) ...
0
votes
2answers
2k views

Huge #sql-xxxx_xxxx.ibd files in mysql-data folder

On one of our mysql databases the size on disk is way larger (28GB) than the actual data (~5GB) so I had a closer look to the files contained in mysql-data I see the following files 12K ...
0
votes
2answers
653 views

MySQL InnoDB database 'hangs'

I have a problem with a MySql server causing it to freeze all the time. In phpMyAdmin when this happens I can see in "Show Processlist" are lots of processes for User "unauthenticated user" with ...
2
votes
2answers
1k views

Setting MySQL INNODB Compression KEY_BLOCK_SIZE

I recently started using the Barracuda InnoDB/MySQL table format which allows compression. I compressed one of my tables by running: alter table pricing row_format=compressed, key_block_size=8; ...
2
votes
2answers
51 views

Does MySQL InnoDB engine use tablecache?

Does MySQL InnoDB engine use tablecache? I migrated from MyIsam to Innodb as the table engine and the monitors for "table-cache" hitrate are super low. Does Innodb use table-cache?
0
votes
1answer
299 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: ...
2
votes
1answer
192 views

MySQL crashing when trying to restore from dump

So I had a very large corrupt innodb table. mysqld would crash whenever I did a check table on it. I did a innodb-force-recovery=1 and did a dump of the table. No errors showed up. I dropped the ...
3
votes
2answers
2k views

Picking the right innodb_buffer_pool_size

I have a 24GB machine running MySQL (only InnoDB tables). My innodb data set is 11.5GB big, and i have set my innodb_buffer_pool_size to 14GB to allow some growth. So the entire innodb data set is ...
0
votes
3answers
981 views

MySQL server not starting up

I have a server running CentOS 5.5 x86_64, and have recently installed MySQL Server via YUM, but when starting the server I get: [root@server etc]# service mysqld start Warning: World-writable ...
2
votes
1answer
127 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 ...
0
votes
1answer
563 views

Moved mySQL to an EBS volume, now innoDB performs very slowly

Hello has anyone had a similar problem to this.. I've set up a new instance on Amazon EC2 for a client. I've also attached a 250GB EBS volume to hold the files and configured mySQL to use the EBS ...
1
vote
1answer
389 views

Monitoring MySQL Rollback Segments

I recently discovered the default open transaction ceiling of 1024 in MySQL. I have since increased the limit using innodb_extra_rsegments. However, I would like to keep my eye on this moving forward. ...
1
vote
1answer
612 views

Creating a raw InnoDB disk in Ubuntu 10.04 with LVM

I'm trying to create a 2TB raw partition for MySQL/InnoDB to use on one of my LVM's. I created the raw disk: Disk /dev/mapper/g0-sql: 2190.4 GB, 2190433320960 bytes 255 heads, 63 sectors/track, ...
3
votes
2answers
971 views

MySQL 5.5 InnoDB = OFF?

We run a server with MySQL 5.5. 95% of the tables are set to the InnoDB engine. However whenever I look at the my.ini file (using the MySQL Workbench) under mysqld section innodb is unchecked and OFF ...
5
votes
1answer
502 views

MySQL transaction issue with Django and Amazon RDS

I'm having a problem with a MySQL 5.5 database instance running on Amazon RDS. Periodically (once every couple of days) a transaction will fail to complete and appears to leave the tables locked. ...
2
votes
2answers
549 views

What happens to InnoDB and MyISAM tables if the power fails during a transaction?

We have two MySQL tables, one is InnoDB and the other is MyISAM. If I execute a chunk of inserts in a single transaction on both tables and the power fails in the middle, what will be the status? ...
5
votes
2answers
3k views

Way to avoid server downtime when creating Master - Slave relationship?

I am preparing for setting up a MySQL master-slave or master-master relationship. Right now I have a single MySQL production server, and of course I don't want a lot of downtime while I connect the ...
1
vote
1answer
849 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 ...
0
votes
1answer
250 views

mysql innodb broken, after hostname change

Gents, Have a mysql cluster down right now... in dev, but down nonetheless. This occurred after a hostname change on both nodes. InnoDB: Check that you do not already have another mysqld process ...
1
vote
2answers
2k 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: ...
1
vote
1answer
586 views

'Table is full' error on table with 3 rows

Every few weeks, i receive the message The table 'ttrss_users' is full from an installation of http://tt-rss.org/redmine/ (a RSS reader application written in PHP). It's always the users table ...
0
votes
2answers
606 views

I had to recover InnoDB tables from my backup, but mysql is crashing

I just recovered my InnoDB tables from my backup (copied ibdata1, ib_logfile1, ib_logfile0) However, when I start mysql now, and try to access my site with InnoDB tables, *I get these errors Got ...
12
votes
2answers
14k views

Best Mysql cache settings for 8gb RAM dedicated mysql server using only Innodb (5gb database)

I'm a pretty big noob when it comes to setting up mysql for performance. And honestly I'm not worried about the fine tuning to squeeze every last bit of performance out of mysql, but I do know that ...
0
votes
1answer
386 views

How to prevent InnoDB log files from getting corrupted?

We run a MySQL server using 600GB of storage over 4 EBS volumes on Amazon EC2. About every 2-3 weeks, the active InnoDB log file gets corrupted, and MySQL won't allow any access on those tables ...
1
vote
0answers
361 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 ...
1
vote
3answers
4k views

Plesk: libmysqlclient_16 not defined in file libmysqlclient_r.so.16

I've found this error in my logs: relocation error: /usr/lib64/libmyodbc5.so: symbol strmov, version libmysqlclient_16 not defined in file libmysqlclient_r.so.16 with link time reference ...
2
votes
2answers
1k views

Unknown table engine 'InnoDB' after deleting ibdata1 file

I was having innodb with one ibdata file. i have changed it in my.cnf to have ibd file for every table (innodb_file_per_table). then i run the following query on all of my innodb tables to have its ...
1
vote
1answer
249 views

MySQL: view read/write proportion, per specific table

I'm optimizing the configuration of a MySQL server, running only Bromine. This is non specific to application, and was just noted for completeness. I am trying to determine if switching from MyISAM to ...
3
votes
1answer
744 views

Transferring InnoDB database via rsync

We are in the process of switching to a new RAID array and need to copy our MySQL InnoDB database to the new RAID array while minimizing downtime (50GB database). I understand that using rsync on a ...
3
votes
1answer
112 views

mysql innodb problem

seeing the following in my mysql error log file: InnoDB: Error: log file ./ib_logfile0 is of different size 0 5242880 bytes InnoDB: than specified in the .cnf file 0 268435456 bytes! 110927 18:36:37 ...
2
votes
2answers
780 views

which is faster mysqldump/restore or alter table?

I have InnoDB databases and they are using the same ibdata file, the size of this ibdata is around 250G. now i have one of those DBs around 100G. My manager asked me to move this DB to another server ...
1
vote
1answer
137 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?)