Hi Rupak!
> We are using MySql version 3.27.53 on a Red Hat Linux platform version
> 7.2. For the past couple of months we are noticing that the performance
> of the server has gone down very badly. Every, single insertion is
> taking a hell lot of time.The particular table has only 150,000 records.
> Is there any remedy for this problem.
I have been working with MySQL tables up to 16 million records, and the
INSERTS was lightning fast (Making SELECTS was another history, but raw
INSERTS worked fine). So I think your problem relates more to index
structure, make sure you don't have more indexes than really needed. You can
test with a temporal table without any keys (not even primary) and adding
indexes until you get the behaviour described so that you can locate which
is the problem.
Cheers,
Jose Miguel.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
