Re: Input needed...

2011-05-05 Thread Reindl Harald
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

Input needed...

2011-05-05 Thread J M
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

Re: [PHP] mysql error

2011-05-05 Thread Michael Dykman
>> 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

Re: [PHP] mysql error

2011-05-05 Thread Daniel Brown
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

Re: DBA Mentor?

2011-05-05 Thread Govinda
> 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

RE: Join based upon LIKE

2011-05-05 Thread Jerry Schwartz
>-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

RE: DBA Mentor?

2011-05-05 Thread Jerry Schwartz
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

Re: RV: independent tables

2011-05-05 Thread Hal�sz S�ndor
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

Re: DBA Mentor?

2011-05-05 Thread Jigal van Hemert
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