MySQL Database optimization-sql

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.