Is there any recommended MySQL settings? My host asked me to find out so that can optimize the mysql server for vbulletin. Currently running version 3.23.56.
[Samba] mysql settings in smb.conf - Usenet Forums::
Hello, I have a question about the mysql settings in smb.conf. I understand the part on the left of the equal sign (matches a field in the user table.
http://www.usenet-forums.com/samba/309032-samba-mysql-settings-smb-conf.htmlHOME |
Thanks,
Tommy
Ok, the upgrade is done and the databases are restored without any problems. Everything is running great. I am running MySQL v 4.1.9. That was the only version available for me. I will post the server config soon.
looking good while i would of recommended MySQL 4.0.24 though
Ok, the upgrade is done and the databases are restored without any problems. Everything is running great. I am running MySQL v 4.1.9. That was the only version available for me. I will post the server config soon.
ok here is my current my.cnf. What's missing? What should I add to optimize mysql for vbulletin?
[client]
password = xxxxxxxxxx
port = 3306
user = xxxxxx
socket = /var/lib/mysql/mysql.sock
[mysqld]
port = 3306
user = xxxxxxx
bind-address = 206.133.88.16
socket = /var/lib/mysql/mysql.sock
pid-file = /var/run/mysqld/mysqld.pid
skip-locking
#Added by HostDirector Plugin Installer -- Don't remove -- begin
skip-networking
#Added by HostDirector Plugin Installer -- Don't remove -- end
set-variable = key_buffer=16M
set-variable = max_allowed_packet=1M
set-variable = thread_stack=128K
log = /dev/null
[mysqldump]
quick
set-variable = max_allowed_packet=16M
[mysql]
no-auto-rehash
[isamchk]
set-variable = key_buffer=16M
tommyxv, head on over to server config forum http://www.vbulletin.com/forum/forumdisplay.php?f=14 and start a new thread and provide info asked at http://www.vbulletin.com/forum/showthread.php?t=70117 :)
ok thanks.
You should upgrade to MySQL 4.0.24 and then post a server config in the server configuration forum so we can optmize both your web and mysql server settings.
I tried, but couldn't get that version from the host. It seems to be working great rigth now. (knock on wood)
Thanks,
Tommy
Ok, my forum is not that big yet, 460 members, 400 threads, 2300 posts. Is it ok to use the database backup that is in the admin control panel and import that to the new MySQL database? Also, is there anything i should before I go from mysql v3.x to v4.x ?? Will i have errors/corruption importing a v3 database to mysql v4??
Thanks,
Tommy
 Where's The Advantage In Windows Genuine Advantage?
 Stocks Bounce After S&P Joins Bear Market |
