On 16.12.2014 15:16, xiangdongzou wrote:
Can anyone tell me why 531808.11 has been changed to 531808.12 ?
typical decimal-binary-decimal conversion/rounding error.
If you want exact decimals you need to stick with the
DECIMAL type which doesn't have this problem, at the
cost of slower
Hello Chris,
Can pls you share the below command output...
SHOW STATUS LIKE 'Threads%';
SELECT @@thread_cache_size, @@net_buffer_length, @@max_allowed_packet;
What about the limits.conf config on operating system level?
-- WB, MySQL Oracle ACE
Em 07/12/2014, às 20:03, Chris Knipe
In some past experiences, firewall can add a small overhead in connection
establishment. If you're using iptables, you can try disable it for a second,
test the connection establishment to check if the overhead is being added by
the firewall and enable that afterwards.
Let us know how's it
Am 08.12.2014 um 14:04 schrieb Wagner Bianchi:
In some past experiences, firewall can add a small overhead in connection
establishment. If you're using iptables, you can try disable it for a second,
test the connection establishment to check if the overhead is being added by
the firewall and
On Mon, Dec 8, 2014 at 3:02 PM, Wagner Bianchi
wagnerbianch...@gmail.com wrote:
Hello Chris,
Can pls you share the below command output...
SHOW STATUS LIKE 'Threads%';
SELECT @@thread_cache_size, @@net_buffer_length, @@max_allowed_packet;
mysql SHOW STATUS LIKE 'Threads%';
Am 08.12.2014 um 14:56 schrieb Chris Knipe:
They have been dealt with. mySQL has 4096 file descriptors available.
Through all of this, not one single error is logged to the errorlog
either.
limits.conf:
mysql soft nofile 4096
mysql hard nofile 4096
that won't work well depending on the
Chris, thanks for you prompt reply. Try to raise up some configuration
regarding /etc/security/limits.conf
mysql soft nofile 10240
mysql hard nofile 40960
mysql soft nproc 10240
mysql hard nproc 40960
root soft nofile 10240
root hard nofile 40960
root soft nproc 10240
root hard nproc 40960
Very good share Reindl.
--
*Wagner Bianchi, MySQL Database Specialist*
Mobile: +55.31.8654.9510
E-mail: m...@wagnerbianchi.com
Twitter: @wagnerbianchijr
2014-12-08 12:05 GMT-02:00 Reindl Harald h.rei...@thelounge.net:
Am 08.12.2014 um 14:56 schrieb Chris Knipe:
They have been dealt
FYI - just an example...
mysql SELECT VERSION();
ERROR 2006 (HY000): MySQL server has gone away
No connection. Trying to reconnect...
Connection id:203720459
Current database: NNTP
+-+
| VERSION() |
+-+
|
...@mrbrklyn.com wrote:
On 11/24/2014 10:00 AM, Johan De Meersman wrote:
- Original Message -
From: Ruben Safir ru...@mrbrklyn.com
Subject: Re: MySQL dying?
Well, this mailing list is dead. This is a mailing list that used to
handle 70+ questions a day, or more.
Is that why you feel the need
2014/11/26 14:25 -0600, Peter Brawley
www.artfulsoftware.com/infotree/mysqltips.php,
And this page is an HTML hack, table for column ... generated by a (PHP?)
program?
*sigh*
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
- Original Message -
From: Ruben Safir ru...@mrbrklyn.com
Subject: Re: MySQL dying?
Well, this mailing list is dead. This is a mailing list that used to
handle 70+ questions a day, or more.
Is that why you feel the need to troll on posts from two years ago?
If you think it's
On Sun, Nov 23, 2014 at 08:31:24PM +0100, Heck, Walter wrote:
I watched a keynote from Thomas Ulin at Percona Live London a few weeks
back, and the slides are quite interesting:
https://www.percona.com/live/london-2014/sites/default/files/slides/PerconaLondon14_keynote.pdf
Well, this
On 11/24/2014 10:00 AM, Johan De Meersman wrote:
- Original Message -
From: Ruben Safir ru...@mrbrklyn.com
Subject: Re: MySQL dying?
Well, this mailing list is dead. This is a mailing list that used to
handle 70+ questions a day, or more.
Is that why you feel the need
- Original Message -
From: Ruben Safir ru...@mrbrklyn.com
Subject: Re: MySQL dying?
abandoned. What would you have done in those days when we handled so
much mail in this list that there was no time to answer trolls... the
real trolls?
We? You mean the two mails you sent back
, 2014 at 12:04 PM, Ruben Safir ru...@mrbrklyn.com wrote:
On 11/24/2014 10:00 AM, Johan De Meersman wrote:
- Original Message -
From: Ruben Safir ru...@mrbrklyn.com
Subject: Re: MySQL dying?
Well, this mailing list is dead. This is a mailing list that used to
handle 70
On 11/24/2014 12:19 PM, Johan De Meersman wrote:
- Original Message -
From: Ruben Safir ru...@mrbrklyn.com
Subject: Re: MySQL dying?
abandoned. What would you have done in those days when we handled so
much mail in this list that there was no time to answer trolls... the
real
On 11/24/2014 12:19 PM, Johan De Meersman wrote:
- Original Message -
From: Ruben Safir ru...@mrbrklyn.com
Subject: Re: MySQL dying?
abandoned. What would you have done in those days when we handled so
much mail in this list that there was no time to answer trolls... the
real
- Original Message -
From: Ruben Safir ru...@mrbrklyn.com
Subject: Re: MySQL dying?
where were you in 2000, youngerman?
Busy writing WAP backends powered out of MySQL and Oracle, if I remember
correctly :-) But, indeed, not on this list; and if you were here back then I
may have
De Meersman wrote:
- Original Message -
From: Ruben Safir ru...@mrbrklyn.com
Subject: Re: MySQL dying?
Well, this mailing list is dead. This is a mailing list that used to
handle 70+ questions a day, or more.
Is that why you feel the need to troll on posts from two years ago
I watched a keynote from Thomas Ulin at Percona Live London a few weeks
back, and the slides are quite interesting:
https://www.percona.com/live/london-2014/sites/default/files/slides/PerconaLondon14_keynote.pdf
There's a lot of haters (some with more valid reasons to hate, others with
little or
On Wed, Dec 05, 2012 at 12:41:09PM +0100, Johan De Meersman wrote:
- Original Message -
From: Anthony Pace anthony.p...@utoronto.ca
I have heard that due to Oracle taking over, the OS community is
shifting to other type of DB's .
I think the question has long been answered.
So I've done some more digging on this.
1. Upgraded to MySQL 5.5.37
2. Made sure we didn't have any old/long running transactions--nothing
more than a few seconds.
3. Did a dump/reload in to a new DB and started with an empty history
list. A few days later, we're back up over 3mil
Hi Brad,
-Original Message-
From: Brad Heller [mailto:b...@cloudability.com]
Sent: Sunday, 7 September 2014 03:07
To: MySQL General List
Subject: MySQL 5.5.33 History list not purging?
For some reason, the history list isn't purging on one of my masters. This is
causing all kinds
Am 06.09.2014 um 19:07 schrieb Brad Heller:
For some reason, the history list isn't purging on one of my masters. This
is causing all kinds of weird issues/behavior with reads
so why do you not just try to update first?
5.5.39 is recent and contains *a lot* of bufixes
look at the changelogs -
Good point. We'll try that out.
I noticed our ibdata file is gigantic now, likely due to the alter table
migration we ran. What's the relationship here, do you think?
*Brad Heller *| Director of Engineering | Cloudability.com | 541-231-1514 |
Skype: brad.heller | @bradhe
Wouldn't you run mysql_upgrade *before* upgrading? (ie: copy new stuff
onto old DB, *then* mysql_upgrade *then* start running new software?)
So I went to google, and realised that I’d probably upgraded without
running mysql_upgrade. So I try..
[~] john@server% (872) mysql_upgrade -u root -p
2014/06/20 11:31 +0100, Neil Tompkins
I'm using MySQL 5.6.17 on Amazon Web Services RDS and when calling SELECT
UUID_SHORT() I'm getting a number bigger than 9223372036854775807. For
example the number I get is
12057145185130250250
help uuid_short
Name: 'UUID_SHORT'
Description:
Syntax:
Edward , use following way
mysql -uroot -p -h{host ip }
else give grant privileges to localhost
On Mon, May 5, 2014 at 7:47 AM, EdwardKing zhan...@neusoft.com wrote:
I use mysql to create a database and grant rights to a user
hadooptest,then I use hadooptest to login mysql and use the
2014-05-05 4:17 GMT+02:00 EdwardKing zhan...@neusoft.com:
I use mysql to create a database and grant rights to a user
hadooptest,then I use hadooptest to login mysql and use the database,but it
failed. Why raise error after I grant rights? How to solve it? Thanks.
My operation is follows:
Am 05.05.2014 08:34, schrieb Manuel Arostegui:
% doesn't match localhost so if you don't specify it you will be
attempting to connect via Unix Socket.
If you don't want to specify -hlocalhost all the time, just do the grant
with @localhost instead of @%
nonsense
% matches *any host*
2014-05-05 10:00 GMT+02:00 Reindl Harald h.rei...@thelounge.net:
Am 05.05.2014 08:34, schrieb Manuel Arostegui:
% doesn't match localhost so if you don't specify it you will be
attempting to connect via Unix Socket.
If you don't want to specify -hlocalhost all the time, just do the grant
Am 05.05.2014 10:19, schrieb Manuel Arostegui:
2014-05-05 10:00 GMT+02:00 Reindl Harald h.rei...@thelounge.net
mailto:h.rei...@thelounge.net:
Am 05.05.2014 08:34, schrieb Manuel Arostegui:
% doesn't match localhost so if you don't specify it you will be
attempting to
2014-05-05 10:57 GMT+02:00 Reindl Harald h.rei...@thelounge.net:
Am 05.05.2014 10:19, schrieb Manuel Arostegui:
2014-05-05 10:00 GMT+02:00 Reindl Harald h.rei...@thelounge.netmailto:
h.rei...@thelounge.net:
Am 05.05.2014 08:34, schrieb Manuel Arostegui:
% doesn't match
Hi,
On 5-5-2014 10:57, Reindl Harald wrote:
Am 05.05.2014 10:19, schrieb Manuel Arostegui:
2014-05-05 10:00 GMT+02:00 Reindl Harald h.rei...@thelounge.net
mailto:h.rei...@thelounge.net:
Am 05.05.2014 08:34, schrieb Manuel Arostegui:
% doesn't match localhost so if you don't
Am 05.05.2014 11:12, schrieb Jigal van Hemert:
On 5-5-2014 10:57, Reindl Harald wrote:
Am 05.05.2014 10:19, schrieb Manuel Arostegui:
2014-05-05 10:00 GMT+02:00 Reindl Harald h.rei...@thelounge.net
mailto:h.rei...@thelounge.net:
Am 05.05.2014 08:34, schrieb Manuel Arostegui:
- Original Message -
From: Reindl Harald h.rei...@thelounge.net
i know that, but it does not change the fact that here
Either you didn't know that but have trouble admitting it; or you did but
conciously chose to be rude and condescending instead of helpful.
Your choice. In the
Am 05.05.2014 15:26, schrieb Johan De Meersman:
- Original Message -
From: Reindl Harald h.rei...@thelounge.net
i know that, but it does not change the fact that here
Either you didn't know that but have trouble admitting it; or you did but
conciously chose to be rude and
On 2014-05-04 9:17 PM, EdwardKing wrote:
I use mysql to create a database and grant rights to a user hadooptest,then I
use hadooptest to login mysql and use the database,but it failed. Why raise
error after I grant rights? How to solve it? Thanks.
The command sequence ...
mysql create
If you're doing this from the cmd-line client, try running it using --quick.
Best,
/ Carsten
On 19-02-2014 09:03, Machiel Richards wrote:
Hi guys
I am hoping that someone might have experienced this before or
might know why we are getting this.
We regularly need to run some
Hi,
the queries are done by connecting to the database using mysql
workbench or otherwise after ssh to server by using straight mysql
connection.
regards
On 19/02/2014 12:51, Carsten Pedersen wrote:
If you're doing this from the cmd-line client, try running it using
--quick. th
- Original Message -
From: Machiel Richards machiel.richa...@gmail.com
Subject: Mysql into outfile problem
- when we run an explain on the query it shows that it is
using indexes and the amount of rows it accesses is about 165000 rows
out of a 90mil+ rows table
Not
I have checked now and there is nothing in the Slow logs.
On 19/02/2014 15:33, Johan De Meersman wrote:
- Original Message -
From: Machiel Richards machiel.richa...@gmail.com
Subject: Mysql into outfile problem
- when we run an explain on the query it shows that it
- Original Message -
From: Machiel Richards machiel.richa...@gmail.com
Subject: Re: Mysql into outfile problem
I have checked now and there is nothing in the Slow logs.
It may be turned off, then. Depending on your version you can change the
settings without having to restart
I don't know what you mean by straight mysql connection. At any rate,
the idea is to use --quick or otherwise using a connection which uses
mysql_use_result over mysql_store_result.
http://dev.mysql.com/doc/refman/5.6/en/mysql.html
Best,
/ Carsten
On 19-02-2014 12:02, Machiel Richards
Hi Igor,
When MySQL 5.7 planned to be released as stable/production ready?
We do not provide planned release dates.
If I can recommend a video to watch about the release process, please watch
Tomas Ulin’s Percona Live keynote April 2013:
http://www.youtube.com/watch?v=OpHTV59I1gs
Watch from
Am 07.01.2014 13:48, schrieb Lukas Lehner:
Are there big changes between MySQL 5.0.0 vs. MySQL 5.6? I am only
interested in developer changes (not admin)
Can I use development books for MySQL 5.0.0 [2003] and use the code an
recent MariaDB and MySQL releases?
clearly yes
the *other
Am 01.01.2014 23:30, schrieb Elim Qiu:
I installed mysql 5.1 to windows 7 using mysql-5.1.73-winx64.msi and got
confused on how to relocate the datadir.
my basedir was F:/MySQL and datadir was F:/MySQL/data
It works fine and I'm trying to relocate the datadir:
(0) stop mysql service
Hi Russ,
Please share with us the exact details of the table data as well as the
o/p.
Regards,
ViXiD
Vikas Shukla
Mail Sent from my Windows Phone From: Russ Lavoie
Sent: 27-12-2013 23:32
To: mysql@lists.mysql.com
Subject: MySQL Descending ORDER issue
Hello,
I am currently upgrading from mysql
`table_foo` WHERE (credential_id IN (13528, 14906,
38845)) ORDER BY `date` DESC LIMIT 1;
Thanks!
From: myfriendvi...@gmail.com
Date: Fri, 27 Dec 2013 10:27:28 -0800
Subject: RE: MySQL Descending ORDER issue
To: russ_lav...@hotmail.com; mysql@lists.mysql.com
Hi Russ,
Please share with us
In the last episode (Dec 27), Russ Lavoie said:
I am currently upgrading from mysql 5.1.72 - mysql 5.6 and the migration
and upgrade is sound (In a QA ENV). Queries work etc. However, when I
run a query similar to SELECT `table`.* FROM `table` WHERE (credential_id
IN (13528, 14906, 38845))
Hi Machiel,
On 8/11/2013 20:04, Machiel Richards wrote:
Good day all
I am hoping someone can assist me in the following.
One of our servers were running mysql 5.0 still and as part of
a phased upgrade route we have upgraded to version 5.1.
However since the upgrade,
- Original Message -
From: Machiel Richards machiel.richa...@gmail.com
ERROR 1064 (42000): You have an error in your SQL syntax; check the
manual that corresponds to your MySQL server version for the right
syntax to use near 'GROUP BY t.AccountID,
I suspect your query has never
Happiness, that gave me what I was looking for. Thank you Johan.
I have tested the option you gave me but my brackets was in the wrong place.
On 08/11/2013 13:23, Johan De Meersman wrote:
- Original Message -
From: Machiel Richards machiel.richa...@gmail.com
ERROR 1064 (42000):
Hi Jesper
I was just discussing this with the development manager now and the
following was noted.
- The query was written for mysql 4.0 originally and it seems
that in version 5.0 they had enabled some legacy support stuff ( I am
not too familiar with this as it is before my
MySQL fans,
2013/09/21 18:04 +0200, Bjorn Munch
MySQL Server 5.7.2 (Milestone Release) is a new version of the world's
most popular open source database. This is the second public milestone
release of MySQL 5.7.
Is this a good replacement for that 5.5.8 that I long ago downloaded and
, regressions are rare.
You should probably upgrade to 5.6 soon, simply to avoid having to do a double
upgrade when you eventually go to 5.7.
-Original Message-
From: h...@tbbs.net [mailto:h...@tbbs.net]
Sent: Thursday, October 24, 2013 7:01 AM
To: mysql@lists.mysql.com
Subject: Re: MySQL
Hello Saquib,
On 10/9/2013 7:17 PM, Saqib N Ali wrote:
no binaries for AIX?
--
saqib
http://hivemined.net
The last ODBC package built for AIX was 5.1.8 released Oct 2010
http://downloads.mysql.com/archives.php?p=mysql-connector-odbc-5.1o=aix
This is inline with our EOL announcements
no binaries for AIX?
--
saqib
http://hivemined.net
On Wed, Oct 9, 2013 at 3:02 PM, Kent Boortz kent.boo...@oracle.com wrote:
Dear MySQL users,
MySQL Connector/ODBC 5.2.6, a new version of the ODBC driver for the
MySQL database management system, has been released.
The available
: Thursday, August 22, 2013 12:16 AM
To: shawn green
Cc: mysql@lists.mysql.com
Subject: Re: MySQL version 3.23 to 5.x features
wow it really helped me a lot. I really thank Shawn,Dale Jesper for there
inputs
On Wed, Aug 21, 2013 at 7:13 PM, shawn green
shawn.l.gr...@oracle.comwrote:
Hello
Hi,
I have managed to get the dB open with
[mysqld]
innodb_force_recovery = 2
I did a mysqldump for all tables, and restarted with innodb_force_recordy
but still have the same old error messages.
Regards, S
On Wed, Aug 28, 2013 at 12:12 PM, Simon Loewenthal
simon.loewent...@gmail.com wrote:
wow it really helped me a lot. I really thank Shawn,Dale Jesper for there
inputs
On Wed, Aug 21, 2013 at 7:13 PM, shawn green shawn.l.gr...@oracle.comwrote:
Hello Naga,
On 8/21/2013 6:45 AM, Nagaraj S wrote:
Hello,
Can anyone share the features/comparison from MySQL version 3.23 to 5.x
Hello Naga,
On 8/21/2013 6:45 AM, Nagaraj S wrote:
Hello,
Can anyone share the features/comparison from MySQL version 3.23 to 5.x in
single document? I can get from Google, however I have to navigate
different pages/sites, if it is in single document that will be useful to
see the overview of
Hi Naga,
On 21/08/2013 23:43, shawn green wrote:
Hello Naga,
On 8/21/2013 6:45 AM, Nagaraj S wrote:
Hello,
Can anyone share the features/comparison from MySQL version 3.23 to
5.x in
single document? I can get from Google, however I have to navigate
different pages/sites, if it is in single
On Thu, 2013-08-01 at 10:41 +0200, Sebastien FLAESCH wrote:
Hello,
On 07/31/2013 01:03 PM, Sunanda Menon wrote:
* The C API libmysqlclient shared-library .so files now have
version 18.1.0 (up from version 18.0.0 used in MySQL 5.5).
(Bug #16809055)
What impact
Hello,
On 07/31/2013 01:03 PM, Sunanda Menon wrote:
* The C API libmysqlclient shared-library .so files now have
version 18.1.0 (up from version 18.0.0 used in MySQL 5.5).
(Bug #16809055)
What impact has this change regarding backward compatibility with
existing C
Am 01.08.2013 10:41, schrieb Sebastien FLAESCH:
On 07/31/2013 01:03 PM, Sunanda Menon wrote:
* The C API libmysqlclient shared-library .so files now have
version 18.1.0 (up from version 18.0.0 used in MySQL 5.5).
(Bug #16809055)
What impact has this change regarding
, July 15, 2013 11:53 PM
To: shawn green; mysql@lists.mysql.com
Subject: Re: Mysql cache issues???
Shawn,
I can't help but wonder wether that first paragraph means there are
concrete plans to redo the qc?
shawn green shawn.l.gr...@oracle.com wrote:
Hello Egoitz,
On 7/15/2013 1:35 PM
; mysql@lists.mysql.com
Subject: Re: Mysql cache issues???
Shawn,
I can't help but wonder wether that first paragraph means there are
concrete plans to redo the qc?
shawn green shawn.l.gr...@oracle.com wrote:
Hello Egoitz,
On 7/15/2013 1:35 PM, Egoitz Aurrekoetxea wrote:
-BEGIN PGP
Shawn,
I can't help but wonder wether that first paragraph means there are concrete
plans to redo the qc?
shawn green shawn.l.gr...@oracle.com wrote:
Hello Egoitz,
On 7/15/2013 1:35 PM, Egoitz Aurrekoetxea wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 15/07/13 17:27, Reindl
On 07/15/2013 07:54 AM, Luis H. Forchesatto wrote:
Greetings.
I'm receiving the following error log often on my MySQL database server:
[SNIP]
I suggest you report a bug as suggested.
--
Rares Aioanei
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To
- Original Message -
From: Egoitz Aurrekoetxea ego...@ramattack.net
Could Mysql cache cause a performance penalty, when invalidating
queries of a big Mysql cache zone?.
Yep, spot on. I tend to keep 200MB caches for some webservers, and that's
already considered fairly large.
The
On 15.07.2013 15:31, Egoitz Aurrekoetxea wrote:
Could Mysql cache cause a performance penalty, when invalidating
queries of a big Mysql cache zone?
can, and *will* ... see also http://dom.as/tech/query-cache-tuner/
cache is locked while entries are being purged to prevent handing out
cached
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 15/07/13 15:53, Johan De Meersman wrote:
- Original Message -
From: Egoitz Aurrekoetxea ego...@ramattack.net
Could Mysql cache cause a performance penalty, when invalidating
queries of a big Mysql cache zone?.
Yep, spot on. I tend
- Original Message -
From: Hartmut Holzgraefe hart...@skysql.com
Subject: Re: Mysql cache issues???
can, and *will* ... see also http://dom.as/tech/query-cache-tuner/
Absolutes are never right.
The query cache is a very useful tool, even though it's implementation leaves
something
Am 15.07.2013 16:00, schrieb Hartmut Holzgraefe:
On 15.07.2013 15:31, Egoitz Aurrekoetxea wrote:
Could Mysql cache cause a performance penalty, when invalidating
queries of a big Mysql cache zone?
can, and *will* ... see also http://dom.as/tech/query-cache-tuner/
Optimal size for your
Hello Reindl,
On 7/15/2013 10:28 AM, Reindl Harald wrote:
Am 15.07.2013 16:00, schrieb Hartmut Holzgraefe:
On 15.07.2013 15:31, Egoitz Aurrekoetxea wrote:
Could Mysql cache cause a performance penalty, when invalidating
queries of a big Mysql cache zone?
can, and *will* ... see also
Am 15.07.2013 16:46, schrieb shawn green:
Hello Reindl,
On 7/15/2013 10:28 AM, Reindl Harald wrote:
Am 15.07.2013 16:00, schrieb Hartmut Holzgraefe:
On 15.07.2013 15:31, Egoitz Aurrekoetxea wrote:
Could Mysql cache cause a performance penalty, when invalidating
queries of a big Mysql
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 15/07/13 17:27, Reindl Harald wrote:
Am 15.07.2013 16:46, schrieb shawn green:
Hello Reindl,
On 7/15/2013 10:28 AM, Reindl Harald wrote:
Am 15.07.2013 16:00, schrieb Hartmut Holzgraefe:
On 15.07.2013 15:31, Egoitz Aurrekoetxea wrote:
Am 15.07.2013 19:35, schrieb Egoitz Aurrekoetxea:
On 15/07/13 17:27, Reindl Harald wrote:
I'm not trying to pick on you, Reindl. Your cache may be doing
splendidly well. I just didn't want anyone else to see your
efficiency rating and derive the wrong formula on their own
i would say my
Hello Egoitz,
On 7/15/2013 1:35 PM, Egoitz Aurrekoetxea wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 15/07/13 17:27, Reindl Harald wrote:
... snip...
i would say my caches are working perfectly (not only the mysql
cache, also opcache etc.) since whe have generate times down to
cgroups won't work for individual MySQL users, only for mysqld as a whole.
Monitor the slowlog and help the naughty users fix their naughty queries.
-Original Message-
From: Rafał Radecki [mailto:radecki.ra...@gmail.com]
Sent: Tuesday, July 02, 2013 3:07 AM
To: mysql@lists.mysql.com
Prefer xfs on RHEL.
Certain stalls are inherent in older InnoDBs, but MariaDB 5.5 should have the
Percona fixes that greatly smoothed out that problem.
What kind of drives? A RAID controller with caching helps for datasets that
big.
innodb_flush_log_at_trx_commit = 1 is a big performance
Hello,
Do you have trim enabled? Maybe those stalls could happen when the
disks are getting trimmed.
Just a random thought.
Manuel
2013/6/28, nixofortune nixofort...@gmail.com:
Hi guys,
Did you have any experience running MyLSQ or in my case MariaDB 5.5.31
on FreeBSD on top of zfs?
We are
2013/5/22 Tim Callaghan tmcallag...@gmail.com
Rafal,
I don't believe TRIM is supported for XFS.
I tried this two weeks ago and worked pretty well:
http://xfs.org/index.php/FITRIM/discard
Manuel.
- Original Message -
From: Rick James rja...@yahoo-inc.com
Subject: RE: Mysql server - which filesystem to choose? Is it really that
important nowadays?
ext does less well with simultaneous IOPs than xfs.
Possibly, but how much less (and which ext)? Without numbers that's not very
Thanks for the information, I'll give it a try myself.
On Thu, May 23, 2013 at 5:02 AM, Manuel Arostegui man...@tuenti.com wrote:
2013/5/22 Tim Callaghan tmcallag...@gmail.com
Rafal,
I don't believe TRIM is supported for XFS.
I tried this two weeks ago and worked pretty well:
2013/5/22 Rafał Radecki radecki.ra...@gmail.com
Hi All.
I use mysql/perconna/maria on my production CentOS 6 Linux servers. I
currently try to choose the default filesystem for partitions with mysql
data. Some time ago (previous dba) reiserfs was the choice but now it is
not in the kernel
Rafal,
I benchmark a lot on various hardware and software configurations. When I
started 2 years back I went along with the general consensus that XFS is
faster than ext4 for MySQL. I recently had the opportunity to see how much
of a difference, if any, it made. I didn't find much, especially
ext does less well with simultaneous IOPs than xfs.
-Original Message-
From: Manuel Arostegui [mailto:man...@tuenti.com]
Sent: Wednesday, May 22, 2013 12:22 AM
To: Rafał Radecki
Cc: mysql@lists.mysql.com
Subject: Re: Mysql server - which filesystem to choose? Is it really
Hi all,
Could someone from the libmysqlclient contributors comment on this, and
could someone complete the documentation regarding client compatiblity?
Thanks!
Seb
On 02/20/2013 09:31 AM, Sebastien FLAESCH wrote:
Hello,
FYI, I found this statement in the doc, at the end of the C API main
Oracle fails the context by make incompatible ABI changes
which are *expected* by raise the minor release number
but claim they are compatible until it is clear that
random things are broken and the soname needs to be
changed what leaves the question: was the QA at holiday
due the whole
Beside the Oracle skills debate and the stupid mistakes with soname
changes between 5.5.8 and 5.5.10 or 5.6.x, (imagine all of this did
not happen):
I have a VERY simple question that needs a VERY CLEAR answer:
In our distribution packages (for different platforms! not only Linux),
I need to
Am 17.05.2013 12:05, schrieb Sebastien FLAESCH:
Beside the Oracle skills debate and the stupid mistakes with soname
changes between 5.5.8 and 5.5.10 or 5.6.x, (imagine all of this did
not happen):
I have a VERY simple question that needs a VERY CLEAR answer:
In our distribution packages
On 05/17/2013 12:29 PM, Reindl Harald wrote:
Am 17.05.2013 12:05, schrieb Sebastien FLAESCH:
Beside the Oracle skills debate and the stupid mistakes with soname
changes between 5.5.8 and 5.5.10 or 5.6.x, (imagine all of this did
not happen):
I have a VERY simple question that needs a VERY
Am 17.05.2013 14:53, schrieb Sebastien FLAESCH:
On 05/17/2013 12:29 PM, Reindl Harald wrote:
Am 17.05.2013 12:05, schrieb Sebastien FLAESCH:
Beside the Oracle skills debate and the stupid mistakes with soname
changes between 5.5.8 and 5.5.10 or 5.6.x, (imagine all of this did
not happen):
On 05/17/2013 03:07 PM, Reindl Harald wrote:
Am 17.05.2013 14:53, schrieb Sebastien FLAESCH:
On 05/17/2013 12:29 PM, Reindl Harald wrote:
Am 17.05.2013 12:05, schrieb Sebastien FLAESCH:
Beside the Oracle skills debate and the stupid mistakes with soname
changes between 5.5.8 and 5.5.10 or
partitioning, failover etc.
Regards, Andrew.
-Original Message-
From: Neil Tompkins [mailto:neil.tompk...@googlemail.com]
Sent: 29 April 2013 14:50
To: Andrew Morgan
Cc: [MySQL]
Subject: Re: MySQL Cluster or MySQL Cloud
Hi Andrew,
Thanks for your response and the useful white paper
To: Neil Tompkins
Cc: [MySQL]
Subject: RE: MySQL Cluster or MySQL Cloud
Hi Neil,
If you use MySQL Cluster then you have synchronous replication between
the 2 data nodes which means that if one should fail you're guaranteed
that the other contains the effects of every committed
Hi Neil,
I hate just sending people off to white papers but you might get some good
insights by taking a look at the MySQL Guide to High Availability Solutions
paper -
http://www.mysql.com/why-mysql/white-papers/mysql-guide-to-high-availability-solutions/
Regards, Andrew.
Andrew Morgan -
101 - 200 of 9139 matches
Mail list logo