…le_size/max_heap_table_size equal Reduce your SELECT DISTINCT queries without LIMIT clauses Variables to adjust: query_cache_size (> 16M) tmp_table_size (> 16M) max_heap_table_size (> 16M) I suggest you NOT enable the slow query log unless the Slow Queries result is very high. Slow Queries result % will be somewhat high if MySQL has run for less than 24 […]
Search results for "opencart mysql query page"
…ress 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 […]
…ache 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 […]
…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.
If you’ve read anything at all about Content Management Systems (CMS), you’ll probably know that CMS are the most effective way to keep your site relevant to your audience. You also know at least three other things: Keeping your site relevant and up-to-date can be time consuming CMS can be complicated Portals can be expensive […]
…for the other installation options, including the Experimental options. For W3 Total Cache (WordPress plugin): Page Cache: do not choose APC for the W3TC’s Page Cache, choose Enhanced Disk. Minify: do not choose APC for Minify, use Disk. Opcode Cache: choose APC for Opcode Cache Database Cache: choose APC for Opcode Cache For APC running […]
Chris Gilligan Web Developer, Information Architect, Web Server Administrator, Media Producer web • video • print email@example.com 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 Front-end UI design, HTML, PHP, LESS Linux Apache […]
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 […]
SEO Consulting $85 per hour. Includes research for page titles, text headings and content keywords to optimize a website for a targeted market. Joomla Sites $350 per site. Includes sh404sef component for automated mod_rewrite URL rewriting, title and keyword rewriting. Includes xMap sitemap generator and setup of optimized sitemaps. Automated Yahoo, MSN and Google Sitemap […]
…t on Virtualmin is working well, though I don’t see much improvement over Apache in terms of initial index page load, or time to first byte on the WordPress test site I created. Cached and subsequent pages load very quickly, so it looks like there is an overall improvement. All WordPress functions seem to work […]