GoFuckYourself.com - Adult Webmaster Forum

GoFuckYourself.com - Adult Webmaster Forum (https://gfy.com/index.php)
-   Fucking Around & Business Discussion (https://gfy.com/forumdisplay.php?f=26)
-   -   Please configure my Mysql my.cnf file ? (https://gfy.com/showthread.php?t=575536)

FuqALot 02-13-2006 12:01 PM

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