Web Performance, Branding, and Social Media
In: Blogging
25 Oct 2005Ok, so I lied; sue me.
The main database is now running MySQL 5.0.15.
Please report any weirdness you see with any of my applications.
In: Blogging
25 Oct 2005Ok Everyone, if you start seeing some odd behaviour from my sites (GrabPERF, Newest Industry, Pierzchala.com), it’s because I am doing some testing to see if the scripts, processes, and applications I have built on top of MySQL 4.1 can stand the upgrade.
I will not be upgrading the primary database system until all of this [...]
In: smp
14 Oct 2005I am thinking about setting up MySQL replication for the GrabPERF database so that the massive number of inserts done does not interfere with the performance of the Web interface.
Does anyone out there have any advice/comments/concerns/experiences on doing this for an active database with large amounts of data in it?
In: smp
14 Sep 2005Greg Gershman from BlogDigger found a bug in the Index charts just now. Seems that the chart legend was out of whack with the lines on the chart.
Easy fix. Turns out I was submitting the test ids in a random order. The graph generation component was fine with this, but when I went to build [...]
In: smp
14 Sep 2005Over the last two days I have been trying to optimize the performance of the Index Charts/Graphs. I think I have found the fix, and you should see results for these charts in the sub 1-second range.
To explain how this works, I have to open up the GrabPERF data model and let you folks peer [...]
In: Architecture / Design| The Web| smp
14 Sep 2005Got a quick note from Ed Lin at MaxMind that their free, country-level GEOIP database is updated monthly. You can get the updated files here.
This is in response to some out-of-date info in an old article (here and here) I wrote.
Most of this article is now deprecated, and the GrabIP service is the only remaining [...]
In: GrabPERF
5 Aug 2005Well, due to the paranoid 1d10ts who run my work network, I can’t test the remote script from my work linux machine. I have one beta tester and need some others to ensure that it works.
Again, what you need on your linux machine:
cURL (compiled from source or with the devel packages)
MySQL client and devel packages
Time::CTime [...]
In: GrabPERF
4 Aug 2005I am looking to implement some new GrabPERF features in the next few days (I still have some vacation left!), and I need some volunteers to help me out.
WHAT YOU NEED
A linux machine with the MySQL and cURL development libraries installed
A static IP address (even a static external NAT IP is ok)
The ability to do [...]
In: smp
29 Jun 2005I have been seeing these bursts of traffic, mainly from spambot morons, that have suddenly been crushing my server. The main cause: excessive database connections.
This was quickly remedied today when I changed all of the mysql_connect statements to mysql_pconnect statements. This allows PHP to use an existing connection to the MySQL database to serve requests [...]
In: smp
17 May 2005I noticed that a new version (4.1.12) of MySQL was up on their site last night. I grabbed the RPMs (Yes, I am a binary-loving weenie, not a hardcore source jockey) and installed them.
For those of you who install MySQL from RPMs know that it takes 4 packages to get all of the components up [...]