Join the community today
Register Now

MariaDB Issue Importing Database

Discussion in 'Nginx, PHP-FPM & MariaDB MySQL' started by Jake, Mar 5, 2015.

  1. eva2000

    eva2000 Administrator Staff Member

    44,731
    10,196
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +15,804
    Local Time:
    1:59 PM
    Nginx 1.17.x
    MariaDB 5.5/10.x
  2. Jake

    Jake Member

    76
    10
    8
    Feb 3, 2015
    Ratings:
    +11
    Local Time:
    1:59 PM
    NA
    Maria DB 5.5
  3. Jake

    Jake Member

    76
    10
    8
    Feb 3, 2015
    Ratings:
    +11
    Local Time:
    1:59 PM
    NA
    Maria DB 5.5
    Code:
    -------------------------------------------------------------
    System MySQL monitoring stats
    mysqlmymonlite.sh - 0.5.3 mysqlmymon.com
    compiled by George Liu (eva2000) vbtechsupport.com
    -------------------------------------------------------------
    
    Report Generated:
    Thu Mar 5 20:07:13 UTC 2015
    
    ----------------------------
    MySQL Uptime:
    ----------------------------
    MySQL server was started 2015-03-05 19:38:33
    Uptime: 28 min 40 sec   
    Uptime 1720
    Uptime_since_flush_status 1720
    
    Max Used Connections:      2/300 (0.67%)
    Key Buffer Used:           1.00k/32.00M (0.00%)
    Key Buffer Used:           8.00k/8.00M (0.10%)
    Current Key Buffer Usage:  5.84M (18.24%)
    Current Key Buffer Usage:  328.00k (4.00%)
    Query Cache:               17.12k/16.00M (0.10%)
    Table Locks Waited:        0 Rate: 0/s (0.00%)
    --------------------
    Query Cache Limit (bytes): 524288
    Query Cache Min Unit (bytes): 2048
    Query Cache Size (bytes): 16777216
    Query Cache Free Mem (bytes): 16759688
    Query Cache Used Mem (bytes): 17528
    Queries in Query Cache: 1
    Query Cache Avg Size (bytes): 17528
    
    ----------------------------
    Hardware Info:
    ----------------------------
    Processors physical = 1, cores = 4, virtual = 8, hyperthreading = yes
          7  1600.000
          1  2801.000
          8  Intel(R) Xeon(R) CPU           W3530  @ 2.80GHz
          8  8192 KB
    
    
    ----------------------------
    TOP stats
    ----------------------------
    
    Linux 3.14.32-xxxx-grs-ipv6-64 ((yourserverhostname))     03/05/2015     _x86_64_    (8 CPU)
    
    08:07:13 PM  CPU    %usr   %nice    %sys %iowait    %irq   %soft  %steal  %guest   %idle
    08:07:15 PM  all   12.51    0.00    0.00    0.06    0.00    0.00    0.00    0.00   87.43
    08:07:15 PM    0    0.00    0.00    0.50    0.00    0.00    0.00    0.00    0.00   99.50
    08:07:15 PM    1    0.00    0.00    0.00    0.50    0.00    0.00    0.00    0.00   99.50
    08:07:15 PM    2    0.00    0.00    0.00    0.00    0.00    0.00    0.00    0.00  100.00
    08:07:15 PM    3  100.00    0.00    0.00    0.00    0.00    0.00    0.00    0.00    0.00
    08:07:15 PM    4    0.00    0.00    0.00    0.00    0.00    0.00    0.00    0.00  100.00
    08:07:15 PM    5    0.00    0.00    0.00    0.00    0.00    0.00    0.00    0.00  100.00
    08:07:15 PM    6    0.00    0.00    0.00    0.00    0.00    0.00    0.00    0.00  100.00
    08:07:15 PM    7    0.00    0.00    0.00    0.00    0.00    0.00    0.00    0.00  100.00
    
    08:07:15 PM  CPU    %usr   %nice    %sys %iowait    %irq   %soft  %steal  %guest   %idle
    08:07:17 PM  all   12.50    0.00    0.00    0.00    0.00    0.00    0.00    0.00   87.50
    08:07:17 PM    0    0.00    0.00    0.00    0.00    0.00    0.00    0.00    0.00  100.00
    08:07:17 PM    1    0.50    0.00    0.00    0.00    0.00    0.00    0.00    0.00   99.50
    08:07:17 PM    2    0.00    0.00    0.00    0.00    0.00    0.00    0.00    0.00  100.00
    08:07:17 PM    3  100.00    0.00    0.00    0.00    0.00    0.00    0.00    0.00    0.00
    08:07:17 PM    4    0.00    0.00    0.00    0.00    0.00    0.00    0.00    0.00  100.00
    08:07:17 PM    5    0.00    0.00    0.00    0.00    0.00    0.00    0.00    0.00  100.00
    08:07:17 PM    6    0.00    0.00    0.00    0.00    0.00    0.00    0.00    0.00  100.00
    08:07:17 PM    7    0.00    0.00    0.00    0.00    0.00    0.00    0.00    0.00  100.00
    
    Average:     CPU    %usr   %nice    %sys %iowait    %irq   %soft  %steal  %guest   %idle
    Average:     all   12.50    0.00    0.00    0.03    0.00    0.00    0.00    0.00   87.46
    Average:       0    0.00    0.00    0.25    0.00    0.00    0.00    0.00    0.00   99.75
    Average:       1    0.25    0.00    0.00    0.25    0.00    0.00    0.00    0.00   99.50
    Average:       2    0.00    0.00    0.00    0.00    0.00    0.00    0.00    0.00  100.00
    Average:       3  100.00    0.00    0.00    0.00    0.00    0.00    0.00    0.00    0.00
    Average:       4    0.00    0.00    0.00    0.00    0.00    0.00    0.00    0.00  100.00
    Average:       5    0.00    0.00    0.00    0.00    0.00    0.00    0.00    0.00  100.00
    Average:       6    0.00    0.00    0.00    0.00    0.00    0.00    0.00    0.00  100.00
    Average:       7    0.00    0.00    0.00    0.00    0.00    0.00    0.00    0.00  100.00
    
    top - 20:07:18 up  1:00,  1 user,  load average: 1.08, 1.14, 1.09
    Tasks: 170 total,   2 running, 168 sleeping,   0 stopped,   0 zombie
    Cpu(s):  7.9%us,  1.0%sy,  0.0%ni, 90.3%id,  0.9%wa,  0.0%hi,  0.0%si,  0.0%st
    Mem:  32995868k total,  3945652k used, 29050216k free,    53692k buffers
    Swap:  1046520k total,        0k used,  1046520k free,  3227000k cached
    
      PID USER      PR  NI  VIRT  RES  SHR S %CPU %MEM    TIME+  COMMAND           
    1960 phpmyadm  20   0  465m 129m  13m R 99.3  0.4  16:04.60 php-fpm           
    32601 mysql     20   0  166m  27m 7460 S  2.0  0.1   0:00.66 mysqld            
        1 root      20   0 19280 1520 1224 S  0.0  0.0   0:00.74 init              
        2 root      20   0     0    0    0 S  0.0  0.0   0:00.00 kthreadd          
        3 root      20   0     0    0    0 S  0.0  0.0   0:00.44 ksoftirqd/0       
        5 root       0 -20     0    0    0 S  0.0  0.0   0:00.00 kworker/0:0H      
        7 root      20   0     0    0    0 S  0.0  0.0   0:04.06 rcu_sched         
        8 root      20   0     0    0    0 S  0.0  0.0   0:00.00 rcu_bh            
        9 root      RT   0     0    0    0 S  0.0  0.0   0:00.04 migration/0       
       10 root      RT   0     0    0    0 S  0.0  0.0   0:00.02 migration/1       
       11 root      20   0     0    0    0 S  0.0  0.0   0:00.33 ksoftirqd/1       
       13 root       0 -20     0    0    0 S  0.0  0.0   0:00.00 kworker/1:0H      
       14 root      RT   0     0    0    0 S  0.0  0.0   0:00.02 migration/2       
       15 root      20   0     0    0    0 S  0.0  0.0   0:00.32 ksoftirqd/2       
       17 root       0 -20     0    0    0 S  0.0  0.0   0:00.00 kworker/2:0H      
       18 root      RT   0     0    0    0 S  0.0  0.0   0:00.02 migration/3       
       19 root      20   0     0    0    0 S  0.0  0.0   0:00.30 ksoftirqd/3       
       21 root       0 -20     0    0    0 S  0.0  0.0   0:00.00 kworker/3:0H      
       22 root      RT   0     0    0    0 S  0.0  0.0   0:00.10 migration/4       
       23 root      20   0     0    0    0 S  0.0  0.0   0:00.16 ksoftirqd/4       
       24 root      20   0     0    0    0 S  0.0  0.0   0:00.00 kworker/4:0       
       25 root       0 -20     0    0    0 S  0.0  0.0   0:00.00 kworker/4:0H      
       26 root      RT   0     0    0    0 S  0.0  0.0   0:00.12 migration/5       
       27 root      20   0     0    0    0 S  0.0  0.0   0:00.15 ksoftirqd/5       
       29 root       0 -20     0    0    0 S  0.0  0.0   0:00.00 kworker/5:0H      
       30 root      RT   0     0    0    0 S  0.0  0.0   0:00.12 migration/6       
       31 root      20   0     0    0    0 S  0.0  0.0   0:00.16 ksoftirqd/6       
       32 root      20   0     0    0    0 S  0.0  0.0   0:00.00 kworker/6:0       
       33 root       0 -20     0    0    0 S  0.0  0.0   0:00.00 kworker/6:0H      
       34 root      RT   0     0    0    0 S  0.0  0.0   0:00.10 migration/7       
       35 root      20   0     0    0    0 S  0.0  0.0   0:00.16 ksoftirqd/7       
       36 root      20   0     0    0    0 S  0.0  0.0   0:00.00 kworker/7:0       
       37 root       0 -20     0    0    0 S  0.0  0.0   0:00.00 kworker/7:0H      
       38 root       0 -20     0    0    0 S  0.0  0.0   0:00.00 khelper           
       39 root      20   0     0    0    0 S  0.0  0.0   0:00.00 kdevtmpfs         
       40 root       0 -20     0    0    0 S  0.0  0.0   0:00.00 netns             
      540 root       0 -20     0    0    0 S  0.0  0.0   0:00.00 writeback         
      543 root      25   5     0    0    0 S  0.0  0.0   0:00.00 ksmd              
      544 root       0 -20     0    0    0 S  0.0  0.0   0:00.00 kintegrityd       
      545 root       0 -20     0    0    0 S  0.0  0.0   0:00.00 bioset            
      546 root       0 -20     0    0    0 S  0.0  0.0   0:00.00 crypto            
      548 root       0 -20     0    0    0 S  0.0  0.0   0:00.00 kblockd           
      625 nobody    20   0  337m  920  404 S  0.0  0.0   0:00.06 memcached         
      698 root       0 -20     0    0    0 S  0.0  0.0   0:00.00 ata_sff           
      709 root      20   0     0    0    0 S  0.0  0.0   0:00.00 khubd             
      719 root       0 -20     0    0    0 S  0.0  0.0   0:00.00 md                
      722 root       0 -20     0    0    0 S  0.0  0.0   0:00.00 edac-poller       
      749 root      20   0     0    0    0 S  0.0  0.0   0:02.12 kworker/0:1       
      751 root      20   0     0    0    0 S  0.0  0.0   0:00.89 kworker/2:1       
      752 root      20   0     0    0    0 S  0.0  0.0   0:00.92 kworker/3:1       
      753 root      20   0     0    0    0 S  0.0  0.0   0:00.64 kworker/4:1       
      754 root      20   0     0    0    0 S  0.0  0.0   0:00.36 kworker/5:1       
      755 root      20   0     0    0    0 S  0.0  0.0   0:00.35 kworker/7:1       
      855 root       0 -20     0    0    0 S  0.0  0.0   0:00.00 rpciod            
      856 root       0 -20     0    0    0 S  0.0  0.0   0:00.00 kvm-irqfd-clean   
      931 root      20   0     0    0    0 S  0.0  0.0   0:00.00 kswapd0           
    1074 root      20   0     0    0    0 S  0.0  0.0   0:00.00 fsnotify_mark     
    1113 root       0 -20     0    0    0 S  0.0  0.0   0:00.00 nfsiod            
    1126 root       0 -20     0    0    0 S  0.0  0.0   0:00.00 cifsiod           
    1147 root      20   0     0    0    0 S  0.0  0.0   0:00.00 jfsIO             
    1148 root      20   0     0    0    0 S  0.0  0.0   0:00.00 jfsCommit         
    1149 root      20   0     0    0    0 S  0.0  0.0   0:00.00 jfsCommit         
    1150 root      20   0     0    0    0 S  0.0  0.0   0:00.00 jfsCommit         
    1151 root      20   0     0    0    0 S  0.0  0.0   0:00.00 jfsCommit         
    1152 root      20   0     0    0    0 S  0.0  0.0   0:00.00 jfsCommit         
    1153 root      20   0     0    0    0 S  0.0  0.0   0:00.00 jfsCommit         
    1154 root      20   0     0    0    0 S  0.0  0.0   0:00.00 jfsCommit         
    1155 root      20   0     0    0    0 S  0.0  0.0   0:00.00 jfsCommit         
    1156 root      20   0     0    0    0 S  0.0  0.0   0:00.00 jfsSync           
    1171 root       0 -20     0    0    0 S  0.0  0.0   0:00.00 xfsalloc          
    1173 root       0 -20     0    0    0 S  0.0  0.0   0:00.00 xfs_mru_cache     
    1176 root       0 -20     0    0    0 S  0.0  0.0   0:00.00 xfslogd           
    1183 root       0 -20     0    0    0 S  0.0  0.0   0:00.00 ocfs2_wq          
    1186 root       0 -20     0    0    0 S  0.0  0.0   0:00.00 user_dlm          
    1192 root       0 -20     0    0    0 S  0.0  0.0   0:00.00 glock_workqueue   
    1193 root       0 -20     0    0    0 S  0.0  0.0   0:00.00 delete_workqueu   
    1201 root       0 -20     0    0    0 S  0.0  0.0   0:00.00 gfs_recovery      
    1239 root       0 -20     0    0    0 S  0.0  0.0   0:00.00 kthrotld          
    1839 root      20   0  125m 3224  392 S  0.0  0.0   0:00.00 nginx             
    1840 nginx     10 -10  136m 9584 4296 S  0.0  0.0   0:00.45 nginx             
    1881 root      20   0     0    0    0 S  0.0  0.0   0:00.14 nvme              
    1882 root       0 -20     0    0    0 S  0.0  0.0   0:00.00 nvme              
    1883 root      20   0  258m 6800  824 S  0.0  0.0   0:00.02 php-fpm           
    1920 root       0 -20     0    0    0 S  0.0  0.0   0:00.00 bioset            
    1921 root       0 -20     0    0    0 S  0.0  0.0   0:00.00 drbd-reissue      
    1957 root       0 -20     0    0    0 S  0.0  0.0   0:00.00 iscsi_eh          
    1961 phpmyadm  20   0  354m  19m  10m S  0.0  0.1   0:00.10 php-fpm           
    2004 root      20   0     0    0    0 S  0.0  0.0   0:00.00 scsi_eh_0         
    2005 root       0 -20     0    0    0 S  0.0  0.0   0:00.00 scsi_tmf_0        
    2010 root      20   0     0    0    0 S  0.0  0.0   0:00.00 scsi_eh_1         
    2011 root       0 -20     0    0    0 S  0.0  0.0   0:00.00 scsi_tmf_1        
    2014 root      20   0     0    0    0 S  0.0  0.0   0:00.00 scsi_eh_2         
    2015 root       0 -20     0    0    0 S  0.0  0.0   0:00.00 scsi_tmf_2        
    2018 root      20   0     0    0    0 S  0.0  0.0   0:00.00 scsi_eh_3         
    2019 root       0 -20     0    0    0 S  0.0  0.0   0:00.00 scsi_tmf_3        
    2022 root      20   0     0    0    0 S  0.0  0.0   0:00.00 scsi_eh_4         
    2023 root       0 -20     0    0    0 S  0.0  0.0   0:00.00 scsi_tmf_4        
    2026 root      20   0     0    0    0 S  0.0  0.0   0:00.00 scsi_eh_5         
    2027 root       0 -20     0    0    0 S  0.0  0.0   0:00.00 scsi_tmf_5        
    2032 root      20   0     0    0    0 S  0.0  0.0   0:02.04 kworker/u32:5     
    2050 root       0 -20     0    0    0 S  0.0  0.0   0:00.00 bond0             
    2092 root       0 -20     0    0    0 S  0.0  0.0   0:00.00 bnx2x             
    2113 root       0 -20     0    0    0 S  0.0  0.0   0:00.00 mlx4              
    2131 root       0 -20     0    0    0 S  0.0  0.0   0:00.00 vfio-irqfd-clea   
    2205 root       0 -20     0    0    0 S  0.0  0.0   0:00.00 kpsmoused         
    2207 root      20   0     0    0    0 S  0.0  0.0   0:00.00 kworker/2:2       
    2227 root       0 -20     0    0    0 S  0.0  0.0   0:00.00 raid5wq           
    2229 root       0 -20     0    0    0 S  0.0  0.0   0:00.00 bcache            
    2230 root       0 -20     0    0    0 S  0.0  0.0   0:00.00 bch_btree_io      
    2237 root       0 -20     0    0    0 S  0.0  0.0   0:00.00 dm_bufio_cache    
    2241 root       0 -20     0    0    0 S  0.0  0.0   0:00.00 kmpathd           
    2242 root       0 -20     0    0    0 S  0.0  0.0   0:00.00 kmpath_handlerd   
    2314 root       0 -20     0    0    0 S  0.0  0.0   0:00.00 ipv6_addrconf     
    2330 root       0 -20     0    0    0 S  0.0  0.0   0:00.00 ceph-msgr         
    2355 root       0 -20     0    0    0 S  0.0  0.0   0:00.00 bioset            
    2366 root       0 -20     0    0    0 S  0.0  0.0   0:00.00 deferwq           
    2371 root       0 -20     0    0    0 S  0.0  0.0   0:00.00 bioset            
    2372 root      20   0     0    0    0 S  0.0  0.0   0:01.56 md3_raid1         
    2376 root       0 -20     0    0    0 S  0.0  0.0   0:00.00 bioset            
    2377 root      20   0     0    0    0 S  0.0  0.0   0:01.23 md2_raid1         
    2379 root      20   0     0    0    0 S  0.0  0.0   0:00.49 kjournald         
    2385 root      20   0     0    0    0 S  0.0  0.0   0:00.00 kworker/6:2       
    2437 root      16  -4 10712  868  424 S  0.0  0.0   0:00.10 udevd             
    2541 root       0 -20     0    0    0 S  0.0  0.0   0:00.00 kworker/2:1H      
    2549 root       0 -20     0    0    0 S  0.0  0.0   0:00.00 kworker/3:1H      
    2836 root       0 -20     0    0    0 S  0.0  0.0   0:00.93 kworker/0:1H      
    2860 root      20   0     0    0    0 S  0.0  0.0   0:00.18 jbd2/md3-8        
    2861 root       0 -20     0    0    0 S  0.0  0.0   0:00.00 ext4-rsv-conver   
    2862 root      20   0     0    0    0 S  0.0  0.0   0:00.75 ext4lazyinit      
    2893 root       0 -20     0    0    0 S  0.0  0.0   0:00.00 kworker/1:1H      
    3167 dbus      20   0 21608 1296  940 S  0.0  0.0   0:00.00 dbus-daemon       
    3257 root      20   0     0    0    0 S  0.0  0.0   0:00.00 kworker/1:0       
    3308 root      20   0 21620  424  220 S  0.0  0.0   0:00.00 atd               
    3319 root      20   0 16996  632  424 S  0.0  0.0   0:00.00 anacron           
    3341 root      20   0  4108  556  472 S  0.0  0.0   0:00.00 mingetty          
    3343 root      20   0  4108  556  476 S  0.0  0.0   0:00.00 mingetty          
    3345 root      20   0  4108  552  472 S  0.0  0.0   0:00.00 mingetty          
    3347 root      20   0  4108  556  472 S  0.0  0.0   0:00.00 mingetty          
    3349 root      20   0  4108  552  472 S  0.0  0.0   0:00.00 mingetty          
    3351 root      20   0  4108  556  476 S  0.0  0.0   0:00.00 mingetty          
    3577 root      20   0     0    0    0 S  0.0  0.0   0:00.00 kworker/0:0       
    3578 root      20   0  100m 4320 3328 S  0.0  0.0   0:00.03 sshd              
    3580 root      20   0 57288 2072 1500 S  0.0  0.0   0:00.00 sftp-server       
    3858 root      20   0  104m 1948 1208 S  0.0  0.0   0:00.01 mysqlmymonlite.   
    3993 root      20   0  114m 1328  624 S  0.0  0.0   0:00.02 crond             
    3997 root      20   0 15076 1248  884 R  0.0  0.0   0:00.00 top               
    4338 root      20   0     0    0    0 S  0.0  0.0   0:00.95 kworker/1:2       
    4356 root      20   0 98.3m 4788 3708 S  0.0  0.0   0:03.13 sshd              
    4358 root      20   0  105m 1916 1528 S  0.0  0.0   0:00.06 bash              
    4492 root       0 -20     0    0    0 S  0.0  0.0   0:00.00 kworker/4:1H      
    4740 root       0 -20     0    0    0 S  0.0  0.0   0:00.00 kworker/7:1H      
    4945 root       0 -20     0    0    0 S  0.0  0.0   0:00.00 kworker/5:1H      
    4968 root      20   0  237m 1340  984 S  0.0  0.0   0:00.19 rsyslogd          
    4988 root      20   0     0    0    0 S  0.0  0.0   0:00.00 kworker/5:2       
    4998 root      20   0  4824  868  504 S  0.0  0.0   0:00.00 mdadm             
    5228 root      20   0 66264 1240  512 S  0.0  0.0   0:00.00 sshd              
    5820 root      20   0     0    0    0 S  0.0  0.0   0:00.00 kworker/3:2       
    6167 root      20   0     0    0    0 S  0.0  0.0   0:00.00 kworker/0:2       
    9043 root      20   0     0    0    0 S  0.0  0.0   0:00.08 kworker/u32:0     
    13239 root      20   0 81324 3388 2508 S  0.0  0.0   0:00.02 master            
    13246 postfix   20   0 81408 3344 2484 S  0.0  0.0   0:00.00 pickup            
    13247 postfix   20   0 81580 3472 2528 S  0.0  0.0   0:00.00 qmgr              
    15512 root      20   0  155m  17m 1908 S  0.0  0.1   0:01.06 lfd               
    31542 nsd       20   0 15144  876  524 S  0.0  0.0   0:00.00 nsd               
    31544 nsd       20   0 22008  836  252 S  0.0  0.0   0:00.00 nsd               
    31545 nsd       20   0 15352  588  124 S  0.0  0.0   0:00.00 nsd               
    31552 ntp       20   0 30780 2080 1464 S  0.0  0.0   0:00.01 ntpd              
    31578 root      20   0  103m 1532 1224 S  0.0  0.0   0:00.09 mysqld_safe       
    32611 root       0 -20     0    0    0 S  0.0  0.0   0:00.00 kworker/6:1H      
    32646 root      20   0 11932 3592  460 S  0.0  0.0   0:00.72 haveged           
    
    
                 total       used       free     shared    buffers     cached
    Mem:         32222       3852      28369         36         52       3151
    Low:         32222       3852      28369
    High:            0          0          0
    -/+ buffers/cache:        649      31573
    Swap:         1021          0       1021
    
    MemTotal:       32995868 kB
    MemFree:        29050508 kB
    MemAvailable:   32234632 kB
    Buffers:           53692 kB
    Cached:          3227000 kB
    SwapCached:            0 kB
    Active:          1884956 kB
    Inactive:        1580324 kB
    Active(anon):     191728 kB
    Inactive(anon):    30260 kB
    Active(file):    1693228 kB
    Inactive(file):  1550064 kB
    Unevictable:           0 kB
    Mlocked:               0 kB
    SwapTotal:       1046520 kB
    SwapFree:        1046520 kB
    Dirty:               384 kB
    Writeback:             0 kB
    AnonPages:        184684 kB
    Mapped:            35656 kB
    Shmem:             37392 kB
    Slab:             226808 kB
    SReclaimable:     186544 kB
    SUnreclaim:        40264 kB
    KernelStack:        3232 kB
    PageTables:         4664 kB
    NFS_Unstable:          0 kB
    Bounce:                0 kB
    WritebackTmp:          0 kB
    CommitLimit:    17544452 kB
    Committed_AS:     519664 kB
    VmallocTotal:   34359738367 kB
    VmallocUsed:      331800 kB
    VmallocChunk:   34359212844 kB
    HardwareCorrupted:     0 kB
    DirectMap4k:        7680 kB
    DirectMap2M:    33538048 kB
    
    --------------------------
    ps_mem.py output:
    http://www.pixelbeat.org/scripts/ps_mem.py
    --------------------------
    Private  +   Shared  =  RAM used    Program
    
    204.0 KiB + 220.0 KiB = 424.0 KiB    atd
    208.0 KiB + 424.0 KiB = 632.0 KiB    anacron
    364.0 KiB + 504.0 KiB = 868.0 KiB    mdadm
    444.0 KiB + 424.0 KiB = 868.0 KiB    udevd
    516.0 KiB + 404.0 KiB = 920.0 KiB    memcached
    488.0 KiB + 476.0 KiB = 964.0 KiB    mingetty (6)
    356.0 KiB + 940.0 KiB =   1.3 MiB    dbus-daemon
    704.0 KiB + 624.0 KiB =   1.3 MiB    crond
    356.0 KiB + 984.0 KiB =   1.3 MiB    rsyslogd
    296.0 KiB +   1.2 MiB =   1.5 MiB    init
    308.0 KiB +   1.2 MiB =   1.5 MiB    mysqld_safe
    388.0 KiB +   1.5 MiB =   1.9 MiB    bash
      1.4 MiB + 524.0 KiB =   1.9 MiB    nsd (3)
    740.0 KiB +   1.2 MiB =   1.9 MiB    mysqlmymonlite.
    572.0 KiB +   1.5 MiB =   2.0 MiB    sftp-server
    616.0 KiB +   1.4 MiB =   2.0 MiB    ntpd
    860.0 KiB +   2.4 MiB =   3.3 MiB    pickup
    880.0 KiB +   2.4 MiB =   3.3 MiB    master
    944.0 KiB +   2.5 MiB =   3.4 MiB    qmgr
      3.1 MiB + 460.0 KiB =   3.5 MiB    haveged
      1.1 MiB +   3.6 MiB =   4.7 MiB    sshd [updated]
      1.7 MiB +   3.2 MiB =   4.9 MiB    sshd (2)
      7.9 MiB +   4.2 MiB =  12.1 MiB    nginx (2)
    16.0 MiB +   1.9 MiB =  17.8 MiB    lfd
    20.5 MiB +   7.3 MiB =  27.8 MiB    mysqld
    130.0 MiB +  14.0 MiB = 144.0 MiB    php-fpm (3)
    
    Private  +   Shared  =  RAM used    Program
    
    
    smem -uk
    User     Count     Swap      USS      PSS      RSS
    
    smem -t -p
      PID User     Command                         Swap      USS      PSS      RSS
    -------------------------------------------------------------------------------
        0 0                                       0.00%    0.00%    0.00%    0.00%
    
    smem -wk
    Area                           Used      Cache   Noncache
    firmware/hardware                 0          0          0
    kernel image                      0          0          0
    kernel dynamic memory          3.6G       3.3G     285.8M
    userspace memory             218.8M      35.7M     183.2M
    free memory                   27.7G      27.7G          0
    
    
    ----------------------------
    Server Disk Usage
    ----------------------------
    Filesystem     Type      Size  Used Avail Use% Mounted on
    rootfs         rootfs     20G  4.8G   14G  26% /
    /dev/root      ext3       20G  4.8G   14G  26% /
    devtmpfs       devtmpfs   16G  556K   16G   1% /dev
    /dev/md3       ext4      1.8T  280M  1.7T   1% /home
    tmpfs          tmpfs      16G     0   16G   0% /dev/shm
    tmpfs          tmpfs      16G  6.8M   16G   1% /tmp
    
    ----------------------------
    MySQL datadir disk usage
    ----------------------------
    /var/lib/mysql/ uses 10412 kilobytes of disk space
    
    ----------------------------
    ulimit -aH
    ----------------------------
    core file size          (blocks, -c) unlimited
    data seg size           (kbytes, -d) unlimited
    scheduling priority             (-e) 0
    file size               (blocks, -f) unlimited
    pending signals                 (-i) 128628
    max locked memory       (kbytes, -l) 64
    max memory size         (kbytes, -m) unlimited
    open files                      (-n) 4096
    pipe size            (512 bytes, -p) 8
    POSIX message queues     (bytes, -q) 819200
    real-time priority              (-r) 0
    stack size              (kbytes, -s) unlimited
    cpu time               (seconds, -t) unlimited
    max user processes              (-u) 128628
    virtual memory          (kbytes, -v) unlimited
    file locks                      (-x) unlimited
    
    ----------------------------------------------------------
    tail -15 /etc/security/limits.conf
    ----------------------------------------------------------
    #
    
    #*               soft    core            0
    #*               hard    rss             10000
    #@student        hard    nproc           20
    #@faculty        soft    nproc           20
    #@faculty        hard    nproc           50
    #ftp             hard    nproc           0
    #@student        -       maxlogins       4
    
    # End of file
    * soft nofile 262144
    * hard nofile 262144
    nginx soft nofile 262144
    nginx hard nofile 262144
    
    ----------------------------------------------------------
    mysqld process limits:
    cat /proc/32601/limits
    ----------------------------------------------------------
    Limit                     Soft Limit           Hard Limit           Units    
    Max cpu time              unlimited            unlimited            seconds  
    Max file size             unlimited            unlimited            bytes    
    Max data size             unlimited            unlimited            bytes    
    Max stack size            8388608              unlimited            bytes    
    Max core file size        0                    unlimited            bytes    
    Max resident set          unlimited            unlimited            bytes    
    Max processes             128628               128628               processes
    Max open files            8192                 8192                 files    
    Max locked memory         65536                65536                bytes    
    Max address space         unlimited            unlimited            bytes    
    Max file locks            unlimited            unlimited            locks    
    Max pending signals       128628               128628               signals  
    Max msgqueue size         819200               819200               bytes    
    Max nice priority         0                    0                   
    Max realtime priority     0                    0                   
    Max realtime timeout      unlimited            unlimited            us       
    
    ----------------------------------
    WEB SERVER & PHP Info:
    ----------------------------------
    PHP 5.4.38 (cli) (built: Mar  5 2015 19:32:39)
    Copyright (c) 1997-2014 The PHP Group
    Zend Engine v2.4.0, Copyright (c) 1998-2014 Zend Technologies
    
    System => Linux yourserverhostname 3.14.32-xxxx-grs-ipv6-64 #1 SMP Sat Feb 7 11:35:27 CET 2015 x86_64
    Build Date => Mar  5 2015 19:32:24
    
    Configure Command =>  '../configure'  '--enable-cgi' '--enable-fpm' '--enable-pcntl' '--with-mcrypt' '--with-snmp' '--with-mhash' '--with-zlib' '--with-gettext' '--enable-intl' '--enable-exif' '--enable-zip' '--with-bz2' '--enable-soap' '--enable-sockets' '--enable-sysvmsg' '--enable-sysvsem' '--enable-sysvshm' '--enable-shmop' '--with-pear' '--enable-mbstring' '--with-openssl' '--with-mysql=mysqlnd' '--with-libdir=lib64' '--with-mysqli=mysqlnd' '--with-mysql-sock=/var/lib/mysql/mysql.sock' '--with-curl' '--with-gd' '--with-xmlrpc' '--enable-bcmath' '--enable-calendar' '--enable-ftp' '--enable-gd-native-ttf' '--with-freetype-dir=lib64' '--with-jpeg-dir=lib64' '--with-png-dir=lib64' '--with-xpm-dir=lib64' '--enable-pdo' '--with-pdo-sqlite' '--with-pdo-mysql=mysqlnd' '--enable-inline-optimization' '--with-imap' '--with-imap-ssl' '--with-kerberos' '--with-readline' '--with-libedit' '--with-gmp' '--with-pspell' '--with-tidy' '--with-enchant' '--with-fpm-user=nginx' '--with-fpm-group=nginx' '--disable-fileinfo' '--with-config-file-scan-dir=/etc/centminmod/php.d'
    
    Server API | Command Line Interface
    Configuration File (php.ini) Path | /usr/local/lib
    Loaded Configuration File | /usr/local/lib/php.ini
    PHP API | 20100412
    Zend Extension Build | API220100525,NTS
    PHP Extension Build | API20100525,NTS
    DOM/XML API Version | 20031129
    MHASH API Version | Emulated Support
    Client API version | mysqlnd 5.0.10 - 20111026 - $Id: c85105d7c6f7d70d609bb4c000257868a40840ab $
    Client API library version | mysqlnd 5.0.10 - 20111026 - $Id: c85105d7c6f7d70d609bb4c000257868a40840ab $
    API Extensions | mysqli,mysql,pdo_mysql
    Client API version | mysqlnd 5.0.10 - 20111026 - $Id: c85105d7c6f7d70d609bb4c000257868a40840ab $
    Phar API version | 1.1.1
    
    display_errors | Off | Off
    error_log | no value | no value
    extension_dir | /usr/local/lib/php/extensions/no-debug-non-zts-20100525 | /usr/local/lib/php/extensions/no-debug-non-zts-20100525
    file_uploads | On | On
    log_errors | On | On
    log_errors_max_len | 1024 | 1024
    max_execution_time | 0 | 0
    max_file_uploads | 20 | 20
    memory_limit | 128M | 128M
    open_basedir | no value | no value
    post_max_size | 15M | 15M
    realpath_cache_size | 4096k | 4096k
    realpath_cache_ttl | 360 | 360
    sendmail_path | /usr/lib/sendmail.postfix -t -i | /usr/lib/sendmail.postfix -t -i
    sql.safe_mode | Off | Off
    upload_max_filesize | 15M | 15M
    upload_tmp_dir | no value | no value
    sqlite3.extension_dir | no value | no value
    
    cURL support | enabled
    cURL Information | 7.19.7
    ZLib Version | 1.2.3
    GD Support | enabled
    GD Version | bundled (2.1.0 compatible)
    FreeType Support | enabled
    FreeType Linkage | with freetype
    FreeType Version | 2.3.11
    GIF Read Support | enabled
    GIF Create Support | enabled
    JPEG Support | enabled
    libJPEG Version | 6b
    PNG Support | enabled
    libPNG Version | 1.2.49
    WBMP Support | enabled
    libXML support | active
    libXML Compiled Version | 2.7.6
    libXML Loaded Version | 20706
    libXML streams | enabled
    PCRE (Perl Compatible Regular Expressions) Support | enabled
    PCRE Library Version | 8.32 2012-11-30
    Soap Client | enabled
    Soap Server | enabled
    ZLib Support | enabled
    
    Additional .ini files parsed | /etc/centminmod/php.d/apc.ini,
    apc
    APC Support | enabled
    APC Debugging | Disabled
    apc.cache_by_default | On | On
    apc.canonicalize | On | On
    apc.coredump_unmap | Off | Off
    apc.enable_cli | On | On
    apc.enabled | On | On
    apc.file_md5 | Off | Off
    apc.file_update_protection | 2 | 2
    apc.filters | no value | no value
    apc.gc_ttl | 3600 | 3600
    apc.include_once_override | Off | Off
    apc.lazy_classes | Off | Off
    apc.lazy_functions | Off | Off
    apc.max_file_size | 1M | 1M
    apc.mmap_file_mask | no value | no value
    apc.num_files_hint | 4096 | 4096
    apc.preload_path | no value | no value
    apc.report_autofilter | Off | Off
    apc.rfc1867 | Off | Off
    apc.rfc1867_freq | 0 | 0
    apc.rfc1867_name | APC_UPLOAD_PROGRESS | APC_UPLOAD_PROGRESS
    apc.rfc1867_prefix | upload_ | upload_
    apc.rfc1867_ttl | 3600 | 3600
    apc.serializer | igbinary | igbinary
    apc.shm_segments | 1 | 1
    apc.shm_size | 32M | 32M
    apc.shm_strings_buffer | 4M | 4M
    apc.slam_defense | Off | Off
    apc.stat | On | On
    apc.stat_ctime | Off | Off
    apc.ttl | 7200 | 7200
    apc.use_request_time | On | On
    apc.user_entries_hint | 4096 | 4096
    apc.user_ttl | 7200 | 7200
    apc.write_lock | On | On
    igbinary APC serializer ABI | 0
    
    igbinary support => enabled
    igbinary version => 1.2.2-dev
    igbinary APC serializer ABI => 0
    igbinary session support => yes
    
    Directive => Local Value => Master Value
    igbinary.compact_strings => On => On
    
    imagick module => enabled
    imagick module version => 3.1.2
    imagick classes => Imagick, ImagickDraw, ImagickPixel, ImagickPixelIterator
    ImageMagick version => ImageMagick 6.5.4-7 2014-02-10 Q16 OpenMP http://www.imagemagick.org
    ImageMagick copyright => Copyright (C) 1999-2009 ImageMagick Studio LLC
    ImageMagick release date => 2014-02-10
    ImageMagick number of supported formats:  => 199
    ImageMagick supported formats => A, AI, ART, ARW, AVI, AVS, B, BGR, BMP, BMP2, BMP3, BRF, BRG, C, CALS, CAPTION, CIN, CIP, CLIP, CMYK, CMYKA, CR2, CRW, CUR, CUT, DCM, DCR, DCX, DDS, DFONT, DNG, DOT, DPS, DPX, EPDF, EPI, EPS, EPS2, EPS3, EPSF, EPSI, EPT, EPT2, EPT3, ERF, EXR, FAX, FITS, FRACTAL, FTS, G, G3, GBR, GIF, GIF87, GRADIENT, GRAY, GRB, HALD, HISTOGRAM, HRZ, HTM, HTML, ICB, ICO, ICON, INFO, INLINE, IPL, ISOBRL, JNG, JP2, JPC, JPEG, JPG, JPX, K, K25, KDC, LABEL, M, M2V, M4V, MAP, MAT, MATTE, MIFF, MNG, MONO, MOV, MP4, MPC, MPEG, MPG, MRW, MSL, MSVG, MTV, MVG, NEF, NULL, O, ORF, OTB, OTF, PAL, PALM, PAM, PATTERN, PBM, PCD, PCDS, PCL, PCT, PCX, PDB, PDF, PDFA, PEF, PFA, PFB, PFM, PGM, PGX, PICON, PICT, PIX, PJPEG, PLASMA, PNG, PNG24, PNG32, PNG8, PNM, PPM, PREVIEW, PS, PS2, PS3, PSD, PTIF, PWP, R, RADIAL-GRADIENT, RAF, RAS, RBG, RGB, RGBA, RGBO, RLA, RLE, SCR, SCT, SFW, SGI, SHTML, SR2, SRF, STEGANO, SUN, SVG, SVGZ, TEXT, TGA, THUMBNAIL, TIFF, TIFF64, TILE, TIM, TTC, TTF, TXT, UBRL, UIL, UYVY, VDA, VICAR, VID, VIFF, VST, WBMP, WMF, WMV, WMZ, WPG, X, X3F, XBM, XC, XCF, XPM, XPS, XV, XWD, Y, YCbCr, YCbCrA, YUV
    
    Directive => Local Value => Master Value
    imagick.locale_fix => 0 => 0
    imagick.progress_monitor => 0 => 0
    
    memcache support => enabled
    Version => 3.0.8
    Revision => $Revision: 329835 $
    
    Directive => Local Value => Master Value
    memcache.allow_failover => 1 => 1
    memcache.chunk_size => 32768 => 32768
    memcache.compress_threshold => 20000 => 20000
    memcache.default_port => 11211 => 11211
    memcache.hash_function => crc32 => crc32
    memcache.hash_strategy => consistent => consistent
    memcache.lock_timeout => 15 => 15
    memcache.max_failover_attempts => 20 => 20
    memcache.protocol => ascii => ascii
    memcache.redundancy => 1 => 1
    memcache.session_redundancy => 2 => 2
    
    memcached support => enabled
    Version => 2.2.0
    libmemcached version => 1.0.18
    SASL support => yes
    Session support => yes
    igbinary support => yes
    json support => yes
    msgpack support => no
    
    Directive => Local Value => Master Value
    memcached.compression_factor => 1.3 => 1.3
    memcached.compression_threshold => 2000 => 2000
    memcached.compression_type => fastlz => fastlz
    memcached.serializer => igbinary => igbinary
    memcached.sess_binary => 0 => 0
    memcached.sess_connect_timeout => 3000 => 3000
    
    pcntl support => enabled
    
    PCRE (Perl Compatible Regular Expressions) Support => enabled
    PCRE Library Version => 8.32 2012-11-30
    
    Directive => Local Value => Master Value
    pcre.backtrack_limit => 1000000 => 1000000
    pcre.recursion_limit => 100000 => 100000
    
    PDO support => enabled
    PDO drivers => mysql, sqlite
    
    PDO Driver for MySQL => enabled
    Client API version => mysqlnd 5.0.10 - 20111026 - $Id: c85105d7c6f7d70d609bb4c000257868a40840ab $
    
    PDO Driver for SQLite 3.x => enabled
    SQLite Library => 3.7.7.1
    
    Phar: PHP Archive support => enabled
    Phar EXT version => 2.0.1
    Phar API version => 1.1.1
    SVN revision => $Id: ec823514107160b7e6fabc519594012657a2db91 $
    Phar-based phar archives => enabled
    Tar-based phar archives => enabled
    ZIP-based phar archives => enabled
    gzip compression => enabled
    bzip2 compression => enabled
    Native OpenSSL support => enabled
    
    
    Phar based on pear/PHP_Archive, original concept by Davey Shafik.
    Phar fully realized by Gregory Beaver and Marcus Boerger.
    Portions of tar implementation Copyright (c) 2003-2009 Tim Kientzle.
    Directive => Local Value => Master Value
    phar.cache_list => no value => no value
    phar.readonly => On => On
    phar.require_hash => On => On
    
    
    
    
    ---------------
    You are running Nginx
    ---------------
    
    
    user              nginx nginx;
    worker_processes  1;
    worker_rlimit_nofile 260000;
        worker_connections  2048;
        use epoll;
    log_format      main    '$remote_addr - $remote_user [$time_local] $request '
                    '"$http_user_agent" "$http_x_forwarded_for" "$gzip_ratio"'
            sendfile on;
            #sendfile_max_chunk 1m;
            keepalive_timeout  10;
        gzip on;
        gzip_vary   on;
        gzip_disable "MSIE [1-6]\.";
            gzip_static on;
            gzip_min_length   1400;
            gzip_buffers      32 8k;
            gzip_http_version 1.0;
            gzip_comp_level 5;
            gzip_proxied    any;
            gzip_types text/plain text/css text/xml application/javascript application/x-javascript application/xml application/xml+rss application/ecmascript application/json image/svg+xml;
    client_body_buffer_size 256k;
    client_body_in_file_only off;
    client_body_timeout 60s;
    client_header_buffer_size 64k;
    client_header_timeout  20s;
    client_max_body_size 10m;
    large_client_header_buffers 8 64k;
    proxy_temp_path  /tmp/nginx_proxy/;
    # for nginx proxy backends to prevent redirects to backend port
    
    ----------------------------
    mysqlreport output
    ----------------------------
    
    MariaDB 5.5.42-MariaDB      uptime 0 0:28:47    Thu Mar  5 20:07:20 2015
    
    __ Key _________________________________________________________________
    Buffer used     1.00k of   32.00M   %Used:   0.00
      Current       5.84M              %Usage:  18.24
    Write hit      50.00%
    Read hit       80.00%
    
    __ Questions ___________________________________________________________
    Total             872       0.5/s
      DMS             532       0.3/s  %Total:  61.01
      Com_            274       0.2/s           31.42
      COM_QUIT         66       0.0/s            7.57
    Slow 1 s            2       0.0/s            0.23  %DMS:   0.38 Log: OFF
    DMS               532       0.3/s           61.01
      INSERT          367       0.2/s           42.09         68.98
      SELECT          164       0.1/s           18.81         30.83
      UPDATE            1       0.0/s            0.11          0.19
      REPLACE           0         0/s            0.00          0.00
      DELETE            0         0/s            0.00          0.00
    Com_              274       0.2/s           31.42
      create_tabl      98       0.1/s           11.24
      set_option       56       0.0/s            6.42
      show_variab      38       0.0/s            4.36
    
    __ Rows ________________________________________________________________
    Rows           13.27k       7.7/s
      Using idx        11       0.0/s  %Index:   0.08
    Rows/question   15.22
    
    __ SELECT and Sort _____________________________________________________
    Scan              225       0.1/s %SELECT: 137.20
    Range               0         0/s            0.00
    Full join           5       0.0/s            3.05
    Range check         0         0/s            0.00
    Full rng join       0         0/s            0.00
    Sort scan          19       0.0/s
    Sort range          0         0/s
    Sort mrg pass       0         0/s
    
    __ Query Cache _________________________________________________________
    Memory usage   17.12k of   16.00M  %Usage:   0.10
    Block Fragmnt 100.00%
    Hits                0         0/s
    Inserts             1       0.0/s
    Insrt:Prune       1:1         0/s
    Hit:Insert     0.00:1
    
    __ Table Locks _________________________________________________________
    Waited              0         0/s  %Total:   0.00
    Immediate         434       0.3/s
    
    __ Tables ______________________________________________________________
    Open               90 of   2048    %Cache:   4.39
    Opened             74       0.0/s
    
    __ Connections _________________________________________________________
    Max used            2 of    300      %Max:   0.67
    Total              69       0.0/s
    
    __ Created Temp ________________________________________________________
    Disk table         15       0.0/s   %Disk:   4.84
    Table             310       0.2/s    Size:  32.0M
    File                0         0/s
    
    __ Threads _____________________________________________________________
    Running             1 of      2
    Created             2       0.0/s
    Slow                0         0/s
    Cached              0 of     64      %Hit:  97.10
    
    __ Aborted _____________________________________________________________
    Clients             1       0.0/s
    Connects            0         0/s
    
    __ Bytes _______________________________________________________________
    Sent          498.88k     288.9/s
    Received       14.50M      8.4k/s
    
    __ Aria Pagecache ______________________________________________________
    Buffer used     8.00k of    8.00M   %Used:   0.10
      Current     328.00k              %Usage:   4.00
    Write hit       0.00%
    Read hit        0.00%
    
    ----------------------------
    Total Server MyISAM and InnoDB Size
    ----------------------------
    *************************** 1. row ***************************
    innodb_tablespace_utilization_perc: NULL
                         total_size_gb: 0.0077336858958005905
                         index_size_gb: 0.00024509429931640625
                          data_size_gb: 0.007488591596484184
                  innodb_total_size_gb: 0
                   innodb_data_size_gb: 0
                  innodb_index_size_gb: 0
                  myisam_total_size_gb: 0.0075963567942380905
                   myisam_data_size_gb: 0.007419927045702934
                  myisam_index_size_gb: 0.00017642974853515625
                            perc_index: 3.1692
                             perc_data: 96.8308
                     innodb_perc_index: NULL
                      innodb_perc_data: NULL
                     myisam_perc_index: 2.3226
                      myisam_perc_data: 97.6774
               innodb_perc_total_index: 0.0000
                innodb_perc_total_data: 0.0000
               myisam_perc_total_index: 71.9844
                myisam_perc_total_data: 99.0831
    
    ----------------------------
    MySQL settings
    ----------------------------
    [mysqld]
    #character-set-server=utf8
    datadir=/var/lib/mysql
    socket=/var/lib/mysql/mysql.sock
    
    #bind-address=127.0.0.1
    # optimized my.cnf for MariaDB 5.5.x
    # by eva2000
    # vbtechsupport.com
    
    tmpdir=/home/mysqltmp
    
    skip-innodb
    #skip-federated
    #skip-pbxt
    #skip-pbxt_statistics
    #skip-archive
    #skip-name-resolve
    #old_passwords
    back_log = 75
    max_connections = 300
    key_buffer_size = 32M
    myisam_sort_buffer_size = 32M
    myisam_max_sort_file_size = 2048M
    join_buffer_size = 64K
    read_buffer_size = 64K
    sort_buffer_size = 128K
    table_definition_cache = 4096
    table_open_cache = 2048
    thread_cache_size = 64
    wait_timeout = 120
    connect_timeout = 10
    tmp_table_size = 32M
    max_heap_table_size = 32M
    max_allowed_packet = 32M
    max_seeks_for_key = 1000
    group_concat_max_len = 1024
    max_length_for_sort_data = 1024
    net_buffer_length = 16384
    max_connect_errors = 100000
    concurrent_insert = 2
    read_rnd_buffer_size = 256K
    bulk_insert_buffer_size = 8M
    query_cache_limit = 512K
    query_cache_size = 16M
    query_cache_type = 1
    query_cache_min_res_unit = 2K
    query_prealloc_size = 262144
    query_alloc_block_size = 65536
    transaction_alloc_block_size = 8192
    transaction_prealloc_size = 4096
    default-storage-engine = MyISAM
    
    log_warnings=1
    slow_query_log=0
    long_query_time=1
    slow_query_log_file=/var/lib/mysql/slowq.log
    log-error=/var/log/mysqld.log
    
    # innodb settings
    #innodb_extra_rsegments = 4
    innodb_purge_threads=1
    innodb_doublewrite = 1
    
    innodb_file_per_table = 1
    innodb_open_files = 1000
    innodb_data_file_path= ibdata1:10M:autoextend
    innodb_buffer_pool_size = 48M
    innodb_additional_mem_pool_size = 32M
    
    innodb_log_files_in_group = 2
    innodb_log_file_size = 64M
    innodb_log_buffer_size = 8M
    innodb_flush_log_at_trx_commit = 2
    innodb_thread_concurrency = 0
    innodb_lock_wait_timeout=50
    #innodb_flush_method = O_DIRECT
    innodb_support_xa=1
    
    # 200 * # DISKS
    innodb_io_capacity = 100
    innodb_read_io_threads = 2
    innodb_write_io_threads = 2
    
    # mariadb settings
    [mariadb]
    #thread-handling = pool-of-threads
    #thread-pool-size= 20
    #mysql --port=3307 --protocol=tcp
    #extra-port=3307
    #extra-max-connections=1
    
    userstat = 0
    key_cache_segments = 1
    aria_group_commit = none
    aria_group_commit_interval = 0
    aria_log_file_size = 32M
    aria_log_purge_type = immediate
    aria_pagecache_buffer_size = 8M
    aria_sort_buffer_size = 8M
    
    [mariadb-5.5]
    #ignore_db_dirs=
    query_cache_strip_comments=0
    
    innodb_read_ahead = linear
    innodb_adaptive_flushing_method = estimate
    innodb_flush_neighbor_pages = 1
    innodb_stats_update_need_lock = 0
    innodb_log_block_size = 512
    
    log_slow_filter =admin,filesort,filesort_on_disk,full_join,full_scan,query_cache,query_cache_miss,tmp_table,tmp_table_on_disk
    
    [mysqld_safe]
    socket=/var/lib/mysql/mysql.sock
    log-error=/var/log/mysqld.log
    #nice = -5
    open-files-limit = 8192
    
    [mysqldump]
    quick
    max_allowed_packet = 32M
    
    [myisamchk]
    key_buffer = 32M
    sort_buffer = 16M
    read_buffer = 16M
    write_buffer = 16M
    
    [mysqlhotcopy]
    interactive-timeout---
    +---------------------------------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
    | Variable_name | Value |
    +---------------------------------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
    | aria_block_size | 8192 |
    | aria_checkpoint_interval | 30 |
    | aria_checkpoint_log_activity | 1048576 |
    | aria_force_start_after_recovery_failures | 0 |
    | aria_group_commit | none |
    | aria_group_commit_interval | 0 |
    | aria_log_file_size | 33554432 |
    | aria_log_purge_type | immediate |
    | aria_max_sort_file_size | 9223372036853727232 |
    | aria_page_checksum | ON |
    | aria_pagecache_age_threshold | 300 |
    | aria_pagecache_buffer_size | 8388608 |
    | aria_pagecache_division_limit | 100 |
    | aria_recover | NORMAL |
    | aria_repair_threads | 1 |
    | aria_sort_buffer_size | 8388608 |
    | aria_stats_method | nulls_unequal |
    | aria_sync_log_dir | NEWFILE |
    | aria_used_for_temp_tables | ON |
    | auto_increment_increment | 1 |
    | auto_increment_offset | 1 |
    | autocommit | ON |
    | automatic_sp_privileges | ON |
    | back_log | 75 |
    | basedir | /usr |
    | big_tables | OFF |
    | binlog_annotate_row_events | OFF |
    | binlog_cache_size | 32768 |
    | binlog_checksum | NONE |
    | binlog_direct_non_transactional_updates | OFF |
    | binlog_format | STATEMENT |
    | binlog_optimize_thread_scheduling | ON |
    | binlog_stmt_cache_size | 32768 |
    | bulk_insert_buffer_size | 8388608 |
    | character_set_client | latin1 |
    | character_set_connection | latin1 |
    | character_set_database | latin1 |
    | character_set_filesystem | binary |
    | character_set_results | latin1 |
    | character_set_server | latin1 |
    | character_set_system | utf8 |
    | character_sets_dir | /usr/share/mysql/charsets/ |
    | collation_connection | latin1_swedish_ci |
    | collation_database | latin1_swedish_ci |
    | collation_server | latin1_swedish_ci |
    | completion_type | NO_CHAIN |
    | concurrent_insert | ALWAYS |
    | connect_timeout | 10 |
    | datadir | /var/lib/mysql/ |
    | date_format | %Y-%m-%d |
    | datetime_format | %Y-%m-%d %H:%i:%s |
    | deadlock_search_depth_long | 15 |
    | deadlock_search_depth_short | 4 |
    | deadlock_timeout_long | 50000000 |
    | deadlock_timeout_short | 10000 |
    | debug_no_thread_alarm | OFF |
    | default_storage_engine | MyISAM |
    | default_week_format | 0 |
    | delay_key_write | ON |
    | delayed_insert_limit | 100 |
    | delayed_insert_timeout | 300 |
    | delayed_queue_size | 1000 |
    | div_precision_increment | 4 |
    | engine_condition_pushdown | OFF |
    | event_scheduler | OFF |
    | expensive_subquery_limit | 100 |
    | expire_logs_days | 0 |
    | extra_max_connections | 1 |
    | extra_port | 0 |
    | flush | OFF |
    | flush_time | 0 |
    | foreign_key_checks | ON |
    | ft_boolean_syntax | + -><()~*:""&| |
    | ft_max_word_len | 84 |
    | ft_min_word_len | 4 |
    | ft_query_expansion_limit | 20 |
    | ft_stopword_file | (built-in) |
    | general_log | OFF |
    | general_log_file | ns511335.log |
    | group_concat_max_len | 1024 |
    | have_compress | YES |
    | have_crypt | YES |
    | have_csv | YES |
    | have_dynamic_loading | YES |
    | have_geometry | YES |
    | have_innodb | DISABLED |
    | have_ndbcluster | NO |
    | have_openssl | DISABLED |
    | have_partitioning | YES |
    | have_profiling | YES |
    | have_query_cache | YES |
    | have_rtree_keys | YES |
    | have_ssl | DISABLED |
    | have_symlink | YES |
    | hostname | yourserverhostname |
    | ignore_builtin_innodb | OFF |
    | ignore_db_dirs | |
    | init_connect | |
    | init_file | |
    | init_slave | |
    | interactive_timeout | 28800 |
    | join_buffer_size | 65536 |
    | join_buffer_space_limit | 2097152 |
    | join_cache_level | 2 |
    | keep_files_on_create | OFF |
    | key_buffer_size | 33554432 |
    | key_cache_age_threshold | 300 |
    | key_cache_block_size | 1024 |
    | key_cache_division_limit | 100 |
    | key_cache_segments | 1 |
    | large_files_support | ON |
    | large_page_size | 0 |
    | large_pages | OFF |
    | lc_messages | en_US |
    | lc_messages_dir | |
    | lc_time_names | en_US |
    | license | GPL |
    | local_infile | ON |
    | lock_wait_timeout | 31536000 |
    | locked_in_memory | OFF |
    | log | OFF |
    | log_bin | OFF |
    | log_bin_trust_function_creators | OFF |
    | log_error | /var/log/mysqld.log |
    | log_output | FILE |
    | log_queries_not_using_indexes | OFF |
    | log_slave_updates | OFF |
    | log_slow_filter | admin,filesort,filesort_on_disk,full_join,full_scan,query_cache,query_cache_miss,tmp_table,tmp_table_on_disk |
    | log_slow_queries | OFF |
    | log_slow_rate_limit | 1 |
    | log_slow_verbosity | |
    | log_warnings | 1 |
    | long_query_time | 1.000000 |
    | low_priority_updates | OFF |
    | lower_case_file_system | OFF |
    | lower_case_table_names | 0 |
    | master_verify_checksum | OFF |
    | max_allowed_packet | 33554432 |
    | max_binlog_cache_size | 18446744073709547520 |
    | max_binlog_size | 1073741824 |
    | max_binlog_stmt_cache_size | 18446744073709547520 |
    | max_connect_errors | 100000 |
    | max_connections | 300 |
    | max_delayed_threads | 20 |
    | max_error_count | 64 |
    | max_heap_table_size | 33554432 |
    | max_insert_delayed_threads | 20 |
    | max_join_size | 18446744073709551615 |
    | max_length_for_sort_data | 1024 |
    | max_long_data_size | 33554432 |
    | max_prepared_stmt_count | 16382 |
    | max_relay_log_size | 0 |
    | max_seeks_for_key | 1000 |
    | max_sort_length | 1024 |
    | max_sp_recursion_depth | 0 |
    | max_tmp_tables | 32 |
    | max_user_connections | 0 |
    | max_write_lock_count | 4294967295 |
    | metadata_locks_cache_size | 1024 |
    | min_examined_row_limit | 0 |
    | mrr_buffer_size | 262144 |
    | multi_range_count | 256 |
    | myisam_block_size | 1024 |
    | myisam_data_pointer_size | 6 |
    | myisam_max_sort_file_size | 2147483648 |
    | myisam_mmap_size | 18446744073709551615 |
    | myisam_recover_options | DEFAULT |
    | myisam_repair_threads | 1 |
    | myisam_sort_buffer_size | 33554432 |
    | myisam_stats_method | nulls_unequal |
    | myisam_use_mmap | OFF |
    | net_buffer_length | 16384 |
    | net_read_timeout | 30 |
    | net_retry_count | 10 |
    | net_write_timeout | 60 |
    | old | OFF |
    | old_alter_table | OFF |
    | old_mode | |
    | old_passwords | OFF |
    | open_files_limit | 8192 |
    | optimizer_prune_level | 1 |
    | optimizer_search_depth | 62 |
    | optimizer_switch | index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,index_merge_sort_intersection=off,engine_condition_pushdown=off,index_condition_pushdown=on,derived_merge=on,derived_with_keys=on,firstmatch=on,loosescan=on,materialization=on,in_to_exists=on,semijoin=on,partial_match_rowid_merge=on,partial_match_table_scan=on,subquery_cache=on,mrr=off,mrr_cost_based=off,mrr_sort_keys=off,outer_join_with_cache=on,semijoin_with_cache=on,join_cache_incremental=on,join_cache_hashed=on,join_cache_bka=on,optimize_join_buffer_size=off,table_elimination=on,extended_keys=off |
    | performance_schema | OFF |
    | performance_schema_events_waits_history_long_size | 10000 |
    | performance_schema_events_waits_history_size | 10 |
    | performance_schema_max_cond_classes | 80 |
    | performance_schema_max_cond_instances | 1000 |
    | performance_schema_max_file_classes | 50 |
    | performance_schema_max_file_handles | 32768 |
    | performance_schema_max_file_instances | 10000 |
    | performance_schema_max_mutex_classes | 200 |
    | performance_schema_max_mutex_instances | 1000000 |
    | performance_schema_max_rwlock_classes | 30 |
    | performance_schema_max_rwlock_instances | 1000000 |
    | performance_schema_max_table_handles | 100000 |
    | performance_schema_max_table_instances | 50000 |
    | performance_schema_max_thread_classes | 50 |
    | performance_schema_max_thread_instances | 1000 |
    | pid_file | /var/lib/mysql/yourserverhostname.pid |
    | plugin_dir | /usr/lib64/mysql/plugin/ |
    | plugin_maturity | unknown |
    | port | 3306 |
    | preload_buffer_size | 32768 |
    | profiling | OFF |
    | profiling_history_size | 15 |
    | progress_report_time | 5 |
    | protocol_version | 10 |
    | query_alloc_block_size | 65536 |
    | query_cache_limit | 524288 |
    | query_cache_min_res_unit | 2048 |
    | query_cache_size | 16777216 |
    | query_cache_strip_comments | OFF |
    | query_cache_type | ON |
    | query_cache_wlock_invalidate | OFF |
    | query_prealloc_size | 262144 |
    | range_alloc_block_size | 4096 |
    | read_buffer_size | 65536 |
    | read_only | OFF |
    | read_rnd_buffer_size | 262144 |
    | relay_log | |
    | relay_log_index | |
    | relay_log_info_file | relay-log.info |
    | relay_log_purge | ON |
    | relay_log_recovery | OFF |
    | relay_log_space_limit | 0 |
    | replicate_annotate_row_events | OFF |
    | replicate_do_db | |
    | replicate_do_table | |
    | replicate_events_marked_for_skip | replicate |
    | replicate_ignore_db | |
    | replicate_ignore_table | |
    | replicate_wild_do_table | |
    | replicate_wild_ignore_table | |
    | report_host | |
    | report_password | |
    | report_port | 3306 |
    | report_user | |
    | rowid_merge_buff_size | 8388608 |
    | rpl_recovery_rank | 0 |
    | secure_auth | OFF |
    | secure_file_priv | |
    | server_id | 0 |
    | skip_external_locking | ON |
    | skip_name_resolve | OFF |
    | skip_networking | OFF |
    | skip_show_database | OFF |
    | slave_compressed_protocol | OFF |
    | slave_exec_mode | STRICT |
    | slave_load_tmpdir | /home/mysqltmp |
    | slave_max_allowed_packet | 1073741824 |
    | slave_net_timeout | 3600 |
    | slave_skip_errors | OFF |
    | slave_sql_verify_checksum | ON |
    | slave_transaction_retries | 10 |
    | slave_type_conversions | |
    | slow_launch_time | 2 |
    | slow_query_log | OFF |
    | slow_query_log_file | /var/lib/mysql/slowq.log |
    | socket | /var/lib/mysql/mysql.sock |
    | sort_buffer_size | 131072 |
    | sql_auto_is_null | OFF |
    | sql_big_selects | ON |
    | sql_big_tables | OFF |
    | sql_buffer_result | OFF |
    | sql_log_bin | ON |
    | sql_log_off | OFF |
    | sql_low_priority_updates | OFF |
    | sql_max_join_size | 18446744073709551615 |
    | sql_mode | |
    | sql_notes | ON |
    | sql_quote_show_create | ON |
    | sql_safe_updates | OFF |
    | sql_select_limit | 18446744073709551615 |
    | sql_slave_skip_counter | 0 |
    | sql_warnings | OFF |
    | ssl_ca | |
    | ssl_capath | |
    | ssl_cert | |
    | ssl_cipher | |
    | ssl_key | |
    | storage_engine | MyISAM |
    | stored_program_cache | 256 |
    | sync_binlog | 0 |
    | sync_frm | ON |
    | sync_master_info | 0 |
    | sync_relay_log | 0 |
    | sync_relay_log_info | 0 |
    | system_time_zone | UTC |
    | table_definition_cache | 4096 |
    | table_open_cache | 2048 |
    | thread_cache_size | 64 |
    | thread_concurrency | 10 |
    | thread_handling | one-thread-per-connection |
    | thread_pool_idle_timeout | 60 |
    | thread_pool_max_threads | 500 |
    | thread_pool_oversubscribe | 3 |
    | thread_pool_size | 8 |
    | thread_pool_stall_limit | 500 |
    | thread_stack | 294912 |
    | time_format | %H:%i:%s |
    | time_zone | SYSTEM |
    | timed_mutexes | OFF |
    | tmp_table_size | 33554432 |
    | tmpdir | /home/mysqltmp |
    | transaction_alloc_block_size | 8192 |
    | transaction_prealloc_size | 4096 |
    | tx_isolation | REPEATABLE-READ |
    | unique_checks | ON |
    | updatable_views_with_limit | YES |
    | userstat | OFF |
    | version | 5.5.42-MariaDB |
    | version_comment | MariaDB Server |
    | version_compile_machine | x86_64 |
    | version_compile_os | Linux |
    | wait_timeout | 120 |
    +---------------------------------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
    +------------------------------------------+-------------+
    | Variable_name | Value |
    +------------------------------------------+-------------+
    | Aborted_clients | 1 |
    | Aborted_connects | 0 |
    | Access_denied_errors | 0 |
    | Aria_pagecache_blocks_not_flushed | 0 |
    | Aria_pagecache_blocks_unused | 983 |
    | Aria_pagecache_blocks_used | 1 |
    | Aria_pagecache_read_requests | 6 |
    | Aria_pagecache_reads | 6 |
    | Aria_pagecache_write_requests | 0 |
    | Aria_pagecache_writes | 0 |
    | Aria_transaction_log_syncs | 0 |
    | Binlog_commits | 0 |
    | Binlog_group_commits | 0 |
    | Binlog_snapshot_file | |
    | Binlog_snapshot_position | 0 |
    | Binlog_bytes_written | 0 |
    | Binlog_cache_disk_use | 0 |
    | Binlog_cache_use | 0 |
    | Binlog_stmt_cache_disk_use | 0 |
    | Binlog_stmt_cache_use | 0 |
    | Busy_time | 0.000000 |
    | Bytes_received | 14499810 |
    | Bytes_sent | 528795 |
    | Com_admin_commands | 1 |
    | Com_alter_db | 0 |
    | Com_alter_db_upgrade | 0 |
    | Com_alter_event | 0 |
    | Com_alter_function | 0 |
    | Com_alter_procedure | 0 |
    | Com_alter_server | 0 |
    | Com_alter_table | 0 |
    | Com_alter_tablespace | 0 |
    | Com_analyze | 0 |
    | Com_assign_to_keycache | 0 |
    | Com_begin | 0 |
    | Com_binlog | 0 |
    | Com_call_procedure | 0 |
    | Com_change_db | 12 |
    | Com_change_master | 0 |
    | Com_check | 0 |
    | Com_checksum | 0 |
    | Com_commit | 0 |
    | Com_create_db | 1 |
    | Com_create_event | 0 |
    | Com_create_function | 0 |
    | Com_create_index | 0 |
    | Com_create_procedure | 0 |
    | Com_create_server | 0 |
    | Com_create_table | 98 |
    | Com_create_trigger | 0 |
    | Com_create_udf | 0 |
    | Com_create_user | 0 |
    | Com_create_view | 0 |
    | Com_dealloc_sql | 0 |
    | Com_delete | 0 |
    | Com_delete_multi | 0 |
    | Com_do | 0 |
    | Com_drop_db | 1 |
    | Com_drop_event | 0 |
    | Com_drop_function | 0 |
    | Com_drop_index | 0 |
    | Com_drop_procedure | 0 |
    | Com_drop_server | 0 |
    | Com_drop_table | 1 |
    | Com_drop_trigger | 0 |
    | Com_drop_user | 2 |
    | Com_drop_view | 0 |
    | Com_empty_query | 0 |
    | Com_execute_sql | 0 |
    | Com_flush | 1 |
    | Com_grant | 0 |
    | Com_ha_close | 0 |
    | Com_ha_open | 0 |
    | Com_ha_read | 0 |
    | Com_help | 0 |
    | Com_insert | 367 |
    | Com_insert_select | 0 |
    | Com_install_plugin | 0 |
    | Com_kill | 0 |
    | Com_load | 0 |
    | Com_lock_tables | 0 |
    | Com_optimize | 0 |
    | Com_preload_keys | 0 |
    | Com_prepare_sql | 0 |
    | Com_purge | 0 |
    | Com_purge_before_date | 0 |
    | Com_release_savepoint | 0 |
    | Com_rename_table | 0 |
    | Com_rename_user | 0 |
    | Com_repair | 0 |
    | Com_replace | 0 |
    | Com_replace_select | 0 |
    | Com_reset | 0 |
    | Com_resignal | 0 |
    | Com_revoke | 0 |
    | Com_revoke_all | 0 |
    | Com_rollback | 0 |
    | Com_rollback_to_savepoint | 0 |
    | Com_savepoint | 0 |
    | Com_select | 166 |
    | Com_set_option | 56 |
    | Com_show_authors | 0 |
    | Com_show_binlog_events | 0 |
    | Com_show_binlogs | 1 |
    | Com_show_charsets | 0 |
    | Com_show_client_statistics | 0 |
    | Com_show_collations | 0 |
    | Com_show_contributors | 0 |
    | Com_show_create_db | 0 |
    | Com_show_create_event | 0 |
    | Com_show_create_func | 0 |
    | Com_show_create_proc | 0 |
    | Com_show_create_table | 0 |
    | Com_show_create_trigger | 0 |
    | Com_show_databases | 6 |
    | Com_show_engine_logs | 0 |
    | Com_show_engine_mutex | 0 |
    | Com_show_engine_status | 0 |
    | Com_show_errors | 0 |
    | Com_show_events | 0 |
    | Com_show_fields | 0 |
    | Com_show_function_status | 0 |
    | Com_show_grants | 1 |
    | Com_show_index_statistics | 0 |
    | Com_show_keys | 0 |
    | Com_show_master_status | 5 |
    | Com_show_open_tables | 0 |
    | Com_show_plugins | 0 |
    | Com_show_privileges | 0 |
    | Com_show_procedure_status | 0 |
    | Com_show_processlist | 4 |
    | Com_show_profile | 0 |
    | Com_show_profiles | 0 |
    | Com_show_relaylog_events | 0 |
    | Com_show_slave_hosts | 0 |
    | Com_show_slave_status | 5 |
    | Com_show_status | 14 |
    | Com_show_storage_engines | 0 |
    | Com_show_table_statistics | 0 |
    | Com_show_table_status | 4 |
    | Com_show_tables | 24 |
    | Com_show_triggers | 0 |
    | Com_show_user_statistics | 0 |
    | Com_show_variables | 40 |
    | Com_show_warnings | 0 |
    | Com_signal | 0 |
    | Com_slave_start | 0 |
    | Com_slave_stop | 0 |
    | Com_stmt_close | 0 |
    | Com_stmt_execute | 0 |
    | Com_stmt_fetch | 0 |
    | Com_stmt_prepare | 0 |
    | Com_stmt_reprepare | 0 |
    | Com_stmt_reset | 0 |
    | Com_stmt_send_long_data | 0 |
    | Com_truncate | 0 |
    | Com_uninstall_plugin | 0 |
    | Com_unlock_tables | 0 |
    | Com_update | 1 |
    | Com_update_multi | 0 |
    | Com_xa_commit | 0 |
    | Com_xa_end | 0 |
    | Com_xa_prepare | 0 |
    | Com_xa_recover | 0 |
    | Com_xa_rollback | 0 |
    | Com_xa_start | 0 |
    | Compression | OFF |
    | Connections | 71 |
    | Cpu_time | 0.000000 |
    | Created_tmp_disk_tables | 24 |
    | Created_tmp_files | 0 |
    | Created_tmp_tables | 377 |
    | Delayed_errors | 0 |
    | Delayed_insert_threads | 0 |
    | Delayed_writes | 0 |
    | Empty_queries | 28 |
    | Executed_events | 0 |
    | Executed_triggers | 0 |
    | Feature_dynamic_columns | 0 |
    | Feature_fulltext | 0 |
    | Feature_gis | 0 |
    | Feature_locale | 0 |
    | Feature_subquery | 0 |
    | Feature_timezone | 2 |
    | Feature_trigger | 0 |
    | Feature_xml | 0 |
    | Flush_commands | 2 |
    | Handler_commit | 0 |
    | Handler_delete | 2 |
    | Handler_discover | 0 |
    | Handler_icp_attempts | 0 |
    | Handler_icp_match | 0 |
    | Handler_mrr_init | 0 |
    | Handler_mrr_key_refills | 0 |
    | Handler_mrr_rowid_refills | 0 |
    | Handler_prepare | 0 |
    | Handler_read_first | 7 |
    | Handler_read_key | 4 |
    | Handler_read_last | 0 |
    | Handler_read_next | 0 |
    | Handler_read_prev | 0 |
    | Handler_read_rnd | 81 |
    | Handler_read_rnd_deleted | 1 |
    | Handler_read_rnd_next | 14255 |
    | Handler_rollback | 0 |
    | Handler_savepoint | 0 |
    | Handler_savepoint_rollback | 0 |
    | Handler_tmp_update | 0 |
    | Handler_tmp_write | 14198 |
    | Handler_update | 4 |
    | Handler_write | 23432 |
    | Key_blocks_not_flushed | 0 |
    | Key_blocks_unused | 26791 |
    | Key_blocks_used | 1 |
    | Key_blocks_warm | 0 |
    | Key_read_requests | 5 |
    | Key_reads | 1 |
    | Key_write_requests | 4 |
    | Key_writes | 2 |
    | Last_query_cost | 0.000000 |
    | Max_used_connections | 2 |
    | Not_flushed_delayed_rows | 0 |
    | Open_files | 223 |
    | Open_streams | 0 |
    | Open_table_definitions | 129 |
    | Open_tables | 129 |
    | Opened_files | 992 |
    | Opened_table_definitions | 204 |
    | Opened_tables | 113 |
    | Opened_views | 0 |
    | Performance_schema_cond_classes_lost | 0 |
    | Performance_schema_cond_instances_lost | 0 |
    | Performance_schema_file_classes_lost | 0 |
    | Performance_schema_file_handles_lost | 0 |
    | Performance_schema_file_instances_lost | 0 |
    | Performance_schema_locker_lost | 0 |
    | Performance_schema_mutex_classes_lost | 0 |
    | Performance_schema_mutex_instances_lost | 0 |
    | Performance_schema_rwlock_classes_lost | 0 |
    | Performance_schema_rwlock_instances_lost | 0 |
    | Performance_schema_table_handles_lost | 0 |
    | Performance_schema_table_instances_lost | 0 |
    | Performance_schema_thread_classes_lost | 0 |
    | Performance_schema_thread_instances_lost | 0 |
    | Prepared_stmt_count | 0 |
    | Qcache_free_blocks | 1 |
    | Qcache_free_memory | 16759688 |
    | Qcache_hits | 0 |
    | Qcache_inserts | 0 |
    | Qcache_lowmem_prunes | 0 |
    | Qcache_not_cached | 166 |
    | Qcache_queries_in_cache | 0 |
    | Qcache_total_blocks | 1 |
    | Queries | 880 |
    | Questions | 879 |
    | Rows_read | 23 |
    | Rows_sent | 11036 |
    | Rows_tmp_read | 14050 |
    | Rpl_status | AUTH_MASTER |
    | Select_full_join | 5 |
    | Select_full_range_join | 0 |
    | Select_range | 0 |
    | Select_range_check | 0 |
    | Select_scan | 230 |
    | Slave_heartbeat_period | 0.000 |
    | Slave_open_temp_tables | 0 |
    | Slave_received_heartbeats | 0 |
    | Slave_retried_transactions | 0 |
    | Slave_running | OFF |
    | Slow_launch_threads | 0 |
    | Slow_queries | 2 |
    | Sort_merge_passes | 0 |
    | Sort_range | 0 |
    | Sort_rows | 81 |
    | Sort_scan | 19 |
    | Ssl_accept_renegotiates | 0 |
    | Ssl_accepts | 0 |
    | Ssl_callback_cache_hits | 0 |
    | Ssl_cipher | |
    | Ssl_cipher_list | |
    | Ssl_client_connects | 0 |
    | Ssl_connect_renegotiates | 0 |
    | Ssl_ctx_verify_depth | 0 |
    | Ssl_ctx_verify_mode | 0 |
    | Ssl_default_timeout | 0 |
    | Ssl_finished_accepts | 0 |
    | Ssl_finished_connects | 0 |
    | Ssl_session_cache_hits | 0 |
    | Ssl_session_cache_misses | 0 |
    | Ssl_session_cache_mode | NONE |
    | Ssl_session_cache_overflows | 0 |
    | Ssl_session_cache_size | 0 |
    | Ssl_session_cache_timeouts | 0 |
    | Ssl_sessions_reused | 0 |
    | Ssl_used_session_cache_entries | 0 |
    | Ssl_verify_depth | 0 |
    | Ssl_verify_mode | 0 |
    | Ssl_version | |
    | Subquery_cache_hit | 0 |
    | Subquery_cache_miss | 0 |
    | Syncs | 198 |
    | Table_locks_immediate | 434 |
    | Table_locks_waited | 0 |
    | Tc_log_max_pages_used | 0 |
    | Tc_log_page_size | 0 |
    | Tc_log_page_waits | 0 |
    | Threadpool_idle_threads | 0 |
    | Threadpool_threads | 0 |
    | Threads_cached | 0 |
    | Threads_connected | 2 |
    | Threads_created | 2 |
    | Threads_running | 1 |
    | Uptime | 1727 |
    | Uptime_since_flush_status | 1727 |
    +------------------------------------------+-------------+
    +----+------+-----------+------+---------+------+-------+------------------+----------+
    | Id | User | Host | db | Command | Time | State | Info | Progress |
    +----+------+-----------+------+---------+------+-------+------------------+----------+
    | 24 | root | localhost | test | Sleep | 2 | | | 0.000 |
    | 70 | root | localhost | | Query | 0 | | show processlist | 0.000 |
    +----+------+-----------+------+---------+------+-------+------------------+----------+
    
    ----------------------------
    MySQL Error Log
    ----------------------------
    
    150305 19:30:47 [Note] /usr/sbin/mysqld: ready for connections.
    Version: '5.5.42-MariaDB'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MariaDB Server
    150305 19:30:47 [Note] /usr/sbin/mysqld: Normal shutdown
    
    150305 19:30:47 [Note] Event Scheduler: Purging the queue. 0 events
    150305 19:30:48 [Note] /usr/sbin/mysqld: Shutdown complete
    
    150305 19:30:48 mysqld_safe mysqld from pid file /var/lib/mysql/yourserverhostname.pid ended
    150305 19:38:33 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
    150305 19:38:33 [Note] Plugin 'InnoDB' is disabled.
    150305 19:38:33 [Note] Plugin 'FEEDBACK' is disabled.
    150305 19:38:33 [Note] Server socket created on IP: '0.0.0.0'.
    150305 19:38:33 [Note] Event Scheduler: Loaded 0 events
    150305 19:38:33 [Note] /usr/sbin/mysqld: ready for connections.
    Version: '5.5.42-MariaDB'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MariaDB Server
    
    Report Complete:
    Thu Mar 5 20:07:20 UTC 2015
    ----------------------------
    
     
  4. Jake

    Jake Member

    76
    10
    8
    Feb 3, 2015
    Ratings:
    +11
    Local Time:
    1:59 PM
    NA
    Maria DB 5.5
    Also, I do see that phpmyadmin is using all the CPU, thats because I still have a 4.3mb database Im trying to test LOL
     
  5. eva2000

    eva2000 Administrator Staff Member

    44,731
    10,196
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +15,804
    Local Time:
    1:59 PM
    Nginx 1.17.x
    MariaDB 5.5/10.x
    all looks good and phpmyadmin at 100% on one cpu thread means it's working but taking it's time, so best o raise wait_timeout , restart mysql and wait to see how long it takes to import via SSH command line. FYI, mysql default wait_timeout is 28800 seconds while Centmin Mod default is 120 seconds, so play with settings for wait_timeout
     
  6. Jake

    Jake Member

    76
    10
    8
    Feb 3, 2015
    Ratings:
    +11
    Local Time:
    1:59 PM
    NA
    Maria DB 5.5
    Finally got this fixed, I hope. Uploading via phpmyadmin using a tar.gz extention, worked a heck of alot better. I was orginally using a .zip. After using the tar.gz extention, it uploaded and ran all tables almost in a matter of 30 seconds! @eva2000 thankyou for time!
     
  7. eva2000

    eva2000 Administrator Staff Member

    44,731
    10,196
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +15,804
    Local Time:
    1:59 PM
    Nginx 1.17.x
    MariaDB 5.5/10.x
    wow first I heard of such, but then again i don't use phpmyadmin for backup/restores, only for viewing data and info and querying the databases if needed :)