Project

General

Profile

Actions

Anomalie #1401

closed

taille de la table des logs de sympa

Added by Vincent-Xavier JUMEL about 11 years ago. Updated almost 4 years ago.

Status:
Fermé
Priority:
Faible
Category:
-
Target version:
-
Start date:
10/29/2013
Due date:
% Done:

0%

Estimated time:
Spent time:
Difficulté:
2 Facile

Description

mysql> select count(*) from logs_table ;
+----------+
| count(*) |
+----------+
|    32953 |
+----------+
1 row in set (0.00 sec)
Actions #1

Updated by Vincent-Xavier JUMEL about 11 years ago

  • Project changed from Libre en Fête to Admins
  • Difficulté set to 2 Facile
Actions #2

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
Actions #3

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.

Actions #4

Updated by Christian P. Momon almost 4 years ago

  • Assignee set to François Poulain
Actions

Also available in: Atom PDF