long login times?

2009-01-05 Thread Jed Reynolds
I've started logging how long my php application takes to login to mysql, and often it's well below 1 millisecond. However, I'll sometimes get a wave of long login attempts that take 3 to 6 seconds. I've enabled skip-name-resolv, and I think that helps. There are no long running queries on the

Re: how to design book db

2009-01-05 Thread mos
At 05:05 PM 1/5/2009, you wrote: mos wrote: > At 08:17 AM 12/29/2008, you wrote: >> I am rather fresh to MySQL and am trying to fix and update a website >> - modifying from just plain html to css, php and MySQL. I'm working >> on FreeBSD 7.0, MySQL 5.1,30, PHP5.28 & Apache 2.2.11. >> I need figur

RE: how to design book db

2009-01-05 Thread bruce
right... forgot about that! -Original Message- From: Paul Wilson [mailto:hoo...@staff.iinet.net.au] Sent: Monday, January 05, 2009 5:59 PM To: 'bruce'; 'PJ'; 'mos' Cc: mysql@lists.mysql.com Subject: RE: how to design book db Recent books that I've looked at have 2 ISBN's - one the olde

RE: how to design book db

2009-01-05 Thread Paul Wilson
Recent books that I've looked at have 2 ISBN's - one the older 10 digit, and also the newer 13 digit version. Both printed on the same book (both on the back cover at the bottom and inside). Of course, a hard cover will have a different ISBN again. Hooker -- " If ignorance is bliss, politicians

RE: how to design book db

2009-01-05 Thread bruce
hey phil... are you sure that a book can have multiple ISBN numbers. I was under the impression that a book/version has a single ISBN number. care to share where you have derived your understanding... i believe bowkers/new jersy is responsible for allocating ISBN blocks for US authors/publishers

Re: how to design book db

2009-01-05 Thread PJ
mos wrote: > At 08:17 AM 12/29/2008, you wrote: >> I am rather fresh to MySQL and am trying to fix and update a website >> - modifying from just plain html to css, php and MySQL. I'm working >> on FreeBSD 7.0, MySQL 5.1,30, PHP5.28 & Apache 2.2.11. >> I need figure out how to set up (design) a data

about tables

2009-01-05 Thread Ahmet DÜLGAR
hi everyone my question is about tables i have lots of records i want to learn that if i slip my record. are the select run more fast for example table1 name surname place bb x xxx asdw sdfjsdx aqq asdasy aqq asdasy aqq asdasy aqq asdasy my que

Re: Binlog error

2009-01-05 Thread Olaf Stein
It is now submitted... Olaf http://bugs.mysql.com/41878 On 1/5/09 12:15 PM, "Santo Leto" wrote: > Hi! > >> And I have not submitted a report yet, I want to make sure this is really >> a >> bug first, which it increasingly seems to be... > > I've tried few days ago to repeat the bug as you

Re: Binlog error

2009-01-05 Thread Santo Leto
Hi! And I have not submitted a report yet, I want to make sure this is really a bug first, which it increasingly seems to be... I've tried few days ago to repeat the bug as you described it but I was not able. Please try to submit a bug report at bugs.mysql.com with all the necessary info t

Re: Binlog error

2009-01-05 Thread Olaf Stein
I have searched the bugs but not found anything that sounds like my problem. Where can I get information what the event_type means? And I have not submitted a report yet, I want to make sure this is really a bug first, which it increasingly seems to be... Thanks Olaf On 1/2/09 11:58 PM, "Baron

slave-skip-errors = 1048

2009-01-05 Thread Krishna Chandra Prajapati
Hi, If, I have started mysql server with --slave-skip-errors=1048 then this error will be logged into mysql error file or not. Thanks, Prajapati Krishna Chandra Prajapati