Here my problem; in such a case it complains about duplicate connections with same connection name: Test::Test(QString connectionName) { db=QSqlDatabase::addDatabase("QMYSQL",connectionName); } int main(int argc, char *argv[]) { QString connectionName=QString("test"); QCoreApplication a(argc, argv); Test myDb(connecti...
Hi, I have to try out a master-master replication for a database of four tables. Both the master can write at once, but they would not be updating the same rows of a table and the insertions will also be collision free. The replication should be asynchronous Is this behaviour possible to implement? If so, do I have to write my own code ...
Hi folks, one question about NDBCLUSTER. I inherited the writing of a web site basing on NDBCLUSTER 5.1 solution (LAMP platform). Unfortunately, who designed the former solution didn't realize that this database engine has strong limits. One, the maximum number of fields a table can have is 128. The former programmer conceived tables ...
Possible Duplicate: What is the best MySQL Client Application for Windows i am used to using tools like SQL Enterprise Mgr for SQL Server databases and Toad for Oracle. I now (for a few reasons) need to start working with MySQL. What is the best desktop front end for MySql databases? ...
i am used to SQL Server and SQL enterprise studio when using databases in my solutions. I have to use mySQL so i have tried out SQL-Front gui which seems pretty good. The one missing thing that is a pain point is that i can't figure how to have multiple queries around at once. in SQL Server Enterprise manager, it would create a new ta...
Hello, As my first message here, i don't know if i have to answer or post a new message. I have the same problem as here and the one and only given answer doesn't help me (except if the documentation is incorrect). "You can make OPTIMIZE TABLE work on other storage engines", but my engine is InnoDB. I thank you for your help. S. ...
Is there any easy way to track/monitor all the SQL of the queries, executed by an MySQL server (on a Windows machine)? Update: I am asking about the free tool. ...
I'm trying to create a drop down select option using PHP, MySQL, and ajadx I have the PHP and ajax pretty much figured out but I'm stumped on how I should organize my tables I couldn't decide so I created it both ways: The first way the tables are: CourseTbl containing (CourseID*, and CourseName) DateTbl, (DateID*, and DatesOffered(en...
Hello I need a Windows based MySQL profiler. I've read the article where says that profiling is limited on Windows, but Im convinced that there has to be a tool which allows me at least to check all queries issued to the database, hopefully providing some more data. Can anyone help? ...
Hey there, Our organization has a very large database which Replicates to separate global servers. In our database some tables contain data exclusive to a certain region thus providing privileges to exclusive information to users who are within those regions. example ( transactions_australia, transactions_dubai ) Contrary t...
Hi, I am working with a database which unfortunately has a lot of unused tables and I am trying to clean it up. I'm trying to find a way where I can be 100% confident that a particular table is no longer being used. After some googling, I still cannot find a good way to do so. I am only able to tell the last writes to a table (INSERT, ...
My Ubuntu installation was recently updated along with MySQL and somehow I have lost contact with my databases. By this, I mean that the FILES are still there on my system, and I have pointed the data-dir to the location of the files. However I can no longer start the mysql client using my previous username/password combination, and wh...
Hi, I'm injecting a stress test into my web app that connects to a mysql server and I'm monitoring the show processlist of mysql. When the load is high (high swap i/o) I get many processes like that: | 97535 | db| localhost | userA | Sleep | 515 | | NULL | 97536 | db| localhost | userA | Sleep | 516 | | NULL | ...