[mysqld] port = 3306 datadir = /var/lib/mysql socket = /var/lib/mysql/mysql.sock default-storage-engine=INNODB max_connections=1510 skip-locking key_buffer = 512M max_allowed_packet = 128M table_cache = 768 sort_buffer_size = 8M read_buffer_size = 8M read_rnd_buffer_size = 16M myisam_sort_buffer_size = 64M thread_cache_size = 8 query_cache_size = 32M innodb_buffer_pool_size = 1024M #-----Suggestion by Nilesh MIDC 18 Jan 2010-------- innodb_log_file_size=15M skip_name_resolve #-------------------------------------- user=mysql # Default to using old password format for compatibility with mysql 3.x # clients (those using the mysqlclient10 compatibility package). old_passwords=1 # To allow mysqld to connect to a MySQL Cluster management daemon, uncomment # these lines and adjust the connectstring as needed. #ndbcluster #ndb-connectstring="nodeid=4;host=localhost:1186" [mysqld_safe] log-error=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid [ndbd] # If you are running a MySQL Cluster storage daemon (ndbd) on this machine, # adjust its connection to the management daemon here. # Note: ndbd init script requires this to include nodeid! connect-string="nodeid=2;host=localhost:1186" [ndb_mgm] # connection string for MySQL Cluster management tool connect-string="host=localhost:1186