Re: server is getting slower and slower

2004-09-13 Thread Jonas Fischer
The problem is solved. The server has two network cards. One was not connected. So I assume that the server was frequently asking the card which was not connected for a response. Therefore the performance of the server went down and the response time for querys went up. Thank you for your help J

Re: server is getting slower and slower

2004-09-13 Thread Aman Raheja
Is the MySQL server 4.1 - default installed? Did you change any parameters (variables) for it? Have you checked the network performance otherwise? I can't really think of anything that the MySQL server is causing, though the Linux server could be having an issue, with hardware or something. i wi

Re: server is getting slower and slower

2004-09-13 Thread Jonas Fischer
The problem is that before (like last friday) there was no problem. The terminals (applications with microcontrollers) were connecting rapidly to the server. Today I checked and they will not connect unless I increase the timeout for the response time of the server inside the program code of the te

Re: server is getting slower and slower

2004-09-13 Thread Aman Raheja
Well, it does not sound to be a problem with the MySQL server if you get a good response from other computers but just not the microcontroller. As far as improving the performance of MySQL is concerned, check the MySQL docs and tons of info when you search google. - Aman Jonas Fischer wrote: Hel

server is getting slower and slower

2004-09-13 Thread Jonas Fischer
Hello When I am connecting to mysql server with another computer I have no problems. But connecting with a microcontroller the mysql server is sending the response very slow. And it is getting slower and slower. Right now the only way I found is to enlage the timeout of the microcontrollers so tha