Problem of deadlocks exists in all programming languages with lock-based synchronization. And even more, if the language has message passing synchronization program can still be stuck in deadlock at database level. Down here I’ll write a Java JDBC example of database deadlock:
Continue reading “Database deadlock example”MySQL
Where is MySQL database stored
All MySQL databases are stored in corresponding directories inside a MySQL DATADIR directory, which is specified in a configuration. E.g. myExampleDB’s files would be stored inside ‘$DATADIR/myExampleDB’ directory.
If you want to get MySQL datadir location and you have access to MySQL you can simply execute the following SQL query: Continue reading “Where is MySQL database stored”