Mysql Error Code 10055
it. The old site was primitive by today's standards. The new site was full of AJAX calls that would refresh elements on the page behind the scenes. However this was bound to put my Database Server under a heavier load than it was used to.After launching the new site everything was going well. But once our members starting loggin in, we started to get this error from all sites on the box.ERROR HY000 MySQLODBC 5.1 DriverCan't connect to MySQL server on 'localhost' (10055) ERROR HY000 MySQLODBC 5.1 DriverCan't connect to MySQL server on 'localhost' (10055)Background on my ServerDual 3.6 Ghz Intel Xeons ( 90 nm )4 x 146GB 15K SAS Drives in RAID 10 on a Dedicated RAID Controller with 256 MB RAM16 GB MemorySoftwareWindows Server 2008 R2SmarterMailSmarterStatsMySQL 5.1Running about 80 Websites.What is the Cause of MySQL Error 10055?The truth is this is more of an Operating System Error than a MySQL error. Each time your website runs a query you open a connection to the Database, run the query, then close the connection. Each time this happens your Server allocates a dynamic port for use by MySQL and your Website. For Websites like mine which may run 2000+ Queries per second, this means that 2000+ dynamic ports must be set asside for these connections. Sometimes your server gets under load and the operating system can't recycle these ports fast enough, leading you to run out of ports and then your server throws a 10055 Error. By default Windows Server 2008 R2 has 16838 Ports designated for Dynamic use. The default ranges are 49152 - 65535. However this can be extended to a wider range of ports.How to Fix MySQL Error 10055To fix the problem you need to increase the number of dynamic ports.Running the following Commands will give give you 50000 ports for dynamic use.On Windows Server 2008 R2Open command PromptType the followingnetsh int ipv4 set dynamicport tcp start=10000 num=50000Press E
Forums Hosting Security and Technology Can't connect to MySQL server on 'localhost' (10055) If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. Results 1 to 10 of 10 Thread: Can't connect to MySQL server on 'localhost' (10055) Tweet Thread Tools Show Printable Version Subscribe to this Thread… Search Thread Advanced Search Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode 06-24-2009,01:25 PM #1 hypebeast View Profile View Forum Posts View Forum Threads Web Hosting http://blog.whitesites.com/How-to-Fix-MySQL-Error-10055__635140180116307813_blog.htm Guru Join Date May 2009 Posts 288 Can't connect to MySQL server on 'localhost' (10055) Do you guys know anything about this? My server works perfectly with INSERT, UPDATE, DELETE for mysql. but after like 12 hours later, my application crashes and I get this "Can't connect to MySQL server on 'localhost' (10055)" and I would have to restart my applications and everything will be working perfectly. Do you guys have any idea why this happen? I do http://www.webhostingtalk.com/showthread.php?t=871167 have a lot of connections coming in and out of my server. Would that mean anything? Reply With Quote 0 06-24-2009,01:37 PM #2 linux-engineer View Profile View Forum Posts View Forum Threads Visit Homepage Disabled Join Date Jun 2009 Posts 126 Have you checked the number of Mysql connections you are making ? in /etc/my.cnf you can check the number of Mysql connections. max_connections=100 Else set it probably 30 would be fine to resolve this issue. Reply With Quote 0 06-24-2009,01:49 PM #3 hypebeast View Profile View Forum Posts View Forum Threads Web Hosting Guru Join Date May 2009 Posts 288 Originally Posted by linux-engineer Have you checked the number of Mysql connections you are making ? in /etc/my.cnf you can check the number of Mysql connections. max_connections=100 Else set it probably 30 would be fine to resolve this issue. i have set it at 99999999 because i run a game server and i need all the players i can get. right now, at peak times, i have 600 players online. my computer specs: core2duo 2.83ghz processor 4gb ram 100mbit unmetered shared windows2k3 server 32bit could there be anything wrong with the server i currently have? like, would i need to upgrade or somethign? Reply With Quote 0 06-24-2009,01:53 PM #4 linux-engineer View Profile View Forum Posts View Forum Threads Visit Homepage Disabled Join Date J
Sep 15, 2012. MarcoZ Basic Pleskian 0 Messages: 26 Likes Received: 0 Trophy Points: 0 Hi, http://dba.stackexchange.com/questions/44583/several-pc-cannot-connect-to-mysql-server-on-certain-time Yesterday the 3.51 ODBC had some 100055 problems starting, only i can't figure out where this problem comes from. mysql error Exception information: Exception type: OdbcException Exception message: ERROR [HY000] [MySQL][ODBC 3.51 Driver]Can't connect to MySQL server on 'localhost' (10055) ERROR [HY000] [MySQL][ODBC 3.51 Driver]Can't connect to MySQL server on 'localhost' (10055) The MySQL settings are: ------------------------------------------------------------- [MySQLD] port=3306 mysql error code basedir=C:\Program Files (x86)\Parallels\Plesk\Databases\MySQL51\ datadir=C:\Program Files (x86)\Parallels\Plesk\Databases\MySQL\Data character-set-server=latin1 default-storage-engine=INNODB read_buffer_size=1M read_rnd_buffer_size=256K sort_buffer_size=256K innodb_additional_mem_pool_size=2M innodb_flush_log_at_trx_commit=1 innodb_log_buffer_size=1M innodb_buffer_pool_size=16M innodb_log_file_size=10M innodb_thread_concurrency=8 max_connections=400 old_passwords=0 max_user_connections=30 thread_cache_size=4 thread_stack=196608 binlog_cache_size=32768 net_read_timeout=30 net_retry_count=10 net_write_timeout=30 thread_concurrency=10 open_files_limit=0 [client] port=3306 Last edited: Sep 15, 2012 MarcoZ, Sep 15, 2012 #1 IgorG Forums Analyst Plesk Team 36 30% Messages: 21,216 Likes Received: 447 Trophy Points: 852 Location: Novosibirsk, Russia Make sure that MySQL InnoDB pool buffer size limit is not exceeded. The following warning may be in MySQL error log C:\Parallels\Plesk\Databases\MySQL\Data\sxxxxxxx.err : InnoDB: Starting InnoDB Monitor to print further InnoDB: diagnostics to the standard output. 120725 21:47:13InnoDB: Warning: difficult to find free blocks from InnoDB: the buffer pool (18363 search iterations)! C
log in tour help Tour Start here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company Business Learn more about hiring developers or posting ads with us Database Administrators Questions Tags Users Badges Unanswered Ask Question _ Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute: Sign up Here's how it works: Anybody can ask a question Anybody can answer The best answers are voted up and rise to the top Several PC Cannot Connect To MySQL Server on Certain Time up vote 1 down vote favorite I have a network of 10 PCs and 1 Server. I installed MySQL Community Server v5.6.10 64-bit on the Server, and all the PCs are Windows XP, using ODBC Connection 5.2(a). Some of the PC (previously it was 3, now become 4) cannot connect to the MySQL at a certain time, which is 2.00 pm. Before, it was OK, the client can connect to the Server normally, but at 2.00 pm, those PC cannot connect anymore, with this error: Your connection attempt failed for user xxx@xxx from your host to server at xxx.xxx.xxx.xxx:xxxx. Cannot connect to MySQL Server on xxx.xxx.xxx.xxx (10055) Please: 1. Check that mysql is running on server xxx.xxx.xxx.xxx 2. Check that mysql is running on port xxxx 3. Check the xxxxxx has rights to connect to xxx.xxx.xxx.xxx from your address (mysql rights define what clients can connect to the server and from which machines) 4. Make sure you are both providing a password if needed and using the correct password for xxx.xxx.xxx.xxx connection from the host address you're connecting fro