Re: Minor collation question

2012-06-13 Thread Johan De Meersman
- Original Message - From: Shawn Green shawn.l.gr...@oracle.com 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

Re: i need advice on redundancy of mysql server.

2012-06-13 Thread Johan De Meersman
- Original Message - From: Joey L mjh2...@gmail.com 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

Re: Aborted clients

2012-06-13 Thread Johan De Meersman
- Original Message - From: Claudio Nanni claudio.na...@gmail.com @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

Re: Aborted clients

2012-06-13 Thread Claudio Nanni
2012/6/13 Johan De Meersman vegiv...@tuxera.be - Original Message - From: Claudio Nanni claudio.na...@gmail.com @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

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 claudio.na...@gmail.comwrote: 2012/6/13 Johan De Meersman vegiv...@tuxera.be - Original Message - From: Claudio Nanni claudio.na...@gmail.com

Re: Aborted clients

2012-06-13 Thread Johan De Meersman
- Original Message - From: Claudio Nanni claudio.na...@gmail.com 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

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

Re: NoSQL help

2012-06-13 Thread Johan De Meersman
- Original Message - From: Manivannan S. manivanna...@spanservices.com 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?

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

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

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 rja...@yahoo-inc.com 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

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

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

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

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 To:

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: