Project

General

Profile

Anomalie #1401

taille de la table des logs de sympa

Added by Vincent-Xavier JUMEL almost 10 years ago. Updated almost 3 years ago.

Status:
Fermé
Priority:
Faible
Assignee:
François Poulain
Category:
-
Target version:
-
Start date:
10/29/2013
Due date:
% Done:

0%

Estimated time:
Spent time:
0.50 h
Difficulté:
2 Facile

Description

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

History

#1

Updated by Vincent-Xavier JUMEL almost 10 years ago

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

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

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.

#4

Updated by Christian P. Momon almost 3 years ago

  • Assignee set to François Poulain

Also available in: Atom PDF