Professional Web Applications Themes

balance between processes - MySQL

Hello, is there a way to configure a MySQL Server (v 5.1.11) that it balances the load between concurrent queries, when using only one instance? All I can find to Load Balancing is for clusters, but I don't use a cluster. I just want, that one large long query does not interrupt/slow-down other short queries running at the same time. It does not matter, if the long one takes 2 or 5 minutes, but having to wait 2 minutes for a short one until it is executed. :-) Maybe I have just been searching with the wrong keywords. Best regards ...

  1. #1

    Default balance between processes

    Hello,

    is there a way to configure a MySQL Server (v 5.1.11) that it balances
    the load between concurrent queries, when using only one instance?
    All I can find to Load Balancing is for clusters, but I don't use a
    cluster.

    I just want, that one large long query does not interrupt/slow-down
    other short queries running at the same time. It does not matter, if
    the long one takes 2 or 5 minutes, but having to wait 2 minutes for a
    short one until it is executed. :-)

    Maybe I have just been searching with the wrong keywords.

    Best regards
    Ralph.

    szeta Guest

  2. #2

    Default Re: balance between processes

    "szeta" <com> wrote: 

    No need to do so. MySQL server is multithreaded and spawns a new thread
    for each client connection (+ a few helper threads). As long as you
    have not more active connections than CPU cores, everything runs in
    parallel. Distributing threads to CPU cores is done by the operating
    system.


    XL
    --
    Axel Schwenke, Support Engineer, MySQL AB

    Online User Manual: http://dev.mysql.com/doc/refman/5.0/en/
    MySQL User Forums: http://forums.mysql.com/
    Axel Guest

  3. #3

    Default Re: balance between processes

    On 22 Feb., 13:53, Axel Schwenke <de> wrote: 

    Okay, but if I have several client connections but only one CPU core,
    is there a way to prevent complex_query_1 from affecting
    trivial_query_2 too much?

    Kind regards
    Ralph

    szeta Guest

  4. #4

    Default Re: balance between processes

    "szeta" <com> wrote: 
    >
    > Okay, but if I have several client connections but only one CPU core,
    > is there a way to prevent complex_query_1 from affecting
    > trivial_query_2 too much?[/ref]

    No. All MySQL threads have the same priority.


    XL
    --
    Axel Schwenke, Support Engineer, MySQL AB

    Online User Manual: http://dev.mysql.com/doc/refman/5.0/en/
    MySQL User Forums: http://forums.mysql.com/
    Axel Guest

  5. #5

    Default Re: balance between processes

    On 23 Feb., 00:19, Axel Schwenke <de> wrote: [/ref][/ref]
    Okay, thanks a lot for this update!
    Ralph
     [/ref]

    >
    > No. All MySQL threads have the same priority.
    >
    > XL
    > --
    > Axel Schwenke, Support Engineer, MySQL AB
    >
    > Online User Manual:http://dev.mysql.com/doc/refman/5.0/en/
    > MySQL User Forums: http://forums.mysql.com/[/ref]


    szeta Guest

Similar Threads

  1. Replies: 31
    Last Post: December 9th, 11:06 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