Anomalie #1401
taille 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)
History
Updated by Vincent-Xavier JUMEL almost 10 years ago
- Project changed from Libre en Fête to Admins
- Difficulté set to 2 Facile
Updated by Vincent-Xavier JUMEL almost 10 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 almost 7 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.