Is there a naming convention for MySQL?
Here’s how I do it: Table names are lower case, uses underscores to separate words, and are singular (e.g. foo, foo_bar, etc. I … Read more
Database
How SID is different from Service name in Oracle tnsnames.ora
Why do I need two of them? When I have to use one or another? 5 Answers 5
Is it better to use multiple databases with one schema each, or one database with multiple schemas?
After this comment to one of my questions, I’m thinking if it is better using one database with X schemas or vice versa. … Read more
Storing time-series data, relational or non?
I am creating a system which polls devices for data on varying metrics such as CPU utilisation, disk utilisation, temperature etc. at (probably) … Read more
How to recover MySQL database from .myd, .myi, .frm files
How to restore one of my MySQL databases from .myd, .myi, .frm files? 11 Answers 11
Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation ‘=’
Error message on MySql: Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation ‘=’ I have gone through several other posts and was … Read more
Choosing a stand-alone full-text search server: Sphinx or SOLR? [closed]
As it currently stands, this question is not a good fit for our Q&A format. We expect answers to be supported by facts, … Read more
How do I turn off the mysql password validation?
It seems that I may have inadvertently loaded the password validation plugin in MySQL 5.7. This plugin seems to force all passwords to … Read more
Maximum number of records in a MySQL database table
What is the upper limit of records for MySQL database table. I’m wondering about autoincrement field. What would happen if I add milions … Read more
On duplicate key ignore? [duplicate]
This question already has answers here: “INSERT IGNORE” vs “INSERT … ON DUPLICATE KEY UPDATE” (12 answers) Closed 9 years ago. I’m trying … Read more