- Something
- Wednesday, July 11th, 2007 at 2:40:12pm MDT
- [mysqld]
- datadir=/var/lib/mysql
- socket=/var/lib/mysql/mysql.sock
- #old_passwords=1
- skip-locking
- key_buffer = 256M
- max_allowed_packet = 16M
- table_cache = 2048
- sort_buffer_size = 1M
- read_buffer_size = 1M
- read_rnd_buffer_size = 8M
- myisam_sort_buffer_size = 8M
- thread_cache_size = 500
- thread_concurrency = 8
- query_cache_size = 256M
- tmp_table_size=64M
- back_log = 100
- max_connect_errors = 10000
- join_buffer_size=1M
- open-files = 20000
- interactive_timeout = 600
- wait_timeout = 600
- max_connections=500
- init-file = /var/lib/mysql/initfile.sql
- myisam_max_sort_file_size=10485760000
- #myisam_sort_buffer_size=8M
- # The following directives should be commented out
- # but included as they are things that get added
- # very frequently on tickets. These are more in a
- # need-this-feature basis.
- # The below 2 cannot be set on the fly. If the customer already has
- # InnoDB tables and wants to change the size of the InnoDB tablespace
- # and InnoDB logs, then:
- # 1. Run a full backup with mysqldump
- # 2. Stop MySQL
- # 3. Move current ibdata and ib_logfiles out of /var/lib/mysql
- # 4. Uncomment the below innodb_data_file_path and innodb_log_file_size
- # 5. Start MySQL (it will recreate new InnoDB files)
- # 6. Restore data from backup
- #innodb_data_file_path = ibdata1:2000M;ibdata2:10M:autoextend
- #innodb_log_file_size = 100M
- #innodb_buffer_pool_size = 384M
- #innodb_additional_mem_pool_size = 20M
- innodb_fast_shutdown=1
- #
- innodb_data_home_dir = /var/lib/mysql/ibdata
- innodb_file_per_table
- #
- # Data files must be able to hold your data and indexes.
- # Make sure that you have enough free disk space.
- innodb_data_file_path = ibdata1:10M:autoextend
- #
- # Set buffer pool size to 50-80% of your computer's memory
- innodb_buffer_pool_size=4G
- innodb_additional_mem_pool_size=32M
- innodb_log_group_home_dir = /var/lib/mysqliblogs
- #
- innodb_log_files_in_group = 2
- #
- # Set the log file size to about 25% of the buffer pool size
- innodb_log_file_size=512M
- innodb_log_buffer_size=8M
- #
- innodb_flush_log_at_trx_commit=1
- innodb_lock_wait_timeout=50
- #
- #innodb_flush_method=O_DIRECT
- #
- # Uncomment the next lines if you want to use them
- innodb_thread_concurrency=5
- #log-slow-queries=/var/lib/mysqllogs/slow-log
- #long_query_time=2
- #log-queries-not-using-indexes
- #log-bin=/var/lib/mysqllogs/bin-log
- #log-slave-updates
- #expire_logs_days = 14
- server-id = 1
- [mysql.server]
- user=mysql
- #basedir=/var/lib
- [mysqld_safe]
- err-log=/var/log/mysqld.log
- pid-file=/var/run/mysqld/mysqld.pid
- open_files_limit=65536
advertising
Update the Post
Either update this post and resubmit it with changes, or make a new post.
You may also comment on this post.
Please note that information posted here will expire by default in one month. If you do not want it to expire, please set the expiry time above. If it is set to expire, web search engines will not be allowed to index it prior to it expiring. Items that are not marked to expire will be indexable by search engines. Be careful with your passwords. All illegal activities will be reported and any information will be handed over to the authorities, so be good.
