MySQL Unreliable

2008-05-16 Thread Marc Perkel
Need a little help for MySQL users. I'm running several servers that are using a common MySQL server for bayes for all the SA servers. What I'm seeing is that MySQL is just plain unreliable. The database is often corrupted and it does so in a manner that basically causes SA to hang until it

Re: MySQL Unreliable

2008-05-16 Thread SM
At 06:30 16-05-2008, Marc Perkel wrote: I'm running several servers that are using a common MySQL server for bayes for all the SA servers. What I'm seeing is that MySQL is just plain unreliable. The database is often corrupted and it does so in a manner that basically causes SA to hang until

Re: MySQL Unreliable

2008-05-16 Thread Steven Stern
Marc Perkel wrote: Need a little help for MySQL users. I'm running several servers that are using a common MySQL server for bayes for all the SA servers. What I'm seeing is that MySQL is just plain unreliable. The database is often corrupted and it does so in a manner that basically causes

Re: MySQL Unreliable

2008-05-16 Thread Marc Perkel
SM wrote: At 06:30 16-05-2008, Marc Perkel wrote: I'm running several servers that are using a common MySQL server for bayes for all the SA servers. What I'm seeing is that MySQL is just plain unreliable. The database is often corrupted and it does so in a manner that basically causes SA to

Re: MySQL Unreliable

2008-05-16 Thread SM
Hi Mark, At 09:15 16-05-2008, Marc Perkel wrote: OK - I'm trying that. So innodb is better? InnoDB supports transactions. The entire table is not locked as with MyISAM when data is inserted, updated or deleted. That's better in the case of a Bayes database. In general, there is a