" "
Impresive MySQL stats August 3rd, 2008
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.
If you use MySQL…. July 15th, 2008
If like me you use MySQL yet don’t pay for commercial support (There is nothing wrong with that!), there is another way to contribute. A MySQL developer finds himself in an bad situation and needs a little bit of help from us all. Normally I would not bother with such things, but then again, I do use MySQL a lot and I am dependant on it and this guy helped devlop it! But there is also a kid involved, if it were your kid, you’d do anything to save them. Anyhow, if you can give a donation as little or as large as you like, every little bit helps. Think about it, if every Wordpress blogger gave just $1 dollar, the medical fund would be rasied very quickly. Decision is yours, just my little nudge 
. Ta
So much for a global company. How Apple & Others treat Europeans July 15th, 2008
Reading Pat Phelan’s blog yesterday about Apple and how it restricts the rest of the world as to what it can purchase through iTunes got me thinking. I’ve long known that Apple deploy such practices as do many other organizations. I don’t think its right at all, yet have thought I would have been a crackpot for thinking same. If I buy an iPhone to have access to all the applications and Games, that means I want access to ALL the games and applications and not a limited subset. Alas they (Apple) cannot be fooled by the use of a mere proxy server, you need to supply a US address too, thus making it impossible for us Europeans to but such games as “Insert desired super cool game not currently available in Europe”.
Another thing Apple engage in which I am also not a fan of, is over charging or taxing their European customers. For example, I recently bought an iMAC 24″ With the 3.06 Proc. Its US cost is $2,199.00, yet its Euro Price is €1,919.00. If the exchange rate were taken into consideration it would be €1,377.43 Euro (15th July 08 – 08:00). This sort of thing is not confined just to Apple, recently I’ve experienced the same sort of practices with Adobe, so I am guessing there are others too.
You could argue that its not possible to keep track of exchange rates. I say balderdash. I know many smaller companies that deploy either daily adjustments or realtime adjustments in order to be as competitive as possible. Yes, Apple don’t need to be competitive to an extent, however they do need to start looking after their customers in Europe and not discriminate against them based simply on where you are coming from. Currently a European customer in not as equal as a US customer to Apple it would appear, from my recent use of iTunes anyhow.
I don’t subscribe to the content licence argument either. If it could be arranged with the music companies it can be arranged with the TV,Film and Software houses. Then Apple may be really disruptive, changing EU broadcasting too.
Calling for a boycott of such products from their vendors is at best a pipe dream. Yes I know they are discriminating against me, but I still want to use their products, or indeed in some circumstances I may need to use them. So how do we register our complaints, how are we heard? Is blogging about it going to be enough? I don’t know, is my answer, but hell I’ll give it a try and add to the growing choir.
So back to the thinking, here is one for someone with a bit of time on their hands. Setup up a buinssess selling proxy serivces Not only web based proxy services, but also real world proxy services, where people order stuff they can’t get in their location so the end up purchasing through you. Yes it would be a pain, to do, but then again I don’t care, I just want my cool iPhone game…. NOW!!!!!!
Just in case you have not guessed, yes I am busy July 13th, 2008
Well yes I have been away for a while. No good reason apart from being very busy. So whats been happening…
- Hooked up with Adam, Walter (Yes Walter I found your blog), James and are planning world dominaiton
- Near the end stages of yet another video app for the web 2.0 kids. Heavily dependant of EC2 & GoGrid and its shaping up nice. All written of course using the Zend FrameWork
- Bought some .me domains but not allowed to say anything more yet, sorry.
- Want to work with some cool tech I came across recently, hope it goes through as it is kick ass
- Druid Dns is go in about a month or so I hope. Further tech to sort out. MySQL cache issue, nothing serious but needs a bit of time to work around
- Bought an iMAC 24″. Yeah it just works. Needed something with a large screen and that was not gonna bug me with crap breaking all the time and did not want to use a Linux box as I am too busy to set it up at present. Just use it to code ZF stuff
- Adams wedding is coming up
- So too is my sisters
- Miss France terribly especially because of the crap weather we have had this summer
- Am using twitter on a dailiy basis
- Am anaylising twitter on a daily basis to come up with ways that don’t make it so sucky (Its still great, but I think their user base is getting tired of excuses)
- Went to Gorbys for the first time, with Walter, James and Damien… weird place
- Am running out of Cuban cigars
- Will have to travel to Spain soon
- Will have to travel to France soon
- WIll end in the UK sooner!!!
Thats it for the moment. Need to sort out this blog as well, its a disaster. Rght now its not viable. Got a question, call me is probaly best, otherwise, mail is fine.
Network Manager & Open VPN Servers On Port 443 Fix May 16th, 2008
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.
Read More »
Installing the Groupwise Client on Ubuntu Hardy Heron May 15th, 2008
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.
Running Confluence on port 80 or 443 using mod_proxy_ajp April 18th, 2008
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.
Read More »
Tibet Spam April 9th, 2008
Recently I published a brief post on Freeing Tibet and since then the amount of abusive comments and email I have gotten has raised considerably.
While I will approve comments both for and against the freeing of Tibet, I will only do so should they be what I deem legitimate. I.e. They do not appear to be copy paste jobs, refrain from abuse and are sensible comments.
Otherwise, please bugger off. I’m not intersted in being a fora for the promotion of your sites. In particular, posters from;
- 168.144.250.89
- 206.155.48.217
- 128.221.197.21
have been banned (not that it will make much difference) but sure I may as well do something at the FW level seening as I was working on it anyhow.
Ahern Quits April 2nd, 2008
Rather than face more scrutiny over payments he may have received, Bertie Ahern has quit as Irish Prime Minister. He will retire from office on May 6th after an address to both houses of congress.
Free Tibet, China and the Olymics and all that March 31st, 2008
Before I go on, I am not normally political, but recently I am just getting fed up with lots of things, maybe its my age catching up on me. I have just being watching John O’Shea on TV3 talk about Tibet and the Olympics. Now I don’t have much time for John O’Shea (for no reason only from I find charities annoying and pushy at times) but he did mention two interesting things.
- The smaller countries like Ireland (Who’s government is ohh so found of telling its citizens how “well respected” it is on the world stage) should take a stance at at least threaten to boycott the games (We won’t miss much anyhow, we rarely win anything)
- Don’t watch them
The second is a really nice passive way of resistance.
Now considering that this post will now be filtered out by the Great firewall of China, I hope that the rest of this post will go unoticed by the Chinese authorities and we’ll all catch them by surprise.
Proposal
I propose that any blogger who feels strongly enough, make a simple post on the 30th of April 2008 with the title of “Why I think Tibet Should Be Free”/”Please Free Tibet” or something with Free and Tibet in the title. If you think independence is not needed you can also post something similar. You can include as little or as much in the post body as you want to.
If you use Wordpress, you can even do it now, and select the publish date as the 30th April and forget all about it. I already have.
Sure its not as strong as storming the Chinese embassy, but its just another way we can all let the Chinese government (I doubt that they need reminding) that people in the world object to whats going on (BTW while I’m at it, China you should be ashamed of your conduct in relation toDarfur). As a side benifit, if enough blogs do this, it should send the Great Firewall into some serious filtering time.
Update: 00:04 01.04.08 – If you don’t feel like doing a blog post, on the 30th you can do simple things like set the status message of your IM client to read “Free Tibet” or similar. You can also do this with Facebook.
Company:
Rush Hour Analytics
Email:
Cell:
+353863805070
Location:
Limerick
Munster
Ireland
IM:
Comments