Professional Web Applications Themes

Too many mysqld instances - MySQL

Hi. We need to run mysql on a server with minimum memory usage. Currently, there are running 3 mysqld instances and 1 mysqld_safe instances on the linux box. How do I reduce the number of instances, I did not find a corresponding setting in the config file. Regards, Jan...

  1. #1

    Default Too many mysqld instances

    Hi.

    We need to run mysql on a server with minimum memory usage. Currently,
    there are running 3 mysqld instances and 1 mysqld_safe instances on the
    linux box. How do I reduce the number of instances, I did not find a
    corresponding setting in the config file.

    Regards, Jan
    Jan Krumsiek Guest

  2. #2

    Default Re: Too many mysqld instances

    >We need to run mysql on a server with minimum memory usage. Currently,
    >there are running 3 mysqld instances and 1 mysqld_safe instances on the
    >linux box. How do I reduce the number of instances, I did not find a
    >corresponding setting in the config file.
    I believe Linux shows you threads with 'ps', so you've probably
    got 1 process, 3 threads for mysqld.

    I believe the mysqld variable 'max_connections' will control this,
    but you really don't want to set it below 3.

    Gordon L. Burditt
    Gordon Burditt Guest

  3. #3

    Default Re: Too many mysqld instances

    Gordon Burditt schrieb:
    > I believe Linux shows you threads with 'ps', so you've probably
    > got 1 process, 3 threads for mysqld.
    >
    > I believe the mysqld variable 'max_connections' will control this,
    > but you really don't want to set it below 3.
    I think 'ps' shows all processes not threads. Both 'ps' and 'top' show
    my two mysqld instances.

    Regards, Jan
    Jan Krumsiek Guest

  4. #4

    Default Re: Too many mysqld instances

    [email]gordonb.wng7kburditt.org[/email] (Gordon Burditt) wrote:
    >>We need to run mysql on a server with minimum memory usage. Currently,
    >>there are running 3 mysqld instances and 1 mysqld_safe instances on the
    >>linux box. How do I reduce the number of instances, I did not find a
    >>corresponding setting in the config file.
    >
    > I believe Linux shows you threads with 'ps', so you've probably
    > got 1 process, 3 threads for mysqld.
    It's threads definitely. Linux kernels below 2.6 don't show the
    difference between threads and processes from user space.
    > I believe the mysqld variable 'max_connections' will control this,
    > but you really don't want to set it below 3.
    Mysqld runs in multiple threads. There is one master thread, a variable
    number of helper threads (log writer, tion, I/O) plus one thread
    per client connection (worker threads). There is also a thread cache
    for workers; it's size is conrolled by the thread_cache variable. Some
    nonstandard features (i.e. tion) and storage engines (innodb)
    start additional threads. AFAIK 3 threads is minimum.

    As for memory consumption: mysqld threads are pretty lightweight. Most
    buffers are shared. Each thread consumes it's own stack (192KB) sort
    buffer, read buffer (default: 8M each) and local variables. Beside the
    buffers thats approximately 300KB memory footprint per extra thread.


    XL
    Axel Schwenke Guest

Similar Threads

  1. FMS Removing instances
    By alanskinner in forum Macromedia Flash Flashcom
    Replies: 1
    Last Post: January 11th, 04:57 PM
  2. how do I manage all these instances?
    By John2 in forum Coldfusion Server Administration
    Replies: 2
    Last Post: June 13th, 04:36 PM
  3. Cluster 2 instances
    By Olav69 in forum Coldfusion Server Administration
    Replies: 1
    Last Post: June 9th, 10:06 PM
  4. CF7 instances
    By A_Sabrina in forum Macromedia ColdFusion
    Replies: 3
    Last Post: May 7th, 06:03 AM
  5. 2 Instances vs 2 DB's in SQL 2K
    By Chris Spiess in forum Microsoft SQL / MS SQL Server
    Replies: 1
    Last Post: June 30th, 04:18 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