Re: [Slashcode-development] Another question: Moving to MySQL 5 or Stay with 4.1?

[Fred M. <fr...@ta...>]

shane wrote:
> 
> On Jan 20, 2006, at 5:50 PM, Fred Moyer wrote:
> 
>> On Fri, 20 Jan 2006, Eric Dannewitz wrote:
>>
>>> to get the slash stuff moved over? Is there any advantage to  running 
>>> Mysql 5 over 4.1? Any thing I should watch out for?
>>
>> I run taperfriendlymusic.org on Slashcode.  At one point the drive  
>> filled up and Mysql truncated two tables in the slash database,  that 
>> was using 3.2x.  I don't know if that is the case with 4.1 or  5 but 
>> you might want to
>> watch out for it.
> 
> huh? How does you letting your hard drive fill up have anything to do  
> with *anything* else? that's like saying "well I've got a server, and  
> it's HD filled up, and then things didn't work quite right" Well,  
> that's a shocker ;) Things are going to break if the filesystem's  full, 
> especially *database* servers!

I assume you use Slash because you have a lot of traffic, right?  That 
traffic generates logfiles, which take disk space.  You can argue that 
"Well you should have bought more hard drives", or "You should have a 
system ships the logs offsite".  Which I agree with but when you run a 
high traffic site based purely on donations, things are not always ideal 
and you make do with what you have.  People link to your site, and 
overnight you can generate several gigs of logfiles.  And also you have 
users uploading music, sometimes 10 or 20 gigs a night.

In my case, the Slash installation lost both the formkeys and access_log 
tables when the drive filled up.  Do you think it's good behavior for 
database servers to drop tables when they fill up?  Would it be good 
behavior for a filesystem to delete files when the filesystem fills up?

I"m not trying to nitpick Slashcode here or assign blame.  Slashcode has 
done really good things for myself and the music community I run.  I'm 
sharing my experience of an edge case that I've run into.  I suspect 
it's a Mysql issue and does not have anything to do with Slashcode, but 
I wanted to give you a heads up regarding my experience.

Good luck,

- Fred