Differences
This shows you the differences between two versions of the page.
| Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
| 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> | <sxh sql> | ||
| DROP USER ‘demo’@‘localhost’; | DROP USER ‘demo’@‘localhost’; | ||
| + | </ | ||
| + | ===== table size ===== | ||
| + | <sxh sql> | ||
| + | SELECT table_schema, | ||
| + | </ | ||
| + | ===== user config file ===== | ||
| + | in ~/.my.cnf | ||
| + | |||
| + | <sxh ini> | ||
| + | [client] | ||
| + | host = localhost | ||
| + | user = myusername | ||
| + | password = mypassword | ||
| + | socket | ||
| + | |||
| + | [mysqld] | ||
| + | # Performance settings used for import. | ||
| + | delay_key_write=ALL | ||
| + | bulk_insert_buffer_size=256M | ||
| </ | </ | ||
| {{tag> | {{tag> | ||