We will stop accepting contributions to Documentation on August 8. Please see our post on meta.

MySQL


Introduction

 Getting started with MySQL

Recent Contributions

Chandru requested cassandra
Akib Bagwan requested drop foreign key
ParthaSen created reset root password when " /var/run/mysqld' for UNIX socket file don't exists"
inetphantom created Getting Started with MySQL Workbench
BacLuc created Recover from lost root password
summary requested topics need improvement proposed changes activity

30 Requested Topics

dismissed handled newest top
4
MySQL replication methods MySQL replication: methods, "pros and cons", example configuration. requested by Kleskowy 2,053
4
MySQL Architecture requested by S.K. Venkat 846
3
MySQL Benchmarking requested by S.K. Venkat 846
3
MySQL Logging requested by S.K. Venkat 846 5 comments
2
Innodb Engine requested by S.K. Venkat 846 1 comment
2
MySQL Partitioning requested by S.K. Venkat 846 2 comments
2
Spatial Indexing >= 5.7 requested by RedactedProfile 1,235
2
InnoDB File Formats requested by aravind kumar 189
2
Privileges What they are, what they can do, how to grant them, common pitfalls with GRANT. cf. dba.stackexchange.com/a/96894/53784 requested by WAF 292
2
User Management Details about managing the users of the database. requested by Matt Clark 12k
2
MySQL Security requested by S.K. Venkat 846
2
Character Sets and Collations Over view; best practice; coding requested by Rick James 39.2k
2
Types of KEYs in MySQL requested by Sanjeev kumar 62
2
MySql datatype vs MsSql datatype This topic should cover what equivalent datatype should be used in MySql, to give an example, In MySql if we want a bit field then "tinyint(1)" should be used instead of "bit" datatype requested by Ranjit Singh 2,597
1
MySQL User Defined Functions requested by S.K. Venkat 846
1
MySQL Plugins requested by S.K. Venkat 846
1
MySQL Administration requested by S.K. Venkat 846
1
Installing and Upgrading requested by Majid 712
1
DTrace requested by S.K. Venkat 846
1
Galera/PXC Tips on setup. Hints on best practice. Benefits/caveats. Multi-master vs pretending to be master-slave. SST/IST. More: mysql.rjweb.org/doc.php/galera requested by Rick James 39.2k
1
Install Mysql Windows 64 bit General Steps for Installing Mysql on Windows 64 bit machine requested by murtaza.webdev 1,339
1
Unity3D Examples to create detailed code for projects. requested by R.K123 127
1
Functions and Operators Operators like logical operators, assignment operators and comparison functions can be explained in this topic with example and syntax requested by Ponnarasu 637
1
Backup without `mysqldump` MyISAM tables can be moved/copied on file-System Level at a much faster Speed than exporting/importing all records. There should be an example on how to do this, including index updating after table move (OPTIMIZE TABLE...). requested by Benvorth 3,084
1
MySql scaling for Reporting requested by Sid 2,223
1
SELECT From JSON Column If you have saved data into a field as json, you can use mysql to retrieve each field. It may be useful in migrating database when you have decided that using JSON in a database was not a good idea. requested by tika 2,446
1
MySQL integer based column stores 0, if any user tries to INSERT string values. requested by Jabed Hossain 40
0
Mysql Transactional requested by Prem Narain 53
0
drop foreign key requested by Akib Bagwan 25
0
cassandra requested by Chandru 1