Re: Slow query not using index

One of the list readers (thanks Brent!) suggested using a full text index on the category names field. Queries dropped from 10-49 seconds down to 0.0085 Thanks for the emails folks! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.my

Re: Slow query not using index

Ian M. Evans wrote: Bad news: I have a slow query that doesn't appear to be using an index even if I force it. Good news: the forehead shaped dent in my desk is really progressing well. Here's the query: SELECT DISTINCT poster_data.* FROM poster_data, poster_prodcat, poster_categories WHERE p

Re: Arabic text storing problem

Hi, Thanks for the link Is there standalone jar/zip Just for auto_ef Also see Perl module Encode::Guess. There are others out there as well. Regards, Jeremy -- high performance mysql consulting www.provenscaling.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/m

Re: German collation for UTF8 missing

On 14.11.2007 21:43 CE(S)T, Marten Lehmann wrote: > I want to store my data with UTF8, thus I'm using the utf8 charset for > my tables. But which collcation shall I use? I cannot find anything > appropriate. If I recall that correctly, utf8_swedish_ci is the collation to use for european/western

Re: Transactions and locking

On 14.11.2007 12:50 CE(S)T, Martijn Tonies wrote: > Yves, > > Did you read this reply I send earlier? I think it does what you > want without needing to "lock" anything, thus making it portable. >> I would suggest the following -- >> >> create a table called "SEQUENCES": Yes, I've read it and ac

RE: MySQL - Replication (Master/Slave) Question

Update/Clarification: It's apparent that you need a master->slaveDB, and that I can have multiple slaveDBs on the slave server. But can I setup all the slaveDBs on a single machine. Thanks hi... in very basic terms/pics... i have : masterServer1 masterDB1 my.cnf masterServer2 ma

Seeking assistance with recurring MySQL crash during nightly dumps

A message in the MySQL log file asserts that someone at this e-mail address may be able to assist in troubleshooting/diagnosing a chronic error we encounter during our nightly database dumps. Here is an excerpt of the log file (near the reference to your e-mail address): InnoDB: Error: semaphore

RE: MySQL - Replication (Master/Slave) Question

hi... in very basic terms/pics... i have : masterServer1 masterDB1 my.cnf masterServer2 masterDB2 my.cnf . . . masterServerN masterDBN my.cnf this gets me N masterServers, each with it's own my.cnf file, as well as it's own masterDB. I'd like to be able to have

Re: MySQL - Replication (Master/Slave) Question

On 11/14/07 4:01 PM, "Mike Johnson" <[EMAIL PROTECTED]> wrote: > Correction to a couple of replies I've seen -- a slave server can have > more than one master, but not to the same database. That is, Slave reads > Database1 and Database3 from Master1 and also reads Database2 from > Master2. > >

Slow query not using index

Bad news: I have a slow query that doesn't appear to be using an index even if I force it. Good news: the forehead shaped dent in my desk is really progressing well. Here's the query: SELECT DISTINCT poster_data.* FROM poster_data, poster_prodcat, poster_categories WHERE poster_categories.apca

RE: MySQL - Replication (Master/Slave) Question

Correction to a couple of replies I've seen -- a slave server can have more than one master, but not to the same database. That is, Slave reads Database1 and Database3 from Master1 and also reads Database2 from Master2. You may actually be able to get down to the table level, but I'd have to check

German collation for UTF8 missing

Hello, I want to store my data with UTF8, thus I'm using the utf8 charset for my tables. But which collcation shall I use? I cannot find anything appropriate. I cannot use utf8_unicode_ci or utf8_general_ci, because this seems to treat "Ä" and "A" equally. So I couldn't store the words "ÄBC"

Re: MySQL - Replication (Master/Slave) Question

On Nov 14, 2007 3:40 PM, bruce <[EMAIL PROTECTED]> wrote: > Hi... > > I have a number of servers that I want to treat as Master Servers or the > purpose of Replication.. > > I'd like to have each of the Master, have the Slave DB on the same machine. > Ie, a Slave server, might have 10 different Sla

Re: MySQL - Replication (Master/Slave) Question

bruce wrote: Hi... I have a number of servers that I want to treat as Master Servers or the purpose of Replication.. I'd like to have each of the Master, have the Slave DB on the same machine. Ie, a Slave server, might have 10 different Slave Databases/config files, with each of the SlaveDB tie

