On Mon, Nov 12, 2012 at 5:21 AM, Machiel Richards - Gmail
machiel.richa...@gmail.com wrote:
1. the fact that the slaves say seconds behind master = 0 does not
neccesarily mean that repliication is working as I have found this a lot of
times where it shows 0 then have proven that
On Wed, May 2, 2012 at 4:58 AM, vishesh kumar linuxtovish...@gmail.com wrote:
I am getting following in error log
120502 07:52:05
On Wed, Mar 28, 2012 at 1:47 AM, Nuno Tavares nuno.tava...@dri.pt wrote:
Halász, not sure if I understood correcly, but you mysql console/client
may have different charsets. This means you should set it accordingly. Check
Good catch, I had not considered that.
mysql set names utf8;
Query OK,
2012/3/27 Halász Sándor h...@tbbs.net:
2012/03/27 00:22 +0200, Walter Tross
it looks like it's as simple as this:
insert into mytable (mycolumn) values (0xE29C94), (0xE29C98)
In some contexts it might be necessary to force the character set like this,
though:
convert(0xE29C94 using utf8)
2012/1/26 Suporte Avanutri supor...@avanutri.com.br:
[At this point I deleted the table “obras.frm”. Still trying to dump,
crashing every time, and restarting mysqld with a higher
“innodb_force_recovery” value at a time]
It doesn't matter what you set in innodb_force_recovery. If you do
not
2012/1/24 Suporte Avanutri supor...@avanutri.com.br:
I've tried this before, but the server stills going down. The first error is
always this:
Couldn't execute 'SELECT /*!40001 SQL_NO_CACHE */* FROM 'usuario': Lost
connection to MySQL server during query (2013)
What's likely happening here
On Wed, Jan 25, 2012 at 6:42 AM, Todd Lyons tly...@ivenue.com wrote:
For example, I shut down my mysql daemon, I make a copy of my
corrupted database at /var/lib/mysql/ into /var/lib/mysql_tmp/, and
then manually start the mysql daemon in the foreground with this:
su - mysql -c '/usr/libexec
On Thu, Sep 29, 2011 at 7:12 AM, Jim Moseby jmos...@elasticfabrics.com wrote:
I still use the old MySQL Administrator GUI on my windows box. A simple
'select * from tablename' that would return only three records takes just
over a minute to return (although it says '3 records returned in
Yeah it happens to all of us. Some master-slave replication system
breaks and goes unnoticed. In my case, I had a monitoring script, but
it was being called with a --verbose flag, and internally that
verbose was being mapped to debug, and the routine to notify
sysadmins of broken replication
On Tue, Jul 26, 2011 at 8:18 AM, Reindl Harald h.rei...@thelounge.net wrote:
1. I did a full copy of the running master database server using
xtrabackup to a backup server via nfs. It took 2 hours, of which the
last 15 minutes did a write lock of the entire server as it copied
over the *.frm
2010/11/4 Changying Li lchangy...@gmail.com:
PRIMARY KEY (`threadid`),
KEY `dateline` (`dateline`),
KEY `forumid_2` (`forumid`,`thread_type_id`,`visible`,`sticky`,`dateline`),
KEY `forumid` (`forumid`,`visible`,`sticky`,`dateline`)
) ENGINE=InnoDB AUTO_INCREMENT=660 DEFAULT CHARSET=utf8;
On Wed, Sep 15, 2010 at 6:50 AM, Johan De Meersman vegiv...@tuxera.be wrote:
I commonly set up a tunnel to the SSH server at the office and then
another tunnel from that server to my development rig, so I can run
MySQL WB at home on my database at work. Is that what you mean?
Pretty much,
On Thu, Aug 26, 2010 at 6:04 AM, Norman Khine nor...@khine.net wrote:
hello,
i have a working master-slave replication, the problem i find is that
if i restart the MASTER there is a difference in the MASTER_LOG_FILE
and MASTER_LOG_POS on the SLAVE.
what is the correct way to keep the two
On Thu, Aug 5, 2010 at 8:35 AM, Nunzio Daveri nunziodav...@yahoo.com wrote:
The server in this case is a stand alone with nothing more then CentOS and
MySQL
5.1.44 on it. The drives are sas 10K rpm drives. The problem I see is that
when you stress test the server (typically by running
On Tue, Oct 27, 2009 at 7:51 AM, Bryan Cantwell bcantw...@firescope.com wrote:
I notice that issuing a reboot or shutdown -r now command, (in Linux) that
the 'service mysql stop' is never run... it just seems to catch the sig 15
and does its own shutdown...
I have scripted in the stop section
On Mon, Sep 14, 2009 at 7:44 AM, Néstor rot...@gmail.com wrote:
Maybe one of you experts know the answer.
I have a Innodb database that I want to back up. Is there a free tool to
do this?
mysqlhotbackup is a paid tool, is that the only one available?
You can also use the free tool from
On Mon, Sep 14, 2009 at 8:28 AM, Michael Dykman mdyk...@gmail.com wrote:
If I may,
If you have foreign keys on your InnoDB, you can still import your
data to MyISAM but foreign keys will be lost. Otherwise, the data
will load just fine.
Very good point. My comment was based on the possibly
On Thu, Sep 10, 2009 at 2:49 PM, Gavin Towey gto...@ffn.com wrote:
When using innodb, your data is stored in the data/ibdata* files. Copying
the database directory is not a valid backup.
In the future, I would suggest using mysqldump. However if you want to make
a file-system copy backup
On Wed, Aug 26, 2009 at 02:12, Joemysql@bluepolka.net
wrote:
We have an inaccessible MySQL v5.0.45 DB (w/Innodb) we
really need some help regaining access to. While attempting
to adjust/add remote user access, we accidentally did the
following:
use mysql;
update user set
On Thu, Jul 16, 2009 at 1:18 PM, Gary Smithg...@primeexalia.com wrote:
I have a new slave I setup against a new master server. The master server
has 4 log files in it, the most current being updated on the 16th. The slave
server on the other hand has several files, many which seem to be
On Wed, Jul 15, 2009 at 11:58 AM, mosmo...@fastmail.fm wrote:
I have backup all the database files(innodb engine).
Now I want to recover it as myisam engine offline.
Any suggestions?
Why can't you copy the InnoDb files to another machine and open the database
with another MySQL server? (You
On Tue, Jul 14, 2009 at 2:14 AM, Marcus
Bointonmar...@synchromedia.co.uk wrote:
You should take a look at Percona's xtrabackup utility to do this. It takes
a clean snapshot of an innodb database that can be restored on a target
machine in a few minutes, though it does crash recovery at backup
expecting me to do their work for them just
so they can receive emails from a public list that they joined.
Regards... Todd
On Wed, Jul 15, 2009 at 10:20 AM, postmas...@boxbe.com wrote:
Hello Todd Lyons,
I use Boxbe to protect my email address. While I did receive your email
about Re: Copy
On Sat, Jun 27, 2009 at 7:03 AM, Mike Spreitzermspre...@us.ibm.com wrote:
Today's instance finished shortly after I sent the email below. BTW, here
are some specifics on the table (which uses MyISAM). Thursday's instance
has 11 GB of data and 0.78 GB of index. Today's instance has 26 GB of
On Mon, Mar 9, 2009 at 9:10 AM, Stefan Hinz stefan.h...@sun.com wrote:
MySQL and ZFS
http://forge.mysql.com/wiki/MySQL_and_ZFS
This Thursday (March 12th, 14:00 UTC), Martin MC Brown will give a MySQL
University session on MySQL and ZFS. MC works on the MySQL Documentation
Team and has been
Hello all!
We have a master-master replication system. Both nodes run 5.0.54,
the version compiled by centos, running on CentOS 5.1 x86_64. The
boxen have 8 GB RAM, 1 GB swap, and the cpu is Xeon(R) CPU X3220 @
2.40GHz (shows as 4 cpus to the system). db1 is serving the live
site, db2 is used
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Sun, May 18, 2008 at 01:02:32PM +0530, Ananda Kumar wrote:
I want to purge bin logs which are older than 4 days. I want to keep 4 days
of bin logs so that in the event of any data issue, i can restore it from
bin logs. So, i tired to use
PURGE
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
I've been looking for a way to fake replication from mysql to a local
BDB database. I'm not finding anything. Anybody ever come across this?
It seems like it wouldn't be too terribly difficult to read from the
relay-log and keep track of where you
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
I've been experimenting with mysql replication, specifically error
handling under varying error conditions. My tests are with 5.0.22 that
comes with CentOS 5.0.
My main concern is that I would like to lower the slave_net_timeout
setting, but don't
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Sun, Dec 02, 2007 at 09:55:23AM +0530, Alex Arul Lurthu wrote:
How about looking at the .frm file of the table.
A couple of quickie tests shows something promising:
strings table.frm | egrep 'MyISAM|InnoDB|engineA|engineB|etc'
Unknonwn
30 matches
Mail list logo