User Tools

Differences

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

Link to this comparison view

Next revision		Previous revision
mysql [2017/03/08 10:59] – created ssm2017mysql [2022/02/07 13:29] (current) – external edit 127.0.0.1
Line 1: Line 1:
 +====== mysql ======
 ===== Add a user ===== ===== Add a user =====
 [[https://www.digitalocean.com/community/tutorials/how-to-create-a-new-user-and-grant-permissions-in-mysql|source]] [[https://www.digitalocean.com/community/tutorials/how-to-create-a-new-user-and-grant-permissions-in-mysql|source]]
Line 17: Line 18:
 <sxh sql> <sxh sql>
 DROP USER ‘demo’@‘localhost’; 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> </sxh>
 {{tag>cli mysql}} {{tag>cli mysql}}

This website uses cookies. By using the website, you agree with storing cookies on your computer. Also, you acknowledge that you have read and understand our Privacy Policy. If you do not agree, please leave the website.

More information