Another area to look at for performance gains is the disk drive. A faster disk provides faster results. If
you have a table that is accessed a lot, you may want to put that table on its own disk. This will speed
things up immensely. Setting up a multiple-disk environment is beyond the scope of this book. The
MySQL online documentation contains all the information that is needed to accomplish this task.Setting System Variable
After you have the best hardware, the next easiest spot is to start tweaking the actual database system.
There are a bunch of variables that control how MySQL operates. To check your current configuration, follow
these steps:
- Make sure you are in the mysql directory and that the server is currently running
(the mysqld daemon). - Enter the following command:
- bin/mysqladmin –p variables
- You will be prompted for the root password. Enter the password. You should see
output similar to Table 20.1.
Table 20.1 MySQL System Variables
Variable Name Value
back_log 5
connect_timeout 5
basedir /usr/local/mysql/
datadir /usr/local/mysql/data
delayed_insert_limit 100
delayed_insert_timeout 300
delayed_queue_size 1000
join_buffer 131072
flush_time 0
key_buffer 8388600
language /usr/local/mysql/share/
mysql/english/
log OFF
log_update OFF
long_query_time 10
low_priority_updates OFF
max_allowed_packet 1048576
max_connections 100
max_connect_errors 10
max_delayed_insert_threads 20
max_join_size 4294967295
max_sort_length 1024
net_buffer_length 16384
pid_file /usr/local/mysql/data/
CorelLinux.pid
port 3306
protocol_version 10
record_buffer 131072
skip_locking ON
skip_networking OFF
socket /tmp/mysql.sock
sort_buffer 2097144
table_cache 64
thread_stack 65536
tmp_table_size 1048576