4218680
Description
Mind Map by Jason Barlow, updated more than 1 year ago
|
Created by Jason Barlow
over 8 years ago
|
|
MySQL
- DB Parameters
- mysqld --verbose --help
- SHOW VARIABLES;
- Changing
Server params
- Startup: mysqld
--query_cache_size=16M
--max_allowed_packet=1G
- SET GLOBAL max_allowed_packet=16M;
- SET commands
- Startup: mysqld
--query_cache_size=16M
--max_allowed_packet=1G
- mysqld --verbose --help
- client connect
- mysql -h host -u <user> -p
- mysql -h host -u <user> -p
- Tables, Indexes
- table info
- INFORMATION_SCHEMA
- describe <table_name>
- show tables
- INFORMATION_SCHEMA
- table info
- locking
- SHOW ENGINE INNODB STATUS
- SHOW ENGINE INNODB STATUS
- Logging, Recovery
- Binary Log
- Binary Log
- Stored Procedures, Cursors
- create
procedure/function
- create
procedure/function
- Storage Engines
- innodb(oracle recommends)
- myisam
- innodb(oracle recommends)
- Performance
Want to create your own Mind Maps for free with GoConqr? Learn more.