Site Issues

Every couple hours for the past week or so my system has been running out of memory and swap. It is a budget system, but I’m not doing anything extraordinary on it. I’ll be investigating, so yes, I know my site is down intermittently.

Comments (3)

Text Link Ads

Google ads didn’t really do too much for me, so I’m trying out Text Link Ads:
Text Link Ads

Check it out in the left tab.

Comments (4)

Forum FS/FT Thread Notifier

I fixed a couple of bugs and made some changes to my Forum FS/FT Thread Notifier, previously known as the Unofficial Anandtech FS/FT Thread Notifier. As the name change implies, I added support for another forum: HardForum. Some time in the future I plan to add support for ArsTechnica as well, these are the 3 main forums I use when looking for used technology items. If it’s not in either of these and I REALLY want it, I’ll turn to eBay or Craig’s List as a last resort.

The main functionality of the thread notifier isn’t as important for HardForum or ArsTechnica, because those forums allow replies as a search criterion. However, for consistency, and so I don’t have to look multiple places, I thought I would add them.

If you use this app, please leave a comment! I appreciate your feedback.

Comments (2)

AnandTech FS/FT Thread Notifier

It occurred to me recently that there are lots of threads deals in the AnandTech For Sale / For Trade forum. Some of these are great deals, some of these are not so great. One thing I’ve found is that the great deals usually go VERY fast, and usually to the members that peruse that forum often.

So I looked for a way to be notified of new threads somehow from their software. There is a somewhat functional RSS feed of the posts in that forum, but that does little to help notify of new deals or threads. Moreover, that feed doesn’t even list how many views or replies any given thread has.

So, I developed a simple web application with PHP that reads the main page of the FS/FT forum, parses out the threads, along with links, views and replies for each, then stores them in a MySQL database. It checks the forum once every five minutes, and updates as necessary. I built a frontend for easy viewing, and made an RSS feed for automating the retrieval process. I consider it “finished” for a 1.0 release, all of my original goals were met. A “1.5” release might include e-mail notifications, time intervals spanning 1/2 hour, 1 hour, 3 hours, 6 hours, 12 hours, 24 hours. We’ll see if it takes off before I spend more time developing it.

So without further adeiu, I present the unofficial AnandTech FS/FT Thread Notifier.

Comments (10)

MySQL Can’t Open File (again)

I had another issue with MySQL not being able to open a file again. Same fix did it.

#1016 - Can't open file: 'wp_bad_behavior_log.MYI' (errno: 145) 

# myisamchk wp_bad_behavior_log.MYI
Checking MyISAM file: wp_bad_behavior_log.MYI
Data records:     109   Deleted blocks:     270
myisamchk: warning: Table is marked as crashed
myisamchk: warning: 4 clients are using or haven't closed the table properly
- check file-size
- check record delete-chain
myisamchk: error: Record at pos: 203284 is not remove-marked
myisamchk: error: record delete-link-chain corrupted
- check key delete-chain
- check index reference
- check data record references index: 1
myisamchk: warning: Auto-increment value: 19908 is smaller than max used value: 19909
- check record links
myisamchk: error: Record-count is not ok; is 113          Should be: 109
myisamchk: warning: Found 235456 deleted space.   Should be 236988
myisamchk: warning: Found        419 parts                Should be: 414 parts
MyISAM-table 'wp_bad_behavior_log.MYI' is corrupted
Fix it using switch "-r" or "-o"

# myisamchk -r wp_bad_behavior_log.MYI
- recovering (with sort) MyISAM-table 'wp_bad_behavior_log.MYI'
Data records: 109
- Fixing index 1
Data records: 113

I wonder what causes the data to be corrupted…

Comments (0)