. .

    @Mail.ru -

interactive_timeout, join_buffer_size, key_buffer_size

» PHP » MySQL » interactive_timeout, join_buffer_size, key_buffer_size MySQL

interactive_timeout

( ) . . wait_timeout.


join_buffer_size

, (, ). . , , . , .


key_buffer_size

. key_buffer_size , . , . (, 50% ), . , MySQL , .

, show status Key_read_requests, Key_reads, Key_write_requests Key_writes. Key_reads/Key_read_request 0.01. A Key_write/Key_write_requests 1, /, , , , delay_key_write. 4.10. SHOW.

, LOCK TABLES. 9.2.2. LOCK TABLES/ UNLOCK TABLES.