Mysql database optimization will be a few parameters Chinese interpretation _mysql

First step:
1: Disk seek ability to high speed hard drive (7200 rpm), theoretically seek 7,200 times per second. There is no way to change, the optimization method is to----with multiple hard drives, or to spread data storage.

2: Read and write speed of hard disk, this speed is very fast, this is easier to solve--can be read and write in parallel from multiple hard drives.

3:CPU.CPU processes the data in memory, which is the most common limiting factor when there is a table with a smaller relative memory.

4: Memory limitations. When the CPU needs to exceed the CPU-cached data, the bandwidth of the cache is a bottleneck in memory---but now the memory is so alarming that it doesn't usually happen.

The second step: (I am using the School website Linux platform (Linux ADVX). Mandrakesoft.com 2.4.3-19mdk))

1: Adjust the server parameters

Use shell>mysqld-help This command sound factory a table of all MySQL options and configurable variables. Output The following information:

Possible variables for option--set-variable (-O) are:

Back_log current Value:5//requires the number of connections that MySQL can have. Back_log indicates how many connection requests can be in the stack when MySQL pauses to accept connections

Connect_timeout current Value:5//mysql server waits for a connection before it is answered with bad handshake (poor translation)

Delayed_insert_timeout current value:200//An insert delayed waits for an insert before terminating

Delayed_insert_limit current VALUE:50//insert delayed processor will check that any SELECT statements are not executed and, if so, execute them before continuing

Delayed_queue_size current value:1000//How many teams are allocated for insert delayed

Flush_time Current value:0//If set to non 0, then every flush_time time, all tables are closed

Interactive_timeout current value:28800//server wait time on Ocean Interactive connection before closing it

Join_buffer_size current value:131072//buffer size with all connections

Key_buffer_size current value:1048540//term the size of the buffer of the index block, increasing it to handle the index better

Lower_case_table_names Current value:0//

Long_query_time Current Value:10//If a query takes longer than this time, the slow_queried count will increase

Max_allowed_packet current value:1048576//size of a package

Max_connections current value:300//number of simultaneous connections allowed

Max_connect_errors Current VALUE:10//If there are more than this number of interrupt connections, will block further connections, you can use the flush hosts to resolve

Max_delayed_threads current VALUE:15//The number of processing insert delayed that can be started

Max_heap_table_size Current value:16777216//

Max_join_size current value:4294967295//number of connections allowed to read

Max_sort_length current value:1024//number of bytes used in the sort blob or text

Max_tmp_tables current VALUE:32//number of temporary tables open at the same time for a connection

Max_write_lock_count current value:4294967295//Specify a value (usually very small) to start the mysqld so that a read lock appears after a certain number of write locks

Net_buffer_length current value:16384//communication buffer size-reset to that size at query time

Query_buffer_size current value:0//query-time buffer size

Record_buffer current value:131072//the size of the buffer allocated for each table scanned by the connection for each sequential scan

Sort_buffer current value:2097116//the size of the buffer allocated for each of the sorted connections

Table_cache current value:64//number of tables opened for all connections

Thread_concurrency Current Value:10//

Tmp_table_size current value:1048576//Temp Table size

Thread_stack current value:131072//size of each thread

Wait_timeout current value:28800//server waits on a connection before it closes 3

Configuring the above information according to your own needs will help you