Re: does DISTINCT kill ORDER BY?

Markus Hoenicka wrote: Hi, is the following behaviour intended? Are my queries wrong? The output shows only the "Extra" field as the other fields are identical in all cases. EXPLAIN SELECT t_refdb.refdb_id FROM t_refdb WHERE t_refdb.refdb_id>0 ORDER BY t_refdb.refdb_id; => Using where; Using i

5.1 Partitioning - effect on inode count?

As I only qualify as 'barely literate' as a Unix admin, does anyone know of a good article on inode count, or, even better, one as it pertains to partitioning? I'm thinking about developing a two partitions per month per table schema but I'm worried about the sheer number of files this will creat

does DISTINCT kill ORDER BY?

Hi, is the following behaviour intended? Are my queries wrong? The output shows only the "Extra" field as the other fields are identical in all cases. EXPLAIN SELECT t_refdb.refdb_id FROM t_refdb WHERE t_refdb.refdb_id>0 ORDER BY t_refdb.refdb_id; => Using where; Using index (results are sorted)

Re: Slave behind master... or not ?

Jocelyn, without more information about how many queries your system has, it's impossible to say. I do not know how MySQL calculates the 'Seconds_Behind_Master' data, but: If your system has bursts of queries, why is the data represented below confusing? What if inbetween your 1st and 2nd '

Adding and Removing tables from MERGE tables dynamically

Problem: I use two applications one called snort, the client that inserts data into eleven(11) tables. The other application BASE joins the tables into one table. When the tables become 4GB in size, deleting records for one month becomes unbearably slow(20-30days). The search(Select ) is slow too

Has InnoDb licensing changed to accommodate Oracle?

Has Oracle placed any restrictions on using InnoDb and MySQL now that the original MySQL AB license has expired with Heikki?? What is the name of the new MySQL transaction engine and is anyone using it? Is it any good? TIA Mike -- MySQL General Mailing List For list archives: http://lists.mys

Re: Slave behind master... or not ?

Hi, Thanks for the answer. I don't think this is what's happening because I can also see within a few seconds : 0 48 0 48 0 for example. Thanks, Jocelyn Michael Loftis a écrit : --On September 5, 2006 3:18:21 PM +0200 Jocelyn Fournier <[EMAIL PROTECTED]> wrote: Hi, Any idea of

Re: Slave behind master... or not ?

--On September 5, 2006 3:18:21 PM +0200 Jocelyn Fournier <[EMAIL PROTECTED]> wrote: Hi, Any idea of what could be wrong here ? My guess is that the variable is based on the last update timestamp, and the last time that the slave has seen data from the master. If it had been about a

Re: Large size of MySql binary for Power PC

--On September 5, 2006 1:41:43 PM +0530 Arvind Kumar <[EMAIL PROTECTED]> wrote: Hi! Any help would be appriciated. I found MySQL binaries for embedded system (Processor: Power PC, OS:Linux) There is not much space available in the hard disk. It is around 20 MB. The binary size is large enou

Slave behind master... or not ?

Hi, I encounter a really strange behaviour with some of my slaves servers : I'm using MySQL 4.1.20 x86_64 on both master and slave servers. If I issue three times the command SHOW SLAVE STATUS several times in a few seconds, I could obtain the following results for the Seconds_Behind_Master co

ndb-storage engine in 5.0.24a-community-max?

Hi, is the ndb-storage-engine for creating clusters included in 5.0.24a-community-max (win)?? if it is, how can I enable it? Or is it still imposible to use clusters on windows-machines? Thx -- Sebastian Mork <[EMAIL PROTECTED]> -- MySQL General Mailing List For list archives: http://lists.m

Large size of MySql binary for Power PC

Hi! Any help would be appriciated. I found MySQL binaries for embedded system (Processor: Power PC, OS:Linux) There is not much space available in the hard disk. It is around 20 MB. The binary size is large enough, could you please tell me how can i reduce binary size. Stripping, I already did.