If you want to see the current schema you are on.SHOW SEARCH_PATH;Normally you might be on the public schema. But if you want to change the current schema, try below command.SET SEARCH_PATH TO test;test is the name of the schema.
MySQL/MariaDB makes DBA’s life much easier by allowing to increase the number of max_connections. You can use SHOW VARIABLE LIKE 'max_connections'; to check the number of max connections allowed. mysql> SHOW VARIABLE LIKE 'max_connections'; +-----------------+-------+ | Variable_name | Value | +-----------------+-------+ | max_connections | 151 | +-----------------+-------+ 1 row in set (0.01 sec) You might want to see how many ...
MySQL/MariaDB makes DBA's life much easier by allowing to increase the number of max_connections.You can use SHOW VARIABLE LIKE'max_connections'; to check the number of max connections allowed.mysql> SHOW VARIABLE LIKE 'max_connections';+-----------------+-------+| Variable_name | Value |+-----------------+-------+| max_connections | 151 |+-----------------+-------+1 row in set (0.01 sec)You might want to see how many connections you have in your database right now. You can ...
MySQL/MariaDB makes DBA’s life much easier by allowing to increase the number of max_connections. You can use SHOW VARIABLE LIKE 'max_connections'; to check the number of max connections allowed. mysql> SHOW VARIABLE LIKE 'max_connections'; +-----------------+-------+ | Variable_name | Value | +-----------------+-------+ | max_connections | 151 | +-----------------+-------+ 1 row in set (0.01 sec) You might want to see how many ...
Happy new year! Although it is quite late. I visited Helsinki. I liked it even though everyone around here says it is boring. Took a ferry. Didn't take more than two and a half hours to go there. Walked pretty much 20km.Helsinki CathedralSea from the Market SquareUspenski CathedralHouse of the Estates
RESET SLAVE; doesn’t work in AWS MySQL RDS. You should use the below command to stop replication. CALL mysql.rds_reset_external_master; You will see something like an error message. You can safely ignore that. Try SLAVE STATUS\G. If you get an empty set, your instance has successfully reset the replication.
RESET SLAVE; doesn't work in AWS MySQL RDS. You should use the below command to stop replication. You will see something like an error message. You can safely ignore that. Try SLAVE STATUS\G. If you get an empty set, your instance has successfully reset the replication.
RESET SLAVE; doesn’t work in AWS MySQL RDS. You should use the below command to stop replication. CALL mysql.rds_reset_external_master; You will see something like an error message. You can safely ignore that. Try SLAVE STATUS\G. If you get an empty set, your instance has successfully reset the replication.
Happy new year! Although it is quite late. I visited Helsinki. I liked it even though everyone around here says it is boring. Took a ferry. Didn’t take more than two and a half hours to go there. Walked pretty much 20km.
Happy new year! Although it is quite late. I visited Helsinki. I liked it even though everyone around here says it is boring. Took a ferry. Didn’t take more than two and a half hours to go there. Walked pretty much 20km.
Dates: 05 January 2019 Transportation: ⛴Ferry - Tallinn to Helsinki ⛴Ferry - Helsinki to Tallinn Places: Helsinki, Finland Helsinki Cathedral Uspenski Cathedral Market Square
Tere! It’s been a long time. Didn’t write any blog posts for a while. So many things happened in between. I moved to Estonia. Started working on databases again. Looking forward to writing about databases and travelling.
Tere!It's been a long time. Didn't write any blog posts for a while. So many things happened in between. I moved to Estonia. Started working on databases again. Looking forward to writing about databases and traveling.
Tere! It’s been a long time. Didn’t write any blog posts for a while. So many things happened in between. I moved to Estonia. Started working on databases again. Looking forward to writing about databases and travelling.
LIRNEasia collaborates with University of Dhaka Data and Design lab to perform policy related research. A research workshop was held at University of Dhaka. Apache Spark and Hadoop session was done by me. Research TeamSriganesh sharing the experience in policy related researchApache Hadoop Hands-on sessionHadoop!!!If you are interested in Big Data Research opportunities, please check this link - http://lirneasia.net/wp-content/uploads/2017/02/big-data-Researcher-170207.pdf ...
