wiki SebMas

User Tools

Site Tools

You are here: All pages » mysql
mysql

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}}
mysql.1488967178.txt.gz · Last modified: (external edit)