- 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
- 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
- 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
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
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
- 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
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
- 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?
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
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
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
**
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
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
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
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:
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:
16 matches
Mail list logo