#1
  1. Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Aug 2012
    Location
    Southern New Jersey, USA
    Posts
    205
    Rep Power
    102

    Having resource issues on a MySQL 5.0 server


    Hello everyone,

    I am looking for some help here. I am a DBA and have some understanding in what I am asking for but I need a higher knowledge resource to aid me here. At my company we use Ultra Sparc 4's as our servers with Dual cores and 8 Processors 1350 Mhz and 32 g memory, running Solaris 10 -1009. The database is 5.0.51a MySql and there are 4 Zones, which are simular to VMs in the Sun/Solaris world. Now the way these Zones are configured, each Zone draws from the total pool of resources of the named machine. So if two of the zones are heavy usage and say a thrid needs resources, this could be a problem. The SysAdmins tell me that this is a common problem.

    Now my need of help is can someone aid me in giving me command line commands to run to see what the perforamce and usage is on this server. We are in beginning proces of design/planning to switch off of Sun/Solaris to Linux/HP servers. Still I need to prove that the performance hits that are happening to these four databases(one in each of these zones) are the issue. Can someone aid me in defining what commands I should run to determine this please.

    Thank you in advance!!!

    PS: I realize this is a Sun/Solaris question and that I asked it in a Linux section too, but there is no Sun/Solaris section to ask it in. Also I have asking it in a MySQL section too, as I am guessing I should also run stats within the database as well too. Note I am a Oracle DBA but I also support MySQL too and I am not fully up on MySQL 5.0
  2. #2
  3. Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Aug 2012
    Location
    Southern New Jersey, USA
    Posts
    205
    Rep Power
    102
    Here is a example of TOP, VMSTAT, and IOSTAT...that was run....what should I be looking for or is there something else that I should be running?


    ********** Statistics for Fri Aug 10 00:35:00 EDT 2012 ***************
    **********************************************************************
    +++++++++++++++++++ TOP +++++++++++++++++++++++++++++++++
    load averages: 3.65, 3.50, 3.23; up 1+04:37:54 00:35:01
    79 processes: 73 sleeping, 6 on cpu
    CPU states: 75.2% idle, 22.0% user, 2.9% kernel, 0.0% iowait, 0.0% swap
    Kernel: 5249 ctxsw, 1715 trap, 3977 intr, 36980 syscall, 4 fork, 1394 flt
    Memory: 32G phys mem, 827M free mem, 32G total swap, 32G free swap

    PID USERNAME LWP PRI NICE SIZE RES STATE TIME CPU COMMAND
    19502 qedadm 4 4 2 510M 467M cpu/5 74:49 6.07% qed
    7565 qedadm 1 4 2 86M 51M cpu/4 0:01 4.59% qed
    19503 qedadm 4 34 2 658M 618M cpu/2 74:57 4.04% qed
    4320 mysql 32 59 0 671M 403M cpu/22 201:15 3.43% mysqld
    7598 qedadm 1 33 2 79M 16M cpu/0 0:00 0.40% qed
    8277 qedadm 11 49 0 50M 26M sleep 8:21 0.12% QdmMonitor
    9687 joazil 9 59 0 145M 120M sleep 19:26 0.10% Q2.exe
    19498 qedadm 3 53 2 82M 41M sleep 0:19 0.09% qed
    8260 qedadm 39 59 0 150M 90M sleep 10:31 0.05% java
    19475 qedadm 11 53 2 82M 59M sleep 0:09 0.04% HardCloseDriver
    7593 root 1 54 0 3352K 1976K cpu/1 0:00 0.03% top
    16444 root 97 59 0 366M 299M sleep 7:22 0.03% java
    2862 root 33 59 0 11M 5160K sleep 0:25 0.02% nscd
    7597 qedadm 1 43 2 1656K 1112K sleep 0:00 0.02% sh
    8297 qedadm 3 59 0 86M 44M sleep 135:42 0.01% qed
    8295 qedadm 3 59 0 86M 44M sleep 125:21 0.01% qed
    8334 qedadm 2 59 0 43M 26M sleep 1:47 0.01% QDataDeliveryCl
    8296 qedadm 3 59 0 86M 44M sleep 128:00 0.00% qed
    6570 noaccess 18 59 0 179M 124M sleep 1:57 0.00% java
    19499 qedadm 3 53 2 82M 41M sleep 0:21 0.00% qed
    9661 joazil 1 59 0 12M 1216K sleep 0:13 0.00% sshd
    3423 root 1 54 0 3440K 1072K sleep 0:00 0.00% cron
    2440 root 12 59 0 14M 1608K sleep 0:07 0.00% svc.startd
    3769 root 1 59 0 1680K 448K sleep 0:00 0.00% utmpd
    6614 qedadm 1 59 0 5368K 320K sleep 0:04 0.00% lighttpd
    8392 qedadm 2 59 0 80M 47M sleep 0:56 0.00% monitorIncoming
    5561 root 1 59 0 4144K 760K sleep 0:35 0.00% tier3loadprobe
    2445 root 14 59 0 11M 2248K sleep 0:23 0.00% svc.configd
    8301 qedadm 1 59 0 37M 18M sleep 0:07 0.00% tecLogDaemon
    4464 root 1 59 0 8040K 3216K sleep 0:04 0.00% cupsd

    ------------------- DF ---------------------------------
    Filesystem size used avail capacity Mounted on
    / 226G 53G 172G 24% /
    /dev 226G 53G 172G 24% /dev
    proc 0K 0K 0K 0% /proc
    ctfs 0K 0K 0K 0% /system/contract
    mnttab 0K 0K 0K 0% /etc/mnttab
    objfs 0K 0K 0K 0% /system/object
    swap 27G 392K 27G 1% /etc/svc/volatile
    /platform/sun4u-us3/lib/libc_psr/libc_psr_hwcap1.so.1 226G 53G 172G 24% /platform/sun4u-us3/lib/libc_psr.so.1
    /platform/sun4u-us3/lib/sparcv9/libc_psr/libc_psr_hwcap1.so.1 226G 53G 172G 24% /platform/sun4u-us3/lib/sparcv9/libc_psr.so.1
    fd 0K 0K 0K 0% /dev/fd
    swap 27G 264K 27G 1% /tmp
    swap 27G 56K 27G 1% /var/run
    ^^^^^^^^^^^^^^^^^^^ VMSTAT ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
    kthr memory page disk faults cpu
    r b w swap free re mf pi po fr de sr s1 sd sd sd in sy cs us sy id
    0 0 0 32835184 5335840 138 436 0 0 0 0 0 -0 37 2 2 5281 29090 4658 11 3 87
    0 0 0 28452840 843680 681 2632 0 0 0 0 0 0 36 0 0 3686 38121 5389 22 4 75
    0 0 0 28474000 847608 308 1219 0 0 0 0 0 0 11 0 0 3635 31059 4501 18 3 79
    0 0 0 28475064 847920 389 1229 0 0 0 0 0 0 45 0 0 3650 35947 4931 18 3 78
    0 0 0 28467384 847328 407 1523 0 0 0 0 0 0 21 0 0 3665 30965 4940 18 3 79
    0 0 0 28451376 840352 388 1618 0 0 0 0 0 0 15 0 0 3502 33076 4703 23 3 74
    0 0 0 28473744 845400 167 647 0 0 0 0 0 0 89 2 2 3975 24405 5352 18 5 76
    0 0 0 28460288 840048 255 1022 0 0 0 0 0 0 84 0 0 3894 25744 5380 19 3 78
    0 0 0 28450640 832952 409 1661 0 0 0 0 0 0 23 0 0 3524 37532 4682 23 3 74
    0 0 0 28444400 834296 480 1832 0 0 0 0 0 0 24 0 0 3654 34963 4849 22 3 75
    ################### IOSTAT #############################
    tty sd1 ssd0 ssd1 ssd2 cpu
    tin tout kps tps serv kps tps serv kps tps serv kps tps serv us sy wt id
    0 8 0 0 0 1281 37 14 52 2 21 52 2 21 11 3 0 87
    0 0 0 0 0 1825 39 8 0 0 0 0 0 0 23 3 0 74
    0 0 0 0 0 884 21 5 0 0 0 0 0 0 21 2 0 77
    0 0 0 0 0 1412 30 8 0 0 0 0 0 0 17 2 0 81
    0 0 0 0 0 1011 24 5 0 0 0 0 0 0 18 2 0 81
    0 0 0 0 0 1296 30 5 0 0 0 0 0 0 17 2 0 81
    0 0 0 0 0 584 14 5 0 0 0 0 0 0 13 1 0 86
    0 0 0 0 0 4096 76 23 56 15 17 56 16 16 11 2 0 86
    0 0 0 0 0 492 48 11 0 0 0 0 0 0 12 1 0 87
    0 0 0 0 0 1011 42 7 0 0 0 0 0 0 11 1 0 88

IMN logo majestic logo threadwatch logo seochat tools logo