"Valdir Henrique Dias Leite" <[EMAIL PROTECTED]> wrote: > I have an application that uses mysql embedded (performance > issues ...). > > The app itself works fine, but data adminsitration (issuing > DDL, DML statements ) is very complicated using C API... > > So, I created an entry in my.cnf pointing to directory where > database used by embedded is, aiming to use mysql interface > to perform queries, updates, et cetera. > > The problem is: Every changes I make using mysql interface, > don=B4t reflect inside embedded scope (for example, inserts > made by mysql don=B4t exists in queries run by embedded > application). > > My questions are: Is it possible to have a situation like > mine ? There is an "isolation" between two aplications > (mysqld and mysqlembedded) ? May I "mix" scenarios as I > wonder ? What is wrong ?
Read manual on "flush tables" and "lock tables": http://dev.mysql.com/doc/mysql/en/LOCK_TABLES.html http://dev.mysql.com/doc/mysql/en/FLUSH.html -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]