Contact Menu

Search results for "opencart mysql query page"


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

…te, and provides more complete recommendations. If you are running MySQL 5 or later, the configuration statements can be in the following form (example from one of my servers): [mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock user=mysql symbolic-links=0 innodb_file_per_table = 1 thread_concurrency = 8 query_cache_size = 64M query_cache_limit = 4M thread_cache_size = 8 myisam_sort_buffer_size = 64M read_rnd_buffer_size = 8M… […]

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

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

…rDefault’] = 1; ?> Create the phpmyadmin database for advanced functionality Look in phpMyAdmin folder /usr/share/phpMyAdmin/examples for create_tables.sql ssh to server as root user mysql — or if it asks for password — mysql -u your-mysql-superuser -pyour-superuser-password mysql > source /usr/share/phpMyAdmin/examples/create_tables.sql Log in to PMA Now you can log into PMA with your mysql root […]

Continue Reading 0 website

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

…ations 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 Content Distribution Network, page […]

Continue Reading 4

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

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


Chris Gilligan Web Developer, Information Architect, Web Server Administrator, Media Producer web • video • print 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 […]

Continue Reading
APC INFO Monitor

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

…requires stat polling to monitor file status, post revisions, plugin upgrades, etc.) turn off apc.optimization (experimental and unstable, may cache user session info, fubaring items which should not be cached, such as admin pages and logged-in site pages) turn off apc.include_once_override (use carefully; only useful with PHP scripts that do not have cache hooks, such […]

Continue Reading 54

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

…er-write the local nginx.conf file. Conclusion Sorry, no benchmarks. See my example/test site here. Nginx support 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, […]

Continue Reading 18
Joe Natural's website

Farm to Table Restaurant Website

…lesheet to replace image-based text with CSS styled text, integrated WordPress navigation, and then added a few WordPress plugins. Constant Contact API for automated newsletter signup Simple Facebook Connect for Facebook Fan Page interconnectedness Google Analyticator and Google XML Sitemaps for search engine optimization and traffic reporting WordPress SEO for simple and effective search engine […]

Continue Reading 0