Top Menu

Search results for "mysql max_clients"

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

…ow_queries = ON open_files_limit = 3200 innodb_buffer_pool_size = 26M join_buffer_size = 4M tmp_table_size = 72M max_heap_table_size = 72M max_connections = 80 [mysqld_safe] log-error=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid This is for example only! table_cache should be set a little higher than the total number of tables (sum of MYISAM,INNODB,MEMORY etc.), as reported by mysqltuner. If you anticipate adding more virtual hosts, or… 2, 0, 0, 0 and 3645.32

Continue Reading 7

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'] = ”; $cfg[‘… 14, 0, 0, 0 and 726.46

Continue Reading 0

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

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

…nd type of PHP script packages running on the account. These accounts are all administered by myself, not by the clients. I do not think APC is the correct cache for most shared web hosting servers, given the number of virtual hosts. You will probably have better results if you remove APC and concentrate on Apache performance tuning and MySQL cache. If your clients are adamant in their requests to use APC cache, you may wish to move them to a dif… 3, 0, 1, 0 and 441.06

Continue Reading 2
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 of a high traffic WordPress site. Configured a large MySQL tabl… 3, 1, 0, 0 and 259.45

Continue Reading 2

Varnish VCL and Config for WordPress with W3 Total Cache

…ish # # /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 of corefile (for ulimit -c). Default in Fedora is 0 # DAEMON_COREFILE_LIMIT=”unlimited” # # Set this to 1 to make init script reload try to switch vcl without restart. #… 1, 0, 0, 0 and 207.56

Continue Reading 23
APC INFO Monitor

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

APC INFO Monitor My Virtualmin CentOS 5.6 Virtual Private Server runs several virtual domains with PHP under FCGId using APC for opcode caching: Joomla, PHPbb, WordPress, etc . APC is somewhat challenging to configure properly with fcgid-enabled virtual domains, but it is quite helpful to optimize system resources and prevent traffic surges on one site from affecting overall server performance. Joomla and PHPbb have code that is pre-optimized w… 1, 0, 0, 0 and 207.56

Continue Reading 53

Remote publishing to WordPress from Facebook via RSS

Most WordPress developers know you can use one of several plugins to publish from WordPress to a Facebook wall, app or fan page. Did you know you can also do the opposite? You can publish from Facebook to WordPress by using the FeedWordPress plugin and the RSS feed from your fan page. This can be handy for clients who want to keep their site updated with blog posts, or share links and information, but don’t necessarily want to spend the ti… 2, 0, 0, 0 and 103.78

Continue Reading 6