Grouping based on state changes

, and 8. How do express a select statement in SQL which gives me the mean of each group? Greetings, Mads Lindstrøm -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

InnoDB crash - recover + bug

Greetings all. I have a bit of a problem here, a database i'm administering was somehow corrupted, and i'm unable to recover it in any way. Is there any way at all to recover a corrupt InnoDB database? (I read on innodb.com that it is impossible, but hope it is not) When I run a query from any

RE: InnoDB crash - recover + bug

>> Greetings all. >> >> I have a bit of a problem here, a database i'm administering was somehow = >> corrupted, and i'm unable to recover it in any way. > >what happened? A power outage? You deleted the ib_logfiles? Modified my.cnf? >Hard disk broke? Thats the weird thing, nothing abnormal happen

Re: B-tree index question

dom insertion. Best regards, Mads -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

MySQL C API questions

eason that I ask this question is that if the fields are not zero-terminated I have to copy the values into a temporary buffer, zero-terminate that buffer and the do the conversion every time... This seems like a lot of wasted work ;-) Best regards, Mads Kristensen -- MySQL General Mailing List For

Amount of data stored in a blob

curious ;-) Best regards, Mads Kristensen -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Amount of data stored in a blob

Ok. I am replying to my own post here ;-) I guess that the reason is the fact that only 2 bytes are reserved for storing the size of the BLOB, and since an unsigned short's maximum value is 2^16-1 this is also the maximum size of the BLOB. So, mystery solved :-) - Mads Mads Kristensen wrot

How much is cached

o the database that select out the contents of a BLOB, will the BLOB be read only once (and found in cache the other time), or will it be read from disk twice? Best regards, Mads Kristensen [1] http://fuse.sf.net -- MySQL General Mailing List For list archives: http://lists.mysql.com/mys

Double inner joins/ nested inner joins?

re returned. the question beeing: Can we use that kind of join combination: "table_ref INNER JOIN (table_ref INNER JOIN table_ref ON join_cond) ON join_cond" if no, how do we work arround it? Mads & Martin ---

Help MySQL on website...

??? Please Help! Cheers, Mads PS: the server administrator told me thta they installed a mysql-adon or something???

MySQL 5.0.24a has been released

attribute if the SQL mode was MYSQL323 or MYSQL40. This also affected mysqldump, which uses SHOW CREATE TABLE to get table definitions. (Bug#14515: http://bugs.mysql.com/14515) Enjoy, Mads Martin Joergensen -- Mads Martin Joergensen, Release Manager MySQL AB, Odense, Denmark -- www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

MySQL 5.1.12 Beta has been released

1.12 delivers several important improvements to ease the creation of Pluggable Storage Engines" says Paul McCullagh, the lead developer behind the Primebase XT Storage Engine for MySQL (PBXT), "we are very excited about this new public release." PBXT 0.9.27 is now in Beta Tes

MySQL-4.1.22 has been released

haracters (which can be different for multi-byte character sets). (Bug#19983: http://bugs.mysql.com/19983) Sincerely, Mads Martin -- Mads Martin Jørgensen, Release Manager MySQL AB, Odense, Denmark -- www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql

MySQL 5.1.14 Beta has been released

n with exclusive lock and updating the retrieved records, the scan could skip some records, which were not updated as the result. (Bug#20446: http://bugs.mysql.com/20446) * NDB Cluster: Aborting a cluster backup too soon after starting it caused a forced shutdown of the data nodes. (B

MySQL Community Server 5.0.33 have been released

this release reverts. Programs compiled against 5.0.26 are not compatible with any other version and must be recompiled. (Bug#23427: http://bugs.mysql.com/23427) * InnoDB: Reduced optimization level for Windows 64 builds to handle possible memory overrun. (Bug#19424: http://bugs.

MySQL 5.1.16 Beta has been released

d function from within a stored procedure crashes the server. (Bug#25382: http://bugs.mysql.com/25382) Enjoy! Sincerely, Mads Martin -- Mads Martin Joergensen, Release Manager MySQL AB, Odense, Denmark -- www.mysql.com -- MySQL General Mailing List For list archives: http://lists

MySQL Community Server 5.0.37 has been released

http://bugs.mysql.com/25059) * NDB Cluster: When a data node was shut down using the management client STOP command, a connection event (NDB_LE_Connected) was logged instead of a disconnection event (NDB_LE_Disconnected). (Bug#22773: http://bugs.mysql.com/22773) Enjoy and regards,

MySQL 5.1.17 Beta has been released

s.mysql.com/19717) * A query of type index_merge, and with a WHERE clause having the form WHERE indexed_column_1=value_1 OR indexed_column_2=value_2 on a partitioned table caused the server to crash. (Bug#26117: http://bugs.mysql.com/26117) Enjoy, Mads Martin -- Mads Martin Joergen

MySQL Community Server 5.0.41 has been released

subquery could return incorrect results. (Bug#23800: http://bugs.mysql.com/23800) * For index reads, the BLACKHOLE engine did not return end-of-file (which it must because BLACKHOLE tables contain no rows), causing some queries to crash. (Bug#19717: http://bugs.mysql.

InnoDB crash - recovery

Greetings all. I have a bit of a problem here, a database i'm administering was somehow corrupted, and i'm unable to recover it in any way. Is there any way at all to recover a corrupt InnoDB database? (I read on innodb.com that it is impossible, but hope it is not) When I run a query from any