1. Is this on dedicated or shared virual server.
- Dedicated
2. your server specs:
cpu: Athlon X2 4400
mem: 2 gigs
hard drive: WD Raptor (74 gig 10,000 RPM) for OS, DB is on seperate Raptor
OS: Win2k SP4
IIS version: 4
PHP version: php 4.4.1
MySQL version: 4.1.15
3. if you use mysql 4.x instead of mysql 3.23.x, do you have any innodb type databases/tables on your server ?
- Novice alert: I have no idea. I (mostly) followed the defaults during the install.
4. if possible how mysql was compiled/installed
- See #3 above
5. your top stats
- Nothing remarkable. Let's call it a pre-emptive strike :rolleyes:
6. your mysql configuration variables...
- See attached
7. your mysql extended-status output...
- See attached
8. is your vB the only thing on the server? or other scripts & sites which utilise php and mysql?
- The server is also hosting a few static websites and is a game server, but no other php/msql apps
9. how many average and max concurrent users on your vB forum ? and what your cookie timeout is ?
- I expect, based on previous experience, a max of 30 concurrent users. This is a new server, new vB install, new everything... Cookie timeout is unknown.
10. create a file named phpinfo.php and place this code in it and post the url/link to it from your web site
- http://www.itsmytoyandican****withitwhywhenandhoweveriwan tkthnx.com/phpinfo.php
11. if you run Apache
- NA
12. what version of vB are you running ?
- 3.5.2
13. check to see if any files i.e. apache log files are hitting 2GB or 4GB max file size limits i.e. see if you have max file size exceeded messages in apache error log
- NA
woah long domain name heh
try posting phpinfo.php url with manually set [URL ] [/URL ] tags
also can you post what you have in your existing my.ini or my.cnf file
if possible post it as a quoted text rather than as attachment
FWIW, since I have remote desktop access to this server, I can back up the DB by stopping the service and drag and dropping the file to another folder :D
:D
I registered it after someone jokingly suggested it. It's definately a copy/paste thing!
Well, as I suspected, the URL has been censored. Just think creatively about words that start with F
:D
Hmmm MySQL 4.1.15 might have defaulted to creating databases using Innodb table format instead of MyISAM. I'll get you to try the below my.cnf and restart mysql and see if it chucks any fits with Innodb disabled in the my.cnf.
1. back up all of your mysql databases using ssh telnet and mysqldump
- http://www.sitepoint.com/article/678
- http://www.vbulletin.com/docs/html/main/manual_database_backup
2. edit my.cnf or my.ini with below settings and restart mysql server
[client]
port=3306
[mysql]
default-character-set=latin1
[mysqld]
port=3306
basedir="C:/Program Files/MySQL/MySQL Server 4.1/"
datadir="C:/Program Files/MySQL/MySQL Server 4.1/Data/"
default-character-set=latin1
default-storage-engine=MyISAM
back_log = 50
skip-innodb
max_connections = 500
key_buffer = 16M
myisam_sort_buffer_size = 64M
join_buffer_size = 1M
read_buffer_size = 1M
sort_buffer_size = 2M
table_cache = 1800
thread_cache_size = 384
wait_timeout = 180
connect_timeout = 10
tmp_table_size = 64M
max_allowed_packet = 64M
max_connect_errors = 10
read_rnd_buffer_size = 524288
bulk_insert_buffer_size = 8M
thread_concurrency = 4
query_cache_limit = 1M
query_cache_size = 96M
query_cache_type = 1
query_prealloc_size = 16384
query_alloc_block_size = 16384
TweakHounds Super XP Tweaking Guide - Tweak & Optimize XP::
See the contact page for info on how to contact me. Tweaking Levels 12 - Clean, Defrag, Optimize. 13 - XP Tweaking Guide Notes & FAQs. 14 - Benchmarking
http://tweakhound.com/xp/xptweaks/supertweaks1.htmHOME |
[mysqld_safe]
open_files_limit = 8192
[mysqldump]
quick
max_allowed_packet = 16M
[myisamchk]
key_buffer = 64M
sort_buffer = 64M
read_buffer = 16M
write_buffer = 16M
I highly suggest just using mysqldump, instead.
try posting phpinfo.php url with manually set [URL ] [/URL ] tags. Well, I would, but I'd rather not bypass any filters :rolleyes:
Just think of an F word and replace a few *'s
also can you post what you have in your existing my.ini or my.cnf file
Sure... I'll even parse out all the crud
[client]
port=3306
[mysql]
default-character-set=latin1
[mysqld]
port=3306
basedir="C:/Program Files/MySQL/MySQL Server 4.1/"
datadir="C:/Program Files/MySQL/MySQL Server 4.1/Data/"
default-character-set=latin1
default-storage-engine=INNODB
max_connections=100
query_cache_size=0
table_cache=256
tmp_table_size=103M
thread_cache_size=8
myisam_max_sort_file_size=100G
myisam_max_extra_sort_file_size=100G
myisam_sort_buffer_size=205M
key_buffer_size=175M
read_buffer_size=64K
read_rnd_buffer_size=256K
sort_buffer_size=256K
innodb_data_home_dir="D:/MySQL Datafiles/"
innodb_additional_mem_pool_size=7M
innodb_flush_log_at_trx_commit=1
innodb_log_buffer_size=3498K
innodb_buffer_pool_size=339M
innodb_log_file_size=170M
innodb_thread_concurrency=8
mysqldump is best and highly recommended!
as MyISAM vs Innodb, Innodb has some advantages due to MyISAM table locking potential but Innodb uses alot more resources and needs more tuning to be optimal so for 95% of vB forums MyISAM would be better
yes, completely replace your my.cnf with my my.cnf and restart mysql
OK, cool.
I have 3 questions first:
1) I am assuming from your comments that MyISAM is superior to Innodb for Vb?
2) In my config I have innodb_data_home_dir="D:/MySQL Datafiles/"
but no equal statement for MyISAM
3) Did you want me to completely replace my config with yours, or just change/add what's different, overriding conflicts with yours?
Sorry, my understanding of this stuff is pretty basic. I really appreciate the help, though!
Wow.. long enough domain name?
Recommendation noted.
I did just do a test, however. I stopped the service, copied the file to another directory, started the service, made a thread, stopped the service, replaced the file with the original, and restarted service. No probems?
Rudimentary test, I know, but I have been doing this type of backup for about a year (and a few restores as well) without any problems. I even restored once to a physically different server.
 Red Hat's Rough Recovery From CFO Exit
 Windows Live Finds a New, Pre-installed Home
|
