I have already seen http://dev.mysql.com/doc/refman/4.1/en/mysql-config-wizard-file-location.html How do I find the MySQL my.cnf location and http://dev.mysql.com/doc/refman/5.1/en/option-files.htm...

Let's say I have a table, email_phone_notes that looks like this: +-----------------------+--------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +----------...

I have got a table time. A time entry (1:n relationship) either belongs to a project entry or to a special_work entry. Either the project id or the special_work id must be set, neither both (exclus...

This appears to be a common problem on 12.04. I've tried everthing in this thread including: sudo apt-get clean sudo apt-get autoclean sudo apt-get remove --purge mysql-client-5.5 mysql-client-c...

Is it possible to set or initialize a query in MySQL for every new connection ? Whenever a connection is created, it will call a procedure or a select query automatically ? Any script or config o...

I have large number of open files limit in MySQL. I have set open_files_limit to 150000 but still MySQL uses almost 80% of it. Also I have low traffic and max concurrent connections around 30 and...

I want to check if innodb_file_per_table is set (i.e .ibd is created) for each database tables using MYSQL-5.5 query. Any way to do it?

I have installed mysql55-server using macports. I can start the server successfully via: $ sudo launchctl load -w /Library/LaunchDaemons/org.macports.mysql55-server.plist And confirm I am runni...

I just saw that MySQL 5.5 offers utf8_general_mysql500_ci as collation. What is the difference to other collations like utf8_general_ci? Should I better use utf8_general_mysql500_ci?

select disease_name from disease where disease_id= (select disease_id from disease_symptom where disease.disease_id=disease_symptom.disease_id AND symptom_id= (select symptom_id from s...