Top Menu

Search results for "best mysql tune setting"

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

…t does not support ConfigServer (e.g. Amazon AWS and some VPS may not play well with CSF), you may use Fail2Ban. Tune Apache the Sane Way (Requires Basic Math Skills) If you wish to tune your Apache MPM settings, you should consider following this method: https://telvps.com/clients/knowledgebase/25/HOW-TO-Optimize-Apache-for-Low-Memory-Usage.html (the formula works well as a basic guide… but does not take into account PHP memory requiremen… 2, 0, 0, 0 and 2885.84

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[‘… 1, 0, 0, 0 and 831.95

Continue Reading 0

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

…ache, minification, browser cache and page cache capabilities to WordPress… and it works with Nginx. Works best with Alternative PHP Cache to provide opcode and database cache. Setting APC for all caches works easiest with Nginx… setting to file caching introduces URL rewrite errors… See W3TC Settings information below for instructions on how to implement File caching. nginx Compatibility — makes WordPress more compatible… 3, 0, 0, 0 and 415.99

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
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.98

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
APC INFO Monitor

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

…ragmentation. During Testing or Debugging with CMS caching plugins or modules While you are tweaking your opcode settings, and especially if you are using APC with a CMS like WordPress (w3 total cache) or phpbb or joomla, and you are experimenting with settings, or updating plugins or core, you should set apc.stat=1 (on). Restart the web server to load the new settings. APC.Stat is the file change polling, which checks for file change every time… 2, 0, 0, 0 and 103.99

Continue Reading 53

Fail2Ban Regex for RedHat, Fedora, CentOS and Amazon Linux 2013

Fail2Ban is a very efficient daemon that scans log files for malicious activity, and offers several options to ban offending IPs and hostnames. Although it is highly configurable, it requires a depth of knowledge beyond that required for GUI-accessible firewalls such as ConfigServer Security & Firewall. Harden the Kernel Before do anything further, it is necessary to harden the server at the kernel level. Doing so will prevent the majority o… 1, 0, 0, 0 and 52

Continue Reading 1

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… 1, 0, 0, 0 and 52

Continue Reading 6