 | | | MySQL General | | Frank
Frank Bottone wrote
> I 've been having trouble with my master/slave server - recently I was
> having a few repeated issues where the mysql slave would stop due to
> "invalid sql syntax " buI 've been having trouble with my master/slave server - recently I was
having a few repeated issues where the mysql slave would stop due to
"invalid sql syntax " but the queries executed fine on the stupid non-technical ?
does anyone know what the registration fee is going to be for the 2008
conference? my mgr needs a # today to put in next yr 's budget & I couldn 't
find it on the conference siOn Sat 06 Oct 2007 00 25 04 -0700 Werner Van Belle <werner@(protected) >
wrote
> Hello
>
> On Friday 05 October 2007 01 11 35 James Card wrote
> > The application I 'm working on uses MySQL 5.0.In the last episode (Oct 08) Ace said
> On 10/7/07 Dan Nelson <dnelson@(protected) > wrote
> > In the last episode (Oct 06) Ace said
> > > You all know the size problems with ibdata and log fI had a server crash over the weekend and discovered that I don 't know
as much about MySQL error logging as I thought. The error logs were
empty because of FLUSH LOGS.
What I learned today is if IHello guys
I would like to get some registers on my database that are older than 90
days and after delete it because the table is very larger
mysql > select count(*) from max_ecardsent
+---------Rajan
I believe you are talking about a NAS setup which is different from
the SAN configuration I was referring to. Check out
http //www.nas-san.com/differ.html for a quick comparison.
With NFOn table it is! -D
Thanks to all of you who helped me with my "problem ".
-afan
John Meyer wrote
> Afan Pasalic wrote
> > hi
> > I have a employees table (first name last_name address city
Yes Scott! Only thing that confused and still confusing me is the following
note on mysql site -
"*Note*
It is not a good idea to configure InnoDB to use datafiles or logfiles on
NFS volumes. OtherwiRajan
In a SAN configuration the lun/volume should appear just like a
locally attached physical disk on your server. MySQL will not need any
special configurations to access it just poiint the daHi
> I tried this
> CREATE TRIGGER username_check AFTER UPDATE ON `users`
> FOR EACH ROW
> UPDATE users SET users.username concat(users.firstname "
> " users.lastname) where users.id NEW.id Thanks Dan! We do know the permission problem. We tried chown but got "Not a
owner " error. That is because of "root squashing " in which root becomes
"nobody " when you cd to NFS directory.
To overcHi
Steffan A. Cline wrote
> on 10/7/07 12 26 PM Steffan A. Cline at steffan@(protected) wrote
>
> > I am new to triggers and am trying to figure this out. The goal I have is to
> > set it up so thatActually I have an somewhat reproducible test case.
Problem is it only works on my Server.
When I start MySQL it crashes almost exactly after one minute. This
happens every single time
Oct 7 21 on 10/7/07 12 26 PM Steffan A. Cline at steffan@(protected) wrote
> I am new to triggers and am trying to figure this out. The goal I have is to
> set it up so that after a row in the users table is I am new to triggers and am trying to figure this out. The goal I have is to
set it up so that after a row in the users table is updated it will check to
see if the affected row has a username in the Ananda Kumar wrote
> Hi All
> Today I installed mysql for debian OS.
>
> After the installation i started mysql using mysqld_safe &.
>
> Now if i try to connect to mysql using "mysql -uroot -p " itI did some more research
I ran "xfs_check " on the partition and it didn 't report any errors at
all so I 'm guessing that the hard drives are ok.
I also recompiled MySQL with "--with-debug ".
How wHey guys
First of all I have tried to post this Issue on forums.mysql.com but
the Topic doesn 't appear in the Forum. When I try to post again it
tells me that it 's a duplicate?!?!
Now the realIn the last episode (Oct 06) Ace said
> Hi Experts
>
> You all know the size problems with ibdata and log files. We plan to
> move those files to SAN to have maximum storage possible. We didAfan Pasalic wrote
> hi
> I have a employees table (first name last_name address city state
> zip phone ...).
> though I got a requested to add additional info about people like
> phone_exHave you guys thought about trying to use a Federated table?
http //dev.mysql.com/doc/refman/5.0/en/federated-storage-engine.html
Probably not exactly the solution you want but maybe useful.
On 10/Hi Experts
You all know the size problems with ibdata and log files. We plan to
move those files to SAN to have maximum storage possible. We did so with
configuration changes in my.cnf files tHello
On Friday 05 October 2007 01 11 35 James Card wrote
> The application I 'm working on uses MySQL 5.0.41 and we also need to
> retrieve some data from a SQL-Server database in another departmeHi Steve
Steve Kiehl wrote
> I was a bit stumped on a good method to select the second record for
> each distinct group in a table. Say I have a table like the following
>
> NAME
> DATE
> I was a bit stumped on a good method to select the second record for
each distinct group in a table. Say I have a table like the following
NAME
DATE
AMOUNT
joe 2007-10-03 19 44 57 45
joe 2007A wise man once taught me "organization is the key to success ".
Put all the data in the same table you have. 200k people is nothing for
mySQL to handle and the cost of an extra JOIN is going to bI just want to see the original insert statement which failed so that I can
do a search on it.
Is there any option for seeing the insert statement that gets executed and
the error line next to next.?Unless you expect to have more than one set of "additional information " per
person then you should add the new fields to your existing records. Don 't
worry too much about space it doesn 't sound like |
|
|
