[snip]
I just noticed a horrible thing.
[/snip]
Keep in mind that the query event is server side and is not tied to the
browser (client side) once it has begun because of the statelessness of
the connection. You would have to have some sort of onClose() event from
the browser that would trigger
Hi,
We have lots of mysql servers, master-slave and sharded databases. A
recurring task when a new feature/application comes in to test the
database with real workload. This needs test data and test query
generation. Until now I did this with ad-hoc scripts, I looked for tools
to do this, so
I use jmeter too, but it can't generate the test dataset (if I have to
write this, I plan that it will create a jmeter test case with the
generated test data). Usually my ad-hoc script generates csv files (to
load initial data) and jmeter test cases.
Michael Dykman wrote:
On Wed, Jun 3, 2009
-Original Message-
From: Jay Blanchard [mailto:jblanch...@pocket.com]
Sent: Wednesday, June 03, 2009 8:46 AM
To: Daevid Vincent; mysql@lists.mysql.com
Subject: RE: Why doesn't mySQL stop a query when the browser tab is
closedL
[snip]
I just noticed a horrible thing.
[/snip]
Keep in
Hi
I'm using version 5.0.67 and have a strange problem. I have a text field
and have a query which returned 193 characters (with spaces). In the mySQL
query browser I can see the field content fine.
However on my classic ASP page, I get nothing when I reponse the data to the
screen. Infact if
Hi Daevid,
You can always stop the query by running
SHOW PROCESSLIST;
from the command line or your MySql Admin tool. The above command will
show you all of the queries that are currently running along with
their PID# and state. Find the query your want to stop, and run the
following command
Hi
Thanks for the response. In fact my main requirement is to track the
queries executed in the event we have some data which has been contaminated
in some way - which will help us with our investigations. Basically I've
designed a brand new back end office - and feel I need to record the
Niel,
I don't use ASP, but it sounds more like a syntax error in your script.
http://classicasp.aspfaq.com/general/how-do-i-prevent-invalid-use-of-null-errors.html
However, if you're still having problems, please give us the exact query you're
running, the table structure, and the Code snippet
We have a NOC that displays this sort of thing and shows myTop in six
windows for DEV/TEST/PROD and Master/Slave for
each.(http://www.daevid.com/content/examples/snippets.php scroll down to
Automatic Monitoring of remote servers for a handy script)
So we do monitor this and will kill long running
my.cnf supports these timeout options
http://dev.mysql.com/doc/refman/5.1/en/mysql-options.html
connect-timeout=seconds
#innodb_lock_wait_timeout = 50
The timeout in seconds an InnoDB
transaction may wait for a row lock before giving up. The
default value is 50 seconds. A
It just seems odd to me that PHP does a mysql_connect and gets a resource
ID. Then it uses that socket (or whatever it is) to do subsequent queries.
Mysql has to know about it too in order for it to send back results to the
same resource/handle/socket/whatever. So either PHP should do some
11 matches
Mail list logo