Professional Web Applications Themes

What make it loked query of mysql 4.0.2 ? - MySQL

Hi I'm using a java application with mysql 4.0.2 when I issue "show processlist", I can see serveral query locked. I didn't lock query from my java code, but some query are locked.... I don't know why query are locked... What make it loked query of mysql 4.0.2 ? Any comment will help me. Have a day....

  1. #1

    Default What make it loked query of mysql 4.0.2 ?

    Hi

    I'm using a java application with mysql 4.0.2
    when I issue "show processlist", I can see serveral query locked.
    I didn't lock query from my java code, but some query are locked....

    I don't know why query are locked...
    What make it loked query of mysql 4.0.2 ?

    Any comment will help me.


    Have a day.


    somez72 Guest

  2. #2

    Default Re: What make it loked query of mysql 4.0.2 ?

    Hi there.
    A number of reasons can lead to locked query appearence in processlist.
    Here's the link where mySQL locking is described in general, i guess
    [url]http://dev.mysql.com/doc/refman/4.1/en/locking-issues.html[/url]

    Other words, queries can be locked because the need resources (i.e. a
    single row for innodb tables and whole table fo myisam tables) which is
    used by someone else now.

    I.e. in one your session you issue
    mysql> select last_name, first_name from emp where emp_id = 12 for
    update;
    and then in parallel session you say
    update emp set department_id = 'Sales' where emp_id = '12';

    Second query will wat until the first session either commited or rolled
    back.

    robocomp Guest

Similar Threads

  1. Is this a MySQL Query bug?
    By Carl Anatorian in forum MySQL
    Replies: 4
    Last Post: June 13th, 07:29 AM
  2. Replies: 0
    Last Post: November 4th, 05:38 PM
  3. Make a query faster...
    By v.demartino2@virgilio.it in forum PostgreSQL / PGSQL
    Replies: 0
    Last Post: December 18th, 06:26 PM
  4. MySql query help
    By luckyrye in forum PHP Development
    Replies: 2
    Last Post: May 1st, 05:25 AM
  5. PHP - MySQL Query...
    By Steven Kallstrom in forum PHP Development
    Replies: 2
    Last Post: August 14th, 02:22 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139