We had version 4.1 installed on a server and a multiuser application accessing it. Over a period of a year or so, accessing queries etc. has become slower and slower, although the number of records have increased dramatically over that time.
Recently we installed 4.1 again on a new server and moved the database over and instantly there was a dramatic increase in speed. However, over the last 3 or 4 weeks it has started slowing down again.
For the moment, let us assume that it is not the application that is causing the problem. Is there anything about the way MySQL is set up that might cause it to slow up in this way? We are using both InnoDB and ISAM tables.
Thanks.
Recently we installed 4.1 again on a new server and moved the database over and instantly there was a dramatic increase in speed. However, over the last 3 or 4 weeks it has started slowing down again.
For the moment, let us assume that it is not the application that is causing the problem. Is there anything about the way MySQL is set up that might cause it to slow up in this way? We are using both InnoDB and ISAM tables.
Thanks.