SLAVE aware of binary log file switch?
Hi all, Given a MASTER and a SLAVE. When launching the SLAVE, it knows about the binary log file used by the MASTER and the position in that log file. Say the binary log file (on the master) has reached its maximum size, so that it has to switch to a +1 binary log file: does he inform the SLAVE of that switch so that the SLAVE updates its information about the MASTER status? I'm readind the documentation http://dev.mysql.com/doc/refman/5.1/en/binary-log.html and dont see what is happening while slaving. Thank you. -- RMA.
Re: SLAVE aware of binary log file switch?
On 2013-06-17 14:43, Denis Jedig wrote: Say the binary log file (on the master) has reached its maximum size, so that it has to switch to a +1 binary log file: does he inform the SLAVE of that switch so that the SLAVE updates its information about the MASTER status? The master does not inform the slave via an immediate communication channel, but the slave knows how to keep up because the end of the binary log file contains continuation information - i.e. the name of the next log file to fetch. OK. I'm sorry I was mislead by the output of: [mihamina@prod-ebidual ~]$ echo SHOW SLAVE STATUS \G; | mysql -uroot -px | grep 'Slave_' Slave_IO_State: Waiting for master to send event -- this Slave_IO_Running: Yes Slave_SQL_Running: Yes -- RMA.
Re: how to replace this data in a complex field?
On 07/31/2012 09:07 AM, Incarus Derp wrote: I need to replace ACRE_PRC119_ID_29 with ACRE_PRC119 and I cannot do this externally. I have PREG_REPLACE but I'm not sure how I would apply this to the database because it only SELECT's as far as I know. You could CREATE a TABLE from the SELECT. Isn't it? -- RMA. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
Re: 回复: 回复: Why is creating indexes faster after inserting massive data rows?
On 05/07/2012 12:30 PM, Zhangzhigang wrote: Thanks, i thought about this answer in the past, and i appreciate your reply. How about the omelet? What's your method? -- RMA. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
Re: FYI: how to prevent mysql from oom-killer
On 04/13/2012 03:17 PM, Reindl Harald wrote: with one single command you can protect processes from get killed i started to run this every 15 minutes to make sure it is also active after restarts I understand your issue, but isn'there a configuration way to just limit the memory usage of MySQL? -- RMA. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
Re: error 1041: Out of memory;
On 02/28/2012 03:34 PM, Shafi AHMED wrote: pls assist - please give more information (OS, ...) - you can search the web with -- ulimit more memory -- mysql you-os increase memory -- mysql you-os increase memory ulimit -- mysql configuration memory -- ... -- RMA. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
Triggers and FOR EACH ROW
Manao ahoana, Hello, Bonjour, I just read several documentation on MySQL triggers. The way to create triggers is: CREATE TRIGGER t21_au BEFORE UPDATE ON t22 FOR EACH ROW BEGIN // ... END; The trigger I want is only on UPDATE. Is FOR EACH ROW referring to each existing row in the table, or to each UPDATEd row? Misaotra, Thanks, Merci. -- Architecte Informatique chez Blueline/Gulfsat: Administration Systeme, Recherche Developpement +261 34 56 000 19 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
describe relation between LDAP entries
Manao ahoana, Hello, Bonjour, I have LDAP entries, and SQL tables are the relation between them. There are only relations between 2 entries. There are modem and customers entries in the LDAP directory I need advice on optimizing the way I store relations. For example SELECT * FROM customer_has_modem; +-++ | customer| modem | +-++ | a=aa,b=bb,c=ccc | d=dd,e=ee,f=ff | +-++ Is it OK? Have you another way to do it? - splitting the comma separated fields? - whatever? There might later be be a date field in this table to trace the modem movements. Misaotra, Thanks, Merci. -- Architecte Informatique chez Blueline/Gulfsat: Administration Systeme, Recherche Developpement +261 34 29 155 34 / +261 33 11 207 36 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: describe relation between LDAP entries
Mihamina Rakotomandimby miham...@gulfsat.mg : Have you another way to do it? - splitting the comma separated fields? I mean: customer_cn|customer_sn| customer_uid|modem_cn|modem_sn|modem_uid| staff | (null) |(null) |staff | (null)| (null) | Joe M |Mudd | joem|Joe M | Mudd | joem | -- Architecte Informatique chez Blueline/Gulfsat: Administration Systeme, Recherche Developpement +261 34 29 155 34 / +261 33 11 207 36 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Problem with mysql
Jørn Dahl-Stamnes sq...@dahl-stamnes.net : I have checked the local DNS and 'r2-d2' and 'r2-d2.dahl-stamnes.net' resovl to the same IP-addresse. What's wrong? Reverse resolution? I have checked that, and reverse DNS is OK - both resolve to 192.18.2.22 I read you solved your problem, but by reverse I meant what r2-d2.dahl-stamnes.net resolves to. -- Architecte Informatique chez Blueline/Gulfsat: Administration Systeme, Recherche Developpement +261 34 29 155 34 / +261 33 11 207 36 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Problem with mysql
(Correction, seel below) Jørn Dahl-Stamnes sq...@dahl-stamnes.net : I have checked the local DNS and 'r2-d2' and 'r2-d2.dahl-stamnes.net' resovl to the same IP-addresse. What's wrong? Reverse resolution? I have checked that, and reverse DNS is OK - both resolve to 192.18.2.22 I read you solved your problem, but by reverse I meant what r2-d2.dahl-stamnes.net resolves to. Sorry (...) what 192.18.2.22 resolves to. -- Architecte Informatique chez Blueline/Gulfsat: Administration Systeme, Recherche Developpement +261 34 29 155 34 / +261 33 11 207 36 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Problem with mysql
Jørn Dahl-Stamnes sq...@dahl-stamnes.net : I have checked the local DNS and 'r2-d2' and 'r2-d2.dahl-stamnes.net' resovl to the same IP-addresse. What's wrong? Reverse resolution? -- Architecte Informatique chez Blueline/Gulfsat: Administration Systeme, Recherche Developpement +261 34 29 155 34 / +261 33 11 207 36 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Help saving MySQL
Tom Worster f...@thefsb.org : my guess is that it would be better if mysql did not need to fork. the harm would be the confusion caused to users. I really dont think it is a problem. _Users_ lazzy to follow the fork will stay with MySQL under Oracle. _Users_ less lazzy will switch. Developpers will always know what to do. -- Architecte Informatique chez Blueline/Gulfsat: Administration Systeme, Recherche Developpement +261 34 29 155 34 / +261 33 11 207 36 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Help saving MySQL
Michael Dykman mdyk...@gmail.com : Are we such sheep that we leave this in the hands of the highest bidder? I dont understand: Dont'you like the idea of forking? Why exactly? -- Architecte Informatique chez Blueline/Gulfsat: Administration Systeme, Recherche Developpement +261 34 29 155 34 / +261 33 11 207 36 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Help saving MySQL
Ryan Chan ryanchan...@gmail.com : On Sun, Dec 13, 2009 at 11:48 AM, Michael Dykman mdyk...@gmail.com wrote: I hope the only reason this thread is so quiet is because we are all busy notifying our friends. There are a hell of a lot more users invested in MySQL than those who read this list. Spread the word! Let's stand up today to face the evil! Could people translate that message to the maximum available langages? -- Architecte Informatique chez Blueline/Gulfsat: Administration Systeme, Recherche Developpement +261 34 29 155 34 / +261 33 11 207 36 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org