Results 1 to 2 of 2
Thread: MySQL 4.1 reject connection
-
06-04-2005, 12:38 PM #1Newbie
- Join Date
- Mar 2005
- Posts
- 24
MySQL 4.1 reject connection
This is a MySQL4.1 on Windows 2003 web server with 2GB memroy and dual xeon.
Current MySQL connection is between 40 -70 per second. The database size is around 1GB, php message board web site.
Every few minute, mysql will reject connection for a few seconds then back to normal. Connectivity is ok when there are over 100 concurrent connection but may be rejected when there is 40 connection.
mysql.ini:
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=500
query_cache_size=256M
table_cache=256
tmp_table_size=185M
thread_cache_size=38
myisam_max_sort_file_size=100G
myisam_max_extra_sort_file_size=100G
myisam_sort_buffer_size=369M
key_buffer_size=318M
read_buffer_size=64K
read_rnd_buffer_size=256K
sort_buffer_size=256K
#skip-innodb
innodb_additional_mem_pool_size=13M
innodb_flush_log_at_trx_commit=1
innodb_log_buffer_size=7M
innodb_buffer_pool_size=616M
innodb_log_file_size=50M
innodb_thread_concurrency=16
#secure-auth
#secure-auth
#old-passwords
-
06-04-2005, 04:31 PM #2PHP for breakfast
- Join Date
- May 2004
- Location
- Lansing, MI, USA
- Posts
- 1,548
1GB is, as I understand it, seriously growing out of the optimal MySQL database target size. Most people will say MySQL is good for smaller DB, but move to Posgres or, as your on windows, maybe MSSQL for larger databases.
Not sure what would be causing your specific problem though, but I would definitely look at the posibility of migrating.Jacob - WebOnce Technologies - 30 Day 100% Satisfaction Guarantee - Over 5 Years Going Strong!
Website Hosting, PHP4&5, RoR, MySQL 5.0, Reseller Hosting, Development, and Designs
Powered By JAM - Professional Website Development - PHP, MySQL, JavaScript, AJAX - Projects Small & Large