may be due to corrupted indexes it is taking long time. just re-org the table.if your table is InnoDB type then use below command to re-org it.
mysql> alter table <<table name>> type=InnoDB; based on size of the table it may execute for long time . for us it has solved performance issue. Thanks Anil -----Original Message----- From: Greg Fortune [mailto:[EMAIL PROTECTED] Sent: Wednesday, December 22, 2004 1:34 AM To: mysql@lists.mysql.com Subject: Re: Need more info about currently running queries Yep, mysqladmin can give the same info. As noted in my original message, I need much more detailed info. The crux of the problem is that I need to run a query that could take several hours when it's using indexes correctly, but it is not working correctly so it takes longer than I've been willing to wait (about 14 hours). I need to make changes to indexes and run the query again, but I don't want to wait hours until I know whether the change was effective or not. I really need a way to find out how far the query has progressed after 15 minutes so I can calculate how much improvement the changes made. Greg On Tuesday 21 December 2004 02:25 am, Gleb Paharenko wrote: > Hello. > > > > Using SHOW PROCESSLIST you can just check if your query running, or > > is waiting for some lock. For more info, you can run "ps axm" in shell > > and look for the thread state, but that's more related to the kernel stuff. > > See: > > http://dev.mysql.com/doc/mysql/en/SHOW_PROCESSLIST.html > > Greg Fortune <[EMAIL PROTECTED]> wrote: > > Is there anyway to get additional information about a query that is > > currently > > > > running? I've got some performance problems I'm trying to analyze while > > > > loading large data sets and I'm running a test query, but I don't have > > any > > > > idea how far the query has progressed. > > > > > > > > The test query is a count(some_field) with the JOINs that I need and I'd > > like > > > > to know how many rows it has counted or how many rows it has visited from > > > > each table, etc, etc, etc. I know ahead of time that the result should > > be > > > > about 2.6 million and am just trying to get timing data. > > > > > > > > Is there any way to get at this kind of info? > > > > > > > > Greg > > -- > For technical support contracts, goto https://order.mysql.com/?ref=ensita > This email is sponsored by Ensita.NET http://www.ensita.net/ > __ ___ ___ ____ __ > / |/ /_ __/ __/ __ \/ / Gleb Paharenko > / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] > /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET > <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
