Problem with Mysql
Hi,
Hope someone is kind enough to help me out with this... i'm out of options... lol
Anyway, I stopped the contract for my webhost and started hosting myself. On my Windows XP Pro PC (Don't even start about the windows thing ).
Anyhow, I have been getting propblems with Mysql. The following error occurs multiple times in a day:
Quote: Database error in vBulletin :
Link-ID == false, connect failed
mysql error:mysql error number: 0
I have read on many sites that this has to do with the max connections that are allowed. So I raised my max connections and that still has not helped. I have even checked the site myself (with me as the only person on the website) and it does happen after some clicks here and there.
Could someone please help me with this? Give me some suggestions as to what it might be. I can't let this continue on my site, lol. I'd have to go back to a webhost.
Anyhow, below is my my.ini file:
[client]
port=3306
default-character-set=latin1
[mysqld]
port=3306
basedir="F:/MySQL/"
datadir="F:/MySQL/Data/"
default-character-set=latin1
default-storage-engine=myisam
max_connections=9999
wait_timeout = 900
connect_timeout = 10
max_allowed_packet=32M
max_connect_errors = 10
query_cache_limit = 1M
query_cache_size=32M
query_cache_type = 1
table_cache=1024
tmp_table_size=26M
thread_cache_size=64
#*** MyISAM Specific options
myisam_max_sort_file_size=100G
myisam_max_extra_sort_file_size=100G
myisam_sort_buffer_size=52M
key_buffer_size=40M
join_buffer_size = 1M
read_buffer_size=1M
read_rnd_buffer_size=256K
sort_buffer_size=2M
#*** INNODB Specific options ***
skip-innodb
innodb_additional_mem_pool_size=2M
innodb_flush_log_at_trx_commit=1
innodb_log_buffer_size=1M
innodb_buffer_pool_size=77M
innodb_log_file_size=39M
[mysqld_safe]
open_files_limit = 8192
[mysqldump]
quick
max_allowed_packet = 32M
[myisamchk]
key_buffer = 64M
sort_buffer = 64M
read_buffer = 16M
write_buffer = 16MPlease help!
chrishirst posted this at 18:00 — 30th May 2005.
He has: 379 posts
Joined: Apr 2005
It's probably the 10 connection limit on XP Pro
//nmh posted this at 21:27 — 30th May 2005.
He has: 17 posts
Joined: May 2005
Thank you, now at least I have something to work with.
Now that I have read about the connection limit, I think it most likely has to do with that too. I will install Windows 2003 Server tomorrow and see if the problem will be resolved.
//nmh posted this at 17:59 — 31st May 2005.
He has: 17 posts
Joined: May 2005
It seems to have worked, thank you.
andy206uk: I would If I was able to properly operate it and make it secure, but I can not.
andy206uk posted this at 12:13 — 31st May 2005.
He has: 1,758 posts
Joined: Jul 2002
Personally, I would get a cheap second PC and install a linux/apache combo. But thats just me. I'm sure you have your reasons for using a windows server.
Andy
JeevesBond posted this at 12:17 — 1st June 2005.
He has: 3,956 posts
Joined: Jun 2002
Heh, well you can't make a windows server secure, ever IMO. Even a basic Linux install will probably be better than trying to use Windows, probably a good idea to use a firewall and only allow forward port 80 to your Linux box, that'll cut down a potential hackers options somewhat.
a Padded Cell our articles site!
Abhishek Reddy posted this at 09:49 — 2nd June 2005.
He has: 3,348 posts
Joined: Jul 2001
I'm sure it's possible to run secure Windows servers. It takes some expertise at Windows config and management, as well as general networking and security know-how to be able to secure one. I've heard of uptime records running into numbers of years on some Windows servers.
Actually, the same applies to running a hardened GNU/Linux server. Although most distros (especially server-oriented ones) tend to be fairly secure out-of-the-box, and come with manuals and guides to help tighten overall security, it really takes a well-designed security policy, based knowledge and control of all services and related aspects, to make a robust system.
//nmh posted this at 08:34 — 2nd June 2005.
He has: 17 posts
Joined: May 2005
Well, I don't know about that. But the windows server has all the ports closed except for the ones I need (and only for the programs that are supposed to use it), and even those are monitored. All incoming signals except for the ones that are permitted, are blocked.
CptAwesome posted this at 10:06 — 7th June 2005.
He has: 370 posts
Joined: Dec 2004
I run XP home, with apache/php/mysql, and have no problems. I only ever have to turn my computer off or restart it is when some annoying installer requires a reboot. I think the only thing really unsecure about my setup is I'm on a Wireless connection
.
Want to join the discussion? Create an account or log in if you already have one. Joining is fast, free and painless! We’ll even whisk you back here when you’ve finished.