Can anyone give me the bash script of mysql db backup?

Did not work

In collab how do we install the driver

have no idea what “collab” is. it is not mysql related question

Anyhow leave it…i will find a way…btw it is related ro mysql

All thanks to God almighty for bringing such a good person into my life like @Hudson_Kaleb Trader, I invested with a start up capital of $500 and to my greatest surprise I received my profit of $5,000 in trading once again sir I’m using this medium to say thank you for your help and support I’m really grateful to have you in my life…
Join the channel and contact him l swear you will never call forex Binary , Bitcoin, Ethereum, usdt a scam again

https://t.me/httpinvestmentsoptions

Hey guys
im used pt-query-digest
and i need to know what is query are popularity
but i think my result is broken
because i need to see top 10 queries ordered by query_time and qps
my script:
pt-query-digest slow.log –filter ‘$qr->distill($event->{arg}) =~ /\bactual_market_sale\b/’ –order-by QPS

How to write store procedure by using Fibonacci series

you can’t get your result sorted by query_time and qps at the same time. you can either use default sort which is query_time:sum or what you query_time:cnt (what is qps). that works for me: pt-query-digest –filter ‘(($event->{arg} ) =~ /\tfoo\b/)’ –order-by query_time:cnt –limit 10 slow.log. but honestly saying I do not think that you should prefer qps over sum of execution time unless you need it for some reporting

I do not need a request that was applied 1 time and took a very long time
I need requests that have been used more than twice
to exclude queries that were written, for example, by analysts for reporting

Thank you for the answer )

–filter ‘(($event->{arg} ) =~ /\tfoo\b/)’
what is foo in your script ?

unfortunately, there is no way to automatically exclude such queries. but you can also add more filters like username (assuming that analysts use dedicated user) or something else. if you do not have anything like that you will have to filter the report manually

“foo” can be any string pattern you would like to match. in your case it could a table name

sorry. i have a typo in a pattern. not sure if you realized but it should be “\bfoo\b” (instead of \tfoo\b)

Lead squared previous year coding question

we have replication lag of 60mins , on the replica currently the system user is on “Reading event from the relay log”. is there anything I can do?

check relay logs for events it tries to process. there should be something specific about them.

#How to write store procedure # 1 to 20 between prime number want to output

exec_master_log_pos isn’t increasing at all

also relay_log_pos is stuck

what can i do?

you must check relay log or binary logs on the master. position/file you can extract from the “show slave status”

how i check the relay log?

relay_log_file
relaylog.330689

relay_log_pos
34288816

we are running mysql 5.7 on cloud (GCP)

please help me understand how to read the relay log

in exactly the same way how would you do it with the binary log: mysqlbinlog tool will help do everything for you

SET @@SESSION.GTID_NEXT= ‘AUTOMATIC’ /* added by mysqlbinlog */ /*!*/;
DELIMITER ;
# End of log file
/*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/;
/*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=0*/;

you did something wrong. please google for how to use mysqlbinlog correctly. you should have a list of events with insert/update/delete statements

ERROR: Got error reading packet from server: Binary log is not open

Can anyone give me the bash script of mysql db backup ?

i have many from those logs:

MySQL thread id 2, OS thread handle 140230850688768, query id 262193344 Reading event from the relay log

what can i do with this?

please anybody? 🙁