Re: Help Save MySQL

2009-12-18 Thread Michael Katz
but there is very scant evidence that this is possible. Sorry for the cynicism but it's just the truth. Michael Katz mos wrote: Instead of forming a group hug and singing kumbuya to save MySQL, why don't we take some action to prevent Oracle from keeping (destroying/crippling) MySQL? Who

MySQL Silently Truncates / Destroys Data

2009-05-28 Thread Michael Katz
We have found a major bug in MySQL that causes MySQL to silently truncate date in LONGTEXT fields when innodb is used and MySQL fails to convert characters in a string to the configured charset of the column. This results in mangled/destroyed data. Since MySQL is kind enough to not report any

Scaling with Replication

2008-04-01 Thread Michael Katz
In a replication environment with 1 master and a 2 slaves, does the entire database always have to be stored on the master? I understand that slaves can come on and off line but I am not sure if the master must always store a complete copy of DB. Thanks, MK -- MySQL General Mailing List For

Re: Troubleshooting Stalls

2007-01-03 Thread Michael Katz
it many cases, since we install on customer supplied hardware. Does show full processlist show local connections and queries as well? We only see remote queries in the list. Thank You On 1/2/07, Michael Katz [EMAIL PROTECTED] wrote: I have a large database, about a million records in some

Re: Troubleshooting Stalls

2007-01-03 Thread Michael Katz
]' AND messages.unix_timestamp = 1165212000 AND messages.reason != 'Archive' ORDER BY messages.received DESC LIMIT 0,200 Dan On 1/3/07, Michael Katz [EMAIL PROTECTED] wrote: Dan Buettner wrote: Michael - You should see all running queries in the output of SHOW PROCESSLIST. MyISAM

Troubleshooting Stalls

2007-01-02 Thread Michael Katz
I have a large database, about a million records in some tables, and I am trying to troubleshoot some stalls in our application. We have assumed that slow query speed causes the stalls, however, when my web app stalls I do not see the query in process list. What we see is the web page stall

libmysql connection timer problems

2005-12-12 Thread Michael Katz
We have an application that uses the libmysql libraries for email archival. We have recently been getting killed because of http://bugs.mysql.com/bug.php?id=4143. It seems that mysql keels over during a big query on a large database and it will not let our client write to the db until the