Top Menu

Search results for "mysql memory usage formula"

LAMP-linux-apache-mysql-php

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

…by mysql. You should adjust config variables to take up no more than 60% of total RAM. Wait 24-48 hours and run mysqltuner again. Example mysqltuner results: ——- Performance Metrics ————————————————- [--] Up for: 13d 2h 34m 16s (1M q [1.561 qps], 67K conn, TX: 81B, RX: 449M) [--] Reads / Writes: 91% / 9% […]

Continue Reading 7
APC INFO Monitor

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

…sit” the configuration: 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″ […]

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

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

…e ForceSSL and auth_type. For a production server, SSL should be ON and auth_type http is better; http auth uses MySQL user/pass combinations to restrict access to user-specific databases. <?php /* Servers configuration */ $i = 0; /* Server: MySQL Server [1] */ $i++; $cfg['Servers'][$i]['verbose'] = ‘MySQL Server’; $cfg['Servers'][$i]['host'] = ’122.34.567.89′; $cfg['Servers'][$i]['port'] = ’3306′; $cfg['Servers'][$i]['socket'] […]

Continue Reading 0
SoccerNews.com website

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

…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 handle the needs […]

Continue Reading 4

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
virtualmin-nginx-wordpress-permalinks-apc

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

…php-fcgi-domain2-com restart The service may also be 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 […]

Continue Reading 18
APC INFO Monitor

APC Cache Considerations for Virtual Hosting Environments

APC cache does not work well in a virtual hosting environment unless PHP is running as FCGID, and every individual virtual host has a unique PHP.ini and a unique fcgiwrapper. This is not the case with many virtual hosting environments because the memory and CPU requirements are too great. I suggest using Virtualmin for a […]

Continue Reading 4

Résumé

Chris Gilligan Information Architect, Web Server Administrator, Media Producer web • video • print chris@chrisgilligan.net chrisgilligan.com 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 Linux Apache MySQL PHP web server administration Postfix Dovecot Sendmail […]

Continue Reading