When will be the above job executed?
What does MyQctoolProd mean?
If any thing goes wrong where should we check?
if I change table B name will it destroy the FKs?
is it possible to select a random item from a json in a row?
or i have to fetch the data first and random it?
mysql -B -u root test -h localhost -p -N -e
-B / -N / -e ?
man mysql
use any kind of testing tool. They can usually populate some data as well. Look at sysbench, tpcc or anything similar
00 22 * * * /db_apps/mysql/cronjob/mysqlbackup.sh MyQctoolProd> /tmp/mysqlbackup_MyQctoolProd.log 2>&1
Can any one please explain:
When will be the above job executed?
What does MyQctoolProd mean??
If any thing goes wrong where should we check?
00 22 * * * /db_apps/mysql/cronjob/mysqlbackup.sh MyQctoolProd> /tmp/mysqlbackup_MyQctoolProd.log 2>&1
Can any one please explain:
When will be the above job executed?
What does MyQctoolProd mean??
If any thing goes wrong where should we check?
This stuff is not related to mySQL
Yes, and it is not related to mySQL
It is Linux/Unix problem
00 22 * * * /db_apps/mysql/cronjob/mysqlbackup.sh MyQctoolProd> /tmp/mysqlbackup_MyQctoolProd.log 2>&1
Can any one please explain:
When will be the above job executed?
What does MyQctoolProd mean??
If any thing goes wrong where should we check?
Read man cron for understanding crontab entries
Thanks
00 22 * * * /db_apps/mysql/cronjob/mysqlbackup.sh MyQctoolProd> /tmp/mysqlbackup_MyQctoolProd.log 2>&1
Can any one please explain:
When will be the above job executed?
What does MyQctoolProd mean??
If any thing goes wrong where should we check?
Neither one can tell you what is in your bash script and where to look for diagnostics it produces.
You must read the script
https://youtu.be/BuHAkila_Oo
MySQL System Admin Real Time Task Step by Step
Mysql admin Playlist
In this video , I am going to discuss about basic MySQL commands in dba doctor channel.
In DBA DOCTOR Channel we are covering System Admin task what all he should know to handle MYSQL related incidents/outages.
Like creating database
Checking and verifying the connection and server status.
monitoring server connection,
Monitoring server status,
Creating user assigning roles,
Dropping the user revoking the roles,
Switching the user,
inserting the data,
Selecting the record,
creating table,
dropping table,
dropping database
Welcome to my channel DBA Doctor.
https://www.youtube.com/channel/UCBf4WAQwFr3XxagqXZMcWZA
DATABASE PLAYLISTS :-
https://studio.youtube.com/channel/UCBf4WAQwFr3XxagqXZMcWZA/playlists
Stay tuned by clicking the subscribe button and clicking on bell icon for future notifications. Thanks 🙏
***********************************************************
Mysql Complete Tutorial:-
SQL Server Complete Tutorial:-
SQL Server Complete DBA Interview Questions and Answer:-
Microsoft Azure Complete Tutorial:-
Aws Complete Tutorial:-
Always on Real Time Interview Questions:-
https://youtu.be/W-ZY2rAKuII
AZ-900 microsoft azure fundamentals tutorial:-
https://youtu.be/xH3fYDyc8Ew
MySQL System Admin Real Time Task Practical Step by Step:-
https://youtu.be/BuHAkila_Oo
Microsoft Azure SQL database Interview Questions and Answers:-
https://youtu.be/VAIJyV-H92w
SQL Server DBA interview Questions and Answers Part-1|Microsoft | SQL Server| DBA:-
https://youtu.be/SoPrSOOSkc4
SQL Interview Questions and Answers:-
https://youtu.be/Bw_6X4zNwIg
Learn How to Migrate Database using Amazon :-
https://youtu.be/Gk7L9s4ntWo
#mysqlrealtime
#mysqldba
#mysqlsysadmin
#mysqluser
#mysqldatabase
#mysqlmonitoring
#mysqlcommandline
.
.
Just ask what will happen when user start a query which would update 1M rows. It is the endless topic to discuss and you will touch almost every piece of mysql internals and you can go as deep as you want based on candidate experience.
yes it is possible.
formally you should re-create the FK constraint after renaming the table.
how can i do that
By using select statement
not in python code
by doing it I see the foreign key navigates to the new table’s name but does it really work or I need to analyze table / drop FK and recreate?
im not sure your got my point
for example i have row with a json column with this value [1,2,3,4,5,6,7,8]
i need to choose one of the items of that list in json randomly with sql query before fetching the data so keep my code clean
you can re-check in the docs, but I would always do this in 3 steps
0 drop the constraint
1 rename the table
2 re-create the constraint.
I’m afraid you can only finally prove this or that behavior by analyzing the source code and writing a test case for this (or use existing)
0 drop the constraint
1 rename the table
2 re-create the constraint.
I’m afraid you can only finally prove this or that behavior by analyzing the source code and writing a test case for this (or use existing)
yeah, guess i’ll give it a try on some test server and see. thanks! 🙂
for example i have row with a json column with this value [1,2,3,4,5,6,7,8]
i need to choose one of the items of that list in json randomly with sql query before fetching the data so keep my code clean
this is not a JSON I suppose
for example i have row with a json column with this value [1,2,3,4,5,6,7,8]
i need to choose one of the items of that list in json randomly with sql query before fetching the data so keep my code clean
you must have an object or array of objects at the top level