Announcement

Collapse
No announcement yet.

Long mysql querries like "sorting result"

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Long mysql querries like "sorting result"

    Processes are being spawned because we have long mysql querries like "sorting result" it the "post" table and all the other database connections are "Locked"

    Code:
    kharkovforum# mysqladmin -uroot -p********* processlist | less
    +--------+------------+-----------+------------+---------+------+----------------+------------------------------------------------------------------------------------------------------+
    | Id     | User       | Host      | db         | Command | Time | State          | Info                                                                                                 |
    +--------+------------+-----------+------------+---------+------+----------------+------------------------------------------------------------------------------------------------------+
    | 711764 | dimoks_db1 | localhost | dimoks_db1 | Query   | 23   | Sorting result | SELECT post.postid
                            FROM post AS post
    
                            WHERE post.threadid = 138177
                                    AND post.visible = 1 |
    | 711819 | dimoks_db1 | localhost | dimoks_db1 | Query   | 23   | Sorting result | SELECT post.postid
                            FROM post AS post
    
                            WHERE post.threadid = 114665
                                    AND post.visible = 1 |
    | 711858 | dimoks_db1 | localhost | dimoks_db1 | Query   | 23   | Sending data   | SELECT MIN(postid) AS postid
                            FROM post
                            WHERE threadid = 159509
                                    AND visible = 1
                                    AND dat |
    | 711942 | root       | localhost |            | Query   | 0    |                | show processlist                                                                                     |
    +--------+------------+-----------+------------+---------+------+----------------+-----------------------------
    ...

    Code:
    kharkovforum# mysqladmin -uroot -p******** processlist | less
    +--------+------------+-----------+------------+---------+------+----------------+------------------------------------------------------------------------------------------------------+
    | Id     | User       | Host      | db         | Command | Time | State          | Info                                                                                                 |
    +--------+------------+-----------+------------+---------+------+----------------+------------------------------------------------------------------------------------------------------+
    | 712940 | dimoks_db1 | localhost | dimoks_db1 | Query   | 34   | Sorting result | SELECT post.postid
                            FROM post AS post
    
                            WHERE post.threadid = 388337
                                    AND post.visible = 1 |
    | 713089 | dimoks_db1 | localhost | dimoks_db1 | Query   | 28   | Sorting result | SELECT post.postid
                            FROM post AS post
    
                            WHERE post.threadid = 91548
                                    AND post.visible = 1
     |
    | 713174 | dimoks_db1 | localhost | dimoks_db1 | Query   | 26   | Sorting result | SELECT post.postid
                            FROM post AS post
    
                            WHERE post.threadid = 91699
                                    AND post.visible = 1
     |
    | 713251 | root       | localhost |            | Query   | 0    |                | show processlist                                                                                     |
    +--------+------------+-----------+------------+---------+------+----------------+--------------------
    Please help

  • #2
    Might be worth posting this in the Server Configuration forum as there's a few guys in there regularly who might not see it here...
    Vote for:

    - *Admin Settable Paid Subscription Reminder Timeframe*
    -
    *PM - Add ability to reply to originator only*
    - Add Admin ability to auto-subscribe users to specific channel(s)
    - Highlight the correct navigation tab when you are on a custom page
    - "Quick Route" Interface...
    - Allow to use custom icons for individual forums

    Comment

    widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
    Working...
    X