Top Menu

Search results for "opencart mysql query page"

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

…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 hours. Example MySQL Tuning Primer results: SLOW QUERIES The slow query log is NOT en… 20, 0, 0, 0 and 3262.87

Continue Reading 7

Remote publishing to WordPress from Facebook via RSS

…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 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 time to post… 20, 0, 2, 0 and 1117.92

Continue Reading 6
SoccerNews.com website

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

…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 table and query cache based on performance and load testing. Configured Amazon CloudFront Co… 3, 0, 1, 0 and 753.95

Continue Reading 4

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 727.95

Continue Reading 0

Joomla Content Management

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 […]

Continue Reading 0
APC INFO Monitor

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

…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 on virtual servers for opcode caching: Remove apc.ini from /etc/php.d. Do not add the APC configura… 2, 0, 1, 0 and 389.97

Continue Reading 53

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

Search Engine Optimization

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 […]

Continue Reading 1

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

…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 well: comments, image uploads, etc. are no problem. I am interested to see if there is improvement with other scripts, especially p… 3, 0, 0, 0 and 155.99

Continue Reading 18