I have skipped 7 years of Wordpress Development (and was victorious over my laziness) and upgraded to the latest version. I must say that I have expected more troubles. As suggested I have done 9 incremental updates jumping over two major releases.
Category Archives: Tools & Technology
Symfony2 and XAMPP 1.7.4 Problems
This evening I’ve spent installing Symfony2 in the XAMPP 1.7.4 environment on Windows 7.
First, many thanks goes to Sebastian Widmann for his original post in German which already saved me a lot of time. Unfortunately the steps which were mentioned there are not sufficient (at least on my Win7 installation). My story follows… Continue reading
How to get an exact version of phpBB
For whatever reason the authors of phpBB are not showing the exact version. At least I can’t find it in two seconds even inside the administration panel.
If there is no easy way to do it, let’s do this simple trick:
SELECT * FROM `phpbb_config` WHERE `config_name` LIKE ‘%version%’
And here is how to do it in case you need an official support.
TortoiseSVN: libapr_tsvn.dll missing
Don’t touch the running system.
Yesterday I’ve decided to spend some time to upgrade my “old school” TortoiseSVN to the latest release. I thought it should be a five-minute-problem or so. Sure…
The result was a nice greeting from my ZoneAlarm who was missing one of the Tortoise dlls. Thanks to Google and the author of this post. It was 5 minutes to find the answer however the solution took another 15 minutes instead of the 5 initially planned.
First commit, then upgrade ;)
Apache Compression: Performance Magic
Recently I have revisited the performance issue on my largest project – Diorama.Ru. 4000 users with 60.000 page views hitting the server every day. I am proud to have such a “playground” for performance optimization.
We’ve started with the MySQL tuning several months ago, then I have introduced the application level caching using Smarty template engine and finally pushed the last button – Apache gzip compression via mod_deflate.
Kiwi Approach
On the first pages of ABAP Performance Tuning I’ve already learned something new. One of the most powerful methods of the performance tuning is the Kiwi Approach.
Kiwi = Kill It With Iron.
Red Giant
Oracle buys Sun Microsystems. It seems this company simply cann’t stop shopping… Peoplesoft, Siebel, InnoDB and now Java and MySQL.
If we call IBM a blue giant should we name Oracle a red one? Or may be a Red Devil?…
Not carrying about Java at all, I’m worried about the MySQL future a bit. I don’t want to see this great project dying. The market sees it different, however.
MySQL Parameters: Performance Optimization
The first part of this post was devoted to the tools for SQL optimization in MySQL. Here I would like to stop at several database parameters which are relevant for MySQL performance.
There are at least three areas to take a look at: Thread Cache, Table Cache and Query Cache.
Performance Killer in phpBB
Leave a reply
First benefits from performance optimization: I have discovered “the mother of all queries” in phpBB.
MySQL Query Optimization
From the first month of my employment at SAP I was really impressed how the guys in support become crazy on SQL optimization. Deeply impressed on variety of tools for doing this on Oracle and DB2 I decided to carry out the same analysis on my own projects. The first question I’ve asked myself: “Do we have any native MySQL tools for sql optimization?”.
Yes, we do.