Aug 2008 10 th
Interesting Graph
Stats from Rush Hour
These stats were captured via the impending Rush Hour engine that myself and a few others have been developing. More info on where they come from later in the week, or eary next week. For the moment, lets just say big DB’s rock, even bigger machines rock harder and see if we can guess where they come from.
For every action there can be an equall reaction!
Add a commentAug 2008 3 rd
Impresive MySQL stats
So I’m doing something that relies on MySQL a lot. Last night I had to test a rebuild process that we would use if there was a failure in our systems. Worst case secnairo would be we would have lost about a weeks data and need to reinsert the whole lot.
So I wrote a quick and nasty PHP script with multiple nested foreach() loops, yeah I know what your thinking, but as I said, it was a quick and nasty script. Basically all this script done was parse a directory full off XML files and based upon the content, perform multiple SELECT, INSERT or UPDATE based on the data per element in the given XML file.
So, on my little iMac (24″, 4GB RAM, 1TB Drive) the following are the stats from the completition of the script.
Total Processing Time: 4975.59566307 seconds.
Total DB Inserts: 1,961,000
Total Selects: 12,035,743
Total Updates: 10,465,071
This all translates to;
Inserts Per Second: 394.12
Selects Per Second: 2,418.95
Updates Per Second: 2,103.28
Keep in mind, I was watching a movie at the same time and that there has been no optimisation carried out on the server at all (Although the DB is fairly well normalised). Table format was MyISAM.
Now imagine what MySQL could do on an optimised Linux server with custom optimisations to make it faster. I am quite impresed given the workstation I was working on and the complexity of the queries we are doing. Pat on head for MySQL. Well done.
1 CommentMay 2008 16 th
Network Manager & Open VPN Servers On Port 443 Fix
Now, after yesterdays post, I decided to play a bit more and set up an Open VPN connection to a remote site. Luckily the site was running the excellent IPCOP with an Open VPN service, however it was configured to run on port 443.
Searching high and low in the Network Manager applet on Ubuntu Heron, I could not find an option to connect on a specific port number. Bruised, I dumped my Open VPN config into /etc/openvpn and brought up the link manually.
May 2008 15 th
Installing the Groupwise Client on Ubuntu Hardy Heron
So we use GroupWise obviously. However for the most part, I spend my time on Ubuntu these days as I like XFCE4 and Ubuntu as a whole. This is not to say I don’t use my Novell Suse Enterprise Desktop, I do, quite a lot, but its also nice to have a bit of a play with other distros from time to time.
2 CommentsApr 2008 18 th
Running Confluence on port 80 or 443 using mod_proxy_ajp
Okay, I use Confluence a lot, and think despite some of its failings in the UI department (Although they are being addressed as version 2.8 shows) its a excellent Enterprise Wiki.
Now, not wanting to arse around with Tomcat all the time, I use the standalone build generally as its quite sufficient for my purposes. The problems arise when we have remote workers, whom are behind restrictive firewall policies. So that means I have to provide the service on 443. Now you could spend a bit of time configuring Tomcat to run on said port, but thats not recommended, plus you may want to use other technologies such a PHP etc. So here is a quick how to on getting confluence up and running on port 443 on Suse Enterprise Server 10 (Al tough the same applies to most Linux distros with the exception of the convoluted config Novell apply to Apache). This post presumes you already have installed Confluence standalone and its running fine.
Feb 2008 22 nd
Goodbye Drupal, Hello Wordpress
Well, finally after ages of messing around, I feel comfortable enough with my theme to switch over to Wordpress instead of Drupal. Note, its not complete, but it is getting there. I hope you don’t find too many things broken.
Before I get hit with a lot of mail asking why I ditched Drupal, let me say it was not for any other reason than time. Something which I have very little of these days as projects come in by the truck load.
Nov 2007 30 th
Testing Wordpress Super Cache Performance on SLES 10 SP1 using Siege
I was reading a post by Donncha recently on the new Wordpress plugin, WP Super Cache. He mentioned that he did not know what the performance would be like, which got me thinking about running my own tests to see for myself (I was doing some basic ones anyhow for another idea I had). There are many bloggers using Wordpress whom do not know one technical thing (nor should they!), but they should know what its gonna be like for them when their site gets busy.
N.B. My intention here was to just see what would happen. This should not be regarded as a complete proper test, but rather an indicative one. I had limited time and was not arsed doing this 100% correctly.
Recent Comments