how to get the creation date of MySQL table

Hi Readers, this document deals with how to get the creation date of MySQL table. MySQL is an open source relational database management system. Its name is a combination of “My”, the name of co-founder Michael Widenius’s daughter, and “SQL”, the abbreviation for Structured Query Language. Sometimes we may need to check when the table is created in the schema, Here is the command for that. The following command can be used to check the last update of a table in the schema. © 2018, Techrunnr. All rights reserved.

Read More

check number of threads connected to mysql

Hi All, this document deals with how to check the number of threads connected to MySQL. Mysql is a single process application which supports multithreading. For each and every connections a thread is created in MySQL server. Thread gets destroy once the operation is done in MySQL server which leads to closing the connection to MySQL server. you can use SHOW PROCESSLIST command in MySQL to see about what’s going on in your SQL server. This is the sample output of the above command. Use the below command to see…

Read More

mariadb star replication

mariadb star replication Hello Techrunnr subscribers, this document deals with how to set up mariadb star replication. This type of topology requires when the application runs in a different region. And our motive is to update data in all the servers on a real-time basis. How does it work? So here we are choosing around 9 servers in a different location. Out of these, we have a server which is placed in the center. In the initial configuration, the central server is marked as the slave for all the servers,…

Read More

connect mysql server from spring boot application with SSL

connect mysql server from spring boot application with SSL Hello Techrunnr, this document deals which how to connect mysql server from spring boot application with SSL enabled. All the applications interact with the database in order to get data for your web application. It’s always better and recommended to have encrypted communication between database and web application. Setting up of an encrypted connection between these two is very simple and easy. Here are the steps connect MySQL server from spring boot application with SSL enabled. Prerequisites * Java installed machine,…

Read More

how to remove password complexity from mysql

How to remove password complexity from MySQL Hello Techrunn readers, this document deals with how to remove password complexity from mysql. Removing password complexity is not a good habit, even though there is some certain condition which makes us remove the complexity due to lack of application support to special characters etc. By default password validate plugin installed with MySql. In order to remove password complexity, you just need to remove the plugin. Here are the steps to achieve this. Step 1 : Login to mysql using root user. Step…

Read More

How to remove old mysql-bin logs

How to remove old mysql-bin logs Hi Techrunnr Readers, this document deals with how to remove old mysql-bin logs. Mysql Bin log file is a binary file which records all the modification made to Mysql server instance. In the worst case, this Binary files are used for recovery of craased mysql server. Mysql server replication is fully based upon the binary logs. Sometimes we have to remove the binary files due to low disk space in mysql server. 1. List Binary Files First list all the binary files, ls -a…

Read More