MYSQL PERFORMANCE TUNING PRIMER and MySQLTuner 1.1.1

Currently viewing the tag: "tuning"

How to view MySql running resources

By juzhax On August 28, 2010 · 1 Comment · In Linux

If your server’s mysql always in high resources or down, I suggest you use this command to trace out which database that eat up your MySql resource

/usr/bin/mysqladmin proc stat
/usr/bin/watch -n 5 ‘mysqladmin proc stat’

Every 5.0s: mysqladmin proc stat [...]

Continue Reading →

MYSQL PERFORMANCE TUNING PRIMER and MySQLTuner 1.1.1

By juzhax On April 22, 2010 · 1 Comment · In Linux

[root@server src]# ./tuning-primer.sh
– MYSQL PERFORMANCE TUNING PRIMER –
- By: Matthew Montgomery -
MySQL Version 5.0.88-community-log i686
Uptime = 22 days 18 hrs 12 min 36 sec
Avg. qps = 14
Total Questions = 28279137
Threads Connected = 4

Some people search for:MYSQL PERFORMANCE TUNING PRIMERmysqltuner windowsConfigured Max Per-thread Buffersmysqltuner vstuning primermysqlwindowstuner-primer shmysql tuner windowsmysql tuning primer windowsmysqltuner for windowsmysqltuner tmp_table_sizemysqltuner 1 [...]

Continue Reading →