Reputation
Top tag
Next privilege 200 Rep.
See reduced ads
Badges
7
Impact
~3k people reached

May
2
awarded  Popular Question
Mar
18
awarded  Popular Question
Nov
21
comment Connecting to MySQL from PHP is extremely slow
This can happen for other servers than localhost. I had the same delay issue for a server address on the form xx.xxxx.xxxxx.xxxxx.com. Once I changed the server name to its IP address, the problem was gone.
Oct
3
accepted VMware Infrastructure Web Access 2.0.0 stuck at “Loading”
Feb
8
comment MySQL error 1429, federation
Thanks for a superb answer. Indeed, max_connections is 100, and Max_used_connections is 101 on my remote server. Intriguingly, Aborted_connects is 26515. Seems to indicate a significant problem. Currently my setup is working again but I will try FLUSH TABLES when it goes down. Exactly how do I check if the remote server shows a lot of idle inbound federated connections?
Feb
8
accepted MySQL error 1429, federation
Feb
1
awarded  Informed
Feb
1
comment MySQL error 1429, federation
@mwasif: Thanks a lot. I've updated the question to include the versions of MySQL I use. Apparently those old versions may have some bugs. One (tedious and risky) option could be to upgrade my servers to modern versions. Perhaps I'll try using ALTER TABLE as described in your linked article.
Feb
1
revised MySQL error 1429, federation
Version info
Jan
31
asked MySQL error 1429, federation
Dec
20
asked VMware Infrastructure Web Access 2.0.0 stuck at “Loading”
Dec
20
answered VMware Infrastructure Web Access 2.0.0 stuck at “Loading”
Nov
14
comment Download deployed Apache Tomcat .war file
On my machine I located the war files in the folder /var/lib/tomcat6/webapps.
Nov
12
awarded  Editor
Nov
12
revised Kill or continue lost Linux sessions
Links to referenced programs
Nov
12
accepted Kill or continue lost Linux sessions
Nov
12
suggested approved edit on Kill or continue lost Linux sessions
Nov
12
comment Kill or continue lost Linux sessions
Sounds like great programs. I'll give them a shot. No way to reconnect using a standard Linux textual command?
Nov
12
asked Kill or continue lost Linux sessions
Oct
3
awarded  Supporter