Percona :o)
> So I think its best someone else chips in.
>
> Ewen
>
>>
>>> -Original Message-
>>> From: Ewen Fortune [mailto:ewen.fort...@gmail.com]
>>> Sent: Thursday, November 18, 2010 4:56 AM
>>> To: Daevid Vincent
>>> Cc
November 18, 2010 4:56 AM
>> To: Daevid Vincent
>> Cc: mysql
>> Subject: Re: Does mysql cache strip out /* comments */ first?
>>
>> Daevid,
>>
>>
>> > My concern is, my gut tells me that the built in mysql
>> cache system is
>> > "
quot; from it?
> -Original 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,
>
>
> > My conc
Daevid,
> 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 h
On Thu, Nov 18, 2010 at 9:00 AM, 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 presumably), includin
ncent
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 ide
...
>
> What I'd REALLY like to do is add more information in there. Perhaps add
> the FUNCTION/METHOD and the logged-in web USER that is actually executing
> that SQL, etc.
>
> My concern is, my gut tells me that the built in mysql cache system is
> "dumb". An
USER that is actually executing
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
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: h
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
enetwork.com wrote:
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 reason
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
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
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 displaye
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/
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
* Soren Ragsdale <[EMAIL PROTECTED]> wrote on 11.01.01 11:30:
> SELECT comics.tagline,votes.score FROM comics,users LEFT OUTER JOIN
> votes ON comics._rowid=votes.comic AND votes.voter=30 WHERE
> users._rowid=comics.author;
I would try the simpler inner join to get the result you want:
SELECT co
Well, I run an online comic strip at http://www.monkeydyne.com/rmcs/
I've done so for three years now, and this is the first time I've been
stumped enough to ask the mysql list for help.
On the site, users can submit their own comics and they can vote on
other people's
19 matches
Mail list logo
