How to replicate a timestamp field
Hello. I know that when a timestamp field has "default current_timestamp on update current_timestamp", it will be updated for each update. Question: I have a slave server which replicate this field (The master is deployed Europe and the slave in Brazil). The time of fly to replicate the query that leave the master and go to slave can be more than 1 second. Therefore, when this query is executed in slave server, the timestamp value will be different of the master server one. Is there some way to fix it? Because, The tuples must have the same value in both Master and Slave. Regards Bruno Silva __ Fale com seus amigos de graça com o novo Yahoo! Messenger http://br.messenger.yahoo.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Int(4) or int(8)
hi all The mysql manual inform that: "EX. century int(4) The result is that values in the century column usually are displayed four digits wide. However, its important to undesrstand that the display width is unrelated to the range of the datatype. The display width specified for a column affects ONLY the maximum number of digits MySQL uses to DISPLAY column values." I understand that theses values are unrelated to the range of datatype values, however i did not saw any diference when i use int(4) or int(8) Some idea? Regards Bruno __ Fale com seus amigos de graça com o novo Yahoo! Messenger http://br.messenger.yahoo.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Decimal versus Float Point Type
Dear all. The MySQL Manual inform that Decimal Data Type is used for represent exact-number, but like Float Point Data Type, Decimal use rounding case the fractional part is not sufficient. Therefore, what the difference? Regards Bruno R. Silva ___ Novidade no Yahoo! Mail: receba alertas de novas mensagens no seu celular. Registre seu aparelho agora! http://br.mobile.yahoo.com/mailalertas/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
#1205 - Lock wait timeout exceeded; Try restarting transaction
I am using tables INNODB. After one query, the MySQL does not liberate the LOCK, and when I try to execute same query it appears the message. #1205 - Lock wait timeout exceeded; Try restarting transaction whait urgently one helps. thanks, Bruno -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Why mysql LOCK any lines and does not allow that I delete?
I am with a problem in one query of simple DELETE. #1205 - Lock wait timeout exceeded; Try restarting transaction Why mysql LOCK this line and does not allow that I delete, if I did not emit none stantment of LOCK? Please, help me! Bruno Rodrigues Silva Brazil. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]