Differences

This shows you the differences between two versions of the page.

--- mysql [2021/03/23 13:26] – ssm2017
+++ mysql [2022/02/07 13:29] (current) – external edit 127.0.0.1
@@ Line 18: / Line 18: @@
 <sxh sql>
 DROP USER ‘demo’@‘localhost’;
+</sxh>
+===== table size =====
+<sxh sql>
+SELECT table_schema,round(sum(data_length+index_length)/1024/1024,4) FROM information_schema.tables WHERE table_schema = 'beta_grid' AND table_name = 'assets';
+</sxh>
+===== user config file =====
+in ~/.my.cnf
+<sxh ini>
+[client]
+host     = localhost
+user     = myusername
+password = mypassword
+socket   = /var/run/mysqld/mysqld.sock
+[mysqld]
+# Performance settings used for import.
+delay_key_write=ALL
+bulk_insert_buffer_size=256M
 </sxh>
 {{tag>cli mysql}}