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

  • webgeek247
    replied
    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

    Leave a comment:


  • Zadar
    replied
    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?



    Leave a comment:


  • cloferba
    replied
    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

    Leave a comment:


  • snakes1100
    replied
    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.

    Leave a comment:


  • Zadar
    replied
    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.

    Leave a comment:


  • George L
    replied
    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.

    Leave a comment:


  • WalkingWaldo
    replied
    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.

    Leave a comment:


  • haythamghareeb
    replied
    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.

    Leave a comment:


  • Ace
    replied
    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?"?

    Leave a comment:


  • Allthumbz
    replied
    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

    Leave a comment:


  • George L
    replied
    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
    ---------------------------

    Leave a comment:


  • Octavius
    replied
    Or.... just get www.urljet.com

    Leave a comment:


  • cbiweb
    replied
    Excellent, Lynne! I've been shopping around for a new host the past few days, and your post is an awesome aid. Nice job!

    Leave a comment:


  • riceboi1230
    replied
    Very good. Thanks Lynne!

    Leave a comment:


  • Lynne
    started a topic List of questions a user should ask a new host

    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.
widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
Working...
X