Zusammenfassung der Ressource
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
- client connect
- mysql -h host -u <user> -p
- Tables, Indexes
- table info
- INFORMATION_SCHEMA
- describe <table_name>
- show tables
- locking
- SHOW ENGINE INNODB STATUS
- Logging, Recovery
- Binary Log
- Stored Procedures, Cursors
- create
procedure/function
- Storage Engines
- innodb(oracle recommends)
- myisam
- Performance