Hi,
According to the manual, the slave-net-timeout specifies how long time to wait
for data from the master before considering the connection dead. From my
experience this actually means that the slave will reconnect if it hasn't
received a full event in that period of time.
E.g. setting slave
Jerry,
Are you sure this is really your explain plan for this query? That's not at
all what I would expect to see.
Regards,
Gavin Towey
-Original Message-
From: Jerry Schwartz [mailto:je...@gii.co.jp]
Sent: Wednesday, May 26, 2010 2:14 PM
To: mysql@lists.mysql.com
Subject: Slow query
Hello everyone,
I am conducting some text retrieval experiments with MySQL 5.5.3.
I have a question regarding WITH QUERY EXPANSION search mode.
In this presentation [1] I learned that it applies blind relevance feedback. It
runs natural language mode query twice and add top 20 results (control
I have a pretty simple query that seems to take a lot longer than it ought to
(over 2 minutes).
Table `feed_new` has a single VARCHAR(255) column, `new_title`, that is an
index.
Table `prod` has many fields: `prod_title` and `pub_id` are both indexes
(VARCHAR).
`feed_new` has 895 records, `pr
Kevin,
The problem occurs because the parameter names are the same as the column names.
I'm not sure why, since the columns are specified in quotes, but it does.
Eh? Backticks merely permit use of reserved words as identifiers.
PB
-
On 5/26/2010 9:56 AM, Kevin Baynes wrote:
The proble
Kevin
WHERE (`id_file` = id_file
AND `id_machine` = id_machine
AND `id_user` = id_user
How is MySQL supposed to distinguish `id_file` from id_file &c!? Name
params diffferently from columns.
PB
-
On 5/26/2010 9:07 AM, Kevin Baynes wrote:
Using MySql 5.1, I have a very s
The problem occurs because the parameter names are the same as the column
names. I'm not sure why, since the columns are specified in quotes, but it does.
Thanks,
Kevin
-Original Message-
From: Kevin Baynes [mailto:kbay...@bluezonesoftware.com]
Sent: Wednesday, May 26, 2010 10:07 AM
Using MySql 5.1, I have a very simple table with 1 row. I have a Stored
Procedure to select if the row exists. I expect the test of this SP to return
null, but it returns a value! The value is always returned if the 'path'
matches, regardless of the other values being tested. If the 'path' does
Hmm, probably not that, then. Strange.
You already said there's 100% cpu on one core while that executes. Can you
see if there's disk activity going on ?
After you kill the script, can you check the contents of that table, to see
if any data from the hanging statement is in there ? Can you try to
Thanks.
Getting better informed by the minute!
plenty of disk space (GBs) - datafiles small MB
mysql> show variables like '%inno%';
+-++
| Variable_name | Value |
+-+---
A-ha ! :-)
That's an InnoDB table, allright. Can you check if your InnoDB file is set
to autoextend ? It smells like it's full and waiting for more space or
something.
Either look in your my.cnf file, or do a "show variables like '%inno%';".
Check the filesize of your InnoDB datafiles, too.
On
Thanks Johan,
Ah I see.
So this line for example:
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
generates the first
Query OK, 0 rows affected (0.00 sec)
I did not realise, it looks like a comment.
Not sure about disk activity - top says 100% on 1 of the 4 CPUS
Seems to be thi
On 26/05/2010 12.18, Sydney Puente wrote:
[...]
CREATE DATABASE /*!32312 IF NOT EXISTS*/ `event` /*!40100 DEFAULT CHARACTER SET
latin1 */;
USE `event`;
Can I have the commands being issued echo to the screen somehow, so I can
identify which command is causing the problem?
Or investigate
The "use event" statement is the one that results in the "database changed"
message. You can easily count the result messages after that to find out
which statement is hanging.
It seems very strange to me that the import would just hang, and not exit
with an error. Is there any disk activity ongoi
Hello,
The invocation syntax is OK I think.
yes backup.sql was just a generic name. I think the sql file could be called
anything.
And there is a use event
The result of sourcing the sql file is to create only the 1st (of the expected
4 ) tables - and it hangs - I never get the mysql prompt bac
On Wed, May 26, 2010 at 10:54 AM, wrote:
>
> Actually Im assuming a DB name of "source", which I mentioned in my first
> post. Thats actually an bad assumption as, as Ive just read, source is an
> alternative way to read in data from a file that Id never seen before.
> However the syntax would st
Quoting Johan De Meersman :
On Wed, May 26, 2010 at 10:20 AM, wrote:
If you are trying to restore from backup.sql to a database called soure
then your syntax is wrong. You should be running:
mysql source < backup.sql
You are assuming that the file named "backup.sql" contains a backup of t
On Wed, May 26, 2010 at 10:20 AM, wrote:
> If you are trying to restore from backup.sql to a database called soure
> then your syntax is wrong. You should be running:
>
> mysql source < backup.sql
>
You are assuming that the file named "backup.sql" contains a backup of the
database named "backup
Quoting Sydney Puente :
Hello,
I have a mysqldump file created by AutoMySQLBackup.
And it hangs when I do a
mysql > source backup.sql
If you are trying to restore from backup.sql to a database called
soure then your syntax is wrong. You should be running:
mysql source < backup.sql
Assumi
Hiya
I have a server that gets connections / requests from Germany and South
Africa, Johannesburg (my server's based in Cape Town).
All servers are in datacentres. Im not 100% sure if its latency related,
but I see a load or SLEEP when I do mysqladin proc, which appears to be
hogging mysql.
20 matches
Mail list logo
