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 q
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 issu
help as well 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
(destroy
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 li
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
se 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 reco
eceiver.address LIKE '[EMAIL PROTECTED]' 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 -
&g
