mysql

FREE THOUGHT · FREE SOFTWARE · FREE WORLD

Posts Tagged ‘mysql’


30x Faster WP-Super Cache Site Speed

Thursday, March 18th, 2010

NOT a typo.. 30x is measurable, well-documented, and easily tested. This is what open-source is about. I haven’t had time to post much the past year, I’m always working! So I wanted to make up for that by publishing an article on a topic that would blow your mind and be something that you could actually start using and really get some benefit out of it. This is one of those articles that the majority of web hosting companies would love to see in paperback, so they could burn it.



Vetted – Top 3 WordPress Speed Plugins

Sunday, November 29th, 2009

There are so many WordPress plugins out there now that I wanted to post my favorite 3 plugins for speeding up a WP-Powered blog. These are the 3 plugins that I install for pretty much all of my WP-Powered sites, which I run about 300 now. They work together to provide a very optimized blog for speed.

DB-Cache Reloaded does something entirely different, it saves the mysql queries that are made to the WP-database, as well as the mysql results to static files, and then through php serves those cached-files instead of re-querying the mysql database. Most mysql databases are stored on separate servers, and although many are on the same local network there is a limit to how many queries, and how many connections can take place.

So DB-Cache Reloaded basically makes WP-Super Cache work alot faster when generating the cache files, and DB-Cache Reloaded helps in a number of areas un-related to WP-Super Cache, like in the admin panel. And DB-Cache without WP-Super-Cache is a joke because it still uses the application-level and php for everything. Gotta use both (or just WPSC).


Optimizing Servers and Processes for Speed with ionice, nice, ulimit

Saturday, October 10th, 2009

To prepare for several upcoming articles on AskApache that are focused on optimizing Servers and Sites from a server admin level, here is an article to introduce the main tools that we will be using. These tools are used to optimize CPU time for each process using nice and renice, and other tools like ionice are used to optimize the Disk IO, or Disk speed / Disk traffic for each process. Then you can make sure your mysqld and httpd processes are always fast and prioritized.



Encrypted WordPress / phpBB Backups

Monday, August 4th, 2008

Enter your DOMAIN_ROOT and the location of your wp-config.php or config.php, and this script finds all the mysql settings by parsing the phpbb or wordpress config file, then creates GPG encrypted backups, and saves your settings for future automation.


Faster Form Submission and Processing with fsockopen

Tuesday, March 4th, 2008

Speedy Forms using background-requestsPart II: Example illustrating how to speed up GET/POST form submissions. Uses fsockopen to initiate a server-side background request to process the submitted data, so that the result page of the form is displayed to the client lightningly quick.


Update: AskApache Password Protect Plugin

Thursday, February 7th, 2008

The Plugin Control PageWordPress plugin gives you control over HTTP Basic Authentication for your WordPress blog which among other things, stops most automated hacking attempts and exploits being attempted, cutting down on the number of requests, connections, and mysql queries for all WordPress blogs on the Internet.


Preload flash .flv files into browser cache

Monday, February 4th, 2008

How I was able to preload many flash flv and swf files on one of my clients sites that has a lot of online video and relatively small traffic. Their site visitors would usually watch 3-10 videos per visit and so to make the videos load almost instantly on every page I came up with a way to preload the top 10 .flv files and the swf flv player files as soon as the visitor successfully started watching the 1st video. Of course I also setup .htaccess caching on the server so that once they downloaded the files into their cache they would never request them from the server again. I was having fun with this so its pretty funky and uses some really cool combinations of javascript, swf preloader from xml, css classes to help automate it all..


Hacking WP Super Cache for Speed

Wednesday, January 30th, 2008

AskApache Crazy Cache - coming soonA plugin built to generate static files from php+mysql for Apache to serve the way its supposed to be.. My dream. Conclusion: Needs some improvement, pretty sweet though.


Tips on Writing WordPress Plugins

Monday, November 26th, 2007

WordPress Plugin Template: AskApache PluginsThought I’d give you all the tips and tricks that I’ve learned and use when developing WordPress plugins.. which can be quite fun!


The Latest and Greatest php.ini

Sunday, November 25th, 2007

Grab the latest php.ini developmental version and discover new or previously hidden php runtime configuration settings… ahead of everyone else!


Apache Directives and Modules on DreamHost

Friday, November 23rd, 2007

Apache .htaccess Directives and Loaded Modules allowed on DreamHost Apache Server 2 Setups.


What I think about DreamHost Web Hosting

Sunday, November 11th, 2007

NOTE: This is a very old post, I do NOT recommend DreamHost for anyone other than spammers. They are not a long-term solution.


WordPress RewriteRules Viewer

Tuesday, September 18th, 2007

AskApache RewriteRules Viewer Plugin PanelOften I am programming a plugin, or modifying my .htaccess rules, or editing a WordPress template file and I get stuck when it comes to how WordPress rewrites url’s internally. This simple plugin displays all the internal WordPress rewrites.


On-Demand MySQL Backup Shell Script

Thursday, May 31st, 2007

On-Demand WordPress MySQL database Backup Shell Script for DreamHost


Custom PHP.ini tips and tricks

Monday, February 5th, 2007

Describes in exhaustive detail how to change configuration settings and implement a custom php.ini file for use with the Apache Web Server. View latest official php.ini Sections: When php run as Apache Module (mod_php) When php run as CGI When cgi?d php is run with wrapper (for FastCGI) .htaccess code from Ultimate htaccess file RUN PHP AS APACHE MODULE AddHandler application/x-httpd-php .php .htm RUN PHP AS CGI AddHandler php-cgi .php .htm CGI PHP WRAPPER FOR CUSTOM PHP.INI AddHandler phpini-cgi .php .htm Action phpini-cgi /cgi-bin/php5-custom-ini.cgi FAST-CGI SETUP WITH PHP-CGI WRAPPER FOR CUSTOM PHP.INI AddHandler fastcgi-script .fcgi AddHandler php-cgi .php .htm Action…


Apache Web Server Speed Configuration Hacks

Thursday, January 25th, 2007

Apache server performance can be improved by adding additional hardware resources such as RAM, faster CPU, etc.


Port Redirector

Monday, January 22nd, 2007

can you please suggest me any tiny and good port redirector
for linux and unix like oses ?
so that when I connect to the box to a given port it redirects my connection
to another box and port that I can chose ?
thanx a lot



It's very simple - you read the protocol and write the code. -Bill Joy

HTML | DCMI | GRDDL | XOXO | XDMP | XFN | DOM | XML | XHTML 1.1 Strict | CSS 2.1 | W3C

Except where otherwise noted, content on this site is licensed under a Creative Commons Attribution 3.0 License, just credit with a link.
This site is not supported or endorsed by The Apache Software Foundation (ASF). All software and documentation produced by The ASF is licensed. "Apache" is a trademark of The ASF. NCSA HTTPd.
UNIX ® is a registered Trademark of The Open Group. POSIX ® is a registered Trademark of The IEEE.

Site Map | Contact Webmaster | Glossary | License and Disclaimer | Terms of Service

↑ TOP
Main