|
|
Joined: Jun 2001
Posts: 729
Coder
|
Coder
Joined: Jun 2001
Posts: 729 |
Although my database is primarily running my UBB system (we are converted to a MySQL backend) I do have a UBBThreads site, I thought some might benefit from seeing how I have MySQL configured in /etc/my.cnf
MySQL 3.23.41 under RH v7.2
[mysqld] datadir=/usr/local/mysql socket=/var/lib/mysql/mysql.sock set-variable = max_connections=450 set-variable = key_buffer=16M set-variable = myisam_sort_buffer_size=64M set-variable = join_buffer=1M set-variable = record_buffer=1M set-variable = sort_buffer=2M set-variable = table_cache=1024 set-variable = thread_cache_size=256 set-variable = wait_timeout=9600 set-variable = connect_timeout=10 set-variable = max_allowed_packet=16M set-variable = max_connect_errors=10
[mysql.server] user=mysql basedir=/usr/local/mysql
[safe_mysqld] err-log=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid open_files_limit=8192
[mysqldump] quick set-variable = max_allowed_packet=16M
[myisamchk] set-variable = key_buffer=64M set-variable = sort_buffer=64M set-variable = read_buffer=16M set-variable = write_buffer=16M
|
|
|
Donate to UBBDev today to help aid in Operational, Server and Script Maintenance, and Development costs.
Please also see our parent organization VNC Web Services if you're in the need of a new UBB.threads Install or Upgrade, Site/Server Migrations, or Security and Coding Services.
|
|
Posts: 1,157
Joined: July 2001
|
|
Forums63
Topics37,573
Posts293,925
Members13,849
|
Most Online5,166 Sep 15th, 2019
|
|
Currently Online
Topics Created
Posts Made
Users Online
Birthdays
|
|
|
|
|