RE: Need more info about currently running queries
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 <> 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]
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]
Re: Need more info about currently running queries
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]
Need more info about currently running queries
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 -- Greg Fortune Enterprise Systems Eastern Washington University Phone: 509-359-6690 Email: [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]