Actions
Anomalie #1401
closedtaille de la table des logs de sympa
Difficulté:
2 Facile
Description
mysql> select count(*) from logs_table ; +----------+ | count(*) | +----------+ | 32953 | +----------+ 1 row in set (0.00 sec)
Updated by Vincent-Xavier JUMEL about 11 years ago
- Project changed from Libre en Fête to Admins
- Difficulté set to 2 Facile
Updated by Vincent-Xavier JUMEL about 11 years ago
- Status changed from Nouveau to Un jour peut-être
- Priority changed from Normale to Faible
http://stackoverflow.com/questions/9620198/how-to-get-the-sizes-of-the-tables-of-a-mysql-database
mysql> select table_name as "Table", round (((data_length + index_length) /1024 / 1024),2) "Size in MB" from information_schema.TABLES where table_schema = sympa and table_name = "logs_table"; ERROR 1054 (42S22): Unknown column 'sympa' in 'where clause' mysql> select table_name as "Table", round (((data_length + index_length) /1024 / 1024),2) "Size in MB" from information_schema.TABLES where table_schema = "sympa" and table_name = "logs_table"; +------------+------------+ | Table | Size in MB | +------------+------------+ | logs_table | 11.33 | +------------+------------+ 1 row in set (0.00 sec)
À regarder un jour, peut-être
Updated by François Poulain about 8 years ago
- Description updated (diff)
- Status changed from Un jour peut-être to Fermé
Je ne comprends pas le soucis. Depuis sympa a été réinstallé d'ailleurs.
Updated by Christian P. Momon almost 4 years ago
- Assignee set to François Poulain
Actions