Announcement

Collapse
No announcement yet.

List of questions a user should ask a new host

Collapse
This is a sticky topic.
X
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • List of questions a user should ask a new host

    In support, we've seen some problems that users run into with hosting. Usually it is because when the user switched hosting, they didn't realize the host would put a certain limit on connections, or set wait_timeouts real low, or other values they didn't realize would cause them issues. So, we tried to put together a list of things a user should ask a potential new host.


    Regarding PHP on the server:
    Ask for the values of these PHP variables and if you may have them changed:
    • wait_timeout - if low, can cause issues with custom scripts or scripts that take a longer time to run or long queries - I wouldn't want less than 30 to start or less than 120 if you aren't allowed to change it *
    • memory_limit - if low, can cause attachment problems or white/blank pages - 32 is a good start
    • max_execution_time - same as above - a good start would be 30 *

    * 120 would be a much better value to start at. However, I would guess most hosts will not start you at 120, which is why it is important to ask if you may change them. Default wait_timeout is 28800, if it doesn't get modified by the host.


    Ask if you may edit your own php.ini file (to modify the variables listed above).

    Ask if installed:
    suhosin
    mod_security (1 or 2)

    Ask if PHP must run in Safe Mode or is it/can it be disabled
    Ask if they place open_basedir restrictions on PHP Scripts

    Check to make sure PHP is compiled with the following:
    • cURL with SSL Support, OpenSSL (for facebook integration)
    • GD (for image support)
    • mbstring and/or iconv (for multi-language compatibility_
    • xml
    • zlib (for compression)
    • mysql/mysqli (which one - both?)
    • standard (most php scripts probably won't work with this disabled)
    • json (for mobile)
    • hash (for md5 support)
    • SPL
    • SOAP (for integration with VerticalResponse)



    Regarding MySQL:
    can the mysql user grant ALL permissions to databases you create?
    how many databases you may create?
    is there a size limitation on the databases you create?
    What are the limitations on a mysql user, max_questions and max_connections
    Regarding Email on the server:
    What kind of email limitations are in place?
    Do you offer expanded email services through SMTP?
    Last edited by Lynne; Mon 18th Apr '11, 6:39am.

    Please don't PM or VM me for support - I only help out in the threads.
    vBulletin Manual & vBulletin 4.0 Code Documentation (API)
    Want help modifying your vbulletin forum? Head on over to vbulletin.org
    If I post CSS and you don't know where it goes, throw it into the additional.css template.

    W3Schools <- awesome site for html/css help

  • #2
    Very good. Thanks Lynne!

    Comment


    • #3
      Excellent, Lynne! I've been shopping around for a new host the past few days, and your post is an awesome aid. Nice job!
      ~ Life isn't always fair, but you can be. ~

      Comment


      • #4
        Or.... just get www.urljet.com
        www.8thos.com

        Comment


        • #5
          Just a heads up for folks with VPS or dedicated servers with root/ssh2 telnet access, you can use this script I wrote mysqlmymonlite.sh to gather your existing server's hardware and software configuration details along with mysql stats to get an idea of your current resource usage and use that info to compare with your new web hosts you find.

          Or use the stats to be informed of your current usage so you know what type of upgrade/new web hosts' resource requirements you need.

          example output

          Code:
          ----------------------------
          System MySQL monitoring stats
          mysqlmymonlite.sh - v0.0.9
          compiled by George Liu (eva2000) vbtechsupport.com
          ----------------------------
          
          Report Generated:
          Fri Jul 1 05:23:00 EST 2011
          
          ----------------------------
          MySQL Uptime:
          ----------------------------
          MySQL server was started 2011-07-01 01:03:24
          Uptime: 4 hours 19 min 36 sec  
          Uptime 15576
          Uptime_since_flush_status 15576
          
          
          ----------------------------
          Hardware Info:
          ----------------------------
          Processors physical = 1, cores = 2, virtual = 2, hyperthreading = no
                2  3375.780
                2  Intel(R) Xeon(R) CPU           W3540  @ 2.93GHz
                2  6144 KB
          
          
          ----------------------------
          TOP stats
          ----------------------------
          
          Linux 2.6.18-194.32.1.el5 (localhost.localdomain)       07/01/2011
          
          05:23:00 AM  CPU   %user   %nice    %sys %iowait    %irq   %soft  %steal   %idle    intr/s
          05:23:02 AM  all    0.00    0.00    0.50    0.00    0.00    0.75    0.00   98.75   1009.00
          05:23:02 AM    0    0.00    0.00    0.00    0.00    0.00    1.50    0.00   98.50   1002.00
          05:23:02 AM    1    0.00    0.00    0.50    0.00    0.00    0.00    0.00   99.50      6.50
          
          05:23:02 AM  CPU   %user   %nice    %sys %iowait    %irq   %soft  %steal   %idle    intr/s
          05:23:04 AM  all    0.50    0.00    0.75    0.00    0.00    0.00    0.00   98.75   1008.00
          05:23:04 AM    0    0.50    0.00    0.50    0.00    0.00    0.00    0.00   99.00   1002.50
          05:23:04 AM    1    0.50    0.00    1.50    0.00    0.00    0.00    0.00   98.00      5.50
          
          Average:     CPU   %user   %nice    %sys %iowait    %irq   %soft  %steal   %idle    intr/s
          Average:     all    0.25    0.00    0.62    0.00    0.00    0.37    0.00   98.75   1008.50
          Average:       0    0.25    0.00    0.25    0.00    0.00    0.75    0.00   98.75   1002.25
          Average:       1    0.25    0.00    1.00    0.00    0.00    0.00    0.00   98.75      6.00
          
          top - 05:23:04 up  4:21,  1 user,  load average: 0.10, 0.05, 0.01
          Tasks: 126 total,   1 running, 125 sleeping,   0 stopped,   0 zombie
          Cpu(s):  0.8%us,  1.4%sy,  0.1%ni, 95.3%id,  2.2%wa,  0.0%hi,  0.2%si,  0.0%st
          Mem:   1542404k total,  1410440k used,   131964k free,    59180k buffers
          Swap:  3112952k total,      140k used,  3112812k free,  1054372k cached
          
            PID USER      PR  NI  VIRT  RES  SHR S %CPU %MEM    TIME+  COMMAND                                                               
              1 root      15   0 10352  700  588 S  0.0  0.0   0:00.83 init                                                                  
              2 root      RT  -5     0    0    0 S  0.0  0.0   0:00.01 migration/0                                                           
              3 root      34  19     0    0    0 S  0.0  0.0   0:00.02 ksoftirqd/0                                                           
              4 root      RT  -5     0    0    0 S  0.0  0.0   0:01.63 watchdog/0                                                            
              5 root      RT  -5     0    0    0 S  0.0  0.0   0:00.01 migration/1                                                           
              6 root      34  19     0    0    0 S  0.0  0.0   0:00.06 ksoftirqd/1                                                           
              7 root      RT  -5     0    0    0 S  0.0  0.0   0:00.09 watchdog/1                                                            
              8 root      10  -5     0    0    0 S  0.0  0.0   0:14.76 events/0                                                              
              9 root      10  -5     0    0    0 S  0.0  0.0   0:01.00 events/1                                                              
             10 root      10  -5     0    0    0 S  0.0  0.0   0:00.00 khelper                                                               
             23 root      10  -5     0    0    0 S  0.0  0.0   0:00.02 kthread                                                               
             28 root      10  -5     0    0    0 S  0.0  0.0   0:00.13 kblockd/0                                                             
             29 root      10  -5     0    0    0 S  0.0  0.0   0:00.61 kblockd/1                                                             
             30 root      14  -5     0    0    0 S  0.0  0.0   0:00.00 kacpid                                                                
             69 root      14  -5     0    0    0 S  0.0  0.0   0:00.00 cqueue/0                                                              
             70 root      14  -5     0    0    0 S  0.0  0.0   0:00.00 cqueue/1                                                              
             73 root      10  -5     0    0    0 S  0.0  0.0   0:00.00 khubd                                                                 
             75 root      10  -5     0    0    0 S  0.0  0.0   0:00.00 kseriod                                                               
            147 root      15   0     0    0    0 S  0.0  0.0   0:00.01 khungtaskd                                                            
            150 root      10  -5     0    0    0 S  0.0  0.0   0:03.06 kswapd0                                                               
            151 root      14  -5     0    0    0 S  0.0  0.0   0:00.00 aio/0                                                                 
            152 root      14  -5     0    0    0 S  0.0  0.0   0:00.00 aio/1                                                                 
            289 root      11  -5     0    0    0 S  0.0  0.0   0:00.00 kpsmoused                                                             
            321 root      13  -5     0    0    0 S  0.0  0.0   0:00.00 ata/0                                                                 
            322 root      13  -5     0    0    0 S  0.0  0.0   0:00.00 ata/1                                                                 
            323 root      15  -5     0    0    0 S  0.0  0.0   0:00.00 ata_aux                                                               
            327 root      10  -5     0    0    0 S  0.0  0.0   0:00.00 scsi_eh_0                                                             
            334 root      11  -5     0    0    0 S  0.0  0.0   0:00.00 kstriped                                                              
            347 root      13  -5     0    0    0 S  0.0  0.0   0:00.00 ksnapd                                                                
            362 root      10  -5     0    0    0 S  0.0  0.0   0:06.64 kjournald                                                             
            388 root      10  -5     0    0    0 S  0.0  0.0   0:00.01 kauditd                                                               
            421 root      17  -4 13040 1212  388 S  0.0  0.1   0:00.08 udevd                                                                 
           1264 root      20  -5     0    0    0 S  0.0  0.0   0:00.00 kmpathd/0                                                             
           1265 root      20  -5     0    0    0 S  0.0  0.0   0:00.00 kmpathd/1                                                             
           1266 root      20  -5     0    0    0 S  0.0  0.0   0:00.00 kmpath_handlerd                                                       
           1328 root      10  -5     0    0    0 S  0.0  0.0   0:00.00 kjournald                                                             
           1784 root      18   0  6744  684  172 S  0.0  0.0   0:00.00 dhclient                                                              
           1932 root      15   0  6744  936  420 S  0.0  0.1   0:00.78 dhclient                                                              
           1977 root      11  -4 27328  816  580 S  0.0  0.1   0:00.26 auditd                                                                
           1979 root       7  -8 16268  752  620 S  0.0  0.0   0:00.11 audispd                                                               
           2001 root      16   0  5912  620  500 S  0.0  0.0   0:00.51 syslogd                                                               
           2004 root      15   0  3808  432  348 S  0.0  0.0   0:00.08 klogd                                                                 
           2077 rpc       24   0  8056  596  472 S  0.0  0.0   0:00.00 portmap                                                               
           2104 root      19  -5     0    0    0 S  0.0  0.0   0:00.00 rpciod/0                                                              
           2105 root      19  -5     0    0    0 S  0.0  0.0   0:00.00 rpciod/1                                                              
           2112 rpcuser   25   0 10164  808  664 S  0.0  0.1   0:00.00 rpc.statd                                                             
           2136 root      25   0 55184  772  308 S  0.0  0.1   0:00.00 rpc.idmapd                                                            
           2151 dbus      15   0 21364 1004  716 S  0.0  0.1   0:00.06 dbus-daemon                                                           
           2166 root      25   0 10436  784  652 S  0.0  0.1   0:00.00 hcid                                                                  
           2172 root      25   0  5940  544  444 S  0.0  0.0   0:00.00 sdpd                                                                  
           2195 root       9 -10     0    0    0 S  0.0  0.0   0:00.00 krfcommd                                                              
           2233 root      18   0 31288 1344  560 S  0.0  0.1   0:07.75 pcscd                                                                 
           2243 root      18   0  3804  564  468 S  0.0  0.0   0:00.00 acpid                                                                 
           2252 haldaemo  15   0 30940 3880 1580 S  0.0  0.3   0:00.90 hald                                                                  
           2253 root      18   0 21700 1060  872 S  0.0  0.1   0:00.01 hald-runner                                                           
           2261 haldaemo  18   0 12328  856  744 S  0.0  0.1   0:00.00 hald-addon-acpi                                                       
           2265 haldaemo  19   0 12328  852  740 S  0.0  0.1   0:00.00 hald-addon-keyb                                                       
           2275 root      18   0 10232  688  592 S  0.0  0.0   0:14.87 hald-addon-stor                                                       
           2292 root      24   0  8520  484  380 S  0.0  0.0   0:00.00 hidd                                                                  
           2326 nsd       18   0 14168  792  600 S  0.0  0.1   0:00.03 nsd                                                                   
           2336 nsd       25   0 21032  732  324 S  0.0  0.0   0:00.00 nsd                                                                   
           2337 nsd       25   0 14300  492  208 S  0.0  0.0   0:00.00 nsd                                                                   
           2349 root      22   0 54400 1512 1120 S  0.0  0.1   0:07.90 automount                                                             
           2415 root      25   0 69264  764  504 S  0.0  0.0   0:07.95 VBoxService                                                           
           2430 root      25   0 26328  528  328 S  0.0  0.0   0:00.00 hpiod                                                                 
           2435 root      18   0  151m 6724  964 S  0.0  0.4   0:00.62 python                                                                
           2442 root      15   0  163m 3540  888 S  0.0  0.2   1:47.37 php-fpm                                                               
           2443 nginx     20   0  163m 3412  760 S  0.0  0.2   0:00.00 php-fpm                                                               
           2444 nginx     20   0  163m 3412  760 S  0.0  0.2   0:00.00 php-fpm                                                               
           2445 nginx     20   0  163m 3412  760 S  0.0  0.2   0:00.00 php-fpm                                                               
           2446 nginx     24   0  163m 3412  760 S  0.0  0.2   0:00.00 php-fpm                                                               
           2447 nginx     23   0  163m 3412  760 S  0.0  0.2   0:00.00 php-fpm                                                               
           2448 nginx     23   0  163m 3412  760 S  0.0  0.2   0:00.00 php-fpm                                                               
           2449 nginx     23   0  163m 3412  760 S  0.0  0.2   0:00.00 php-fpm                                                               
           2450 nginx     23   0  163m 3412  760 S  0.0  0.2   0:00.00 php-fpm                                                               
           2451 nginx     23   0  163m 3412  760 S  0.0  0.2   0:00.00 php-fpm                                                               
           2452 nginx     23   0  163m 3412  760 S  0.0  0.2   0:00.00 php-fpm                                                               
           2453 nginx     25   0  163m 3412  760 S  0.0  0.2   0:00.00 php-fpm                                                               
           2454 nginx     25   0  163m 3416  760 S  0.0  0.2   0:00.00 php-fpm                                                               
           2455 nginx     25   0  163m 3416  760 S  0.0  0.2   0:00.00 php-fpm                                                               
           2456 nginx     25   0  163m 3416  760 S  0.0  0.2   0:00.00 php-fpm                                                               
           2457 nginx     25   0  163m 3416  760 S  0.0  0.2   0:00.00 php-fpm                                                               
           2458 nginx     25   0  163m 3416  760 S  0.0  0.2   0:00.00 php-fpm                                                               
           2459 nginx     25   0  163m 3416  760 S  0.0  0.2   0:00.00 php-fpm                                                               
           2460 nginx     25   0  163m 3416  760 S  0.0  0.2   0:00.00 php-fpm                                                               
           2461 nginx     25   0  163m 3416  760 S  0.0  0.2   0:00.00 php-fpm                                                               
           2462 nginx     25   0  163m 3416  760 S  0.0  0.2   0:00.00 php-fpm                                                               
           2473 root      15   0 62628 1204  644 S  0.0  0.1   0:00.00 sshd                                                                  
           2482 root      18   0  130m 2616 1712 S  0.0  0.2   0:00.01 cupsd                                                                 
           2496 root      22   0 21648  892  676 S  0.0  0.1   0:00.01 xinetd                                                                
           2508 ntp       15   0 23396 5032 3904 S  0.0  0.3   0:05.09 ntpd                                                                  
           2524 root      25   0 65968 1324 1072 S  0.0  0.1   0:00.02 mysqld_safe                                                           
           2794 mysql     15   0  771m  94m 5036 S  0.0  6.3   5:03.85 mysqld                                                                
           3055 root      18   0  124m  24m 1560 S  0.0  1.6   0:03.28 lfd                                                                   
           3068 nobody    15   0 64552  852  552 S  0.0  0.1   0:10.55 memcached                                                             
           3070 nobody    15   0 64552  856  552 S  0.0  0.1   0:10.52 memcached                                                             
           3111 root      15   0 71108 2340  800 S  0.0  0.2   0:00.71 sendmail                                                              
           3119 smmsp     15   0 57700 1780  632 S  0.0  0.1   0:00.00 sendmail                                                              
           3129 root      15   0  6456  364  284 S  0.0  0.0   0:02.38 gpm                                                                   
           3142 root      19   0 37712 2588  316 S  0.0  0.2   0:00.00 nginx                                                                 
           3151 root      15   0 74852 1164  588 S  0.0  0.1   0:00.13 crond                                                                 
           3158 nginx     19   0 52592  16m  612 S  0.0  1.1   0:00.01 nginx                                                                 
           3181 xfs       15   0 20968 1780  776 S  0.0  0.1   0:00.02 xfs                                                                   
           3198 root      18   0 18736  452  304 S  0.0  0.0   0:00.01 atd                                                                   
           3225 avahi     15   0 23280 1304 1080 S  0.0  0.1   0:00.02 avahi-daemon                                                          
           3226 avahi     25   0 23152  332  180 S  0.0  0.0   0:00.00 avahi-daemon                                                          
           3287 root      18   0 18420  528  272 S  0.0  0.0   0:00.00 smartd                                                                
           3292 root      15   0  3796  492  420 S  0.0  0.0   0:00.00 mingetty                                                              
           3296 root      15   0  3796  492  420 S  0.0  0.0   0:00.00 mingetty                                                              
           3299 root      18   0  3796  488  416 S  0.0  0.0   0:00.00 mingetty                                                              
           3300 root      18   0  3796  492  420 S  0.0  0.0   0:00.00 mingetty                                                              
           3306 root      18   0  3796  492  420 S  0.0  0.0   0:00.00 mingetty                                                              
           3308 root      18   0  3796  492  420 S  0.0  0.0   0:00.00 mingetty                                                              
           3309 root      15   0  163m 2592 1976 S  0.0  0.2   0:00.03 gdm-binary                                                            
           3408 root      18   0  185m 4100 3376 S  0.0  0.3   0:25.64 gdm-rh-security                                                       
           3418 root      16   0  190m 2356 1644 S  0.0  0.2   0:00.00 gdm-binary                                                            
           3421 root      15   0  103m 6168 4272 S  0.0  0.4   0:01.58 Xorg                                                                  
           3438 gdm       16   0  219m  19m 7064 S  0.0  1.3   0:00.78 gdmgreeter                                                            
           3439 root      34  19  251m  16m 2220 S  0.0  1.1   0:00.23 yum-updatesd                                                          
           3441 root      34  19 12920 1196  972 S  0.0  0.1   0:08.25 gam_server                                                            
           3443 root      15   0 90128 3388 2636 S  0.0  0.2   0:12.73 sshd                                                                  
           3445 root      15   0 66236 1676 1216 S  0.0  0.1   0:01.22 bash                                                                  
           3728 root      15   0     0    0    0 S  0.0  0.0   0:01.79 pdflush                                                               
           4349 root      15   0     0    0    0 S  0.0  0.0   0:01.20 pdflush                                                               
          10453 root      18   0 64140 1508  980 S  0.0  0.1   0:00.00 mysqlmymonlite.                                                       
          10555 root      15   0 12740  992  720 R  0.0  0.1   0:00.00 top                                                                   
          
          
                       total       used       free     shared    buffers     cached
          Mem:          1506       1377        128          0         57       1029
          Low:          1506       1377        128
          High:            0          0          0
          -/+ buffers/cache:        289       1216
          Swap:         3039          0       3039
          
          MemTotal:      1542404 kB
          MemFree:        131948 kB
          Buffers:         59180 kB
          Cached:        1054372 kB
          SwapCached:          0 kB
          Active:         920452 kB
          Inactive:       387184 kB
          HighTotal:           0 kB
          HighFree:            0 kB
          LowTotal:      1542404 kB
          LowFree:        131948 kB
          SwapTotal:     3112952 kB
          SwapFree:      3112812 kB
          Dirty:             316 kB
          Writeback:           0 kB
          AnonPages:      194124 kB
          Mapped:          26380 kB
          Slab:            70460 kB
          PageTables:      12828 kB
          NFS_Unstable:        0 kB
          Bounce:              0 kB
          CommitLimit:   3884152 kB
          Committed_AS:  1155616 kB
          VmallocTotal: 34359738367 kB
          VmallocUsed:     26752 kB
          VmallocChunk: 34359711235 kB
          HugePages_Total:     0
          HugePages_Free:      0
          HugePages_Rsvd:      0
          Hugepagesize:     2048 kB
          
          ----------------------------
          Server Disk Usage
          ----------------------------
          Filesystem            Size  Used Avail Use% Mounted on
          /dev/mapper/VolGroup00-LogVol00
                                 13G  9.1G  3.0G  76% /
          /dev/sda1              99M   19M   75M  21% /boot
          tmpfs                 754M     0  754M   0% /dev/shm
          tmpfs                 754M  8.0K  754M   1% /tmp
          
          ----------------------------
          MySQL datadir disk usage
          ----------------------------
          /var/lib/mysql/ uses 2190612 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) 12287
          max locked memory       (kbytes, -l) 32
          max memory size         (kbytes, -m) unlimited
          open files                      (-n) 65536
          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) 12287
          virtual memory          (kbytes, -v) unlimited
          file locks                      (-x) unlimited
          
          ----------------------------
          WEB SERVER & PHP Info:
          ----------------------------
          PHP 5.3.6 (cli) (built: Jun 19 2011 12:45:19) 
          Copyright (c) 1997-2011 The PHP Group
          Zend Engine v2.3.0, Copyright (c) 1998-2011 Zend Technologies
          
          System => Linux localhost.localdomain 2.6.18-194.32.1.el5 #1 SMP Wed Jan 5 17:52:25 EST 2011 x86_64
          Build Date => Jun 19 2011 12:44:15
          
          Configure Command =>  '../configure'  '--enable-cgi' '--enable-fpm' '--with-mhash' '--with-zlib' '--with-gettext' '--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=/usr/bin/' '--with-libdir=lib64' '--with-mysqli=/usr/bin/mysql_config' '--with-mysql-sock' '--with-curl' '--with-gd' '--with-xmlrpc' '--enable-bcmath' '--enable-calendar' '--enable-ftp' '--enable-gd-native-ttf' '--without-sqlite' '--disable-pdo' '--enable-inline-optimization' '--with-fpm-user=nginx' '--with-fpm-group=nginx'
          
          Configuration File (php.ini) Path | /usr/local/lib
          Loaded Configuration File | /usr/local/lib/php.ini
          
          Server API | Command Line Interface
          PHP API | 20090626
          Zend Extension Build | API220090626,NTS
          PHP Extension Build | API20090626,NTS
          DOM/XML API Version | 20031129
          MHASH API Version | Emulated Support
          Client API version | 5.2.7-MariaDB
          Client API library version | 5.2.7-MariaDB
          Client API header version | 5.2.6-MariaDB
          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-20090626 | /usr/local/lib/php/extensions/no-debug-non-zts-20090626
          file_uploads | On | On
          log_errors | On | On
          log_errors_max_len | 1024 | 1024
          magic_quotes_gpc | Off | Off
          magic_quotes_sybase | Off | Off
          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 | 1024k | 1024k
          realpath_cache_ttl | 180 | 180
          safe_mode | Off | Off
          safe_mode_exec_dir | no value | no value
          safe_mode_gid | Off | Off
          safe_mode_include_dir | no value | no value
          sendmail_path | /usr/sbin/sendmail -t -i  | /usr/sbin/sendmail -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
          safe_mode_allowed_env_vars | PHP_ | PHP_
          safe_mode_protected_env_vars | LD_LIBRARY_PATH | LD_LIBRARY_PATH
          
          cURL support | enabled
          cURL Information | 7.15.5
          ZLib Version | 1.2.3
          GD Support | enabled
          GD Version | bundled (2.0.34 compatible)
          GIF Read Support | enabled
          GIF Create Support | enabled
          PNG Support | enabled
          libPNG Version | 1.2.10
          WBMP Support | enabled
          libXML support | active
          libXML Compiled Version | 2.6.26
          libXML Loaded Version | 20626
          libXML streams | enabled
          PCRE (Perl Compatible Regular Expressions) Support | enabled
          PCRE Library Version | 8.11 2010-12-10
          Soap Client | enabled
          Soap Server | enabled
          ZLib Support | enabled
          
          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 | 1000 | 1000
          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 | default | default
          apc.shm_segments | 1 | 1
          apc.shm_size | 32M | 32M
          apc.slam_defense | On | On
          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
          
          
          memcache
          memcache support | enabled
          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
          Registered save handlers | files user memcache 
          
          
          
          
          ---------------
          You're running Nginx
          ---------------
          
          nginx: nginx version: nginx/1.0.4
          nginx: built by gcc 4.1.2 20080704 (Red Hat 4.1.2-48)
          nginx: TLS SNI support enabled
          nginx: configure arguments: --sbin-path=/usr/local/sbin --conf-path=/usr/local/nginx/conf/nginx.conf --with-http_ssl_module --with-http_gzip_static_module --with-http_stub_status_module --with-http_sub_module --with-http_addition_module --with-http_secure_link_module --with-http_flv_module --with-http_realip_module --add-module=../ngx-fancyindex-ngx-fancyindex --add-module=../ngx_cache_purge-1.3 --add-module=../nginx-accesskey-2.0.3 --with-google_perftools_module --with-openssl=../openssl-1.0.0d --with-ld-opt=-ltcmalloc_minimal
          
          user              nginx nginx;
          worker_processes  1;
          worker_rlimit_nofile 51200;
              worker_connections  32768;
              use epoll;
                  sendfile        on;
                  keepalive_timeout  10;
                  gzip            on;
                    gzip_vary   on;
                    gzip_disable "MSIE [1-6]\.";
                  gzip_static on;
                  gzip_min_length   1100;
                  gzip_buffers      32 8k;
                  gzip_http_version 1.0;
                  gzip_comp_level 1;
                  gzip_proxied    any;
           gzip_types      text/plain text/css text/javascript text/xml application/x-javascript application/xml application/xml+rss;
           client_body_buffer_size 128k;
           client_body_in_file_only on;
           client_body_timeout 60s;
           client_header_buffer_size 256k;
           client_header_timeout  20s;
           client_max_body_size 64m; 
           large_client_header_buffers 4 256k;
           proxy_temp_path  /tmp/nginx_proxy/;
          
          ----------------------------
          Table Index Size
          ----------------------------
          ------------------------------
          db2 Index Size = NULL
          ------------------------------
          ------------------------------
          mysql Index Size = 0.08 MB
          ------------------------------
          ------------------------------
          sbtest Index Size = 155.65 MB
          ------------------------------
          ------------------------------
          test Index Size = NULL
          ------------------------------
          
          ----------------------------
          Table Data Size
          ----------------------------
          ------------------------------
          db2 Data Size = NULL
          ------------------------------
          ------------------------------
          mysql Data Size = 0.52 MB
          ------------------------------
          ------------------------------
          sbtest Data Size = 1802.44 MB
          ------------------------------
          ------------------------------
          test Data Size = NULL
          ------------------------------
          
          ----------------------------
          Database per Table Size
          ----------------------------
          
          ----------------------
          db2 per Table Size
          ----------------------
          
          ----------------------
          mysql per Table Size
          ----------------------
          +---------------------------------+----------------+----------------+-----------+------------+--------+
          | Table Name                      | Number of Rows | Storage Engine | Data Size | Index Size | Total  |
          +---------------------------------+----------------+----------------+-----------+------------+--------+
          | mysql.columns_priv              | 0 Rows         | MyISAM         | 0.00MB    | 0.00MB     | 0.00MB |
          | mysql.db                        | 3 Rows         | MyISAM         | 0.00MB    | 0.00MB     | 0.01MB |
          | mysql.event                     | 1 Rows         | MyISAM         | 0.00MB    | 0.00MB     | 0.00MB |
          | mysql.func                      | 0 Rows         | MyISAM         | 0.00MB    | 0.00MB     | 0.00MB |
          | mysql.general_log               | 2 Rows         | CSV            | 0.00MB    | 0.00MB     | 0.00MB |
          | mysql.help_category             | 37 Rows        | MyISAM         | 0.02MB    | 0.00MB     | 0.02MB |
          | mysql.help_keyword              | 450 Rows       | MyISAM         | 0.08MB    | 0.01MB     | 0.10MB |
          | mysql.help_relation             | 990 Rows       | MyISAM         | 0.01MB    | 0.02MB     | 0.02MB |
          | mysql.help_topic                | 504 Rows       | MyISAM         | 0.40MB    | 0.02MB     | 0.42MB |
          | mysql.host                      | 0 Rows         | MyISAM         | 0.00MB    | 0.00MB     | 0.00MB |
          | mysql.ndb_binlog_index          | 0 Rows         | MyISAM         | 0.00MB    | 0.00MB     | 0.00MB |
          | mysql.plugin                    | 0 Rows         | MyISAM         | 0.00MB    | 0.00MB     | 0.00MB |
          | mysql.proc                      | 0 Rows         | MyISAM         | 0.00MB    | 0.00MB     | 0.00MB |
          | mysql.procs_priv                | 0 Rows         | MyISAM         | 0.00MB    | 0.00MB     | 0.00MB |
          | mysql.servers                   | 0 Rows         | MyISAM         | 0.00MB    | 0.00MB     | 0.00MB |
          | mysql.slow_log                  | 2 Rows         | CSV            | 0.00MB    | 0.00MB     | 0.00MB |
          | mysql.tables_priv               | 0 Rows         | MyISAM         | 0.00MB    | 0.00MB     | 0.00MB |
          | mysql.time_zone                 | 0 Rows         | MyISAM         | 0.00MB    | 0.00MB     | 0.00MB |
          | mysql.time_zone_leap_second     | 0 Rows         | MyISAM         | 0.00MB    | 0.00MB     | 0.00MB |
          | mysql.time_zone_name            | 0 Rows         | MyISAM         | 0.00MB    | 0.00MB     | 0.00MB |
          | mysql.time_zone_transition      | 0 Rows         | MyISAM         | 0.00MB    | 0.00MB     | 0.00MB |
          | mysql.time_zone_transition_type | 0 Rows         | MyISAM         | 0.00MB    | 0.00MB     | 0.00MB |
          | mysql.user                      | 9 Rows         | MyISAM         | 0.00MB    | 0.00MB     | 0.00MB |
          +---------------------------------+----------------+----------------+-----------+------------+--------+
          
          ----------------------
          sbtest per Table Size
          ----------------------
          +----------------+----------------+----------------+-----------+------------+----------+
          | Table Name     | Number of Rows | Storage Engine | Data Size | Index Size | Total    |
          +----------------+----------------+----------------+-----------+------------+----------+
          | sbtest.sbtest1 | 5000000 Rows   | MyISAM         | 901.22MB  | 77.83MB    | 979.05MB |
          | sbtest.sbtest2 | 5000000 Rows   | MyISAM         | 901.22MB  | 77.83MB    | 979.05MB |
          +----------------+----------------+----------------+-----------+------------+----------+
          
          ----------------------
          test per Table Size
          ----------------------
          
          ----------------------------
          Total Server MyISAM and InnoDB Size
          ----------------------------
          *************************** 1. row ***************************
          innodb_tablespace_utilization_perc: NULL
                               total_size_gb: 1.91291540581733
                               index_size_gb: 0.152149200439453
                                data_size_gb: 1.76076620537788
                        innodb_total_size_gb: 0
                         innodb_data_size_gb: 0
                        innodb_index_size_gb: 0
                        myisam_total_size_gb: 1.91279333550483
                         myisam_data_size_gb: 1.76070517022163
                        myisam_index_size_gb: 0.152088165283203
                                  perc_index: 7.9538
                                   perc_data: 92.0462
                           innodb_perc_index: NULL
                            innodb_perc_data: NULL
                           myisam_perc_index: 7.9511
                            myisam_perc_data: 92.0489
                     innodb_perc_total_index: 0.0000
                      innodb_perc_total_data: 0.0000
                     myisam_perc_total_index: 99.9599
                      myisam_perc_total_data: 99.9965
          
          ----------------------------
          mysqlreport output
          ----------------------------
          mysqlreport [found]
          MySQL 5.2.7-MariaDB-mar  uptime 0 4:19:41       Fri Jul  1 05:23:05 2011
          
          __ Key _________________________________________________________________
          Buffer used    26.16M of  32.00M  %Used:  81.76
            Current       5.84M            %Usage:  18.24
          Write hit       0.00%
          Read hit        0.00%
          
          __ Questions ___________________________________________________________
          Total           1.58k     0.1/s
            Com_            661     0.0/s  %Total:  41.92
            COM_QUIT        550     0.0/s           34.88
            DMS             386     0.0/s           24.48
            -Unknown         20     0.0/s            1.27
          Slow 1 s            1     0.0/s            0.06  %DMS:   0.26  Log: OFF
          DMS               386     0.0/s           24.48
            SELECT          386     0.0/s           24.48        100.00
            REPLACE           0       0/s            0.00          0.00
            DELETE            0       0/s            0.00          0.00
            INSERT            0       0/s            0.00          0.00
            UPDATE            0       0/s            0.00          0.00
          Com_              661     0.0/s           41.92
            show_variab     355     0.0/s           22.51
            set_option      161     0.0/s           10.21
            check            35     0.0/s            2.22
          
          __ SELECT and Sort _____________________________________________________
          Scan              465     0.0/s %SELECT: 120.47
          Range               0       0/s            0.00
          Full join           0       0/s            0.00
          Range check         0       0/s            0.00
          Full rng join       0       0/s            0.00
          Sort scan           0       0/s
          Sort range          0       0/s
          Sort mrg pass       0       0/s
          
          __ Query Cache _________________________________________________________
          Memory usage   17.14k of  32.00M  %Used:   0.05
          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          98     0.0/s
          
          __ Tables ______________________________________________________________
          Open               25 of 2048    %Cache:   1.22
          Opened             59     0.0/s
          
          __ Connections _________________________________________________________
          Max used            2 of  350      %Max:   0.57
          Total             552     0.0/s
          
          __ Created Temp ________________________________________________________
          Disk table         24     0.0/s
          Table             624     0.0/s    Size:  32.0M
          File                5     0.0/s
          
          __ Threads _____________________________________________________________
          Running             1 of    1
          Cached              1 of  256      %Hit:  99.64
          Created             2     0.0/s
          Slow                0       0/s
          
          __ Aborted _____________________________________________________________
          Clients             0       0/s
          Connects            8     0.0/s
          
          __ Bytes _______________________________________________________________
          Sent            4.37M   280.3/s
          Received      108.39k     7.0/s
          
          __ InnoDB Buffer Pool __________________________________________________
          Usage           1.23M of 127.98M  %Used:   0.96
          Read hit       99.98%
          Pages
            Free          8.11k            %Total:  99.04
            Data             79                      0.96 %Drty:   0.00
            Misc              0                      0.00
            Latched                                  0.00
          Reads         406.38k    26.1/s
            From file        80     0.0/s            0.02
            Ahead Rnd                 0/s
            Ahead Sql                 0/s
          Writes              0       0/s
          Flushes             0       0/s
          Wait Free           0       0/s
          
          __ InnoDB Lock _________________________________________________________
          Waits               0       0/s
          Current             0
          Time acquiring
            Total             0 ms
            Average           0 ms
            Max               0 ms
          
          __ InnoDB Data, Pages, Rows ____________________________________________
          Data
            Reads            90     0.0/s
            Writes            3     0.0/s
            fsync             3     0.0/s
            Pending
              Reads           0
              Writes          0
              fsync           0
          
          Pages
            Created           0       0/s
            Read             79     0.0/s
            Written           0       0/s
          
          Rows
            Deleted           0       0/s
            Inserted          0       0/s
            Read              0       0/s
            Updated           0       0/s
          
          ----------------------------
          MySQL settings
          ----------------------------
          [mysqld]
          datadir=/var/lib/mysql/
          # optimized my.cnf for MariaDB 5.2.7
          # by eva2000
          # vbtechsupport.com
          
          #skip-innodb
          #skip-name-resolve
          #old_passwords
          back_log = 50
          max_connections = 350
          key_buffer_size = 32M
          myisam_sort_buffer_size = 64M
          myisam_max_sort_file_size = 2048M
          join_buffer_size = 256K
          read_buffer_size = 256K
          sort_buffer_size = 256K
          table_definition_cache = 8000
          table_open_cache = 2048
          thread_cache_size = 256
          wait_timeout = 90
          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 = 1M
          query_cache_size = 32M
          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
          #max_write_lock_count = 8
          
          slow_query_log=0
          long_query_time=1
          slow_query_log_file=/var/lib/mysql/slowq.log
          
          # mariadb settings
          userstat = 0
          key_cache_segments = 2
          maria_group_commit = none
          maria_group_commit_interval = 0
          
          # innodb settings
          innodb_file_per_table = 1
          innodb_open_files = 1000
          innodb_data_file_path= ibdata1:50M:autoextend
          innodb_buffer_pool_size = 128M
          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
          
          [mysqld_safe] 
          log-error=/var/log/mysqld.log
          #nice = -5
          open-files-limit = 16384
          
          [mysqldump]
          quick
          max_allowed_packet = 32M
          
          [myisamchk] 
          key_buffer = 256M 
          sort_buffer = 16M
          read_buffer = 16M
          write_buffer = 16M
          
          [mysqlhotcopy]
          interactive-timeout
          ---
          +---------------------------------------+----------+
          | Variable_name | Value |
          +---------------------------------------+----------+
          | Aborted_clients | 0 |
          | Aborted_connects | 8 |
          | Access_denied_errors | 6 |
          | Aria_pagecache_blocks_not_flushed | 0 |
          | Aria_pagecache_blocks_unused | 15736 |
          | Aria_pagecache_blocks_used | 0 |
          | Aria_pagecache_read_requests | 0 |
          | Aria_pagecache_reads | 0 |
          | Aria_pagecache_write_requests | 0 |
          | Aria_pagecache_writes | 0 |
          | Aria_transaction_log_syncs | 0 |
          | Binlog_bytes_written | 0 |
          | Binlog_cache_disk_use | 0 |
          | Binlog_cache_use | 0 |
          | Busy_time | 0.000000 |
          | Bytes_received | 108572 |
          | Bytes_sent | 4399715 |
          | Com_admin_commands | 0 |
          | Com_assign_to_keycache | 15 |
          | 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 | 4 |
          | Com_backup_table | 0 |
          | Com_begin | 0 |
          | Com_binlog | 0 |
          | Com_call_procedure | 0 |
          | Com_change_db | 0 |
          | Com_change_master | 0 |
          | Com_check | 35 |
          | Com_checksum | 0 |
          | Com_commit | 0 |
          | Com_create_db | 0 |
          | Com_create_event | 0 |
          | Com_create_function | 0 |
          | Com_create_index | 0 |
          | Com_create_procedure | 0 |
          | Com_create_server | 0 |
          | Com_create_table | 0 |
          | 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 | 0 |
          | Com_drop_event | 0 |
          | Com_drop_function | 0 |
          | Com_drop_index | 0 |
          | Com_drop_procedure | 0 |
          | Com_drop_server | 0 |
          | Com_drop_table | 0 |
          | Com_drop_trigger | 0 |
          | Com_drop_user | 0 |
          | Com_drop_view | 0 |
          | Com_empty_query | 0 |
          | Com_execute_sql | 0 |
          | Com_flush | 0 |
          | Com_grant | 0 |
          | Com_ha_close | 0 |
          | Com_ha_open | 0 |
          | Com_ha_read | 0 |
          | Com_help | 0 |
          | Com_insert | 0 |
          | Com_insert_select | 0 |
          | Com_install_plugin | 0 |
          | Com_kill | 4 |
          | Com_load | 0 |
          | Com_load_master_data | 0 |
          | Com_load_master_table | 0 |
          | Com_lock_tables | 0 |
          | Com_optimize | 4 |
          | Com_preload_keys | 15 |
          | 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 | 11 |
          | Com_replace | 0 |
          | Com_replace_select | 0 |
          | Com_reset | 0 |
          | Com_restore_table | 0 |
          | Com_revoke | 0 |
          | Com_revoke_all | 0 |
          | Com_rollback | 0 |
          | Com_rollback_to_savepoint | 0 |
          | Com_savepoint | 0 |
          | Com_select | 386 |
          | Com_set_option | 161 |
          | Com_show_authors | 0 |
          | Com_show_binlog_events | 0 |
          | Com_show_binlogs | 0 |
          | Com_show_charsets | 0 |
          | Com_show_client_statistics | 0 |
          | Com_show_collations | 0 |
          | Com_show_column_types | 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 | 12 |
          | Com_show_engine_logs | 0 |
          | Com_show_engine_mutex | 0 |
          | Com_show_engine_status | 2 |
          | Com_show_events | 0 |
          | Com_show_errors | 0 |
          | Com_show_fields | 0 |
          | Com_show_function_status | 0 |
          | Com_show_grants | 0 |
          | Com_show_keys | 0 |
          | Com_show_index_statistics | 0 |
          | Com_show_master_status | 0 |
          | Com_show_new_master | 0 |
          | Com_show_open_tables | 0 |
          | Com_show_plugins | 0 |
          | Com_show_privileges | 0 |
          | Com_show_procedure_status | 0 |
          | Com_show_processlist | 14 |
          | Com_show_profile | 0 |
          | Com_show_profiles | 0 |
          | Com_show_slave_hosts | 0 |
          | Com_show_slave_status | 0 |
          | Com_show_status | 30 |
          | Com_show_storage_engines | 0 |
          | Com_show_table_statistics | 0 |
          | Com_show_table_status | 0 |
          | Com_show_tables | 0 |
          | Com_show_triggers | 0 |
          | Com_show_user_statistics | 0 |
          | Com_show_variables | 357 |
          | Com_show_warnings | 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 | 0 |
          | 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 | 553 |
          | Cpu_time | 0.000000 |
          | Created_tmp_disk_tables | 24 |
          | Created_tmp_files | 5 |
          | Created_tmp_tables | 627 |
          | Delayed_errors | 0 |
          | Delayed_insert_threads | 0 |
          | Delayed_writes | 0 |
          | Empty_queries | 7 |
          | Flush_commands | 1 |
          | Handler_commit | 0 |
          | Handler_delete | 0 |
          | Handler_discover | 0 |
          | Handler_prepare | 0 |
          | Handler_read_first | 3 |
          | Handler_read_key | 0 |
          | Handler_read_next | 0 |
          | Handler_read_prev | 0 |
          | Handler_read_rnd | 0 |
          | Handler_read_rnd_next | 145332 |
          | Handler_rollback | 0 |
          | Handler_savepoint | 0 |
          | Handler_savepoint_rollback | 0 |
          | Handler_update | 0 |
          | Handler_write | 144845 |
          | Innodb_buffer_pool_pages_data | 79 |
          | Innodb_buffer_pool_pages_dirty | 0 |
          | Innodb_buffer_pool_pages_flushed | 0 |
          | Innodb_buffer_pool_pages_free | 8112 |
          | Innodb_buffer_pool_pages_misc | 0 |
          | Innodb_buffer_pool_pages_total | 8191 |
          | Innodb_buffer_pool_read_ahead | 0 |
          | Innodb_buffer_pool_read_ahead_evicted | 0 |
          | Innodb_buffer_pool_read_requests | 406385 |
          | Innodb_buffer_pool_reads | 80 |
          | Innodb_buffer_pool_wait_free | 0 |
          | Innodb_buffer_pool_write_requests | 0 |
          | Innodb_data_fsyncs | 3 |
          | Innodb_data_pending_fsyncs | 0 |
          | Innodb_data_pending_reads | 0 |
          | Innodb_data_pending_writes | 0 |
          | Innodb_data_read | 3493888 |
          | Innodb_data_reads | 90 |
          | Innodb_data_writes | 3 |
          | Innodb_data_written | 1536 |
          | Innodb_dblwr_pages_written | 0 |
          | Innodb_deadlocks | 0 |
          | Innodb_dblwr_writes | 0 |
          | Innodb_dict_tables | 8 |
          | Innodb_have_atomic_builtins | ON |
          | Innodb_log_waits | 0 |
          | Innodb_log_write_requests | 0 |
          | Innodb_log_writes | 1 |
          | Innodb_os_log_fsyncs | 3 |
          | Innodb_os_log_pending_fsyncs | 0 |
          | Innodb_os_log_pending_writes | 0 |
          | Innodb_os_log_written | 512 |
          | Innodb_page_size | 16384 |
          | Innodb_pages_created | 0 |
          | Innodb_pages_read | 79 |
          | Innodb_pages_written | 0 |
          | Innodb_row_lock_current_waits | 0 |
          | Innodb_row_lock_time | 0 |
          | Innodb_row_lock_time_avg | 0 |
          | Innodb_row_lock_time_max | 0 |
          | Innodb_row_lock_waits | 0 |
          | Innodb_rows_deleted | 0 |
          | Innodb_rows_inserted | 0 |
          | Innodb_rows_read | 0 |
          | Innodb_rows_updated | 0 |
          | Key_blocks_not_flushed | 0 |
          | Key_blocks_unused | 26792 |
          | Key_blocks_used | 26792 |
          | Key_blocks_warm | 0 |
          | Key_read_requests | 1036082 |
          | Key_reads | 1036082 |
          | Key_write_requests | 0 |
          | Key_writes | 0 |
          | Last_query_cost | 0.000000 |
          | Maria_pagecache_blocks_not_flushed | 0 |
          | Maria_pagecache_blocks_unused | 15736 |
          | Maria_pagecache_blocks_used | 0 |
          | Maria_pagecache_read_requests | 0 |
          | Maria_pagecache_reads | 0 |
          | Maria_pagecache_write_requests | 0 |
          | Maria_pagecache_writes | 0 |
          | Maria_transaction_log_syncs | 0 |
          | Max_used_connections | 2 |
          | Not_flushed_delayed_rows | 0 |
          | Open_files | 54 |
          | Open_streams | 0 |
          | Open_table_definitions | 25 |
          | Open_tables | 25 |
          | Opened_files | 314 |
          | Opened_table_definitions | 52 |
          | Opened_tables | 59 |
          | Prepared_stmt_count | 0 |
          | Qcache_free_blocks | 1 |
          | Qcache_free_memory | 33536880 |
          | Qcache_hits | 0 |
          | Qcache_inserts | 0 |
          | Qcache_lowmem_prunes | 0 |
          | Qcache_not_cached | 386 |
          | Qcache_queries_in_cache | 0 |
          | Qcache_total_blocks | 1 |
          | Queries | 1581 |
          | Questions | 1581 |
          | Rows_read | 13 |
          | Rows_sent | 144789 |
          | Rpl_status | NULL |
          | Select_full_join | 0 |
          | Select_full_range_join | 0 |
          | Select_range | 0 |
          | Select_range_check | 0 |
          | Select_scan | 468 |
          | Slave_open_temp_tables | 0 |
          | Slave_retried_transactions | 0 |
          | Slave_running | OFF |
          | Slow_launch_threads | 0 |
          | Slow_queries | 1 |
          | Sort_merge_passes | 0 |
          | Sort_range | 0 |
          | Sort_rows | 0 |
          | Sort_scan | 0 |
          | 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 | |
          | Syncs | 3 |
          | Table_locks_immediate | 98 |
          | Table_locks_waited | 0 |
          | Tc_log_max_pages_used | 0 |
          | Tc_log_page_size | 4096 |
          | Tc_log_page_waits | 0 |
          | Threads_cached | 1 |
          | Threads_connected | 1 |
          | Threads_created | 2 |
          | Threads_running | 1 |
          | Uptime | 15581 |
          | Uptime_since_flush_status | 15581 |
          +---------------------------------------+----------+
          +-----+----------+-----------+----+---------+------+-------+------------------+
          | Id | User | Host | db | Command | Time | State | Info |
          +-----+----------+-----------+----+---------+------+-------+------------------+
          | 552 | mysqlmon | localhost | | Query | 0 | | show processlist |
          +-----+----------+-----------+----+---------+------+-------+------------------+
          
          ----------------------------
          INNODB Status
          ----------------------------
          *************************** 1. row ***************************
            Type: InnoDB
            Name: 
          Status: 
          =====================================
          110701  5:23:05 INNODB MONITOR OUTPUT
          =====================================
          Per second averages calculated from the last 53 seconds
          -----------------
          BACKGROUND THREAD
          -----------------
          srv_master_thread loops: 1 1_second, 1 sleeps, 0 10_second, 1 background, 1 flush
          srv_master_thread log flush and writes: 1
          ----------
          SEMAPHORES
          ----------
          OS WAIT ARRAY INFO: reservation count 148, signal count 120
          Mutex spin waits 1306, rounds 17033, OS waits 139
          RW-shared spins 2, OS waits 1; RW-excl spins 0, OS waits 0
          Spin rounds per wait: 13.04 mutex, 30.00 RW-shared, 0.00 RW-excl
          --------
          FILE I/O
          --------
          I/O thread 0 state: waiting for i/o request (insert buffer thread)
          I/O thread 1 state: waiting for i/o request (log thread)
          I/O thread 2 state: waiting for i/o request (read thread)
          I/O thread 3 state: waiting for i/o request (read thread)
          I/O thread 4 state: waiting for i/o request (write thread)
          I/O thread 5 state: waiting for i/o request (write thread)
          Pending normal aio reads: 0, aio writes: 0,
           ibuf aio reads: 0, log i/o's: 0, sync i/o's: 0
          Pending flushes (fsync) log: 0; buffer pool: 0
          90 OS file reads, 3 OS file writes, 3 OS fsyncs
          0.00 reads/s, 0 avg bytes/read, 0.00 writes/s, 0.00 fsyncs/s
          -------------------------------------
          INSERT BUFFER AND ADAPTIVE HASH INDEX
          -------------------------------------
          Ibuf: size 1, free list len 0, seg size 2,
          0 inserts, 0 merged recs, 0 merges
          Hash table size 276671, node heap has 0 buffer(s)
          0.00 hash searches/s, 0.00 non-hash searches/s
          ---
          LOG
          ---
          Log sequence number 811367
          Log flushed up to   811367
          Last checkpoint at  811367
          Max checkpoint age    108005254
          Checkpoint age target 104630090
          Modified age          0
          Checkpoint age        0
          0 pending log writes, 0 pending chkp writes
          8 log i/o's done, 0.00 log i/o's/second
          ----------------------
          BUFFER POOL AND MEMORY
          ----------------------
          Total memory allocated 137691136; in additional pool allocated 0
          Internal hash tables (constant factor + variable factor)
              Adaptive hash index 2217584         (2213368 + 4216)
              Page hash           139112
              Dictionary cache    592524  (554768 + 37756)
              File system         83536   (82672 + 864)
              Lock system         333248  (332872 + 376)
              Recovery system     0       (0 + 0)
              Threads             83704   (82696 + 1008)
          Dictionary memory allocated 37756
          Buffer pool size        8191
          Buffer pool size, bytes 134201344
          Free buffers            8112
          Database pages          79
          Old database pages      0
          Modified db pages       0
          Pending reads 0
          Pending writes: LRU 0, flush list 0, single page 0
          Pages made young 0, not young 0
          0.00 youngs/s, 0.00 non-youngs/s
          Pages read 79, created 0, written 0
          0.00 reads/s, 0.00 creates/s, 0.00 writes/s
          Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
          Pages read ahead 0.00/s, evicted without access 0.00/s
          LRU len: 79, unzip_LRU len: 0
          I/O sum[0]:cur[0], unzip sum[0]:cur[0]
          --------------
          ROW OPERATIONS
          --------------
          0 queries inside InnoDB, 0 queries in queue
          1 read views open inside InnoDB
          Main thread process no. 2794, id 1235167552, state: waiting for server activity
          Number of rows inserted 0, updated 0, deleted 0, read 0
          0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s
          ------------
          TRANSACTIONS
          ------------
          Trx id counter B00
          Purge done for trx's n:o < 0 undo n:o < 0
          History list length 0
          LIST OF TRANSACTIONS FOR EACH SESSION:
          ---TRANSACTION 0, not started, process no 2794, OS thread id 1082267968
          MySQL thread id 553, query id 1585 localhost mysqlmon
          show engine innodb status
          ----------------------------
          END OF INNODB MONITOR OUTPUT
          ============================
          
          
          ----------------------------
          MySQL Error Log
          ----------------------------
          110701  1:03:25 Percona XtraDB (http://www.percona.com) 1.0.15-12.7 started; log sequence number 811367
          110701  1:03:25 [Note] Recovering after a crash using tc.log
          110701  1:03:25 [Note] Starting crash recovery...
          110701  1:03:25 [Note] Crash recovery finished.
          110701  1:03:26 [Note] Event Scheduler: Loaded 1 event
          110701  1:03:26 [Note] /usr/sbin/mysqld: ready for connections.
          Version: '5.2.7-MariaDB-mariadb101'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  (MariaDB - http://mariadb.com/)
          110701  1:39:45 [Note] Retrying repair of: './sbtest/sbtest1' with keycache
          110701  1:50:19 [ERROR] mysqld: Table './sbtest/sbtest1' is marked as crashed and last (automatic?) repair failed
          110701  1:50:19 [ERROR] mysqld: Table './sbtest/sbtest1' is marked as crashed and last (automatic?) repair failed
          110701  1:50:53 [Note] Found 5000000 of 0 rows when repairing './sbtest/sbtest1'
          110701  2:09:55 [Note] Retrying repair of: './sbtest/sbtest1' with keycache
          110701  2:55:26 [ERROR] mysqld: Table './sbtest/sbtest1' is marked as crashed and last (automatic?) repair failed
          110701  2:55:26 [ERROR] mysqld: Table './sbtest/sbtest1' is marked as crashed and last (automatic?) repair failed
          110701  2:56:10 [Note] Found 5000000 of 0 rows when repairing './sbtest/sbtest1'
          
          Report Complete:
          Fri Jul 1 05:23:05 EST 2011
          ---------------------------
          :: Always Back Up Forum Database + Attachments BEFORE upgrading !
          :: Nginx SPDY SSL - World Flags Demo [video results]
          :: vBulletin hacked forums: Clean Up Guide for VPS/Dedicated hosting users [ vbulletin.com blog summary ]

          Comment


          • #6
            Read their TOS very closely before you pay- ask what happens if you prepay on VPS plans and things do not go well and you want a refund. Some places offer a 30 day refund policy, but if you read the fine print, it is only on shared accounts. Kevin at HostAtom just kept $480 of my money when I prepaid for a year's service when I wanted to cancel, and he terminated my account for complaining to Paypal.

            Also, find out how long they are in business and where their location is. Don't host with people who are only in business one or two years (like HostAtom) who use only a post office box as their contact location (like HostAtom). They probably are young geeks who still live with their parents and work out of their home. If something goes wrong, you have little or no legal recourse, so be careful out there.

            You could end up losing a lot of money, like I did.


            Nelson
            Nelson
            www.Hobby-Machinist.com

            Comment


            • #7
              Originally posted by Allthumbz View Post
              Read their TOS very closely before you pay- ask what happens if you prepay on VPS plans and things do not go well and you want a refund. Some places offer a 30 day refund policy, but if you read the fine print, it is only on shared accounts. Kevin at HostAtom just kept $480 of my money when I prepaid for a year's service when I wanted to cancel, and he terminated my account for complaining to Paypal.
              When a host offers a 12month deal, it's discounted, because it is paid as a lump sum. They also usually have a no-refund policy in place, to prevent people just deciding to get the cheaper deal for a couple of months.

              It is clearly spelt out in HostAtom's Terms of Service.. are you saying people should ask their host "Are your Terms of Service real, or did you write them to exercise your fingers?"?
              My Live vB5 Site - NZEating.com
              vBulletin Hosting | vBulletin Services - Need hosting for your vB? Need it installed? Something else? Let me take that hassle off your hands.

              Comment


              • #8
                Thanks for this info. About this point:

                What are the limitations on a mysql user, max_questions and max_connections

                How much is a good value for Max_questions? And would you mind taking a look here please to see if you can help me? I posted to know if the fault is with me or the host because they say "money back anytime guarantee" and I will hold them to it.

                https://www.vbulletin.com/forum/show...-VB-4-1-0-Beta

                Thank you.

                Comment


                • #9
                  I asked a possible future hosting service the following question and received the shown reply.

                  Q) What are the limitations on a mysql user, max_questions and max_connections

                  A) You will be limited to 25 concurrent MySQL connections

                  What is an acceptable number for this? I do not see that listed in this thread.

                  Comment


                  • #10
                    Originally posted by WalkingWaldo View Post
                    I asked a possible future hosting service the following question and received the shown reply.

                    Q) What are the limitations on a mysql user, max_questions and max_connections

                    A) You will be limited to 25 concurrent MySQL connections

                    What is an acceptable number for this? I do not see that listed in this thread.
                    It's a tricky question and it depends on each individual forum's traffic make up. I explained it a bit at http://www.vbulletin.com/forum/showt...=1#post1485769 as it pertains to dedicated servers, but same applies to shared hosting as well. vB session timeout default 900 seconds will make real accuracy of max_used_connections figures. Depending on session timeout, 25 concurrent MySQL connections could allow between 25-500 vB users online - the larger the session timeout value, the more inaccurate the figure will be and higher the reported vB users online.
                    :: Always Back Up Forum Database + Attachments BEFORE upgrading !
                    :: Nginx SPDY SSL - World Flags Demo [video results]
                    :: vBulletin hacked forums: Clean Up Guide for VPS/Dedicated hosting users [ vbulletin.com blog summary ]

                    Comment


                    • #11
                      Hi,I am complete beginner with vbulettin. One question. Is it possible to host a vbulletin forum on shared hosting or do I need something stronger like VPS.

                      Thanks.

                      Comment


                      • #12
                        Vhosting on most hosts are fine, as long as your not installing a lot of addons & your user base logged in stays around 250 or lower, you shouldnt have to much of a issue starting out.
                        Gentoo Geek

                        Comment


                        • #13
                          Originally posted by Zadar View Post
                          Hi,I am complete beginner with vbulettin. One question. Is it possible to host a vbulletin forum on shared hosting or do I need something stronger like VPS.

                          Thanks.
                          Hi Zadar,

                          A shared hosting is fine
                          vBulletin Services I offer: www.Todo10.com
                          Technical vB/Server/Hosting support Service also!

                          Comment


                          • #14
                            I did a bit of research on which questions to ask your host.
                            I found one reasonable article on this topic

                            It goes a lot into detail about bandwidth and disk space and not forum hosting stuff, but I couldn't find any
                            forum hosting tutorial etc.
                            http://www.pariscoolblog.com/web-hos...-the-best-one/

                            One thing that I am worried about is, are forums more likely to run
                            into bandwidth and disk space problems than usual sites? Just because of the amount of generated content.

                            A lot of shared hosts offer unlimited bandwidth ( and this is probably bul...), how much bandwidth can you actually
                            use on shared hosting before they suspend you or ask for more money?
                            The other thing I did not find answer is does it make difference if you are based in Europe and your host server is in US?



                            Comment


                            • #15
                              A big deciding factor when hosting vBulletin is you need lots of CPU and MEM; unfortunately, a lot of providers use default CloudLinux limits which are set very low, e.g., 1GB MEM and 25% of 1 CPU core.
                              HostXNow offer 2 CPUs and 2 GB MEM per cPanel account, i.e., if you have a Reseller account, then you can use that amount for each cPanel account hosted under the Reseller account.

                              All vBulletin versions (including vBulletin 5) run fine at HostXNow.com for anyone who is interested.

                              You can see how fast vBulletin 5 loads on HostXNow.com at https://forums.hosting
                              Web Hosting - Professional Hosting Solutions
                              Web Hosting Forum - Web Hosting Community

                              Comment

                              Working...
                              X