Hi Andrew,
Thanks for your response and the useful white paper. I've read the
document in great detail. I'm looking for the best up time possible for my
application and am still struggling to see the major differences with MySQL
cluster compared to MySQL in the Cloud on multiple servers; apart
On Tue, Apr 16, 2013 at 11:31 AM, Reindl Harald h.rei...@thelounge.net wrote:
Am 16.04.2013 18:34, schrieb Larry Martell:
I just set up mysql on Mac OS 10.8. Each time after the machine is
rebooted the server fails to start with:
2013-04-13 14:09:54 1 [ERROR] /usr/local/mysql/bin/mysqld:
Am 17.04.2013 15:32, schrieb Larry Martell:
On Tue, Apr 16, 2013 at 11:31 AM, Reindl Harald h.rei...@thelounge.net
wrote:
Am 16.04.2013 18:34, schrieb Larry Martell:
I just set up mysql on Mac OS 10.8. Each time after the machine is
rebooted the server fails to start with:
2013-04-13
On Wed, Apr 17, 2013 at 8:32 AM, Reindl Harald h.rei...@thelounge.net wrote:
Am 17.04.2013 15:32, schrieb Larry Martell:
On Tue, Apr 16, 2013 at 11:31 AM, Reindl Harald h.rei...@thelounge.net
wrote:
Am 16.04.2013 18:34, schrieb Larry Martell:
I just set up mysql on Mac OS 10.8. Each time
Not a solution but a workaround for [ERROR] /usr/local/mysql/bin/mysqld:
Can't create/write to file '/var/run/mysqld/mysqld.pid'
explicitly set
pid_file=
to some existing file path in
/usr/local/mysql/bin/mysqld_safe (Line:26)
e.g. you could possibly set it to:
Am 17.04.2013 17:29, schrieb Larry Martell:
On Wed, Apr 17, 2013 at 8:32 AM, Reindl Harald h.rei...@thelounge.net wrote:
[root@srv-rhsoft:~]$ cat /etc/tmpfiles.d/mysql.conf
d /var/run/mysqld 0755 mysql mysql -
Doesn't seem to be anything like that running on MacOS. I googled and
didn't
Larry,
Nothing in the mysql startup files ever removes any directories of any kind.
At a guess: only my clients who work on Macs ever report this king of
'disappearing folder' behaviour. And every time it turn out to be Time
Machine. Ask around on those lists.
On Tue, Apr 16, 2013 at 12:34
On Tue, Apr 16, 2013 at 10:50 AM, Michael Dykman mdyk...@gmail.com wrote:
Larry,
Nothing in the mysql startup files ever removes any directories of any kind.
At a guess: only my clients who work on Macs ever report this king of
'disappearing folder' behaviour. And every time it turn out to
Am 16.04.2013 18:34, schrieb Larry Martell:
I just set up mysql on Mac OS 10.8. Each time after the machine is
rebooted the server fails to start with:
2013-04-13 14:09:54 1 [ERROR] /usr/local/mysql/bin/mysqld: Can't
create/write to file '/var/run/mysqld/mysqld.pid' (Errcode: 2 - No
Am 15.04.2013 15:20, schrieb Paul Nowosielski:
I'm running mysql 5.6.10 on Fedora.
when I try and boot mysql I get this:
# /etc/init.d/mysql start
Starting MySQL.The server quit without updating PID file
(/[FAILED]xt/mysql/veritian.pid).
Any ideas?
look in the logfile?
Fedora does
Have you got permissions to start the daemon (sudo)? Is the destination for
the pid file writable by the MySQL user?
A
On Mon, Apr 15, 2013 at 2:20 PM, Paul Nowosielski paulnowosiel...@yahoo.com
wrote:
Hi,
I'm running mysql 5.6.10 on Fedora.
when I try and boot mysql I get this:
#
Hi Kevin,
What do you mean by running MySQL in cluster mode - MySQL Cluster? If so then
the data is stored in the data nodes rather than the MySQL Servers and so if
bad data is written to one MySQL Server then that same bad data will be viewed
through the other MySQL Server too.
Regards,
I would guess it would work.
Better to upgrade to RHEL 6.3.
-Original Message-
From: Keith Keller [mailto:kkel...@wombat.san-francisco.ca.us]
Sent: Friday, April 05, 2013 6:46 AM
To: mysql@lists.mysql.com
Subject: Re: MySQL on RHEL4
On 2013-04-05, Nitin Mehta ntn...@yahoo.com
Am 05.04.2013 09:46, schrieb Nitin Mehta:
Thanks for your response. However, i'm not sure which case it is because in
the downloads, it says Platform: Oracle and Redhat 45. Isn't it supposed
to work?
most likely Oracle does not care about RHEL4 because it is EOL
and has no longer support
On 2013-04-05, Nitin Mehta ntn...@yahoo.com wrote:
However, i'm not sure which case it is because in the downloads, it says
Platform: Oracle and Redhat 45
Isn't it supposed to work?
The downloads section is titled Oracle and Red Hat 4 and 5, but each
individual download is clearly marked as
Am 05.04.2013 07:56, schrieb Keith Keller:
On 2013-04-05, Nitin Mehta ntn...@yahoo.com wrote:
We're trying to upgrade our existing MySQL 5.1.26 to MySQL 5.1.68 but the
installation gives error:libc.so.6(GLIBC_2.4) is needed by
MySQL-server-community-5.1.68-1.rhel5.i386 rtld(GNU_HASH) is
Sent: Friday, April 5, 2013 11:26 AM
Subject: Re: MySQL on RHEL4
On 2013-04-05, Nitin Mehta ntn...@yahoo.com wrote:
We're trying to upgrade our existing MySQL 5.1.26 to MySQL 5.1.68 but the
installation gives error:libc.so.6(GLIBC_2.4) is needed by
MySQL-server-community-5.1.68-1.rhel5
On 2013-04-05, Nitin Mehta ntn...@yahoo.com wrote:
We're trying to upgrade our existing MySQL 5.1.26 to MySQL 5.1.68 but the
installation gives error:libc.so.6(GLIBC_2.4) is needed by
MySQL-server-community-5.1.68-1.rhel5.i386 rtld(GNU_HASH) is needed by
Olivier-Wilson; mysql@lists.mysql.com
Subject: RE: MySQL Error#: 2002
Check directory permissions, and check out the 'answers' in here:
http://forums.mysql.com/read.php?10,284776,284936
-Original Message-
From: Patrice Olivier-Wilson [mailto:b...@biz-comm.com]
Sent: Monday, March 18, 2013 12
-Original Message-
From: Mike Franon [mailto:kongfra...@gmail.com]
Sent: 18 March 2013 13:34
To: mysql@lists.mysql.com
Subject: mysql cluster and auto shard
I am looking at the best way to scale writes.
Either using sharding with our existing infrastructure, or moving to
Check directory permissions, and check out the 'answers' in here:
http://forums.mysql.com/read.php?10,284776,284936
-Original Message-
From: Patrice Olivier-Wilson [mailto:b...@biz-comm.com]
Sent: Monday, March 18, 2013 12:05 PM
To: mysql@lists.mysql.com
Subject: MySQL Error#: 2002
: RE: mysql cluster and auto shard
-Original Message-
From: Mike Franon [mailto:kongfra...@gmail.com]
Sent: 18 March 2013 13:34
To: mysql@lists.mysql.com
Subject: mysql cluster and auto shard
I am looking at the best way to scale writes.
Either using sharding with our
Am 08.03.2013 15:53, schrieb frederic nivor:
I use mysql-5.6.10 on a cross-platform.
when I :
use mysql;
I got :
ERROR 1049 (42000): Unknown database 'mysql'
but when I :
select User,Host,Password from mysql.user;
I got the right results.
Did I do something wrong in configuration ?
I've just installed the mysql, and its default database (mysql and
performance_schema), so I connect with:
mysql -u root
Initialy there is not password.
and when I :
show grants for 'root'@'localhost';
I got :
GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' WITH GRANT OPTION
GRANT PROXY ON ''@''
Am 08.03.2013 17:32, schrieb frederic nivor:
when I :
show databases;
I got:
++
| Database |
++
| information_schema |
| Applications |
| Developer |
| Library|
| System |
| bin|
when I :
show databases;
I got:
++
| Database |
++
| information_schema |
| Applications |
| Developer |
| Library|
| System |
| bin|
| cores |
| etc|
| private
Hi Neil,
MySQL Cluster *does* support stored procedures. There are some limitation that
MySQL Cluster has; this white paper would be a good place to start...
http://www.mysql.com/why-mysql/white-papers/mysql-cluster-evaluation-guide/
Regards, Andrew.
-Original Message-
From: Neil
- Original Message -
From: Neil Tompkins neil.tompk...@googlemail.com
Subject: MySQL Cluster Solution
I've used in the past MySQL Community Server 5.x. Everything is
fine, however I'm now wanting to implement a new High Availability solution
and am considering MySQL Cluster.
: Thursday, March 07, 2013 7:06 AM
To: Neil Tompkins
Cc: [MySQL]
Subject: Re: MySQL Cluster Solution
- Original Message -
From: Neil Tompkins neil.tompk...@googlemail.com
Subject: MySQL Cluster Solution
I've used in the past MySQL Community Server 5.x. Everything is
fine
you need CREATE Privileges.
http://dev.mysql.com/doc/refman/5.0/en/grant.html#grant-privileges
On Wed, Feb 27, 2013 at 10:42 PM, Rajeev Prasad rp.ne...@yahoo.com wrote:
Hello,
currently on this version of MySQL a database has been built for me to
use. and following privileges are given: I
is that he/she needs CREATE to create tables and
ALTER to alter them.
-Original Message-
From: Reindl Harald [mailto:h.rei...@thelounge.net]
Sent: Wednesday, February 27, 2013 12:55 PM
To: mysql@lists.mysql.com
Subject: Re: mysql Ver 14.12 Distrib 5.0.27 user privileges question
I am using graphite, but what exactly do you want to graph?
For mysql graphing I actually use nagios plugin called
check_mysql_health along with check_mk/pnp4nagios
That works really well.
On Fri, Feb 22, 2013 at 2:24 AM, Johan De Meersman vegiv...@tuxera.be wrote:
- Original Message
says who?
you MAY need CREATE privileges
but it not uncommon have a defined scheme and not allow
the user to create or drop tables, the user below is
able to do anything for a common web-app
to anser the OP's question
% in mysql is the same as * for the bash
so yes, % means any host
Am
...@thelounge.net]
Sent: Wednesday, February 27, 2013 12:55 PM
To: mysql@lists.mysql.com
Subject: Re: mysql Ver 14.12 Distrib 5.0.27 user privileges question
says who?
you MAY need CREATE privileges
but it not uncommon have a defined scheme and not allow the user to create or
drop tables, the user
They are both right. It is a matter of how many decimal places you want to
display:
mysql SELECT 365 * 1.67 * ( 1 - 0.10);
+--+
| 365 * 1.67 * ( 1 - 0.10) |
+--+
| 548.5950 |
+--+
1 row in set (0.00 sec)
Anyone has any idea about this.
On Thu, Feb 21, 2013 at 7:42 PM, Adarsh Sharma eddy.ada...@gmail.comwrote:
Hi all,
I need to set up mysql monitoring graphs in Graphite. I am able to monitor
basic system metrics after runnning example-client.py that comes with
graphite installation.
when
- Original Message -
From: Adarsh Sharma eddy.ada...@gmail.com
Anyone has any idea about this.
Unless someone else here is using Graphite (I've never even heard of it, tbh) I
think this may be something for the Graphite support channels, instead.
--
Unhappiness is discouraged and
Hello,
FYI, I found this statement in the doc, at the end of the C API main page:
http://dev.mysql.com/doc/refman/5.6/en/c.html
If, after an upgrade, you experience problems with compiled client programs, such as Commands out of sync or unexpected core dumps, you probably have
used old header
Am 18.02.2013 10:57, schrieb Sebastien FLAESCH:
Hi all,
What is the compatibility policy regarding the MySQL C API library?
I could not find the rules in the documentation.
I have several versions of MySQL installed on my Linux, and it appears
that the libmysqlclient versions have
On Mon, 2013-02-18 at 10:57 +0100, Sebastien FLAESCH wrote:
I have several versions of MySQL installed on my Linux, and it appears
that the libmysqlclient versions have changed in the 5.x version line:
/opt3/dbs/mys/4.1.24/lib/libmysqlclient.so.14
On 02/18/2013 12:14 PM, Noel Butler wrote:
On Mon, 2013-02-18 at 10:57 +0100, Sebastien FLAESCH wrote:
I have several versions of MySQL installed on my Linux, and it appears
that the libmysqlclient versions have changed in the 5.x version line:
/opt3/dbs/mys/4.1.24/lib/libmysqlclient.so.14
15.02.2013 15:07, Alex Keda пишет:
OK. But, how about:
mysql SELECT 365 * 1.67 * ( 1 - 0.10);
+--+
| 365 * 1.67 * ( 1 - 0.10) |
+--+
| 548.5950 |
+--+
1 row in set (0.00 sec)
mysql
??
sorry, I'm too many
- Original Message -
From: Alex Keda ad...@lissyara.su
mysql SELECT SUM(`Amount`*`Cost`*(1-`Discont`)) as `Summ` FROM
`WorksCompliteAgregate` WHERE (`ContractID` = 10369 AND `Month` = 497);
Based off the select you printed, this comes to EXACTLY 548.595 for the first
row and 0
15.02.2013 14:43, Johan De Meersman пишет:
- Original Message -
From: Alex Keda ad...@lissyara.su
mysql SELECT SUM(`Amount`*`Cost`*(1-`Discont`)) as `Summ` FROM
`WorksCompliteAgregate` WHERE (`ContractID` = 10369 AND `Month` = 497);
Based off the select you printed, this comes to
- Original Message -
From: Alex Keda ad...@lissyara.su
To: mysql@lists.mysql.com
Sent: Friday, 15 February, 2013 12:16:18 PM
Subject: Re: MySQL 5.1: incorrect arithmetic calculation
sorry, I'm too many work... =)
Heh :-) I was thinking, why would that not be correct? It's exactly
From: Alex Keda ad...@lissyara.su
To: mysql@lists.mysql.com;
Sent: 6:37 Piątek 2013-02-15
Subject: MySQL 5.1: incorrect arithmetic calculation
( ... cut ...)
but, my desktop calculator gives the result 548.60
1. your desktop calculator is wrong
2. correct result is 548.595, variations
Wayne,
You going to need a MySQL Enterprise version, This version there's a pam
connection, then you can use libpam-ldap/nss-ldap to authenticate via
Active Directory.
Thanks,
Fabricio
On Mon, Feb 4, 2013 at 5:40 PM, Wayne Leutwyler wleut...@columbus.rr.comwrote:
List,
Has anyone has any
Hi Bheemsen,
looks like a few different things going on there; if you have a MySQL support
contract/subscription then it would be worth raising SRs - it doesn't need to
be a bug, it's fine tyo ask questions too. A couple of things that spring to
mind in-line
I am frequently seeing the
Hello Trimurthy,
As far as I know, MySQL does not have such thing implemented as other database
systems.
--
Adrián Espinosa.
Engineering Support, Wholesale Systems.
Jazztel.com
-Mensaje original-
De: Trimurthy [mailto:trimur...@tulassi.com]
Enviado el: viernes, 14 de diciembre de
- Original Message -
From: Néstor rot...@gmail.com
I spoke to soon!!!
Here is the error about 1.5 hours after replication has started.
121205 16:39:51 [ERROR] Slave: Error 'Duplicate entry '3468897'
for
Yes, that's what you get for running SQL_SLAVE_SKIP_COUNTER
Yes that's correct.
it needs to be added on the slave side under [mysqld] section usually
close to the place where you define your replication settings (for
convenience only).
The reason why server failed to start difficult to guess without error log.
this will prevent all tables under
Hi Néstor,
You might want to put those lines into your my.cnf under replication
section and restart the slave:
replicate-wild-ignore-table=dbname%.watchdog%
and may be this as well:
replicate-wild-ignore-table=dbname%.cache%
Do you really need to replicate cache and session tables?
Cheers,
I spoke to soon!!!
Here is the error about 1.5 hours after replication has started.
121205 16:39:51 [ERROR] Slave: Error 'Duplicate entry '3468897' for
key 1' on query. Default database: 'parallax'. Query: 'INSERT INTO watchdog
(uid, type, message, variables, severity, link, location,
In regards to the second part of your email.
You don't have errors in your mysql.err log. Those are notes saying that
you started IO and SQL replication threads after you skipped an
replication error and run start slave command.
I wouldn't run SET GLOBAL SQL_SLAVE_SKIP_COUNTER = 1; command
I added those line to the slave's my.cnf and mysql would not start
replicate-wild-ignore-table=parallax%.watchdog%
replicate-wild-ignore-table=parallax%.cache%
Nestor
On Thu, Dec 6, 2012 at 4:39 PM, Néstor rot...@gmail.com wrote:
HI Igor,
Are you saying to add these lines to the my.cnf
MySQL runs the internet. Go ahead kill it. I dare you.
On Tue, Dec 4, 2012 at 11:18 PM, Karen Abgarian a...@apple.com wrote:
MySQL, like all other products, can be peachy or bitchy. Good ones, they
also die.Wish I was kidding :-)
On Dec 4, 2012, at 2:37 PM, Andrés Tello wrote:
Are
- Original Message -
From: divesh kamra kamra.div...@gmail.com
slave-skip-errors=1062 --- in my.cnf and restart mysql
Really? Just like that? Without even knowing what it does or what the problem
is?
If you have replication errors, this kind of stuff is only going to break
- 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. However, out of curiosity (and
because they are the questions you should
2012/11/30 Néstor rot...@gmail.com
I am trying to set up mysql replication on 2 systems but Once I get it
going, I get the following an error 1062,
skip
I have re-installed the database on the slave also to see if this fixes the
problem
but after a few minutes I get the same error. I
I was about to reply with a long message of all the steps I followed to
create replication but I did my steps about an hour ago and I have not
seen the replication fail so far.
BTW, I created my replication following the info on this web page:
Mysql is used by just about every web host and is one of the most common
database servers around the world. I do not have any intent to stop using
mysql unless they start charging for it which I do not think will happen.
Thanks,
Tim Pownall
Sr. Linux Systems Monitoring
Hostgator.com LLC
On Tue,
A touch of realism: we are all dying. For some, it may take a while,
hopefully.
On 04.12.2012, at 9:53, Tim Pownall wrote:
Mysql is used by just about every web host and is one of the most common
database servers around the world. I do not have any intent to stop using
mysql unless they
nasty, there are exit strategies that do not
involve porting to some other RDBMS.
I say don't worry.
-Original Message-
From: Karen Abgarian [mailto:a...@apple.com]
Sent: Tuesday, December 04, 2012 10:03 AM
To: mysql.
Subject: Re: MySQL dying?
A touch of realism: we are all dying
Lol! Good point Karen!
On Tue, Dec 4, 2012 at 1:02 PM, Karen Abgarian a...@apple.com wrote:
A touch of realism: we are all dying. For some, it may take a while,
hopefully.
On 04.12.2012, at 9:53, Tim Pownall wrote:
Mysql is used by just about every web host and is one of the most
Are u kidding?
Mysql is dead easy and damn good... obviously it has its perks, but any
database engine has them... (I'm looking at you DB2)...
There has been a lot of improvements lately, I feel that mysql is moving
much more faster under oracle umbrella than when it was alone...
Replication...
MySQL, like all other products, can be peachy or bitchy. Good ones, they also
die.Wish I was kidding :-)
On Dec 4, 2012, at 2:37 PM, Andrés Tello wrote:
Are u kidding?
Mysql is dead easy and damn good... obviously it has its perks, but any
database engine has them... (I'm
2012/12/04 15:18 -0800, Karen Abgarian
MySQL, like all other products, can be peachy or bitchy. Good ones, they also
die.Wish I was kidding :-)
Mind VHS BetaMax? BetaMax had much better color--but VHS long outlasted it.
--
MySQL General Mailing List
For list archives:
Hi
first check this thought application end
or
There is another way
slave-skip-errors=1062 --- in my.cnf and restart mysql
On Sat, Dec 1, 2012 at 4:30 AM, Reindl Harald h.rei...@thelounge.netwrote:
Am 30.11.2012 23:52, schrieb Rick James:
Possible causes:
* Someone is writing
Possible causes:
* Someone is writing to the Slave.
* The Slave was not in synch with the Master.
* Schemas are different between Master and Slave.
* Someone is changing the POS for replication.
After you have eliminated those possibilities, provide
SHOW SLAVE STATUS \G
SHOW MASTER STATUS;
SHOW
Am 30.11.2012 23:52, schrieb Rick James:
Possible causes:
* Someone is writing to the Slave
that is why the option read-only exists for my.cnf
* The Slave was not in synch with the Master.
* Schemas are different between Master and Slave
should not happen if the slave is properly cloned
No, If you are using non-persistence connection once the query get
complete you are closing the connection properly.
On Wed, Nov 14, 2012 at 11:44 AM, Trimurthy trimur...@tulassi.com wrote:
hi every one, i am working with some application which is
developed in php and back
On Tue, November 13, 2012 22:38, Prabhat Kumar wrote:
No, If you are using non-persistence connection once the query get
complete you are closing the connection properly.
Is this true if you are using mod_php or equivalent?
On Wed, Nov 14, 2012 at 11:44 AM, Trimurthy trimur...@tulassi.com
Hi,
If things are still as before,
you get MEM only if you have a support contract with Oracle,
so it would make more sense to ask Oracle.
They make that product, they know better how it works, they can help you
better, and you are entitled to get that help.
Consider that the users of the
-
From: Reindl Harald h.rei...@thelounge.net
Date: Thu, 01 Nov 2012 16:49:45
To: mysql@lists.mysql.commysql@lists.mysql.com
Subject: Re: Mysql backup for large databases
good luck
i would call snapshots on a running system much more dumb
than innodb_flush_log_at_trx_commit = 2
@lists.mysql.com
Subject: Re: Mysql backup for large databases
good luck
i would call snapshots on a running system much more dumb
than innodb_flush_log_at_trx_commit = 2 on systems with
100% stable power instead waste IOPS on shared storages
Am 01.11.2012 16:45, schrieb Singer Wang:
Assuming
(I'm not using such.)
Would you explain what your application is doing that would push the limits of
thread concurrency?
-Original Message-
From: Singer Wang [mailto:w...@singerwang.com]
Sent: Wednesday, October 31, 2012 2:08 PM
To: mysql@lists.mysql.com
Subject: MySQL Thread Pool
On 01/11/2012 11.28, Machiel Richards - Gmail wrote:
[...]
I am busy investigating some options relating to the backup for
MySQL databases when they get quite large.
When using the MySQL enterprise, there is the option to use the
MySQL enterprise backup as it is part of the
Am 01.11.2012 11:28, schrieb Machiel Richards - Gmail:
Using mysqldump and restores on an 80-100GB database seems a bit unpractical
as the restore times seems to
get quite long as well as the backup times.
* setup a master/slave configuration
* stop the slave
* rsync the raw datadir to
@lists.mysql.com
Subject: Re: Mysql backup for large databases
Am 01.11.2012 11:28, schrieb Machiel Richards - Gmail:
Using mysqldump and restores on an 80-100GB database seems a bit
unpractical as the restore times seems to get quite long as well as the
backup times.
* setup a master/slave
-
From: Reindl Harald [mailto:h.rei...@thelounge.net]
Sent: Thursday, November 01, 2012 4:47 AM
To: mysql@lists.mysql.com
Subject: Re: Mysql backup for large databases
Am 01.11.2012 11:28, schrieb Machiel Richards - Gmail:
Using mysqldump and restores on an 80-100GB database
Am 01.11.2012 16:36, schrieb Singer Wang:
On Thu, Nov 1, 2012 at 11:34 AM, Rick James rja...@yahoo-inc.com
mailto:rja...@yahoo-inc.com wrote:
Full backup:
* Xtrabackup (Backup: slight impact on source; more if you have MyISAM
(as mentioned))
* Slave (Backup: zero impact on
Assuming you're not doing dumb stuff like innodb_flush_log_at_tx=0 or 2 and
etc, you should be fine. We have been using the trio: flush tables with
read lock, xfs_freeze, snapshot for months now without any issues. And we
test the backups (we load the backup into a staging once a day, and dev
once
good luck
i would call snapshots on a running system much more dumb
than innodb_flush_log_at_trx_commit = 2 on systems with
100% stable power instead waste IOPS on shared storages
Am 01.11.2012 16:45, schrieb Singer Wang:
Assuming you're not doing dumb stuff like innodb_flush_log_at_tx=0 or 2
@lists.mysql.com
Subject: Re: Mysql backup for large databases
good luck
i would call snapshots on a running system much more dumb
than innodb_flush_log_at_trx_commit = 2 on systems with
100% stable power instead waste IOPS on shared storages
Am 01.11.2012 16:45, schrieb Singer Wang:
Assuming you're
find you!
-Original Message-
From: Reindl Harald h.rei...@thelounge.net
Date: Thu, 01 Nov 2012 16:49:45
To: mysql@lists.mysql.commysql@lists.mysql.com
Subject: Re: Mysql backup for large databases
good luck
i would call snapshots on a running system much more dumb
than
[mailto:machiel.richa...@gmail.com]
Sent: Thursday, November 01, 2012 8:54 AM
To: Reindl Harald; mysql@lists.mysql.com
Subject: Re: Mysql backup for large databases
Well, the biggest problem we have to answer for the clients is the
following:
1. Backup method that doesn't take long and don't
find you!
-Original Message-
From: Reindl Harald h.rei...@thelounge.net
Date: Thu, 01 Nov 2012 16:49:45
To: mysql@lists.mysql.commysql@lists.mysql.com
Subject: Re: Mysql backup for large databases
good luck
i would call snapshots on a running system much more dumb
than
2012/10/25 Sabika M sabika.makhd...@gmail.com:
We are in the process of switching to percona binaries of MySQL . I am
using Percona 5.5.27 and monitoring the MySQL server with the MySQL
Enterprise monitor. It starts up fine, but after a while I end up with
MySQL monitor connections stacking up
Hi Tim,
It looks like your '.sql backup file' has changed the password for root user
and why it is persisting is perhaps you have data directory outside the install
directory.
How you correct the problem:
Stop the service, start the service with option '--skip-grant-tables', login
with root
Not sure how the .sql backup file would have done that, but it seems to
be working now. I'll just step away slowly and carry on. Thanks for
the help!
On 10/25/2012 2:45 AM, Nitin Mehta wrote:
Hi Tim,
It looks like your '.sql backup file' has changed the password for root user
and why it
What does SHOW FULL PROCESSLIST say?
What values do you have for
max_connections
wait_timeout (GLOBAL version)
-Original Message-
From: Sabika M [mailto:sabika.makhd...@gmail.com]
Sent: Thursday, October 25, 2012 11:44 AM
To: mysql@lists.mysql.com
Subject: MySQL Monitor and Percona
I don't have the full anymore. It had a few hundred of these. I had issues
a drop database that hung which made me run show processlist. Sadly, I did
not check the processlist beforehand.
| 101189 | monitor | localhost:42585 | NULL | Query | 4079 |
NULL
, 2012 4:15 PM
To: Rick James
Cc: mysql@lists.mysql.com
Subject: Re: MySQL Monitor and Percona
I don't have the full anymore. It had a few hundred of these. I had issues a
drop database that hung which made me run show processlist. Sadly, I did not
check the processlist beforehand.
| 101189
On 10/15/2012 7:15 PM, spameden wrote:
Thanks a lot for all your comments!
I did disable Query cache before testing with
set query_cache_type=OFF
for the current session.
I will report this to the MySQL bugs site later.
First. What are all of your logging settings?
SHOW GLOBAL
Will do.
mysql SHOW GLOBAL VARIABLES LIKE '%log%';
+-+-+
| Variable_name | Value
|
+-+-+
| back_log
your now() statement is getting executed for every row on the select. try
ptting the phrase up front
as in:
set @ut= unix_timestamp(now())
and then use that in your statement.
On 2012-10-16 8:42 AM, spameden spame...@gmail.com wrote:
Will do.
mysql SHOW GLOBAL VARIABLES LIKE '%log%';
Interesting thought, but I get the same result.
# Query_time: 0.001769 Lock_time: 0.001236 Rows_sent: 0 Rows_examined: 0
use kannel;
SET timestamp=1350413592;
select * from send_sms FORCE INDEX (priority_time) where time=@ut order by
priority limit 0,11;
the MySQL i'm using is 5.5.28 from
2012/10/16 12:57 -0400, Michael Dykman
your now() statement is getting executed for every row on the select. try
ptting the phrase up front
as in:
set @ut= unix_timestamp(now())
and then use that in your statement.
Quote:
Functions that return the current date or time each are evaluated only
That's exactly what I thought when reading Michael's email, but tried
anyways, thanks for clarification :)
2012/10/16 h...@tbbs.net
2012/10/16 12:57 -0400, Michael Dykman
your now() statement is getting executed for every row on the select. try
ptting the phrase up front
as in:
set @ut=
Hi, I've just checked on MySQL-5.5.28
it acts absolutely same.
I need to use (priority,time) KEY instead of (time, priority) because query
results in better performance.
With first key used there is no need to sort at all, whilst if using latter:
mysql *desc select * from send_sms_test FORCE
201 - 300 of 9139 matches
Mail list logo
