Web Performance, Branding, and Social Media
In: GrabPERF
13 Mar 2009Over the last seven days, GrabPERF has been running in a very unstable state. This appears to be directly related to the use of InnoDB as the DB engine on a few of the larger tables in the database. [InnoDB changeover discussed here]
Today, the system was offline for several hours before I noticed that the [...]
In: GrabPERF| Technology| The Web| Web Performance| WebPerformance.Org
3 Mar 2009On the weekend, I upgraded the database engine for GrabPERF to Mysql 5.1 and switched the main data table from MyISAM to InnoDB.
The switch to InnoDB was done because of the locking issues that were occurring during long queries, especially when doing ad-hoc analysis. The row-level (versus table-level) locking of InnoDB has removed most of [...]
One of the performance hits that the GrabPERF system has is the dynamic generation of the main page. The nature of the SQL calls and the underlying PHP makes it scale exponentially past a certain number of measurements.
Last night, Kevin Burton made a grand suggestion: generate a static page on a regular schedule.
Duh!
Today, I wrote [...]
In: GrabPERF| Web Performance
2 Aug 2006I was trying yesterday to debug an issue that was appeared to be affecting the PubSub Agent — yes, I re-started it at the request of their sysadmin.
The issue was that it was showing data that appeared to have no relationship with the data appearing from all of the other measurement locations. I tried blocking [...]
In: GrabPERF| Web Performance
21 Jul 2006After a few month hiatus, I am starting to code for GrabPERF again. I need to exercise my brain; as I am a hobbyist code mangler, I have to take on a project every now and then to keep my not-so-l33t skillz honed.
The change to the agent is one of efficiency. The current production agent [...]
In: GrabPERF
20 Apr 2006I updated the GrabPERF database to the latest version of MySQL. Please let me know it you notice any unusual behaviour…
…from GrabPERF.
Technorati Tags: GrabPERF, MySQL, upgrade
In: GrabPERF| Software| Technology
11 Nov 2005MySQL 5.0 has a Blackhole Storage Engine. [here]
Cool. And if you make me grumpy, all of your performance data will be stored there!
Via: Jeremy Zawodny
In: GrabPERF
26 Oct 2005For reasons that I have yet to discover, my outbound connection to the Internet appears to have been down between the times listed in the title.
As I have said before, my connection is less than “professional grade”, i.e. “don’t do this at home”.
If I find a cause, I will update.
I apologize for the incovenience.
UPDATE: Ouch.
Found [...]
In: Blogging
25 Oct 2005Wait! Didn’t he say he had done this already?
Yup. But forgot one stupid little step. You have to re-compile PHP to work with the new MySQL 5.0 libraries. I tried to restart Apache and it barfed all over the PHP module with MySQL library module mismatch errors…or something like that.
Done and the system is now [...]