RE: Table query and column overlap

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 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: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 and 1000 different

Re: Need help optimizing query

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 compression. Arnaud -- MySQL General Mailing List For list

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

! 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: Repeated 100% CPU problem in FreeBSD

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-resolve

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

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 work? Arnaud

Re: using temporary / using filesort and disk tables

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]

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 -- MySQL

Re: using temporary / using filesort and disk tables

. 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

, 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]

temporary table always created on disk

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 list archives: http

using temporary / using filesort and disk tables

? 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/mysql To unsubscribe:http

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.

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

.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