Tagged Questions
0
votes
1answer
49 views
How can extract the table schema from just the .frm file?
I have extracted the data directory of mysql from a backup and need to get the schema from an old table, however it's a backup from a different machine.
I have read a fair number of tutorials today ...
1
vote
1answer
54 views
Table corruption: How to perform Innodb Checksum checks in MySQL 5.5 for Windows?
Having a corrupted Mysql 5.5.31 (Windows) database, my question relates to the the top solution provided in How do you identify InnoDB table corruption? , more precisely to the following script that ...
1
vote
1answer
269 views
How to recover data from corrupted innoDB table from a crashed mySQL server?
Some background:
I had a MySQL server running on Ubuntu Server. I don't remember which versions they were running but it was likely a Ubuntu 12.04 with MySQL 5.5. During the course of a day, ...
1
vote
1answer
224 views
MySQL InnoDB logfiles resized - review mysql-err.log for potential problems
I restarted mysqld this morning, to increase the size of the innodb logs and increase the amount of memory allocated to the innodb buffer pool. (MySQL 5.1.53-Community on Ubuntu)
To increase the ...
3
votes
0answers
104 views
“InnoDB: error clustered record for sec rec not found” MySQL 5.5.28
We have a high-end server, 128GB RAM, 32 Core , Xeon, SSD RAID 10 - running Ubuntu 12.04 with MySQL 5.5.28.
During high load, randomly we got the below error.
MySQLcheck, innochecksum shows no ...
2
votes
1answer
319 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
593 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 ...
2
votes
1answer
153 views
Recovering from a stuck query
I have a big DELETE query (deleting 20M rows from a 600M row table with condition according to indexed column) that is stuck - running already for 17hrs. Because it's an InnoDB table, killing it will ...
2
votes
3answers
3k views
ERROR Cannot find or open table?
MySQL version: 5.5.24
Due to the following problem:
mysql> desc reportingdb.v3_zone_date_cpm7k;
ERROR 1146 (42S02): Table 'reportingdb.v3_zone_date_cpm7k' doesn't exist
...
2
votes
1answer
5k views
MySQL: InnoDB keeps crashing - how to recover?
# free -m
total used free shared buffers cached
Mem: 48289 35288 13000 0 347 30399
-/+ buffers/cache: 4541 43747
...
