Problem with Mysql

//nmh's picture

He has: 17 posts

Joined: May 2005

Hi,

Hope someone is kind enough to help me out with this... i'm out of options... lol Smiling

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 Sticking out tongue).

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. Sad

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 = 16M
'

Please help! Sad

chrishirst's picture

He has: 379 posts

Joined: Apr 2005

It's probably the 10 connection limit on XP Pro

//nmh's picture

He has: 17 posts

Joined: May 2005

chrishirst wrote: It's probably the 10 connection limit on XP Pro

Thank you, now at least I have something to work with. Smiling

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's picture

He has: 17 posts

Joined: May 2005

//nmh wrote: Thank you, now at least I have something to work with. Smiling

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.

It seems to have worked, thank you. Smiling

andy206uk: I would If I was able to properly operate it and make it secure, but I can not. Smiling

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's picture

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. Smiling

a Padded Cell our articles site!

Abhishek Reddy's picture

He has: 3,348 posts

Joined: Jul 2001

JeevesBond wrote: 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. Smiling

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. Smiling

//nmh's picture

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's picture

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 Smiling.

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.