Hi
I am running collectd
(http://www.collectd.org/wiki/index.php/Plugin:MySQL) version 4.9.0 on
Ubuntu Linux 8.04 (Hardy) Server.
Plugin mysql
Database SMSPAY
Host localhost
Hello,
I have a table, which has a column named as domain, each domain has
some IPs, each IP has two attributes: disabled,noticed.
For example, the table:
domainIP
www.aol.com 64.12.245.203 64.12.244.203 64.12.190.33 64.12.190.1
But I don't know how to control the IP's
Hi Eva,
It seems to me that you might want to have two tables that will describe
data in your database
* - DOMAINS
* - IPS
DOMAINS table should contain two fields:
* `domain_key` - auto-increment
* `domain_name` - varchar(20)
IPS table should contain three fields
domain_key - int(10) -
-Original Message-
From: Mikhail Berman [mailto:mikhail...@gmail.com]
Sent: Wednesday, December 23, 2009 9:16 AM
To: Eva
Cc: mysql@lists.mysql.com
Subject: Re: help design the table
Hi Eva,
It seems to me that you might want to have two tables that will describe
data in your database
*
Hey.
Back to few years ago, InnoDB require table level locking when
inserting auto-increment PK to the table, and Heikki said there will
be a fix.
Is this problem still exist now?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
I got an alert that one of the drives was filling up (3% free). So I
figured out that a large chunk was from /var/log/mysql
r...@pse10:~# find / -type d -print0 | xargs -0 -n1 du -sk | sort -rn |
head -n20 ~/dir-sizes.txt
r...@pse10:~# cat ~/dir-sizes.txt
159121012 /
70442396 /var
70127764
That was a wrong operation to do.
Anyway, issue a show master status, and set the replucation again on the
slave with the new values. Next time look for 'purge binary logs'!
Ciao
Claudio
On 23 dec 2009 21:21, Daevid Vincent dae...@daevid.com wrote:
I got an alert that one of the drives was
The issue is that replication relies on this logs !!!, so when you
deleted them .
Generally speaking you have to:
stop the slave
sync the master with the slave (there are several ways to do this and
depending how busy is your master)
grab the master status (position)
change the slave
In this case it should not be needed to sync the slave,
Resetting the master basically broke the 'pipe' but events are still on the
new binary logs, it might have lost some event in some unfortunate case, but
anyway it is probably for now to put slave back on track, check and
eventually resync.
*Next time look for 'purge binary logs'!*
Purge may also cause problem , before doing purge make sure slave is in sync
with master or at least cross check slave currently which bin file getting
sync.
On Thu, Dec 24, 2009 at 2:05 AM, Carlos Proal carlos.pr...@gmail.comwrote:
The issue is that
Thank you guys for the tips.
I've also updated the documentation so others don't run into this:
http://dev.mysql.com/doc/refman/5.0/en/reset.html
-Original Message-
From: prabhat kumar [mailto:aim.prab...@gmail.com]
Sent: Wednesday, December 23, 2009 12:46 PM
To: Carlos Proal
Cc:
Yep, It might not be needed to sync, but its better to double check ;).
Carlos
On 12/23/2009 2:44 PM, Claudio Nanni wrote:
In this case it should not be needed to sync the slave,
Resetting the master basically broke the 'pipe' but events are still
on the new binary logs, it might have lost
Hi,
I am getting this information from slave
mysql show slave status \G;
*** 1. row ***
Slave_IO_State: Connecting to master
Master_Host: 201.107.236.77
Master_User: root
Master_Port:
You can see connecting to master means it is not able to establish the
connection from slave to master, give the grants as (replication client
etc..)
and then try again.
Thanks,
Dilipkumar
Database Engineering
Pager mail:9884430...@nma.vodafone.in
-Original Message-
From: Jeetendra
14 matches
Mail list logo