there is much less need for a cache than 'they' have.
> -Original Message-
> From: Johan De Meersman [mailto:vegiv...@tuxera.be]
> Sent: Monday, August 13, 2012 5:49 AM
> To: MID.night
> Cc: 673575760; mysql
> Subject: Re: Hi, how did u do de-emphasis of sql statements?
der how they do this?...>_;
: 2012??8??13??(??) 8:48
??: "MID.night"<693893...@qq.com>;
: "673575760"<673575...@qq.com>; "mysql";
: Re: Hi, how did u do de-emphasis of sql statements?
- Original Message -
> From
kit/Aspersa/Percona toolset does transform
SQL statements into their canonical form, though; so if you're looking for ways
to do that you can have a look at how it's done there.
--
Linux Bier Wanderung 2012, now also available in Belgium!
August, 12 to 19, Diksmuide, Belgium - http://
Hey man, I would like to ask a question about de-emphasis of sql statements? I
Mean mysql engines have to be aware of which two statements are exactly the same
Despite of variables?? values at runtime. Because in slow log, the execution
counter is
Maintained for each sql statement. De
I can't speak to the exact internals of MySQL, but in database practice
one *generally* uses prepared statements for two reasons:
1. Security
2. Speed
If your system is at all exposed to the outside world *and you at all
value your data*, your biggest concern should /absolutely/ be security.
To know the exact speed improvement ,you have to have a test yourself append
on your hardware mathine.
On Jan 15, 2008 11:39 PM, mos <[EMAIL PROTECTED]> wrote:
> At 11:25 AM 1/14/2008, Jay Pipes wrote:
> >Are you using the PREPARE STATEMENT server-side syntax or an emulated
> >prepared statement
At 11:25 AM 1/14/2008, Jay Pipes wrote:
Are you using the PREPARE STATEMENT server-side syntax or an emulated
prepared statement like in PDO?
-jay
Jay,
Currently I'm not using prepared statements at all. Before I switch,
I wanted to know how much of a speed improvement I can expect, if
ried about that because there is no user input.
So have you (or anyone else) noticed a significant speed improvement using
parameters with MySQL 5?
TIA
Mike
--- On Mon, 1/14/08, mos <[EMAIL PROTECTED]> wrote:
> From: mos <[EMAIL PROTECTED]>
> Subject: Prepared SQL statements
Are you using the PREPARE STATEMENT server-side syntax or an emulated
prepared statement like in PDO?
-jay
mos wrote:
I would like to speed up my Select queries since I'm executing approx
5,000 of them, same syntax but the search values for 2 columns will
change with each query. Will I see an
;[EMAIL PROTECTED]>
> Subject: Prepared SQL statements - Faster performance?
> To: mysql@lists.mysql.com
> Date: Monday, January 14, 2008, 11:17 PM
> I would like to speed up my Select queries since I'm
> executing approx 5,000
> of them, same syntax but the search values for
I would like to speed up my Select queries since I'm executing approx 5,000
of them, same syntax but the search values for 2 columns will change with
each query. Will I see any performance increase if I prepare the statement
and use parameters? (I don't need to use the query cache since the resu
have a large batch of insert sql statements, of which some of them are
> > failing. I want to know which one is failing exactly.
> > Is there anyway I can debug it and which statement went wrong. I have
> only
> > 4 or 5 out of 200 statements that are failing.
> >
> It
On Friday 05 October 2007 16:50, Arun wrote:
> Baron,
> I am sourcing it. I do not know if that is the best way though.. I am
> running the insert statement from a mysql prompt in a linux/windows
> machine.
> My script has a single build script which sources other scripts.
> build.sql
> ==
> s
see last run errors, like some errors that
are saved in the buffer. As I know this is the last sql statement that gets
executed.
On 10/5/07, Baron Schwartz <[EMAIL PROTECTED]> wrote:
>
> Arun wrote:
> > I have a large batch of insert sql statements, of which some of them are
>
Arun wrote:
I have a large batch of insert sql statements, of which some of them are
failing. I want to know which one is failing exactly.
Is there anyway I can debug it and which statement went wrong. I have only
4 or 5 out of 200 statements that are failing.
It depends on how you're ru
I have a large batch of insert sql statements, of which some of them are
failing. I want to know which one is failing exactly.
Is there anyway I can debug it and which statement went wrong. I have only
4 or 5 out of 200 statements that are failing.
--
Thanks
Arun George
On 6/8/06, murthy gandikota <[EMAIL PROTECTED]> wrote:
I've checked the dump file I created with mysqldump on a database sfg, and
it has statements like the following:
DROP VIEW IF EXISTS `advAPI`;
CREATE ALGORITHM=UNDEFINED VIEW `sfg`.`advAPI` AS select
`sfg`.`advertiser`.`advertiserid` AS
`ad
I've checked the dump file I created with mysqldump on a database sfg, and it
has statements like the following:
DROP VIEW IF EXISTS `advAPI`;
CREATE ALGORITHM=UNDEFINED VIEW `sfg`.`advAPI` AS select
`sfg`.`advertiser`.`advertiserid` AS
`advertiserid`,count(`sfg`.`cust`.`custid`) AS `api` from
Moeller, Thorsten, AO wrote:
Hi,
is there a possibility to collect the sql statements issued to a mysql
db to analyse them??
perhaps there is an extra tool or script for this??
Thanks for any suggestions!
I don't know about collecting all queries, but we're doing this in
> Hi,
>
> is there a possibility to collect the sql statements issued to a mysql
> db to analyse them??
>
> perhaps there is an extra tool or script for this??
>
> Thanks for any suggestions!
>
>
>
eller, Thorsten, AO [mailto:[EMAIL PROTECTED]
Sent: Wednesday, January 25, 2006 9:15 AM
To: mysql@lists.mysql.com
Subject: Collect SQL Statements
Hi,
is there a possibility to collect the sql statements issued to a mysql db to
analyse them??
perhaps there is an extra tool or script for this??
Thank
Hi,
is there a possibility to collect the sql statements issued to a mysql
db to analyse them??
perhaps there is an extra tool or script for this??
Thanks for any suggestions!
Tried the build 5.0.2-alpha-nt:
select 'te\''st' returns "te''t"
and
select 'te\'''st' causes a fast server crash:
-ken
(the function symbols are missing so a stacktrace is a bit hard)
Application exception occurred:
App: (pid=1188)
When: 12/17/2004 @ 09:07:05.253
Exception
Thanks!!! Yes, I found the bug on it, but it looks like its not working
yet Is the bug simply no updated to show the fix perhaps?
ken
Sergei Golubchik wrote:
Hi!
On Dec 17, Sergei Golubchik wrote:
On Dec 16, Ken Johanson wrote:
Hi all,
Does anyone know fo a way to run the server in more of a
Hi!
On Dec 17, Sergei Golubchik wrote:
> On Dec 16, Ken Johanson wrote:
> > Hi all,
> >
> > Does anyone know fo a way to run the server in more of a string-quoting
> > standards compliant mode, so that a generic SQL string quoting function
> > only has to escape single quotes, instead of also '
Hi!
On Dec 16, Ken Johanson wrote:
> Hi all,
>
> Does anyone know fo a way to run the server in more of a string-quoting
> standards compliant mode, so that a generic SQL string quoting function
> only has to escape single quotes, instead of also '"', '\', and '\0'?
>
> I've tried the ANSI_QUO
Hi all,
Does anyone know fo a way to run the server in more of a string-quoting
standards compliant mode, so that a generic SQL string quoting function
only has to escape single quotes, instead of also '"', '\', and '\0'?
I've tried the ANSI_QUOTES startup option, but that apparently only
chang
You rock!! Worked perfectly
On Aug 25, 2004, at 4:31 PM, Rhino wrote:
- Original Message -
From: "David Souza" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, August 25, 2004 7:18 PM
Subject: Question about SQL statements..
So I have all of th
- Original Message -
From: "David Souza" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, August 25, 2004 7:18 PM
Subject: Question about SQL statements..
> So I have all of this years apache access logs in a huge DB table, most
> of
So I have all of this years apache access logs in a huge DB table, most
of what I wanted to get out is working fine, but I am trying to get top
10 requests (hits) by day inside a certain section of the hierarchy,
but I can't seem to get the correct results.
I have been trying many different
Thanks Shawn!
Marty Gainty
(cell) 617-852-7822
From: [EMAIL PROTECTED]
To: "Martin Gainty" <[EMAIL PROTECTED]>
CC: [EMAIL PROTECTED]
Subject: Re: Optimising SQL Statements
Date: Fri, 25 Jun 2004 12:59:28 -0400
MIME-Version: 1.0
Received: from lists.mysql.com ([213.136.5
; To: [EMAIL PROTECTED]
> Subject: Optimising SQL Statements
>
> Hello All:
>
> I have a very simple test procedure
>
> PROCEDURE TEST_PROCEDURE AS
> BEGIN
>
> DELETE FROM X;
> COMMIT;
>
> INSERT INTO X (column1)
> SELECT
> Y.y_id
> FROM
>
cc:
Fax to:
06/25/2004 12:43 Subject: Optimising SQL Statements
Hello All:
I have a very simple test procedure
PROCEDURE TEST_PROCEDURE AS
BEGIN
DELETE FROM X;
COMMIT;
INSERT INTO X (column1)
SELECT
Y.y_id
FROM
Y_TABLE Y
WHERE
Y.y_id NOT IN (select Y.y_id FROM TABLEY2);
COMMIT;
END;
this very simple procedure takes 5 min 30 sec to complete its very basic
delet
> -Message d'origine-
> De : brent [mailto:[EMAIL PROTECTED]
> Envoyé : Thursday, January 22, 2004 4:50 PM
> À : [EMAIL PROTECTED]
> Objet : large SQL statements
>
>
> Everyone,
>
> I downloaded Backup Watcher for MySQL today and am trying a
> f
Hi,
> Is there a more practical way to execute a statement of
> this size, or another program that will handle remote
> server backups differently?
You might use mysql.exe client (found in 'c:\mysql\bin'
folder):
mysql.exe -u your_username -p http://lists.mysql.com/mysql
To unsubscr
Everyone,
I downloaded Backup Watcher for MySQL today and am trying a few tests. I
created one backup from a remote server, but the SQL statement Backup
Watcher generated is over 20 megs, making it a little difficult (at least
for me) to process. I'm running a W2K-SP4 setup, MySQL 3.23.49. I'm
"Kim G. Pedersen" <[EMAIL PROTECTED]> wrote:
>
> How can I see the lastest Sql Commands/statements which
> has been send to my mySql server ??
>
> Are there Any Logfile or command to use ???
Yes, you can check log file. You can enabled general query log with --log option of
mysqld.
--
For t
Hello
How can I see the lastest Sql Commands/statements which
has been send to my mySql server ??
Are there Any Logfile or command to use ???
Thanks in advance
Kim G. Pedersen
macaos/elprint Development
+45 35373808
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mys
As far as I'm aware, in php you can only do one statement per call.
Terry
--Original Message-
> Hi there,
>
> When i try to do the following in PHP I get errors. Is this not
> permitted or is this due to a setting somewhere? Can i do only one SQL
> statement per call to mysq
"Edison Cneeden" <[EMAIL PROTECTED]> wrote:
> Hi there,
>
> When i try to do the following in PHP I get errors. Is this not permitted or
> is this due to a setting somewhere? Can i do only one SQL statement per call
> to mysql_query?
Yes.
>
> $sql = "CREATE TEMPORARY TABLE tmp
> SELECT field1
Hi there,
When i try to do the following in PHP I get errors. Is this not permitted or
is this due to a setting somewhere? Can i do only one SQL statement per call
to mysql_query?
$sql = "CREATE TEMPORARY TABLE tmp
SELECT field1_index, field2_index FROM test_table WHERE field1_index = '1';
INSE
From: "Daniel Wetzler" <[EMAIL PROTECTED]>
To: "MySQL Mailing Liste" <[EMAIL PROTECTED]>
Sent: Wednesday, January 15, 2003 11:54 AM
Subject: Problem using the C-API for MySQL Program breakdown after about 1
Mio SQL-statements
Hallo,
I apologize for my bad engli
ECTED]
[EMAIL PROTECTED]
- Original Message -
From: "Daniel Wetzler" <[EMAIL PROTECTED]>
To: "MySQL Mailing Liste" <[EMAIL PROTECTED]>
Sent: Wednesday, January 15, 2003 11:54 AM
Subject: Problem using the C-API for MySQL Program breakdown after
rbindung hat nicht geklappt.\n");
}
printf ("Datenbankverbindung 1 ok\n");
while(ergebnisarray[zaehler] != NULL) {
/*printf ("zahl = %i\n", ergebnisarray[zaehler]);*/
j=read_coor(ergebnisarray[zaehler]);
/* This is my fuction which sends the
FlashGuy wrote:
What SQL statements do I have to use to get the following results?
http://www.google.com ... "sql query howto" ...
--
Michael T. Babcock
C.T.O., FibreSpeed Ltd.
http://www.fibrespeed.net
Hi,
What SQL statements do I have to use to get the following results?
I have a preferences page that lists directories with check boxes. This is displaying
by querying my database. It looks something like this:
Preferences: (Click to omit directories from listing)
[ ] dir1
[ ] dir2
Owain,
Sunday, September 22, 2002, 8:37:55 PM, you wrote:
OM> Is there an easy way to turn logging or SQL statement executions on or off without
having to restart with a changed my.cnf file? Just want to log queries to try and
sort out some performance
OM> problems.
Nope.
--
For technica
Is there an easy way to turn logging or SQL statement executions on or off without
having to restart with a changed my.cnf file? Just want to log queries to try and
sort out some performance problems.
Thanks,
O.
(sql)
-
The mysql command line client can accept batch files as:
mysql -uuser -ppassword database < file.sql
file.sql is just a file with the plain text SQL statements in it that you
want to run.
Then since you are on Windows 2000, you could setup Task Scheduler to run it
every night at whatever t
I want to write a batch file of sql statements so that I can schedule
this batch file to run at night automatically and send the sql commands
to a mysql database on a Win2K server. Does anybody have any experience
doing this? Any pointers in the right direction would be much
appreciated.
Tab
t; <[EMAIL PROTECTED]>
Date: Sat, 04 May 2002 16:36:33 +0300
To: [EMAIL PROTECTED]
Subject: Re: Parsing SQL statements
> Thanks for your reply.
> I meant the second, to check the query whether it can be executed
> succesfully.
> Seems transactions are needed, is there any
Just to make sure I understand you, you need to check the sql statements themselves
for errors. Is this correct?
Or, do you instead need to check that a query ran with success?
Late on,
BDKR
- Original Message -
From: "mustafa karabulut" <[EMAIL PROTECTED]>
Date: Sat
=d0Mi=
DCS.net
[EMAIL PROTECTED]
> mustafa karabulut wrote
> Hello,
>
> I need sql statements parsed before they are sent to be queried. I
> know-though I am not sure- mysql does these steps:
> 1-Parse sql statement,check for errors
>
> 2-execute the stat
Hello,
I need sql statements parsed before they are sent to be queried. I
know-though I am not sure- mysql does these steps:
1-Parse sql statement,check for errors
2-execute the statement
Is there a way to intrude in between step1 and step2 so that we could get
sql statement parsed without
PM
To: Gerald R. Jensen
Cc: [EMAIL PROTECTED]
Subject:Re: Multi Line SQL Statements
It's The MySQL Control Center program.
I can take and save the sql statements from Mycc to a text file and
call "MySql > c:\sql.txt" and it runs fine...
wierd
"Gerald R.
Hi !!
> -Original Message-
> From: Michael Grover [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, April 24, 2002 5:51 PM
> To: Gerald R. Jensen
> Cc: [EMAIL PROTECTED]
> Subject: Re: Multi Line SQL Statements
>
>
> It's The MySQL Control Center progra
It's The MySQL Control Center program.
I can take and save the sql statements from Mycc to a text file and
call "MySql > c:\sql.txt" and it runs fine...
wierd
"Gerald R. Jensen" wrote:
>
> Michael ...
>
> Works for me ... at the console:
>
> m
L with same results.
How are you entering a multiple SQL statement?
Gerald Jensen
- Original Message -
From: "Michael Grover" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, April 24, 2002 6:59 PM
Subject: Multi Line SQL Statements
I have a dumb Questi
I have a dumb Question...
When I try to enter a Multiple line SQL statement like:
create table ZIPSTA2 (zip char(5), state char(2)) ;
create table ZIPSTATES (state char(2), zip char(5));
I get this error:
[root@localhost:3306] ERROR 1064: You have an error in your SQL syntax
near '; create t
[EMAIL PROTECTED]
cc:
Subject: RE: Saving and re-using SQL statements
Hi Neal,
I am not clearly understanding your question , do you mean that you have
some variables in your queries??
Normally you would just save your query in a file and either run it in
the shell command line in batch mode with
-
From: Neal Caidin [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 16, 2002 3:14 PM
To: [EMAIL PROTECTED]
Subject: Saving and re-using SQL statements
Hi All,
I am a little more familiar with Oracle environments where I can "save" and
"get" SQL statements that I formulate. How
Hi All,
I am a little more familiar with Oracle environments where I can "save" and
"get" SQL statements that I formulate. How do I do this from within MySQL?
I've tried editing my query, with vi, and then saving it using vi's w
filename command, but I can't
I am using the 'C' API and would like to be able to be able to get
information on columns involved in a SELECT statement without executing the
statement. I am also using placeholders.
An example of what I would like to get info on (but not execute) is:
SELECT col1 from table1 where col2
>> I would like to send multiple SQL statements using the C
>> API mysql_query. I have a large string with 20 SQL statements. When
>> I call mysql_query with that string, only the first one is processed.
>>
>> Is there a way to do what I'm doing withou
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
hi,
On Tue, 20 Nov 2001, Anna Winkler wrote:
> I would like to send multiple SQL statements using the C
> API mysql_query. I have a large string with 20 SQL statements. When
> I call mysql_query with that string, only the first one is
Hi,
I would like to send multiple SQL statements using the C
API mysql_query. I have a large string with 20 SQL statements. When
I call mysql_query with that string, only the first one is processed.
Is there a way to do what I'm doing without separating the statements
into individual cal
lto:[EMAIL PROTECTED]]
Sent: Sunday, May 13, 2001 2:13 PM
To: [EMAIL PROTECTED]
Subject: SQL Statements
Hi there
I have run into a problem, I have changed all my code from using ADO and
MSACCESS to SQL statements using the MYSQL API, however, some of my fields
have a single quotation in them, an
Hi there
I have run into a problem, I have changed all my code from using ADO and
MSACCESS to SQL statements using the MYSQL API, however, some of my fields
have a single quotation in them, and now this interfears with my syntax and
I am getting problems, is there a way to overcome this? I know
Hi,
I was wondering if MySQL allows the ability to perform a SQL Prepare on sql
statements prior to performing an execute.
I'm using ADO on Windows and with a CommandPtr object, you can set a
property called "Prepared", that will attempt to prepare sql statements and
will keep th
>Description:
We have just upgraded from 3.22.26a to 3.23.33. One table has a column
name "FullText". However, any SQL statements (either using PHP or the command
line interface) that directly reference the column will cause an SQ
71 matches
Mail list logo
