Re: Very slow query

Although you're not really asking a question, I presume that you want to know why the query is very slow and how you speed it up. > The following query: > > CREATE TEMPORARY TABLE orders.recentClickOrders > SELECT recentHeader.transNum, recentClickLog.adRunId, links.letterId, > recentHeade

Re: Cannot lock: called with 1 bind variables when 0 are needed

Another interesting thing. Mysql is running on Solaris. Once past the "Cannot lock" error, I got approximately: db.TBUSR does not exist on this server db.tbusr does. I thought table names were case insensitive on unix. Apparently not. - Original Message - From: "Mike Wexler" <[EMAIL PROTEC

Re: Cannot lock: called with 1 bind variables when 0 are needed

Hmmm, you're probably right. I got carried away. - Original Message - From: "Mike Wexler" <[EMAIL PROTECTED]> To: "Jonathan Mangin" <[EMAIL PROTECTED]> Sent: Sunday, October 24, 2004 4:53 PM Subject: Re: Cannot lock: called with 1 bind variables when 0 are needed Try this: my $sql = "LO

Fwd: Very slow query

The didn't show up on the list 2 days after posting it, so I'm posting it again. -- Forwarded message -- From: Mike Wexler <[EMAIL PROTECTED]> Date: Fri, 22 Oct 2004 14:39:49 -0700 Subject: Very slow query To: [EMAIL PROTECTED] The following query: CREATE TEMPORARY TABLE orders

Plz accept my subcription

Hi, kindly accept the subsciption for mysql help..since i need this very seriously ... thanks Din Yahoo! India Matrimony: Find your life partneronline.

MySQL version and sysklogd-sql problem

I'm banging my head against a somewhat strange problem I hope somewhat more proficient than me can help me with. I'm trying to setup a central logging-server and having it dump all input into a MySQL db for easier access from diferent analisys systems. I've found sysklogd-sql on Sourceforge, wh

Re: Question

How to run multiple instances of the MySQL server is documented in the manual . Did you follow those directions? It appears that you did not. We shouldn't do your homework for you, but we can answer specific questions if you get stuck.

Question

Dear sir, I am college student from Indonesia which is holding a research in mysql. For doing my research, i have to install and running multiple servers on the same time and on the same machine. I have install 2 mysql server ver 4.0.15 in my computer, but until now, only one server could r

Question

Dear sir, I am college student from Indonesia which is holding a research in mysql. For doing my research, i have to install and running multiple servers on the same time and on the same machine. I have install 2 mysql server ver 4.0.15 in my computer, but until now, only one server could r

ENUMs and SETs

Hi, Apologies to all those who read this via mailing.database.mysql, for the repost. I didn't realise that there wasn't two way synchronisation between the mailing list, and the news group. I'm looking for some advice on database structure. Without unnecessary details, I ha

Re: Index not used for "select distinct"?

Matthias, I think that MySQL is doing what would be expected, namely an index scan which reads entire index on IP and selects distinct values of IP. Whatever you do, it's going to read 10,991,123 of something and select distinct values. The use of the index saves a possible sort and allows readi

ERROR 123 when reading table

Sometimes, mysql client got this error, mysql error: Record has changed since last read in table 'table' And I checked from mysql error log, 041023 8:28:06 Got error 123 when reading table './db/table' What's this error? -- MySQL General Mailing List For list archives: http://lists.mysql.com/