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”
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”