On Mon, Nov 12, 2012 at 5:21 AM, Machiel Richards - Gmail
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 replication was not working
>
On Wed, May 2, 2012 at 4:58 AM, vishesh kumar wrote:
> I am getting following in error log
>
>
> 120502 07:52:05 mysqld started
> 120502
On Wed, Mar 28, 2012 at 1:47 AM, Nuno Tavares 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, 0 rows affe
2012/3/27 Halász Sándor :
> 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 :
[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 hav
On Wed, Jan 25, 2012 at 6:42 AM, Todd Lyons 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 '/u
2012/1/24 Suporte Avanutri :
> 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 is that the access
On Thu, Sep 29, 2011 at 7:12 AM, Jim Moseby 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 0.0086
> seconds' at the
On Tue, Jul 26, 2011 at 8:18 AM, Reindl Harald 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 files and the
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
2010/11/4 Changying Li :
> 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;
>
> mysql> expla
On Wed, Sep 15, 2010 at 6:50 AM, Johan De Meersman 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, yeah. I'
On Thu, Aug 26, 2010 at 6:04 AM, Norman Khine 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 slaves in sync
On Thu, Aug 5, 2010 at 8:35 AM, Nunzio Daveri 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 loads of reports -
> s
On Tue, Oct 27, 2009 at 7:51 AM, Bryan Cantwell 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 of my init script t
On Mon, Sep 14, 2009 at 8:28 AM, Michael Dykman 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 erroneous
as
On Mon, Sep 14, 2009 at 7:44 AM, Néstor 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 Percona which c
On Thu, Sep 10, 2009 at 2:49 PM, Gavin Towey 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 with innod
>> On Wed, Aug 26, 2009 at 02:12, Joe
> 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 hos
On Wed, Jul 15, 2009 at 11:58 AM, mos 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 could do
On Thu, Jul 16, 2009 at 1:18 PM, Gary Smith 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 blank.
> This slave
not being fair is someone 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, wrote:
> Hello Todd Lyons,
>
> I use Boxbe to protect my email address. While I did receive your e
On Tue, Jul 14, 2009 at 2:14 AM, Marcus
Bointon 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 time which
> can take a
On Sat, Jun 27, 2009 at 7:03 AM, Mike Spreitzer 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
> data and 1.8 GB
On Mon, Mar 9, 2009 at 9:10 AM, Stefan Hinz 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 involved with q
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 o
-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
>
>PURG
-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 a
-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 wa
-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 whethe
30 matches
Mail list logo
