# Example MySQL config file for medium systems.## This is for a system with little memory (32M - 64M) where MySQL plays# an important part, or systems up to 128M where MySQL is used together with# other programs (such as a web server)## MySQL programs look for option files in a set of# locations which depend on the deployment platform.# You can copy this option file to one of those# locations. For information about these locations, see:# http://dev.mysql.com/doc/mysql/en/option-files.html ## In this file, you can use all long options that a program supports.# If you want to know which optionsa program supports, run the program# with the "--help" option.# The following options will be passed to all MySQL clients[client]port = 3306socket = /var/run/mysqld/mysqld.sock[mysqld_safe]socket = /var/run/mysqld/mysqld.socknice = 0# The MySQL server[mysqld]user = mysqlport = 3306pid-file = /var/run/mysqld/mysqld.pidsocket = /var/run/mysqld/mysqld.sockbasedir = /usrdatadir = /var/lib/mysqltmpdir = /tmplc-messages-dir = /usr/share/mysqlskip-external-lockingkey_buffer_size = 16Mmax_allowed_packet = 1Mtable_open_cache = 64sort_buffer_size = 512Knet_buffer_length = 8Kread_buffer_size = 256Kread_rnd_buffer_size = 512Kmyisam_sort_buffer_size = 8M#if no other servers are going to beconnecting to this server, uncomment the following line#bind-address = 127.0.0.1 skip-innodbdefault-storage-engine = MyISAMmax-connections = 25query-cache-size = 2Mquery-cache-limit = 1Mthread-stack = 256Kthread-cache-size = 2Mslow-query-loglong_query_time = 5[mysqldump]quickmax_allowed_packet = 16M[mysql]no-auto-rehash[myisamchk]key_buffer_size = 20Msort_buffer_size = 20Mread_buffer = 2Mwrite_buffer = 2M[mysqlhotcopy]interactive-timeout