MySQL - Replication (Master/Slave) Question

Hi... I have a number of servers that I want to treat as Master Servers or the purpose of Replication.. I'd like to have each of the Master, have the Slave DB on the same machine. Ie, a Slave server, might have 10 different Slave Databases/config files, with each of the SlaveDB tied back to the M

Triggers/Innodb/Locking

Hi... As I understand mysql, Innodb provides for row level locking, as opposed to myIsam which does tbl level locking. Is this correct? If I am correct, if I have a trigger on a Innodb tbl (foo), such that the trigger then copies a row to another innodb tbl (cat), foo should only do a lock of the

Re: Use select within delete

thanks all, I'll do it with a perl script! Dario 2007/11/14, Ravi Kumar. <[EMAIL PROTECTED]>: > Try this (I do not have 4.0.24 to try): > > delete table1.* from table1, table2 where table1.id = table2.id and > date > Ravi. > > > On 11/13/07, mark addison <[EMAIL PROTECTED]> wrote: > > > > Dar

Trigger/Locking question--

Hi... I'm trying to get me head around a possible situation involving locks/triggers. Suppose I have two tables: FooTBL CatTBL in FooTBL, I have a trigger that operates such that whenever a new row is added to FooTBL, it's immeadiately copied to CatTBL. I'm trying to understand what happens i

Re: Arabic text storing problem

> Thanks for the link > Is there standalone jar/zip Just for auto_ef Not that I know of. Since I work on Solaris most of the time, it's not an issue for me. It's probably a bit much to install an OS just for a single utility... Company allegiance aside [I work for Sun], the Solaris Express Devel

Re: Arabic text storing problem

> i have one problem with Arabic text. I have created database with > charaterset utf8. when i insatal sql file all the content which is arabic > that content stored as arabic. but when i retrieve When you retrieve this content, how are you viewing it? - browser? terminal? For the browser, it ne

What am I misunderstanding here?

I'm running MySQL version 5.0.33. I have the 2 following queries: SELECT Resource.Id, Resource.Name, Resource.Description, Resource.IsVisible, Resource.UpdatedDate, Resource.CreatedDate FROM Resource INNER JOIN ObjectTarget ON Resource.Id = ObjectTarget.TargetId AND ObjectTarg

Re: SET GLOBAL don't work

Hi Thomas Raso wrote: Hi all, i have a mysql 4.1.21 and i want to change the wait_timeout variable without restarting mysql. I found that this variable can be changed by using SET GLOBAL wait_timeout=XXX mysql> show variables like 'wait%'; +---+---+ | Variable_name | Value |

Re: SQL query problem

Dear Mat, Your mail is not very clear. But I have a feeling that using '%' wildcard in the like operand should help you Regards, Ravi. On 11/14/07, Matthew Stuart <[EMAIL PROTECTED]> wrote: > > Hi, I have built a site with Dreamweaver and I have a problem with a > query. > > I am trying to

Re: Transactions and locking

Yves, Did you read this reply I send earlier? I think it does what you want without needing to "lock" anything, thus making it portable. > > >> Damn, I found out that I need table locking *and* transactions. > > > > > > What makes you say that? > > > > BEGIN TRANSACTION > > SELECT MAX(id) FROM ta

SET GLOBAL don't work

Hi all, i have a mysql 4.1.21 and i want to change the wait_timeout variable without restarting mysql. I found that this variable can be changed by using SET GLOBAL wait_timeout=XXX mysql> show variables like 'wait%'; +---+---+ | Variable_name | Value | +---+---

SQL query problem

Hi, I have built a site with Dreamweaver and I have a problem with a query. I am trying to pass a parameter from one page to another to drill down. Basically, I have one product entry that is in multiple categories on my website. So, say it's a dress, it is therefore related to category 1

Re: Use select within delete

Try this (I do not have 4.0.24 to try): delete table1.* from table1, table2 where table1.id = table2.id and date wrote: > > Dario Hernan wrote: > > Hi all I need to delete some fields from a table but in the where > > clause I need to put a select command. > > For instance, delete from table1

Arabic text storing problem

i have one problem with Arabic text. I have created database with charaterset utf8. when i insatal sql file all the content which is arabic that content stored as arabic. but when i retrieve this content it is display something like ASCII value("فعاÙ"ÙSØ© ادارة اÙ"Ù^Ù,ت"). one more th