CentOS 6.0 fix for VBoxGuestAdditions installation for VirtualBox
Virtualbox is a useful tool for testing various Linux and Windows operating systems in a virtualized environment. However, while testing my modified Centmin Nginx installation script on CentOS 6.0 64bit, I came across an issue with installing VBoxGuestAddition components – the VirtualBox Guest Additions’ kernel modules failed to get built. Prior to CentOS 6.0, you could fix this by ensuring kernel-headers and other prerequisites were installed first.
i.e. Original pre-CentOS 6.0 fix
yum -y install dkms kernel* gcc |
The error message:
sh ./VBoxLinuxAdditions-amd64.run Building the VirtualBox Guest Additions kernel modules[FAILED] Your system does not seem to be set up to build kernel modules. Look at /var/log/vboxadd-install.log to find out what went wrong. Once you have corrected it, you can run /etc/init.d/vboxadd setup to build them. Doing non-kernel setup of the Guest Additions[ OK ] Installing the Window System drivers Installing X.Org Server 1.7 modules[ OK ] Setting up the Window System to use the Guest Additions[ OK ] You may need to restart the hal service and the Window System (or just restart the guest system) to enable the Guest Additions. Installing graphics libraries and desktop services components[ OK ] |
If you check log /var/log/vboxadd-install.log you’ll see
*** Error: unable to find the sources of your current Linux kernel. Specify KERN_DIR=<directory> and run Make again.. Stop. |
The Fix
However, with CentOS 6.0 the above solution didn’t work as it seems the YUM mirrors aren’t all updated yet so you have specify the exact kernel-header version during install
yum -y install dkms gcc kernel-headers-`uname -r` kernel-devel-`uname -r` |
Once you do that, reinstall the VirtualBox Guest Additions
sh ./VBoxLinuxAdditions-amd64.run Building the VirtualBox Guest Additions kernel modules Building the main Guest Additions module[ OK ] Building the shared folder support module[ OK ] Building the OpenGL support module[ OK ] Doing non-kernel setup of the Guest Additions[ OK ] Starting the VirtualBox Guest Additions [ OK ] Installing the Window System drivers Installing X.Org Server 1.7 modules[ OK ] Setting up the Window System to use the Guest Additions[ OK ] You may need to restart the hal service and the Window System (or just restart the guest system) to enable the Guest Additions. Installing graphics libraries and desktop services components[ OK ] |
Centmin Nginx install on CentOS 6.0 64bit
Testing Centmin v1.2.1-eva2000.04 Nginx install script on CentOS 6.0 64bit works with MariaDB 5.2.7 MySQL server installed by default.
Here’s output from mysqlmymonlite.sh stats:
[root@centos6 ~]# ./mysqlmymonlite.sh run ---------------------------- System MySQL monitoring stats mysqlmymonlite.sh - v0.2.0 compiled by George Liu (eva2000) vbtechsupport.com ---------------------------- Report Generated: Wed Aug 10 04:59:42 EST 2011 ---------------------------- MySQL Uptime: ---------------------------- MySQL server was started 2011-08-10 04:59:35 Uptime: 6 sec Uptime 6 Uptime_since_flush_status 6 ---------------------------- Hardware Info: ---------------------------- Processors physical = 1, cores = 1, virtual = 2, hyperthreading = yes 2 3375.049 2 Intel(R) Xeon(R) CPU W3540 @ 2.93GHz 2 6144 KB ---------------------------- TOP stats ---------------------------- Linux 2.6.32-71.29.1.el6.x86_64 ((yourserverhostname)) 08/10/2011 _x86_64_ (2 CPU) 04:59:42 AM CPU %usr %nice %sys %iowait %irq %soft %steal %guest %idle 04:59:44 AM all 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 100.00 04:59:44 AM 0 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 100.00 04:59:44 AM 1 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 100.00 04:59:44 AM CPU %usr %nice %sys %iowait %irq %soft %steal %guest %idle 04:59:46 AM all 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 100.00 04:59:46 AM 0 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 100.00 04:59:46 AM 1 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 100.00 Average: CPU %usr %nice %sys %iowait %irq %soft %steal %guest %idle Average: all 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 100.00 Average: 0 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 100.00 Average: 1 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 100.00 top - 04:59:46 up 6 min, 1 user, load average: 0.02, 0.12, 0.08 Tasks: 150 total, 1 running, 149 sleeping, 0 stopped, 0 zombie Cpu(s): 0.9%us, 1.9%sy, 0.0%ni, 93.1%id, 3.5%wa, 0.3%hi, 0.3%si, 0.0%st Mem: 1537412k total, 565100k used, 972312k free, 96076k buffers Swap: 3080184k total, 0k used, 3080184k free, 142888k cached PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND 361 root 20 0 0 0 0 S 0.0 0.0 0:00.00 ext4-dio-unwrit 2078 root 20 0 376m 1724 1256 S 0.0 0.1 0:00.00 automount 2141 root 20 0 176m 816 520 S 0.0 0.1 0:00.03 VBoxService 2173 nginx 20 0 234m 3752 660 S 0.0 0.2 0:00.00 php-fpm 2174 nginx 20 0 234m 3752 660 S 0.0 0.2 0:00.00 php-fpm 2175 nginx 20 0 234m 3752 660 S 0.0 0.2 0:00.00 php-fpm 2227 root 20 0 63756 1320 708 S 0.0 0.1 0:00.00 sshd 2235 root 20 0 21972 972 748 S 0.0 0.1 0:00.00 xinetd 2243 ntp 20 0 30048 1564 1120 S 0.0 0.1 0:00.00 ntpd 2787 nobody 20 0 318m 876 540 S 0.0 0.1 0:00.00 memcached 2794 nobody 20 0 318m 876 540 S 0.0 0.1 0:00.00 memcached 2828 root 20 0 69804 2176 716 S 0.0 0.1 0:00.00 sendmail 2837 smmsp 20 0 59340 1888 660 S 0.0 0.1 0:00.00 sendmail 2847 root 20 0 254m 5488 3788 S 0.0 0.4 0:00.02 abrtd 2859 root 20 0 33980 1056 304 S 0.0 0.1 0:00.00 nginx 2860 nginx 20 0 50960 17m 640 S 0.0 1.2 0:00.01 nginx 3075 root 20 0 97436 3688 2852 S 0.0 0.2 0:00.32 sshd 3079 root 20 0 105m 1868 1496 S 0.0 0.1 0:00.04 bash 3805 root 20 0 11212 1452 1180 S 0.0 0.1 0:00.04 mysqld_safe 4079 mysql 20 0 809m 71m 5376 S 0.0 4.7 0:00.03 mysqld 4093 root 20 0 103m 1796 1212 S 0.0 0.1 0:00.01 mysqlmymonlite. 4228 root 20 0 14928 1156 832 R 0.0 0.1 0:00.00 top total used free shared buffers cached Mem: 1501 551 949 0 93 139 Low: 1501 551 949 High: 0 0 0 -/+ buffers/cache: 318 1182 Swap: 3007 0 3007 MemTotal: 1537412 kB MemFree: 972428 kB Buffers: 96076 kB Cached: 142888 kB SwapCached: 0 kB Active: 252240 kB Inactive: 141224 kB Active(anon): 154704 kB Inactive(anon): 1024 kB Active(file): 97536 kB Inactive(file): 140200 kB Unevictable: 0 kB Mlocked: 0 kB SwapTotal: 3080184 kB SwapFree: 3080184 kB Dirty: 68 kB Writeback: 0 kB AnonPages: 154544 kB Mapped: 37808 kB Shmem: 1232 kB Slab: 137868 kB SReclaimable: 56384 kB SUnreclaim: 81484 kB KernelStack: 2048 kB PageTables: 12888 kB NFS_Unstable: 0 kB Bounce: 0 kB WritebackTmp: 0 kB CommitLimit: 3848888 kB Committed_AS: 804868 kB VmallocTotal: 34359738367 kB VmallocUsed: 36780 kB VmallocChunk: 34359680540 kB HardwareCorrupted: 0 kB AnonHugePages: 75776 kB HugePages_Total: 0 HugePages_Free: 0 HugePages_Rsvd: 0 HugePages_Surp: 0 Hugepagesize: 2048 kB DirectMap4k: 12224 kB DirectMap2M: 1560576 kB ---------------------------- Server Disk Usage ---------------------------- Filesystem Size Used Avail Use% Mounted on /dev/mapper/vg_centos6-lv_root 27G 3.9G 22G 16% / tmpfs 751M 88K 751M 1% /dev/shm /dev/sda1 485M 69M 391M 15% /boot tmpfs 751M 12K 751M 1% /tmp ---------------------------- MySQL datadir disk usage ---------------------------- /var/lib/mysql/ uses 1052 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) 11896 max locked memory (kbytes, -l) 64 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) 11896 virtual memory (kbytes, -v) unlimited file locks (-x) unlimited ---------------------------- WEB SERVER & PHP Info: ---------------------------- PHP 5.3.6 (cli) (built: Aug 10 2011 04:41:04) Copyright (c) 1997-2011 The PHP Group Zend Engine v2.3.0, Copyright (c) 1998-2011 Zend Technologies System => Linux yourserverhostname 2.6.32-71.29.1.el6.x86_64 #1 SMP Mon Jun 27 19:49:27 BST 2011 x86_64 Build Date => Aug 10 2011 04:39:50 Configure Command => '../configure' '--enable-cgi' '--enable-fpm' '--with-mcrypt' '--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.7-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.19.7 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.44 WBMP Support | enabled libXML support | active libXML Compiled Version | 2.7.6 libXML Loaded Version | 20706 libXML streams | enabled PCRE (Perl Compatible Regular Expressions) Support | enabled PCRE Library Version | 8.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 are running Nginx --------------- nginx: nginx version: nginx/1.0.5 nginx: built by gcc 4.4.4 20100726 (Red Hat 4.4.4-13) (GCC) 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 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 ---------------------------- ------------------------------ mysql Index Size = 0.09 MB ------------------------------ ------------------------------ test Index Size = NULL ------------------------------ ---------------------------- Table Data Size ---------------------------- ------------------------------ mysql Data Size = 0.52 MB ------------------------------ ------------------------------ test Data Size = NULL ------------------------------ ---------------------------- Database 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 | 2 Rows | MyISAM | 0.00MB | 0.00MB | 0.01MB | | mysql.event | 0 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 | 38 Rows | MyISAM | 0.02MB | 0.00MB | 0.02MB | | mysql.help_keyword | 452 Rows | MyISAM | 0.08MB | 0.02MB | 0.10MB | | mysql.help_relation | 992 Rows | MyISAM | 0.01MB | 0.02MB | 0.03MB | | mysql.help_topic | 506 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 | 6 Rows | MyISAM | 0.00MB | 0.00MB | 0.00MB | +---------------------------------+----------------+----------------+-----------+------------+--------+ ---------------------------- Total Server MyISAM and InnoDB Size ---------------------------- *************************** 1. row *************************** innodb_tablespace_utilization_perc: NULL total_size_gb: 0.000713882967829704 index_size_gb: 0.000146865844726562 data_size_gb: 0.000567017123103142 innodb_total_size_gb: 0 innodb_data_size_gb: 0 innodb_index_size_gb: 0 myisam_total_size_gb: 0.000591812655329704 myisam_data_size_gb: 0.000505981966853142 myisam_index_size_gb: 8.58306884765625e-05 perc_index: 20.5728 perc_data: 79.4272 innodb_perc_index: NULL innodb_perc_data: NULL myisam_perc_index: 14.5030 myisam_perc_data: 85.4970 innodb_perc_total_index: 0.0000 innodb_perc_total_data: 0.0000 myisam_perc_total_index: 58.4416 myisam_perc_total_data: 89.2357 ---------------------------- mysqlreport output ---------------------------- mysqlreport [found] MySQL 5.2.7-MariaDB-mar uptime 0 0:0:11 Wed Aug 10 04:59:46 2011 __ Key _________________________________________________________________ Buffer used 0 of 32.00M %Used: 0.00 Current 5.84M %Usage: 18.24 Write hit 0.00% Read hit 0.00% __ Questions ___________________________________________________________ Total 45 4.1/s COM_QUIT 17 1.5/s %Total: 37.78 DMS 16 1.5/s 35.56 Com_ 13 1.2/s 28.89 -Unknown 1 0.1/s 2.22 Slow 1 s 0 0/s 0.00 %DMS: 0.00 Log: OFF DMS 16 1.5/s 35.56 SELECT 16 1.5/s 35.56 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_ 13 1.2/s 28.89 show_variab 6 0.5/s 13.33 show_status 3 0.3/s 6.67 show_databa 2 0.2/s 4.44 __ SELECT and Sort _____________________________________________________ Scan 17 1.5/s %SELECT: 106.25 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.1/s Insrt:Prune 1:1 0/s Hit:Insert 0.00:1 __ Table Locks _________________________________________________________ Waited 0 0/s %Total: 0.00 Immediate 18 1.6/s __ Tables ______________________________________________________________ Open 23 of 2048 %Cache: 1.12 Opened 30 2.7/s __ Connections _________________________________________________________ Max used 1 of 350 %Max: 0.29 Total 19 1.7/s __ Created Temp ________________________________________________________ Disk table 8 0.7/s Table 70 6.4/s Size: 32.0M File 0 0/s __ Threads _____________________________________________________________ Running 1 of 1 Cached 0 of 256 %Hit: 94.74 Created 1 0.1/s Slow 0 0/s __ Aborted _____________________________________________________________ Clients 0 0/s Connects 0 0/s __ Bytes _______________________________________________________________ Sent 58.37k 5.3k/s Received 5.37k 488.5/s ---------------------------- MySQL settings ---------------------------- [mysqld] # optimized my.cnf for MariaDB 5.2.7 # by eva2000 # vbtechsupport.com skip-innodb 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 = 120 connect_timeout = 10 tmp_table_size = 32M max_heap_table_size = 32M max_allowed_packet = 32M max_seeks_for_key = 1000 group_concat_max_len = 1024 max_length_for_sort_data = 1024 net_buffer_length = 16384 max_connect_errors = 100000 concurrent_insert = 2 read_rnd_buffer_size = 256K bulk_insert_buffer_size = 8M query_cache_limit = 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 log_warnings=1 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 aria_group_commit = none aria_group_commit_interval = 0 aria_log_file_size = 64M aria_log_purge_type = immediate aria_pagecache_buffer_size = 16M aria_sort_buffer_size = 16M #mariadb innodb innodb_stats_update_need_lock = 0 innodb_extra_rsegments = 64 innodb_use_purge_thread = 4 innodb_log_block_size = 512 innodb_flush_neighbor_pages = 1 innodb_adaptive_checkpoint = estimate innodb_doublewrite = 0 # innodb settings innodb_read_ahead = none innodb_file_per_table = 1 innodb_open_files = 1000 innodb_data_file_path= ibdata1:2G: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 innodb_thread_concurrency = 0 innodb_lock_wait_timeout=50 innodb_flush_method = O_DIRECT innodb_support_xa=0 # 200 * # DISKS innodb_io_capacity = 100 innodb_read_io_threads = 2 innodb_write_io_threads = 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 | +-------------------------------------------+-------------------------------------------------------------------------------------------+ | aria_block_size | 8192 | | aria_checkpoint_interval | 30 | | aria_force_start_after_recovery_failures | 0 | | aria_group_commit | none | | aria_group_commit_interval | 0 | | aria_log_file_size | 67108864 | | aria_log_purge_type | immediate | | aria_max_sort_file_size | 9223372036853727232 | | aria_page_checksum | ON | | aria_pagecache_age_threshold | 300 | | aria_pagecache_buffer_size | 16777216 | | aria_pagecache_division_limit | 100 | | aria_recover | NORMAL | | aria_repair_threads | 1 | | aria_sort_buffer_size | 16777216 | | aria_stats_method | nulls_unequal | | aria_sync_log_dir | NEWFILE | | aria_used_for_temp_tables | ON | | auto_increment_increment | 1 | | auto_increment_offset | 1 | | autocommit | ON | | automatic_sp_privileges | ON | | back_log | 50 | | basedir | / | | big_tables | OFF | | binlog_cache_size | 32768 | | binlog_direct_non_transactional_updates | OFF | | binlog_format | STATEMENT | | bulk_insert_buffer_size | 8388608 | | character_set_client | latin1 | | character_set_connection | latin1 | | character_set_database | latin1 | | character_set_filesystem | binary | | character_set_results | latin1 | | character_set_server | latin1 | | character_set_system | utf8 | | character_sets_dir | /usr/share/mysql/charsets/ | | collation_connection | latin1_swedish_ci | | collation_database | latin1_swedish_ci | | collation_server | latin1_swedish_ci | | completion_type | 0 | | concurrent_insert | 2 | | connect_timeout | 10 | | datadir | /var/lib/mysql/ | | date_format | %Y-%m-%d | | datetime_format | %Y-%m-%d %H:%i:%s | | deadlock_search_depth_long | 15 | | deadlock_search_depth_short | 4 | | deadlock_timeout_long | 50000000 | | deadlock_timeout_short | 10000 | | default_week_format | 0 | | delay_key_write | ON | | delayed_insert_limit | 100 | | delayed_insert_timeout | 300 | | delayed_queue_size | 1000 | | div_precision_increment | 4 | | engine_condition_pushdown | ON | | error_count | 0 | | event_scheduler | OFF | | expire_logs_days | 0 | | extra_max_connections | 1 | | extra_port | 0 | | flush | OFF | | flush_time | 0 | | foreign_key_checks | ON | | ft_boolean_syntax | + -><()~*:""&| | | ft_max_word_len | 84 | | ft_min_word_len | 4 | | ft_query_expansion_limit | 20 | | ft_stopword_file | (built-in) | | general_log | OFF | | general_log_file | /var/lib/mysql/centos6.log | | group_concat_max_len | 1024 | | have_community_features | YES | | have_compress | YES | | have_crypt | YES | | have_csv | YES | | have_dynamic_loading | YES | | have_geometry | YES | | have_innodb | DISABLED | | have_ndbcluster | NO | | have_openssl | DISABLED | | have_partitioning | YES | | have_query_cache | YES | | have_rtree_keys | YES | | have_ssl | DISABLED | | have_symlink | YES | | hostname | yourserverhostname | | identity | 0 | | ignore_builtin_innodb | OFF | | init_connect | | | init_file | | | init_slave | | | insert_id | 0 | | interactive_timeout | 28800 | | join_buffer_size | 262144 | | keep_files_on_create | OFF | | key_buffer_size | 33554432 | | key_cache_age_threshold | 300 | | key_cache_block_size | 1024 | | key_cache_division_limit | 100 | | key_cache_segments | 2 | | language | /usr/share/mysql/english/ | | large_files_support | ON | | large_page_size | 0 | | large_pages | OFF | | last_insert_id | 0 | | lc_time_names | en_US | | license | GPL | | local_infile | ON | | locked_in_memory | OFF | | log | OFF | | log_basename | | | log_bin | OFF | | log_bin_trust_function_creators | OFF | | log_bin_trust_routine_creators | OFF | | log_error | /var/log/mysqld.log | | log_output | FILE | | log_queries_not_using_indexes | OFF | | log_slave_updates | OFF | | log_slow_filter | | | log_slow_queries | OFF | | log_slow_rate_limit | 1 | | log_slow_time | 1.000000 | | log_slow_verbosity | | | log_warnings | 1 | | long_query_time | 1.000000 | | low_priority_updates | OFF | | lower_case_file_system | OFF | | lower_case_table_names | 0 | | maria_block_size | 8192 | | maria_checkpoint_interval | 30 | | maria_force_start_after_recovery_failures | 0 | | maria_group_commit | none | | maria_group_commit_interval | 0 | | maria_log_file_size | 67108864 | | maria_log_purge_type | immediate | | maria_max_sort_file_size | 9223372036853727232 | | maria_page_checksum | ON | | maria_pagecache_age_threshold | 300 | | maria_pagecache_buffer_size | 16777216 | | maria_pagecache_division_limit | 100 | | maria_recover | NORMAL | | maria_repair_threads | 1 | | maria_sort_buffer_size | 16777216 | | maria_stats_method | nulls_unequal | | maria_sync_log_dir | NEWFILE | | maria_used_for_temp_tables | ON | | max_allowed_packet | 33554432 | | max_binlog_cache_size | 18446744073709547520 | | max_binlog_size | 1073741824 | | max_connect_errors | 100000 | | max_connections | 350 | | max_delayed_threads | 20 | | max_error_count | 64 | | max_heap_table_size | 33554432 | | max_insert_delayed_threads | 20 | | max_join_size | 18446744073709551615 | | max_length_for_sort_data | 1024 | | max_long_data_size | 33554432 | | max_prepared_stmt_count | 16382 | | max_relay_log_size | 0 | | max_seeks_for_key | 1000 | | max_sort_length | 1024 | | max_sp_recursion_depth | 0 | | max_tmp_tables | 32 | | max_user_connections | 0 | | max_write_lock_count | 18446744073709551615 | | min_examined_row_limit | 0 | | multi_range_count | 256 | | myisam_block_size | 1024 | | myisam_data_pointer_size | 6 | | myisam_max_sort_file_size | 2147483648 | | myisam_mmap_size | 18446744073709551615 | | myisam_recover_options | DEFAULT | | myisam_repair_threads | 1 | | myisam_sort_buffer_size | 67108864 | | myisam_stats_method | nulls_unequal | | myisam_use_mmap | OFF | | net_buffer_length | 16384 | | net_read_timeout | 30 | | net_retry_count | 10 | | net_write_timeout | 60 | | new | OFF | | old | OFF | | old_alter_table | OFF | | old_passwords | OFF | | open_files_limit | 16384 | | optimizer_prune_level | 1 | | optimizer_search_depth | 62 | | optimizer_switch | index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on | | pbxt_auto_increment_mode | 0 | | pbxt_checkpoint_frequency | 28MB | | pbxt_data_file_grow_size | 2MB | | pbxt_data_log_threshold | 64MB | | pbxt_flush_log_at_trx_commit | 1 | | pbxt_garbage_threshold | 50 | | pbxt_index_cache_size | 32MB | | pbxt_log_buffer_size | 256K | | pbxt_log_cache_size | 16MB | | pbxt_log_file_count | 3 | | pbxt_log_file_threshold | 32MB | | pbxt_max_threads | 357 | | pbxt_offline_log_function | 0 | | pbxt_record_cache_size | 32MB | | pbxt_row_file_grow_size | 256K | | pbxt_support_xa | ON | | pbxt_sweeper_priority | 0 | | pbxt_transaction_buffer_size | 1MB | | pid_file | /var/lib/mysql/yourserverhostname.pid | | plugin_dir | /usr/lib64/mysql/plugin | | plugin_maturity | unknown | | port | 3306 | | preload_buffer_size | 32768 | | profiling | OFF | | profiling_history_size | 15 | | protocol_version | 10 | | pseudo_thread_id | 0 | | query_alloc_block_size | 65536 | | query_cache_limit | 1048576 | | query_cache_min_res_unit | 2048 | | query_cache_size | 33554432 | | query_cache_type | ON | | query_cache_wlock_invalidate | OFF | | query_prealloc_size | 262144 | | rand_seed1 | | | rand_seed2 | | | range_alloc_block_size | 4096 | | read_buffer_size | 262144 | | read_only | OFF | | read_rnd_buffer_size | 262144 | | relay_log | | | relay_log_index | | | relay_log_info_file | relay-log.info | | relay_log_purge | ON | | relay_log_space_limit | 0 | | report_host | | | report_password | | | report_port | 3306 | | report_user | | | rpl_recovery_rank | 0 | | secure_auth | OFF | | secure_file_priv | | | server_id | 0 | | skip_external_locking | ON | | skip_name_resolve | OFF | | skip_networking | OFF | | skip_show_database | OFF | | slave_compressed_protocol | OFF | | slave_exec_mode | STRICT | | slave_load_tmpdir | /tmp | | slave_net_timeout | 3600 | | slave_skip_errors | OFF | | slave_transaction_retries | 10 | | slow_launch_time | 2 | | slow_query_log | OFF | | slow_query_log_file | /var/lib/mysql/slowq.log | | socket | /var/lib/mysql/mysql.sock | | sort_buffer_size | 262144 | | sql_auto_is_null | ON | | sql_big_selects | ON | | sql_big_tables | OFF | | sql_buffer_result | OFF | | sql_log_bin | ON | | sql_log_off | OFF | | sql_log_update | ON | | sql_low_priority_updates | OFF | | sql_max_join_size | 18446744073709551615 | | sql_mode | | | sql_notes | ON | | sql_quote_show_create | ON | | sql_safe_updates | OFF | | sql_select_limit | 18446744073709551615 | | sql_slave_skip_counter | | | sql_warnings | OFF | | ssl_ca | | | ssl_capath | | | ssl_cert | | | ssl_cipher | | | ssl_key | | | storage_engine | MyISAM | | sync_binlog | 0 | | sync_frm | ON | | system_time_zone | EST | | table_definition_cache | 8000 | | table_lock_wait_timeout | 50 | | table_open_cache | 2048 | | table_type | MyISAM | | thread_cache_size | 256 | | thread_handling | one-thread-per-connection | | thread_pool_size | 20 | | thread_stack | 294912 | | time_format | %H:%i:%s | | time_zone | SYSTEM | | timed_mutexes | OFF | | timestamp | 1312916386 | | tmp_table_size | 33554432 | | tmpdir | /tmp | | transaction_alloc_block_size | 8192 | | transaction_prealloc_size | 4096 | | tx_isolation | REPEATABLE-READ | | unique_checks | ON | | updatable_views_with_limit | YES | | userstat | OFF | | version | 5.2.7-MariaDB-mariadb101 | | version_comment | (MariaDB - http://mariadb.com/) | | version_compile_machine | x86_64 | | version_compile_os | unknown-linux-gnu | | wait_timeout | 120 | | warning_count | 0 | +-------------------------------------------+-------------------------------------------------------------------------------------------+ +------------------------------------+----------+ | Variable_name | Value | +------------------------------------+----------+ | Aborted_clients | 0 | | Aborted_connects | 0 | | Access_denied_errors | 0 | | Aria_pagecache_blocks_not_flushed | 0 | | Aria_pagecache_blocks_unused | 1967 | | 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 | 5560 | | Bytes_sent | 83238 | | Com_admin_commands | 0 | | Com_assign_to_keycache | 0 | | Com_alter_db | 0 | | Com_alter_db_upgrade | 0 | | Com_alter_event | 0 | | Com_alter_function | 0 | | Com_alter_procedure | 0 | | Com_alter_server | 0 | | Com_alter_table | 0 | | Com_alter_tablespace | 0 | | Com_analyze | 0 | | Com_backup_table | 0 | | Com_begin | 0 | | Com_binlog | 0 | | Com_call_procedure | 0 | | Com_change_db | 0 | | Com_change_master | 0 | | Com_check | 0 | | 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 | 0 | | Com_load | 0 | | Com_load_master_data | 0 | | Com_load_master_table | 0 | | Com_lock_tables | 0 | | Com_optimize | 0 | | Com_preload_keys | 0 | | Com_prepare_sql | 0 | | Com_purge | 0 | | Com_purge_before_date | 0 | | Com_release_savepoint | 0 | | Com_rename_table | 0 | | Com_rename_user | 0 | | Com_repair | 0 | | Com_replace | 0 | | Com_replace_select | 0 | | Com_reset | 0 | | Com_restore_table | 0 | | Com_revoke | 0 | | Com_revoke_all | 0 | | Com_rollback | 0 | | Com_rollback_to_savepoint | 0 | | Com_savepoint | 0 | | Com_select | 16 | | Com_set_option | 1 | | 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 | 2 | | Com_show_engine_logs | 0 | | Com_show_engine_mutex | 0 | | Com_show_engine_status | 0 | | 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 | 1 | | Com_show_profile | 0 | | Com_show_profiles | 0 | | Com_show_slave_hosts | 0 | | Com_show_slave_status | 0 | | Com_show_status | 4 | | 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 | 8 | | 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 | 20 | | Cpu_time | 0.000000 | | Created_tmp_disk_tables | 8 | | Created_tmp_files | 0 | | Created_tmp_tables | 73 | | Delayed_errors | 0 | | Delayed_insert_threads | 0 | | Delayed_writes | 0 | | Empty_queries | 0 | | 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 | 2913 | | Handler_rollback | 0 | | Handler_savepoint | 0 | | Handler_savepoint_rollback | 0 | | Handler_update | 0 | | Handler_write | 2879 | | Key_blocks_not_flushed | 0 | | Key_blocks_unused | 26792 | | Key_blocks_used | 0 | | Key_blocks_warm | 0 | | Key_read_requests | 0 | | Key_reads | 0 | | Key_write_requests | 0 | | Key_writes | 0 | | Last_query_cost | 0.000000 | | Maria_pagecache_blocks_not_flushed | 0 | | Maria_pagecache_blocks_unused | 1967 | | 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 | 1 | | Not_flushed_delayed_rows | 0 | | Open_files | 49 | | Open_streams | 0 | | Open_table_definitions | 23 | | Open_tables | 23 | | Opened_files | 125 | | Opened_table_definitions | 23 | | Opened_tables | 30 | | 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 | 16 | | Qcache_queries_in_cache | 0 | | Qcache_total_blocks | 1 | | Queries | 49 | | Questions | 49 | | Rows_read | 8 | | Rows_sent | 2771 | | Rpl_status | NULL | | Select_full_join | 0 | | Select_full_range_join | 0 | | Select_range | 0 | | Select_range_check | 0 | | Select_scan | 20 | | Slave_open_temp_tables | 0 | | Slave_retried_transactions | 0 | | Slave_running | OFF | | Slow_launch_threads | 0 | | Slow_queries | 0 | | 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 | 2 | | Table_locks_immediate | 18 | | Table_locks_waited | 0 | | Tc_log_max_pages_used | 0 | | Tc_log_page_size | 0 | | Tc_log_page_waits | 0 | | Threads_cached | 0 | | Threads_connected | 1 | | Threads_created | 1 | | Threads_running | 1 | | Uptime | 11 | | Uptime_since_flush_status | 11 | +------------------------------------+----------+ +----+----------+-----------+----+---------+------+-------+------------------+ | Id | User | Host | db | Command | Time | State | Info | +----+----------+-----------+----+---------+------+-------+------------------+ | 19 | rootuser | localhost | | Query | 0 | | show processlist | +----+----------+-----------+----+---------+------+-------+------------------+ ---------------------------- MySQL Error Log ---------------------------- tail -15 /var/log/mysqld.log Version: '5.2.7-MariaDB-mariadb101' socket: '/var/lib/mysql/mysql.sock' port: 3306 (MariaDB - http://mariadb.com/) 110810 4:59:33 [Note] /usr/sbin/mysqld: Normal shutdown 110810 4:59:33 [Note] Event Scheduler: Purging the queue. 0 events 110810 04:59:34 [Note] PrimeBase XT Engine shutdown... 110810 4:59:34 [Note] /usr/sbin/mysqld: Shutdown complete 110810 04:59:34 mysqld_safe mysqld from pid file /var/lib/mysql/yourserverhostname.pid ended 110810 04:59:35 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 110810 4:59:35 [Note] Plugin 'InnoDB' is disabled. 110810 04:59:35 [Note] PrimeBase XT (PBXT) Engine 1.0.11-7 Pre-GA loaded... 110810 04:59:35 [Note] Paul McCullagh, PrimeBase Technologies GmbH, http://www.primebase.org 110810 4:59:35 [Note] Event Scheduler: Loaded 0 events 110810 4:59:35 [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/) Report Complete: Wed Aug 10 04:59:46 EST 2011 ---------------------------- |
