![]() |
Please configure my Mysql my.cnf file ?
Anyone good with MySQL? I would really appreciate it if anyone could take a quick look at my MySQL my.cnf file and make changes so that the MySQL server will be very fast and will use about 80% of the computer.
The computer info: Dual CPU P4 3.2ghz with 2GB Memory. [mysqld] set-variable=wait_timeout=28800 set-variable=max_connections=2500 set-variable=flush_time=5 set-variable=max_connect_errors=100 set-variable=interactive_timeout=10800 set-variable=key_buffer_size=256M set-variable=join_buffer_size=16M set-variable=table_cache=5120 set-variable=myisam_sort_buffer_size=32M set-variable=myisam_max_sort_file_size=2M set-variable=myisam_max_extra_sort_file_size=256K set-variable=max_allowed_packet=3M set-variable=thread_concurrency=4 Thank you very much. |
| All times are GMT -7. The time now is 12:25 PM. |
Powered by vBulletin® Version 3.8.8
Copyright ©2000 - 2026, vBulletin Solutions, Inc.
©2000-, AI Media Network Inc123