Recently, when performing a slew of alter table statements, I had to do some checking to verify, that I had not completely destroyed my database.
From unix commandline
$ mysqlshow --status my_table
From mysql commandline
> SHOW TABLE STATUS FROM my_database;
> FLUSH TABLES;
> SHOW INDEX FROM my_table;
> ANALYZE TABLE my_table;
> CHECK TABLE my_table;
> OPTIMIZE TABLE my_table;
> DESCRIBE my_table
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment