TagsTagsSomehow an LGF post made it past the Brain Police and onto the front page of Digg.com, so we’re currently going up and down depending on the waves of traffic; we’re still mostly online because it’s after work hours now in the US. Some of you West Coast Lizards are ...
LGF, Technical Info, Blogosphere, Traffic, Makeover, Blog Engine, MySQL, Refactoring
Excellent progress was made on the LGF Blog Engine MySQL Makeover today. Here’s the current status of the project: * Registration system and Lizard Overlord Tool - DONE * Logging functions - DONE * Display modules - front page, entries with/without comments, monthly archives - DONE * Monthly archive index - DONE * Thread posting/editing ...
LGF, Technical Info, Blogosphere, Traffic, Makeover, Blog Engine, MySQL
In the ongoing LGF Blog Engine Makeover Project, huge progress was made today on the display side of the application. I’ve settled on the database table designs for entries and comments, converted most of the existing entries/comments to MySQL, and now the display engine is capable of building and sending ...
LGF, Technical Info, Database, MySQL, Abstraction Layer, PHP, Refactoring, Design Patterns, MVC, Blog Engine
After poring over system logs, I’ve discovered another big drain on our system resources. At the bottom right of each post on the front page are links to versions of the individual post with and without comments. Sometimes people link to the pages with comments, even though they’re only interested ...
LGF, Technical Info, Database, MySQL, Abstraction Layer, PHP, Refactoring, Comments, Referrers
To decrease the load on our main server, and help us to better handle peak traffic times on weekdays, we now have a five minute cache on the front page, and a 15 minute cache on individual entry pages that don’t show comments. Judging from emails I received, some of you ...
LGF, Technical Info, Database, MySQL, Abstraction Layer, PHP, Refactoring, Cache
It took about 9 hours to read through 24,745 flat files and import 3,625,599 comments into MySQL, but it’s done. I imported all of them up to about 7 days ago, so that when I’m ready to switch the Blog Engine to MySQL entirely (and it’s not very close yet) ...
LGF, Technical Info, Database, MySQL, Abstraction Layer, PHP, Refactoring, Registration
I’m testing a script right now that, if all goes well, will add every post and every comment at LGF into our MySQL database; nearly 25,000 posts and over 3.6 million comments. The comments section is so huge and takes so long to convert (several hours, probably) that it kept ...
LGF, Technical Info, Database, MySQL, Abstraction Layer, PHP, Refactoring, Registration
The LGF Makeover project, intended to help us stay online even if/when a huge-traffic site like Drudge Report links to us (or Digg, where the Diggbats continue to furiously bury every LGF post), is proceeding. Almost all of our logging functions are now being handled by the MySQL server; this ...
LGF, Technical Info, Database, MySQL, Abstraction Layer, PHP, Refactoring, Registration
The MySQL conversion of our registration database had one small glitch on launch, quickly tracked down—I had written a variable name as $lowername instead of $lowerName. On such things do mighty lizard empires reside. To really give this thing a Texas-style workout, I’m going to open registration to the seething masses, ...
LGF, Technical Info, Database, MySQL, Abstraction Layer, PHP, Refactoring, Registration
At about 3:20 pm Pacific time (give or take a few minutes) I’ll be briefly shutting down comments while I run the conversion script to import our existing registered user database, then install the new MySQL-based registration/authentication modules. See you on the other side... UPDATE at 3/10/07 4:14:16 pm: Success! Our registration system ...
LGF, Technical Info, Database, MySQL, Abstraction Layer, PHP, Refactoring, Registration
This place is a mess, although you probably can’t tell. I’ve been ripping out the walls and the floors at LGFHQ, doing what coders call “refactoring” the codebase of the LGF Blog Engine to transfer all our existing content into a MySQL database system, instead of the unwieldy collection of ...
LGF, Technical Info, Database, MySQL, Abstraction Layer, PHP, Refactoring, Registration
The LGF Blog Engine Scalability Project, born out of necessity, is proceeding apace. (If anyone’s keeping track of such things, a decently-designed flat file system starts to get creaky around the 200K unique visits/day mark, on a mostly-dedicated server. I’m sure there are flat file aficionados out there who can do ...
LGF, Technical Info, Database, MySQL, Abstraction Layer, PHP, Refactoring