Results 1 to 6 of 6
  1. #1

    Mysql and Memory

    Hi,
    I have clean install of Ubuntu 10.04 server. I installed mysql-server.
    Even with no databases, the mysqld shows 140mb used.

    Is this normal ?
    pmap shows
    Code:
    af534000      4K -----    [ anon ]
    af535000  10236K rw---    [ anon ]
    aff34000      4K -----    [ anon ]
    aff35000  10236K rw---    [ anon ]
    b0934000      4K -----    [ anon ]
    b0935000  10236K rw---    [ anon ]
    b1334000      4K -----    [ anon ]
    b1335000  12308K rw---    [ anon ]
    b2163000      4K -----    [ anon ]
    b2164000    188K rw---    [ anon ]
    b2193000      4K -----    [ anon ]
    b2194000    188K rw---    [ anon ]
    b21c3000      4K -----    [ anon ]
    b21c4000  10236K rw---    [ anon ]
    b2bc3000      4K -----    [ anon ]
    b2bc4000  10236K rw---    [ anon ]
    b35c3000      4K -----    [ anon ]
    b35c4000  54352K rw---    [ anon ]
    b6ad8000     40K r-x--  /lib/libnss_files-2.11.1.so
    b6ae2000      4K r----  /lib/libnss_files-2.11.1.so
    b6ae3000      4K rw---  /lib/libnss_files-2.11.1.so
    b6ae4000     32K r-x--  /lib/libnss_nis-2.11.1.so
    b6aec000      4K r----  /lib/libnss_nis-2.11.1.so
    b6aed000      4K rw---  /lib/libnss_nis-2.11.1.so
    b6aee000     24K r-x--  /lib/libnss_compat-2.11.1.so
    b6af4000      4K r----  /lib/libnss_compat-2.11.1.so
    b6af5000      4K rw---  /lib/libnss_compat-2.11.1.so
    b6af6000      4K -----    [ anon ]
    b6af7000  10244K rw---    [ anon ]
    b74f8000   1288K r-x--  /lib/libc-2.11.1.so
    b763a000      4K -----  /lib/libc-2.11.1.so
    b763b000      8K r----  /lib/libc-2.11.1.so
    b763d000      4K rw---  /lib/libc-2.11.1.so
    b763e000     12K rw---    [ anon ]
    b7641000    116K r-x--  /lib/libgcc_s.so.1
    b765e000      4K r----  /lib/libgcc_s.so.1
    b765f000      4K rw---  /lib/libgcc_s.so.1
    b7660000      4K rw---    [ anon ]
    b7661000    144K r-x--  /lib/libm-2.11.1.so
    b7685000      4K r----  /lib/libm-2.11.1.so
    b7686000      4K rw---  /lib/libm-2.11.1.so
    b7687000    932K r-x--  /usr/lib/libstdc++.so.6.0.13
    b7770000      4K -----  /usr/lib/libstdc++.so.6.0.13
    b7771000     16K r----  /usr/lib/libstdc++.so.6.0.13
    b7775000      4K rw---  /usr/lib/libstdc++.so.6.0.13
    b7776000     28K rw---    [ anon ]
    b777d000     76K r-x--  /lib/libnsl-2.11.1.so
    b7790000      4K r----  /lib/libnsl-2.11.1.so
    b7791000      4K rw---  /lib/libnsl-2.11.1.so
    b7792000      8K rw---    [ anon ]
    b7794000     36K r-x--  /lib/libcrypt-2.11.1.so
    b779d000      4K r----  /lib/libcrypt-2.11.1.so
    b779e000      4K rw---  /lib/libcrypt-2.11.1.so
    b779f000    156K rw---    [ anon ]
    b77c6000      8K r-x--  /lib/libdl-2.11.1.so
    b77c8000      4K r----  /lib/libdl-2.11.1.so
    b77c9000      4K rw---  /lib/libdl-2.11.1.so
    b77ca000     28K r-x--  /lib/libwrap.so.0.7.6
    b77d1000      4K r----  /lib/libwrap.so.0.7.6
    b77d2000      4K rw---  /lib/libwrap.so.0.7.6
    b77d3000      4K rw---    [ anon ]
    b77d4000     76K r-x--  /lib/libz.so.1.2.3.3
    b77e7000      4K r----  /lib/libz.so.1.2.3.3
    b77e8000      4K rw---  /lib/libz.so.1.2.3.3
    b77e9000     80K r-x--  /lib/libpthread-2.11.1.so
    b77fd000      4K r----  /lib/libpthread-2.11.1.so
    b77fe000      4K rw---  /lib/libpthread-2.11.1.so
    b77ff000      8K rw---    [ anon ]
    b7805000      8K rw---    [ anon ]
    b7807000    108K r-x--  /lib/ld-2.11.1.so
    b7822000      4K r----  /lib/ld-2.11.1.so
    b7823000      4K rw---  /lib/ld-2.11.1.so
    b7824000   7648K r-x--  /usr/sbin/mysqld
    b7f9c000    208K r----  /usr/sbin/mysqld
    b7fd0000    380K rw---  /usr/sbin/mysqld
    b802f000     72K rw---    [ anon ]
    b9db2000   5088K rw---    [ anon ]
    bfce3000     84K rw---    [ stack ]
     total   145332K

  2. #2
    Join Date
    Apr 2005
    Location
    Raleigh, NC
    Posts
    816
    I'm not a Linux expert, so please wait until one of them chimes in, but I'd say this is about normal.

  3. #3
    Join Date
    Mar 2011
    Location
    Bahrain
    Posts
    1

    perlengkapan bayi

    perlengkapan bayi

  4. #4
    Yes, that's normal. The list isn't showing anything out of line.

  5. #5
    Join Date
    Mar 2011
    Posts
    41
    mysql allocates a certain amount of memory for things like buffer pools and such. If innodb is enabled, there is multiple variables that account for memory usage. Do a > show variables; and look for things like innodb_buffer_pool_size is usually the biggest.

  6. #6
    Join Date
    Nov 2006
    Location
    Karachi, Pakistan
    Posts
    1,349
    Yeah this is normal even under centos. I usually grab a VPS optimized version of the mysql config file my.cnf. Here's a copy:

    http://wiki.vpslink.com/Low_memory_M...configurations

Similar Threads

  1. how much memory for MYSql
    By taykunats in forum VPS Hosting
    Replies: 3
    Last Post: 10-21-2010, 02:32 AM
  2. mysql out of memory error
    By dustro in forum Hosting Security and Technology
    Replies: 5
    Last Post: 05-05-2010, 02:28 AM
  3. MySQL 4.1 vs 5.1/5.0 (memory usage)
    By DjiXas in forum Hosting Security and Technology
    Replies: 3
    Last Post: 11-07-2009, 04:08 AM
  4. MySQL memory problem
    By Zaggs in forum Hosting Security and Technology
    Replies: 3
    Last Post: 05-16-2008, 12:00 PM
  5. mysql uses up a lot of memory
    By HD Fanatic in forum Hosting Security and Technology
    Replies: 19
    Last Post: 11-28-2005, 05:44 AM

Posting Permissions

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