Tagged Questions

5
votes
1answer
592 views

MySQL INNODB corruption after server crash during concurrent truncate command

My server crashed today I think due to a concurrent truncate table command on one of our INNODB tables. The server could be restarted, but after it starts up, everytime I try to issue an SQL command, ...
2
votes
1answer
290 views

MySQL 5.5 : (InnoDB) - Manually edited an .ibd file to test recovery, now entire MySQL installation is broken!

So I wanted to test MySQL recovery from Innodb corruption. file-per-table is enabled. I have a few test db's on the MySQL instance. I shutdown mysql. Manually edited/added random characters to an ...
3
votes
1answer
516 views

Innodb, MySQL 5.5.28 - Segmentation Signal 11 faults, on high load. .. my.cnf file included

We have a high-end server, 128GB RAM, 32 Core , Xeon, SSD RAID 10 - running Ubuntu 12.04 with MySQL 5.5.28 . Doing random imports to large InnoDB tables, over 50+ gigs, randomly after a few hours of ...
5
votes
1answer
3k views

intermittent MySQL crashes with error “Fatal error: cannot allocate memory for the buffer pool”

I'm a beginner system administrator for a small virtual server. The main function of the server is to run the open-source Moodle course management system software, written in PHP. It relies on a ...
7
votes
1answer
2k views

MySQL InnoDB crash post-mortem

MySQL crashed on me this morning. With the exception of the standard MySQL included databases everything I use is InnoDB. I attempted to restart the MySQL daemon but it failed twice. I then ...