Cc: mysql
Subject: Re: Does mysql cache strip out /* comments */ first?
Given that even spacing is important, it's a safe bet that it takes comments
into consideration, too.
Easily tested, though: grab one of the heaviest queries you have from your
slowlog, and execute with identical
On Thu, Nov 18, 2010 at 9:00 AM, andrew.2.mo...@nokia.com wrote:
I think you will probably find that the code you write isn't what MySQL
executes or stores in the cache.
it is indeed not quite what it executes, but as I understand it the QC index
is *exactly* the string you send (well, hashed
Daevid,
snip
My concern is, my gut tells me that the built in mysql cache system is
dumb. And by that I mean, I suspect that mySQL isn't smart enough to
strip out comments from the SQL statement string BEFORE storing it as the
cache hash key (yet I have no facts either way to back it up
: Ewen Fortune [mailto:ewen.fort...@gmail.com]
Sent: Thursday, November 18, 2010 4:56 AM
To: Daevid Vincent
Cc: mysql
Subject: Re: Does mysql cache strip out /* comments */ first?
Daevid,
snip
My concern is, my gut tells me that the built in mysql
cache system is
dumb. And by that I
mysql cache strip out /* comments */ first?
Daevid,
snip
My concern is, my gut tells me that the built in mysql
cache system is
dumb. And by that I mean, I suspect that mySQL isn't
smart enough to
strip out comments from the SQL statement string BEFORE
storing it as the
cache hash key
Message-
From: Ewen Fortune [mailto:ewen.fort...@gmail.com]
Sent: Thursday, November 18, 2010 4:56 AM
To: Daevid Vincent
Cc: mysql
Subject: Re: Does mysql cache strip out /* comments */ first?
Daevid,
snip
My concern is, my gut tells me that the built in mysql
cache system is
dumb
is, my gut tells me that the built in mysql cache system is
dumb. And by that I mean, I suspect that mySQL isn't smart enough to
strip out comments from the SQL statement string BEFORE storing it as the
cache hash key (yet I have no facts either way to back it up and hence the
reason for this email
that SQL, etc.
My concern is, my gut tells me that the built in mysql cache system is
dumb. And by that I mean, I suspect that mySQL isn't smart enough to
strip out comments from the SQL statement string BEFORE storing it as the
cache hash key (yet I have no facts either way to back it up
UPDATE my_table
SET my_column = TRIM(my_column),
my_other_column = TRIM(my_other_column)
etc...
Dave Merrill
Is it possible to remove all trailing and leading spaces for selected
fields once the data has already been loaded?
Steve
--
MySQL General Mailing List
For list archives:
Is it possible to remove all trailing and leading spaces for selected
fields once the data has already been loaded?
Steve
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
On Thu, Dec 04, 2003 at 10:33:17AM -0500, Brent Baisley wrote:
Actually, you want to try to match the stripe size to your data size.
The ideal would be to have a stripe size equal to the size of a record
in your database. This way the disk needs only one read or write for
each database
,
Please comment on the validity of my logic:
In setting the RAID(10/2disks) strip size everything I read says you
must
benchmark your particular system. Since that is not an option, my
current
logic is to have a large strip size (1024) with the reasoning that
fewer
writes/reads (yet longer writes
Greetings Mysqlians,
Please comment on the validity of my logic:
In setting the RAID(10/2disks) strip size everything I read says you must
benchmark your particular system. Since that is not an option, my current
logic is to have a large strip size (1024) with the reasoning
I use Perl/DBI with MySQL and I'm trying to find a way to sort email
addresses by domain. I would assume there is probably an option in MySQL
to strip off the text after the '@' sign that will allow me to sort on.
In Perl:
@fields = split(/@/, $email);
My domain would be displayed as: $fields[1
Hi,
On Fri, 2002-05-03 at 02:43, Andrew Kuebler wrote:
I use Perl/DBI with MySQL and I'm trying to find a way to sort email
addresses by domain. I would assume there is probably an option in MySQL
to strip off the text after the '@' sign that will allow me to sort on.
In Perl:
@fields
Marcelo wrote:
Can someone tell me how i can get(or
can someone send me) the strip command
for SCO Open Server 5.0.5?
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http
Can someone tell me how i can get(or
can someone send me) the strip command
for SCO Open Server 5.0.5?
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com
17 matches
Mail list logo