RE: Mysql Table Case

2002-08-15 Thread Nilesh Shah
Answer is No. Case-sensitivity of table names depends on operating system you are running mysql on.MySQL stores table definitions in TABLENAME.* files. So it will always be case-sensitive on *nix and case-insensitive on windows. Nilesh -Original Message- From: James Kelty [mailto:[EMAIL

RE: Replication from InnoDB -> MyISAM

2002-07-15 Thread Nilesh Shah
I am sorry. I should have paid more attention to Heikki email. Nilesh -Original Message- From: Philip Molter [mailto:[EMAIL PROTECTED]] Sent: Monday, July 15, 2002 2:43 PM To: Nilesh Shah Cc: [EMAIL PROTECTED] Subject: Re: Replication from InnoDB -> MyISAM On Mon, Jul 15, 2002 at

RE: Replication from InnoDB -> MyISAM

2002-07-15 Thread Nilesh Shah
How does transaction works in this scenario?. Is rollbacked transaction written into bin-log files?. Nilesh -Original Message- From: Heikki Tuuri [mailto:[EMAIL PROTECTED]] Sent: Monday, July 15, 2002 1:30 PM To: Philip Molter; [EMAIL PROTECTED] Subject: Re: Replication from InnoDB -> My

RE: Replication slave repeatedly gets error 1159 from master

2002-07-15 Thread Nilesh Shah
Check the list. This question has been asked before many time. You can set net_read_timeout variable to bigger value to avoid this problem. Still no one knows (or answered) impact of net_read_timeout and wait_timeout. which one takes precedence. Nilesh -Original Message- From: Santia

RE: Goodday

2002-07-12 Thread Nilesh Shah
This is funny, but my email regarding replication slave disconnect error in 3.23.51 was bounced back as Spam and asked me to add sql,query in message. Whereas, Spam like this goes unnoticed. Nilesh -Original Message- From: Njamba [mailto:[EMAIL PROTECTED]] Sent: Friday, July 12, 2002 5

RE: mysql replication

2002-07-10 Thread Nilesh Shah
No. You cann't have one slave connected to more than one master. Nilesh -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 09, 2002 10:30 PM To: [EMAIL PROTECTED] Subject: mysql replication Hi All, I have 3 mysql servers with Red Hat 7.2 as the O

RE: Replication - Error reading packet from server: (server_errno=1159)

2002-07-10 Thread Nilesh Shah
Set variable net_read_timeout to some bigger value. http://www.mysql.com/doc/S/H/SHOW_VARIABLES.html Nilesh Shah -Original Message- From: Mark Hughes [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 10, 2002 3:36 AM To: [EMAIL PROTECTED] Subject: Replication - Error reading packet

RE: verification upon update, help, please

2002-07-03 Thread Nilesh Shah
What happens if you put third TIMESTAMP column.?. Will that be updated?. Just curios. Nilesh -Original Message- From: Paul DuBois [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 03, 2002 12:42 PM To: Paul Tomsic; [EMAIL PROTECTED] Subject: Re: verification upon update, help, please A

RE: er diagramming

2002-07-01 Thread Nilesh Shah
PowerDesigner from Sybase is awesome. Nilesh -Original Message- From: Bill Bernat [mailto:[EMAIL PROTECTED]] Sent: Monday, July 01, 2002 3:25 PM To: [EMAIL PROTECTED] Subject: er diagramming ERwin, in which I did the logical data model for a MySQL database, doesn't support MySQL data t

RE: Multiple Network Interface

2002-06-27 Thread Nilesh Shah
Thanks all -Original Message- From: Joseph Bueno [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 27, 2002 10:56 AM To: Nilesh Shah Cc: [EMAIL PROTECTED] Subject: Re: Multiple Network Interface Nilesh Shah wrote: > We are setting up three MySQL server (on separate machines) with

Multiple Network Interface

2002-06-27 Thread Nilesh Shah
We are setting up three MySQL server (on separate machines) with one master and two slave servers. All the machines has two network interface. We want to create Private network between three machines only to route replication traffic. Can MySQL use multiple network interface on machine?. Than

MySQL DBA wanted

2002-06-11 Thread Nilesh Shah
> Sorry for Job posting. Looking at the popularity of MySQL it would be > better if there is separate mailing list for Job Offered/Wanted for > MySQL. > > We are SIP based VoIP company located in Edision,NJ,USA looking for > MySQL DBA with 1-2 years of solid MySQL experience. Experience with

RE: mysqld refusing connections while getting sloooow

2002-06-11 Thread Nilesh Shah
I think increasing memory and giving more memory to MySQL would help. Nilesh -Original Message- From: Jared Richardson [mailto:[EMAIL PROTECTED]] Sent: Tuesday, June 11, 2002 1:48 PM To: Stefan Hinz; [EMAIL PROTECTED] Subject: Re: mysqld refusing connections while getting slw We'v

RE: 45 seconds

2002-06-10 Thread Nilesh Shah
Try using LIKE instead of regexp and create index on HOST_NAME if not present. Nilesh -Original Message- From: Chris Knipe [mailto:[EMAIL PROTECTED]] Sent: Monday, June 10, 2002 1:24 PM To: Elsad YUSIFLI; [EMAIL PROTECTED] Subject: Re: 45 seconds I have multiple tables on a 166MMX wi