mysql ladenie na vykon ..

[Jan ' Kozo ' Vajda]

zdravim ...

potreboval by som pomoct vyladit mysql na maximalny vykon .. princip je
taky, ze mysql databaza je v spojeni s 4 apache ( resp. naopak .. apached
s databazou ) .. kazdy apache ma MaxClients 150 a drzi si persistentne
spojenie s databazou ..

obcas sa stane, ze apache vytuhne a pomoze len restart ( cas odozvy je
neumerne dlhy ) po restarte to zase facha ako hodinky a je to svizne a
rychle ..

mate niekto nejaky napad ?

Zvysenie max_connections na 1000 pomohlo, ale este tomu stale nieco chyba ..

takto vyzera sucasna konfiguracia: 

+----------------------------+---------------------------------+
| Variable_name              | Value                           |
+----------------------------+---------------------------------+
| back_log                   | 50                              |
| connect_timeout            | 5                               |
| basedir                    | /opt/mysql/                     |
| datadir                    | /opt/mysql/var/                 |
| delayed_insert_limit       | 100                             |
| delayed_insert_timeout     | 300                             |
| delayed_queue_size         | 1000                            |
| join_buffer                | 131072                          |
| flush_time                 | 0                               |
| key_buffer                 | 8388600                         |
| language                   | /opt/mysql/share/mysql/english/ |
| log                        | OFF                             |
| log_update                 | OFF                             |
| long_query_time            | 10                              |
| low_priority_updates       | OFF                             |
| max_allowed_packet         | 1048576                         |
| max_connections            | 1024                            |
| max_connect_errors         | 10                              |
| max_delayed_insert_threads | 20                              |
| max_join_size              | 4294967295                      |
| max_sort_length            | 1024                            |
| net_buffer_length          | 16384                           |
| pid_file                   | /opt/mysql/var/host.pid         |
| port                       | 3306                            |
| protocol_version           | 10                              |
| record_buffer              | 131072                          |
| skip_locking               | OFF                             |
| skip_networking            | OFF                             |
| socket                     | /tmp/mysql.sock                 |
| sort_buffer                | 2097144                         |
| table_cache                | 64                              |
| thread_stack               | 65536                           |
| tmp_table_size             | 1048576                         |
| tmpdir                     | /var/tmp/                       |
| version                    | 3.22.27                         |
| wait_timeout               | 28800                           |
+----------------------------+---------------------------------+



		                                   K O Z O 
                		    ===================================
                                      Look At Your Young Man Fighting
                                         Look At Your Woman Crying
                                       Look At Your Young Man Dying
                                    The Way They've Always Done Before