RE: Table query and column overlap

umented somewhere ! I am sure there is a lot of people out there thinking that it is some kind of command-prompt limitation. Thanks a lot ! Arnaud -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: join subquerie rand problem

ORDER BY RAND() LIMIT 1) AS my_id_animals FROM fruits_animals GROUP BY my_id_fruits) AS tmpQuery GROUP BY tmpQuery.my_id_animals ORDER BY whatever you want LIMIT 100; On 20 Jul 2004 at 16:36, Arnaud <[EMAIL PROTECTED]> wrote: > > i have lets say 1000 different fruits

Re: join subquerie rand problem

M fruits_animals GROUP BY my_id_fruits ORDER BY RAND() LIMIT 100; You have your unique many-to-many relations' table, you just have to join this with the animals and fruits tables. Regards, Arnaud -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:

Re: Need help optimizing query

than 1 mini. I > don't think that's normal. Your indexes look good, but I see that you have some varchar fields. Maybe you could run an "optimize table" on these tables? Also, you are talking about a 40M rows table. If it is a read only MyISAM table, I might try compre

cannot update read/write table with a read-only table in the where clause

but it is a lot less optimized than using joins, I think... Thanks for helping ! Arnaud Lesauvage -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: create threads rate

Hello, Do you have add in your my.cnf skip-name-resolve ? If not maybe the problem come from here. Also upgrade to 4.0.17 will fix some bug on FreeBSD if i remenber right (check maybe changelog) At 11:42 26/01/2004, Varshavchick Alexander wrote: Hi, I have a 4.0.7 mysql server which services re

Re: Repeated 100% CPU problem in FreeBSD

hanks for answer. Best Regards, At 16:59 20/01/2004, you wrote: Hi Arnaud, I did not see an answer to this so; I think the info you need is here http://jeremy.zawodny.com/blog/archives/000203.html and here http://jeremy.zawodny.com/blog/archives/000697.html But I think you want "skip-name-r

Re: Repeated 100% CPU problem in FreeBSD

Hi ! Anyone find a solution for this problem ? We have 2 mysql server with same problem. Happen like every 1-2 months. Regards, -- Arnaud Pignard ([EMAIL PROTECTED]) Frontier Online - Opérateur Internet -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To

Re: Cannot find an index that will be used for SELECT

Ed, You should still have a WHERE clause : SELECT * FROM ROWS AS R1 LEFT JOIN ROWS AS R2 ON (R1.index=R2.index AND R2.X<=Right) LEFT JOIN ROWS AS R3 ON (R1.index=R3.index AND R3.X>=Left) LEFT JOIN ROWS AS R4 ON (R1.index=R4.index AND R4.Y>=Bottom) WHERE R1.Y<=Top Does this wo

temporary table always created on disk

eated_disk_tables 1 (I checked before and after the query, they both get increased by one) I understand that the temporary table is created because of the GROUP BY clause, but why on disk ??? How could I work around this? Thanks a lot if anyone can help! Arnaud -- MySQL General Mailing List For

Re: using temporary / using filesort and disk tables

ows in the result of my query, and that would definitively not make 512M ! Arnaud -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: using temporary / using filesort and disk tables

in advance. Arnaud -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Cannot find an index that will be used for SELECT

Hi Ed, May you could join the table to itself, using a join criteria of index and position : SELECT * FROM ROWS AS R1 LEFT JOIN ROWS AS R1 ON (R1.index=R2.index AND R2.X<=Right) LEFT JOIN ROWS AS R3 ON (R1.index=R3.index AND R3.X>=Left) LEFT JOIN etc etc... Does that help? Arnaud --

Re: using temporary / using filesort and disk tables

r testing purpose. I am the only user of this server, and since I couldn't find the reason for this disk tables, I tried some 'huge' settings... ;-) Thanks again for helping! Arnaud -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

using temporary / using filesort and disk tables

n disk, and not in memory? Is it because of the filesort? If yes, how could I get rid of the filesort? If this is not clear enough, I can post a sample query and the result of the explain. Thanks in advance! Arnaud -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysq

Is there any file .frm, .MYD, .MID on mySQL in HPUX Plateform?

Hi everybody, On Windows mySQL database stores its record in 3 files per tables (table.frm, table.MYD, table.MYI) in this directory c:\mysql\data\database_name\ I use this file to make a backup. I want to know if these files exist in mySQL on HPUX? I hope someone can help me. Thanks.

.frm, .MYD & .MYI exists HPUX?

I know that this files exist on mySQL Windows, (3 files by Tables) someone can tell me if this files exist on mySQL HPUX? I use this files to make a rollback. Thanks. __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail http://per

Database backup on Windows & HPUX

On windows, I copy the 2 MYD MYI of a database to another directory as a way of backup. It seems to function properly. I just want to know if the same file exists on HPUX and if I can do the same thing. Any help appreciate. Thanks. __ Do You