Extremly slow Join with 'OR'

The main problem - if add in Join on `OR`-condition, select become VERY slow. I realy have to use this condition. -- -- -- `tree_data` -- CREATE TABLE IF NOT EXISTS `tree_data` ( `id` int(11) NOT NULL AUTO_INCREMENT, `pid` int(11) NOT

Re: Extremly slow Join with 'OR'

You may want to split of your or conditions into a separate query, and use UNION. On Tue, Aug 17, 2010 at 11:22 AM, Влад Р vul...@gmail.com wrote: The main problem - if add in Join on `OR`-condition, select become VERY slow. I realy have to use this condition. --

Re: Extremly slow Join with 'OR'

use UNION ALL ..instead of UNION for better performance... On Tue, Aug 17, 2010 at 5:01 PM, Johan De Meersman vegiv...@tuxera.bewrote: You may want to split of your or conditions into a separate query, and use UNION. On Tue, Aug 17, 2010 at 11:22 AM, Влад Р vul...@gmail.com wrote: The

Re: Extremly slow Join with 'OR'

Only if you want to see duplicate rows :-) On Tue, Aug 17, 2010 at 2:21 PM, Ananda Kumar anan...@gmail.com wrote: use UNION ALL ..instead of UNION for better performance... On Tue, Aug 17, 2010 at 5:01 PM, Johan De Meersman vegiv...@tuxera.be wrote: You may want to split of your or

Problem with mytop

If sombody can help me I'll be gratefull I have a problem with mytop1.6 on Mandriva 2010.1, when I install it on a Slave server mytop works, but when I install it on a Master Server don't works, don't display the queries. I use mysql version 5.0.77 and linux mandriva 2010.1 Very Thanks

MySQL 5.1 config for approx 100 concurrent users

I'm looking to implement a new website, which will have on average around 100 approx users at any one time. Is there anything I need to be aware of when setting up MySQL in terms of the server configuration ? Regards Neil

Re: Problem with mytop

Carlos, Have you tried innotop instead? It's a better replacement for mytop. (I wrote it.) - Baron On Tue, Aug 17, 2010 at 8:50 AM, Carlos Eduardo Caldi ce_ca...@hotmail.com wrote: If sombody can help me I'll be gratefull I have a problem with mytop1.6 on Mandriva 2010.1, when I install

max_seeks_for_key

Hi,   We have myisam tables which has round 10 lakhs of records in each tables.I want to search the records based on index. What should be the value of max_seeks_for_key as it is set at default 4294967295.   Thanks in advance.   Jeetendra Ranjan MySQL DBA

Can InnoDB do without doublewrite

Hi all, I don't fully understand the importance of doublewrite in InnoDB. (1) Performance wise. Performance wise I can understand that, doublewrite can coalesce many dirty pages into a big buf chunk, and upon flush, first write this big buf chunk to tablespace + fsync(), then write those

RE: max_seeks_for_key

It's not really necessary for you to adjust that variable. -Original Message- From: jitendra ranjan [mailto:jitendra_ran...@yahoo.com] Sent: Tuesday, August 17, 2010 7:52 AM To: mysql@lists.mysql.com Subject: max_seeks_for_key Hi, We have myisam tables which has round 10 lakhs of

Re: How to use SSL? (SSL is enabled but not used)

On Wed, 2010-08-11 at 14:23 -0400, Shawn Green (MySQL) wrote: On 8/9/2010 5:27 PM, Yves Goergen wrote: What's that supposed to mean? If there's no way to force the connection into SSL, it is entirely useless. Anyone on the wire could simply pretend that the server doesn't support SSL and so

Re: How to use SSL? (SSL is enabled but not used)

On 18.08.2010 00:02 CE(S)T, Anders Kaseorg wrote: This same issue was reported back in 2004 and ignored: http://bugs.mysql.com/bug.php?id=3138 Oh dear, 2004... I think this is a serious security problem that demands more attention than dismissal as documented behavior. To solve it, there

Re: How to use SSL? (SSL is enabled but not used)

On Wed, 18 Aug 2010, Yves Goergen wrote: Since MySQL is now Oracle […] Yves, I think we should be treating this security issue seriously, and working with Shawn and the MySQL team towards solving it constructively, instead of just taking potshots at their new company. Anders -- MySQL General

Updatable View limited by current user

Hello, I would like to have an updatable view that only shows the records in a table that have been created by the current user. By restricting regular users to this view (rather than the underlying table) they could only look at and modify their own data; more privileged users could look at

OpenOffice, Go-OO, ODBC, Offline Data Entry

Hello, I am new to the mailing list here, so I'd like to introduce myself quickly. My name is Casey Quibell, and I am also rather new to the concept of programming a database (Or in this case, more specifically using an ODBC connector to tie OpenOffice into it.) Just a bit of technical