| ?????? Mysql ??????? |
|
|
|
|
??? ???????????? ? ?????????????? ????????????? ????????? Mysql. ?????? ?????????? ? ??????? ?????????????????? mysql ????? ??????? ????? - http://dev.mysql.com/doc/refman/5.0/en/optimizing-the-server.html ????? ?????? ????????? ? ????????? ????? ??????? ????????? ? ????? my.cnf. ?????? ?? ????????? ?/etc/my.cnf ????????????? ???????? ? ???? ???? ????????? ?????????: [mysqld] #???????? ??? ?????????, ???? mysql ?????? ???????????? ?????? ?? ????????? ??????? ( ?????? ??? ). skip-networking #????? ???????? ?????????????? ?????????????? ??? ??????, ????????, ????? ?????? ??????? ???????: myisam-recover #??? ?????? ?????????????????? ????????????? ????????? ???????? key_buffer: key_buffer = 32M # ??? mysql 3.23 ?????? ??????????????? ????????? ???? ?????? set-variable=key_buffer_size = 32M #???????? query cache ??? ?????????? ?????????????????? ( ???????? ??? mysql 4.0 ? ???? ) - ????? ?????????????!!! query_cache_size= 32M query_cache_type= 2 #???? ?? ?? ??????????? bdb ? innodb ??????? ? ?????? ???????????, ?? ????????? ?? ??? ?????????? ??????????????????: skip-bdb skip-innodb #?? ?????? ??????, ???? ??? ???? ???????? ?? 1.5-2 ???????? ????? ? ????, ???????? ???????????? ?????? ??? memory ?????? :) max_heap_table_size = 67108864 #??? mysql 3.23 ??????????? set-variable=max_heap_table_size = 67108864 |
| След. > |
|---|