Contact Menu

Search results for "mysql memory usage formula"


Tuning Apache and MySQL for Best Performance in a Shared Virtual Hosting Environment

…te, and provides more complete recommendations. If you are running MySQL 5 or later, the configuration statements can be in the following form (example from one of my servers): [mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock user=mysql symbolic-links=0 innodb_file_per_table = 1 thread_concurrency = 8 query_cache_size = 64M query_cache_limit = 4M thread_cache_size = 8 myisam_sort_buffer_size = 64M read_rnd_buffer_size = 8M… […]

Continue Reading 9
APC INFO Monitor

How to Configure APC Cache on Virtual Servers with PHP running under FCGId

…nfiguration: use the APC monitor (apc.php) to see how many files are being cached, and how much memory (apc.shm_size) is needed to avoid fragmentation, which will cause the 500 errors. If fragmentation rises quickly to 100%, memory usage is full, and cache full count rises above 0, you will almost surely see “500” errors. If […]

Continue Reading 54
Screen Shot 2012-09-07 at 11.09.50 AM

Install phpMyAdmin with SSL on CentOS, Amazon Linux, RedHat (Apache or NginX)

…rDefault’] = 1; ?> Create the phpmyadmin database for advanced functionality Look in phpMyAdmin folder /usr/share/phpMyAdmin/examples for create_tables.sql ssh to server as root user mysql — or if it asks for password — mysql -u your-mysql-superuser -pyour-superuser-password mysql > source /usr/share/phpMyAdmin/examples/create_tables.sql Log in to PMA Now you can log into PMA with your mysql root […]

Continue Reading 0 website

Apache and MySql Performance Tuning for High Traffic WordPress Website on Cpanel

…from the Internet’s millions of malicious and compromised servers and personal computers. Reconfigured Apache web server, PHP and MySQL to better utilize the server’s horsepower. Cpanel’s efault Apache and MySQL configurations were limiting the number of concurrent user sessions the server could handle. Changed PHP to run as FastCGI (fcgid) and recompiled Apache to better […]

Continue Reading 4

WordPress with W3 Total Cache on Nginx with APC (Virtualmin)

…e restarted via Webmin > Services > Bootup and Shutdown Memory Considerations PHP FCGId will launch the number of sub-processes you specify in Virtualmin > Server Configuration > Website Options, so beware of the memory overhead if you specify a large number, because each will consume the amount of memory specified in apc.shm_size. You may […]

Continue Reading 18

Web Hosting

Decades of experience hosting websites, from small local sites with only a few html pages, to high-traffic sites with thousands of users and pages.  Website hosting, evolved Web hosting has changed dramatically in the last few years. The majority of accounts are now running PHP scripts and MySQL, whereas in the past most accounts were only […]

Continue Reading
APC INFO Monitor

APC Cache Considerations for Virtual Hosting Environments

…rtual host, and so to set an individual configuration for APC per virtual server. However with 200+ virtual hosts all running PHP script packages, as is the case with a commodity shared hosting server, this will use a lot of memory, and you will need somewhere in the neighborhood of 10-30GB apc.shm_size if you attempt […]

Continue Reading 4


Chris Gilligan Web Developer, Information Architect, Web Server Administrator, Media Producer web • video • print I design and produce information and communication media for university, corporate, small business, manufacturing and non-profit clients: web sites Information architecture and design for open source content management systems Front-end UI design, HTML, PHP, LESS Linux Apache […]

Continue Reading

Varnish VCL and Config for WordPress with W3 Total Cache

…nish) # Configuration file for varnish # # /etc/init.d/varnish expects the variable $DAEMON_OPTS to be set from this # shell script fragment. # # # Maximum number of open files (for ulimit -n) NFILES=131072 # # Locked shared memory (for ulimit -l) # Default log size is 82MB + header MEMLOCK=82000 # # Maximum size […]

Continue Reading 23