How to LOCK all the database??
Hello colleagues. How can I global lock a database? Global means that no user/process should be able to access it; I want to keep the database in read only for a certain period, NOT ONLY for the current session. thanks Enrico -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
What's the best way to align master and slave before starting replication?
Hello colleagues, I want to set up a replication schema on MySQL (ISAM tables). I then have to align the databases before starting the replication. I would like to NOT stop the database to do the alignment because the application needs a lot of time to startup (1 hour) and I may have to start and stop the replication several times during the application life (don't care about binary logs, they are always enabled!) My database is composed by several "pieces" ... What is the best way to perform the alignment including the costs Vs. benefits? * tar cvf of the datafiles? Is it absolutely needed to shutdown the database? * mysqlhotcopy? can I keep ON the application? * mysqldump? How can I to lock all the database structures? what's about the application transactions? are they frozen on the COMMIT until the tables are unlocked? Thanks Enrico -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
innodb_locks_unsafe_for_binlog
Hello colleagues, I knew there's an option to have a row level locking rather than a table level one, the innodb_locks_unsafe_for_binlog I knew also that this option makes the binary logs unsafe I'd like to know if the whole replication mechanism becomes unsafe in this case and then what's the mechanism to be used to replicate the DB when the innodb_locks_unsafe_for_binlog is enabled. regards Enrico -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Does the binary log enabling affect the MySQL performances?
Hello colleagues, I'd like to know IF by enabling the binary logs production I'll affect meaningfully the MySQL DB performances, and HOW MUCH the performances are impacted Any witnesses on this topic? Regards Enrico -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
[Fwd: [Fwd: Do the following LOG enabling / disabling command work in 3.23??]]
Hello colleagues, Im'using the MySQL 3.23, I've found the following commands SET SQL_LOG_BIN=0 Disables update logging if the user has process privilege. Ignored otherwise. (Master) SET SQL_LOG_BIN=1 Re-enables update logging if the user has process privilege. Ignored otherwise. (Master) in the http://www.scit.wlv.ac.uk/appdocs/mysql/manual_toc.html manual ... I suppose they enable/disable the binary log production, is it right? I mean: all the log production, not just for the current client, is it right?? . Why they don't work properly??? Which is the right way to enable / disable ALL the LOG production at run time, if any? thanks Enrico -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
ORACLE to MySQL migration
Hello colleagues, I have to migrate a lot of ORACLE 8.1.7 databases to MySQL 3.23 I'm looking for a tool or for an algorithm which fully supports any ORACLE structures ... If needed I may use a commercial tool, otherwise a free software / shared software should be very appreciated Can anyone give me some suggestions? thanks a lot Enrico -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Log production option enabling
Hello colleagues: I would like to know if it's possible to start the log file production at run time, i.e. without stopping and restarting the database ... I would like to know also of it's possible to change at run time the directory where the log files are stored after their generation. I'm working with 3.23 release. Thanks a lot Enrico -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]