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
-
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.
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:
-
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:
-
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:
-
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:
-
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:
-
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:
-
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:
-
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.
NelsonLeave a comment:
-
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:
-
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:
-
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:Regarding MySQL:- 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)
can the mysql user grant ALL permissions to databases you create?Regarding Email on the server:
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
What kind of email limitations are in place?
Do you offer expanded email services through SMTP?Last edited by Lynne; Mon 18 Apr '11, 6:39am.
Leave a comment: