BrnDmp

MySQL performance tuning

tried to optimize mysql DB performance on server. Especially when querying groups and users there is a high load on the database.

To show the type of DB-engine used for a database (and performance vars):

• SHOW TABLE STATUS FROM db_name;
• SHOW STATUS;
• SHOW VARIABLES;

Set key_buffer = 256M and user queries went much faster, especially when running for a second time. got info from this thread: Mysql server tweaking basics.

Checking for good value of max_connections: set to 200.

Some debian article on mysql performance.