please post your my.cnf settings becuase stats are useless without
knowing the configuration and without knowing your hardware (memory!)
nobody can say what buffers are making sense
i would use "mysqltuner.pl" because it shows in the most cases good advises
Am 05.05.2011 20:42, schrieb J M:
> Hi
Hi,
I have this stats: I have tuned some of it but I was wondering if someone
can give inputs regarding it:
*
__ Key _
Buffer used54.63M of 384.00M %Used: 14.23
Current 123.21M%Usage: 32.09
Write hit
>> CREATE TABLE log ( idlog int auto_increment not null, imepriimek
>> varchar(50), clock timestamp, action varchar(30), onfile
>> varchar(100), filesize float(6,2),
uniqueid(idlog) ); -- here is your mistake
the syntax for that should be 'unique key(idlog)' if you only wanted
to specify a
On Thu, May 5, 2011 at 10:29, Grega Leskovšek wrote:
> Can smbd please look at this sentence - I got an error and do not
> know how to fix it - I am still very unfamiliar with MYSQL:
>
> CREATE TABLE log ( idlog int auto_increment not null, imepriimek
> varchar(50), clock timestamp, action va
> Folks, I have no skin in this game whatsoever
same with me ^^^ .
...but I was just never sure what the OP meant by "mentor".
> "[...] take me under his or her wing [...]"
...seemed to imply wanting to hire someone to soften/expedite the $free
self-study process.
When I really look into peopl
>-Original Message-
>From: Nuno Tavares [mailto:nuno.tava...@dri.pt]
>Sent: Tuesday, May 03, 2011 6:21 PM
>To: mysql@lists.mysql.com
>Subject: Re: Join based upon LIKE
>
>Dear Jerry,
>
>I've been silently following this discussion because I've missed the
>original question.
>
>But from your
Folks, I have no skin in this game whatsoever; but I thought the original
question was reasonable (given that the person was new to the list), and I
thought the first answer was rude.
Regards,
Jerry Schwartz
Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796
2011/05/04 16:57 +0200, Rocio Gomez Escribano
I suppose my solution is an Join, but they have no intersection
Really?
Your examples are very much like a simple join, a special case of
... client OUTER JOIN user ON clientCodeDrivingLicense = userCodeDrivingLicense
What is wrong
Hi,
On 5-5-2011 0:52, Akachi Pictures wrote:
perhaps u misinterpreted. didn't get angry. just moved on :)
The reason why you get some surprised messages on the list is because we
see the following:
May 4th 19:06 - your first message about a mentor
May 4th 19:57 - a reply by Claudio explaini