--- kapil <[EMAIL PROTECTED]> wrote: > hello there, > I want to find out processes that are causing other > processes in MySQL to backlog. > when i use show processlist command. It gives me the > snapshot of all the processes currently running. if i fired a > long-running query it gets "locked" and due to this other small > queries which i fired after words also get locked. > Now how will i get the processes that is causing other > processes to be locked. > i am using windows 2000 and MySQL 4.0 > > is there any solution? > > Thanks & Regards > Kapil.
SQL queries like a DELETE, UPDATE, or INSERT can lock a table under the right circumstances. Normally this isn't a problem. If you are having regular problems with this, you may need to add or remove indexes to alter the performance of the database. James ------------------------ Yahoo! Groups Sponsor --------------------~--> Great things are happening at Yahoo! Groups. See the new email design. http://us.click.yahoo.com/TISQkA/hOaOAA/yQLSAA/HKFolB/TM --------------------------------------------------------------------~-> Community email addresses: Post message: [email protected] Subscribe: [EMAIL PROTECTED] Unsubscribe: [EMAIL PROTECTED] List owner: [EMAIL PROTECTED] Shortcut URL to this page: http://groups.yahoo.com/group/php-list Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/php-list/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
