[nycbug-talk] MySQL and FreeBSD 6.0

[Jonathan Vanasco]

> Hans Zaunere wrote:
>> I'm seeing MySQL randomly crash - especially as concurrent  
>> connections
>> increases.  Anyone with other experiences with FreeBSD 6.0 and  
>> MySQL, either
>> good or bad?
>>

several ideas hit me

a) MySQL doesn't handle many concurrent connections well.

	The last 'x connections' report i saw, had x for mysql , 10x for  
pgsql and 500x for oracle.

b) what are you doing with mysql?

	if you're doing some selects / inserts, thats odd
	but if you're relying on some of the 'new' features -- triggers,  
views, referential integrity -- i wouldn't be surprised if you saw  
tons of crashes.  i had super bad luck whenever I tried to use the  
'new' features