recreate the table with the index.
This procedure will require some downtime of your sql-server. However - this should work.
Follow the steps to backup/drop/create and restore your table:
1) Create a backup of your table:
bash> mysqldump mydb large_table > large_table.sql
2) Modify the...
I'm running mySQL 3.22.27.
A table in my DB contains 190,000 entries.
The table is accessed aproximately by 1.48 users a second.
Every 5 - 15 minutes the table gets damaged, so that
isamchk -a table1 returns:
- check record links
isamchk: error: Wrong bytesec: 0-0-0 at linkstart: 12202079...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.