0
votes
2answers
219 views

MySQL: Increased buffer pool, ibdata1 corrupt?

I tried increasing innodb_buffer_pool_size via my.cnf from default 128m to 256m, but on restart attempt, mysql shutdown failed with: 130125 11:49:55 InnoDB: Initializing buffer pool, size = 256.0M ...
2
votes
1answer
211 views

Which is more durable? MyISAM or InnoDB with innodb_flush_log_at_trx_commit=0 [closed]

I am trying to determine the difference in durability between MySQL's MyISAM and InnoDB when innodb_flush_log_at_trx_commit=0. I am aware of the some of the benefits of InnoDB with ACID. However, ...
1
vote
2answers
470 views

Copying /var/lib/mysql files over resulted in InnoDB corruption

My server had to be re-installed yesterday so they replaced the hard drive and hooked the old one up via USB. I grabbed the database files (/var/lib/mysql) and downloaded them and then I erased all ...
1
vote
1answer
312 views

MySQL InnoDB random data corruptions: hardware or software errors?

I'm an administrator of a social game which uses MySQL(Percona 5.1.56 to be precise) for data storage(all tables have InnoDB type). There are about 2 millions of players in the game and database size ...