I have a 19GB archive table that is working as expected on one server. I copied the following 2 files to another server. The table is not working on the new server.
The first server version is 5.5.22-log MySQL Community Server (GPL) by Remi The second server version is: 5.5.20 MySQL Community Server (GPL)
What can be the reason? When I used mysqlshow db_name it would list the table, but when I use --count I do not get count. Instead I get "Opening tables" state for command Field list.
mysql seems to be writing to the ARN file...
Is this one time optimization? How do I improve the speed of ARN file creation?