RE: Foreign key and uppercase / lowercase values

2012-06-13 Thread Rick James
To discuss this further, please provide SHOW CREATE TABLE for the table in question and the table(s) tied to it via FOREIGN KEYs. > -Original Message- > From: GF [mailto:gan...@gmail.com] > Sent: Tuesday, June 12, 2012 6:20 AM > To: Shawn Green > Cc: mysql@lists.mysql.com > Subject: Re: F

RE: Minor collation question

2012-06-13 Thread Rick James
A warning about β -- There was a change in the collation at 5.1.24. Search http://mysql.rjweb.org/doc.php/charcoll for 'German'; there is a brief discussion near the end. > -Original Message- > From: Johan De Meersman [mailto:vegiv...@tuxera.be] > Sent: Wednesday, June 13, 2012 2:26 AM >

RE: i need advice on redundancy of mysql server.

2012-06-13 Thread Rick James
I prefer: * Master-Master ("dual master") but write to only one of them. (Writing to both can lead to duplicate keys, etc., unless you are very careful in your code.) * Have the two Masters geographically separate. (Think tornados, floods, earthquakes, etc) * Have Slave(s) hanging of each mast

Re: i need advice on redundancy of mysql server.

2012-06-13 Thread Prabhat Kumar
Does really Master-Master replication provide load balancing feature? since, each node need to replicate to other node, and MySQL replication still a is single threaded replication , it mean there is only single replication thread sql_thread for DML queries. eg. There is two node with master mas

is it quiet out there?

2012-06-13 Thread hsv
** Scanned by MailScan AntiVirus and Content Security Software. Visit http://www.escanav.com for more info on eScan and X-Spam. ** -- MySQL General Mailing List For list arch

Re: NoSQL help

2012-06-13 Thread Ananda Kumar
Did you try with myisam tables. They are supposed to be good for reporting requirement On Wed, Jun 13, 2012 at 11:52 PM, Rick James wrote: > I'll second Johan's comments. > > "Count the disk hits!" > > One minor change: Don't store averages in the summary table; instead > store the SUM(). That

RE: NoSQL help

2012-06-13 Thread Rick James
I'll second Johan's comments. "Count the disk hits!" One minor change: Don't store averages in the summary table; instead store the SUM(). That lets you get the mathematically correct AVERAGE over any time range via SUM(sum_foo) / SUM(count_foo) Switching between MySQL and Mongo requires rew

Re: NoSQL help

2012-06-13 Thread mos
At 07:27 AM 6/13/2012, Manivannan S. wrote: Hi all, I am using MySQL 5.1, in this I am inserting 5GB of data for two days into my database. I am trying to generate a report by processing these data which are available in my database. Our clients are planning to keep the record

Re: NoSQL help

2012-06-13 Thread Johan De Meersman
- Original Message - > From: "Manivannan S." > > Hi all, > > [lots of data] > [slow reports] > [wooo NoSQL magic] Not that I want to discourage you, but my standard first question is "why do you think NoSQL (let alone any specific product) is the right solution?" :-) Don't get me wro

NoSQL help

2012-06-13 Thread Manivannan S.
Hi all, I am using MySQL 5.1, in this I am inserting 5GB of data for two days into my database. I am trying to generate a report by processing these data which are available in my database. Our clients are planning to keep the records for 60 days then that will cross 150GB of da

Re: Aborted clients

2012-06-13 Thread Johan De Meersman
- Original Message - > From: "Claudio Nanni" Sigh. Because the application gets unstable when the connection falters, the Unix boys have a kill-and-restart script in place - so any number of the messages in the log may be due to that. Don't you love these complex environments :-) /m

Re: Aborted clients

2012-06-13 Thread Ananda Kumar
is iptables service running on db server, if yes, trying stopping it and check On Wed, Jun 13, 2012 at 5:04 PM, Claudio Nanni wrote: > 2012/6/13 Johan De Meersman > > > > > - Original Message - > > > From: "Claudio Nanni" > > > > > > @Johan, you say "I'm having trouble with clients abor

Re: Aborted clients

2012-06-13 Thread Claudio Nanni
2012/6/13 Johan De Meersman > > - Original Message - > > From: "Claudio Nanni" > > > > @Johan, you say "I'm having trouble with clients aborting, but for > > some reason they don't get logged." > > Ah, it *did* start logging, now, and they come from multiple applications, > too. > > 1206

Re: Aborted clients

2012-06-13 Thread Johan De Meersman
- Original Message - > From: "Claudio Nanni" > > @Johan, you say "I'm having trouble with clients aborting, but for > some reason they don't get logged." Ah, it *did* start logging, now, and they come from multiple applications, too. 120612 12:19:09 [Warning] Aborted connection 1301914

Re: i need advice on redundancy of mysql server.

2012-06-13 Thread Johan De Meersman
- Original Message - > From: "Joey L" > > It sounds like you are all consultants. Hehe. I'm not :-p A lot are, though, because the combined technical knowledge on this list draws in consultants looking for stuff, and having experienced consultants on the list in turn heightens the com

Re: Minor collation question

2012-06-13 Thread Johan De Meersman
- Original Message - > From: "Shawn Green" > > The other tactical move has been to jump 5.1 and upgrade directly > from 5.0 to 5.5 where that problem is resolved. Sure, it's a bit more > work (full dump/restore is highly recommended) but it avoids the collation > bug which exists in all 5