forum.lissyara.su

Код: Выделить всё

character-set-server = cp1251
collation-server = cp1251_general_ci
# bind-address = 127.0.0.1
# port<><------>= 3306
socket<><------>= /tmp/mysql.sock
skip-external-locking
skip-networking
key_buffer_size = 2048M
max_allowed_packet = 32M
table_cache = 2048
sort_buffer_size = 2M
read_buffer_size = 2M
read_rnd_buffer_size = 16M
myisam_sort_buffer_size = 256M
thread_cache_size = 32
query_cache_size = 128M
thread_concurrency = 8
max_connections = 500
innodb_file_per_table
innodb_buffer_pool_size = 2048M
innodb_additional_mem_pool_size = 50M
innodb_read_io_threads = 8
innodb_write_io_threads = 8
innodb_lock_wait_timeout = 50
innodb_log_buffer_size = 16M
innodb_flush_log_at_trx_commit = 2
innodb_flush_method = O_DIRECT
transaction-isolation = READ-COMMITTED
tmp_table_size = 1024M
max_heap_table_size = 1024M
join_buffer_size = 128M
long_query_time = 2
slow-query-log = On
slow-query-log-file = /var/log/mysqld-slow-query.log
tmpdir = /ramdisk

Код: Выделить всё

#########################################################################
#                                                                       #
#       MySQL performance tuning primer script                          #
#       Writen by: Matthew Montgomery <mmontgomery@mysql.com>           #
#       Inspired by: MySQLARd (http://gert.sos.be/demo/mysqlar/)        #
#       Version: 1.5-r5         Released: 2009-11-22                    #
#       Licenced under GPLv2                                            #
#                                                                       #
#########################################################################

#########################################################################
#                                                                       #
# Little known feature: 1st argument is execution mode                  #
#                                                                       #
#       Usage: ./tuning-primer.sh [ mode ]                              #
#                                                                       #
#       Available Modes:                                                #
#               all :           perform all checks (default)            #
#               prompt :        prompt for login credintials and socket #
#                               and execution mode                      #
#               mem, memory :   run checks for tunable options which    #
#                               effect memory usage                     #
#               disk, file :    run checks for options which effect     #
#                               i/o performance or file handle limits   #
#               innodb :        run InnoDB checks /* to be improved */  # 
#               misc :          run checks for that don't categorise    #
#                               well Slow Queries, Binary logs,         #
#                               Used Connections and Worker Threads     #
#########################################################################
#                                                                       #
# Set this socket variable ONLY if you have multiple instances running  # 
# or we are unable to find your socket, and you don't want to to be     #
# prompted for input each time you run this script.                     #
#                                                                       #
#########################################################################

Код: Выделить всё

>whereis mysqltuner
mysqltuner: /usr/local/bin/mysqltuner /usr/ports/databases/mysqltuner