Results 1 to 2 of 2
  1. #1

    Exclamation 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

  2. #2
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •