dimanche 25 mai 2014

Création d'index mysql a échoué sur table mysql d'amazon RDS - Stack Overflow


I was trying to create index for a 100million rows table on a datatime type field called updated_date. My clause is: create index ops_index_updated on ops_data(updated_date); But I met the following problem: lERROR 1034 (HY000): Incorrect key file for table 'ops_data'; try to repair it.


I searched on google, it says the reason is the folder /tmp is full, I need to delete this folder. But I'm using amazon RDS mysql, how can I logon the server to delete the folder?



I was trying to create index for a 100million rows table on a datatime type field called updated_date. My clause is: create index ops_index_updated on ops_data(updated_date); But I met the following problem: lERROR 1034 (HY000): Incorrect key file for table 'ops_data'; try to repair it.


I searched on google, it says the reason is the folder /tmp is full, I need to delete this folder. But I'm using amazon RDS mysql, how can I logon the server to delete the folder?


0 commentaires:

Enregistrer un commentaire