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 wo

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 gi

[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)

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

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 m

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

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.