Groovy DBA

 show databases; drop database grafanaprod;

(1)  [root@db2prd603 ~]# ls -lrt /var/spool/cron/ total 8 -rw-------. 1 1665466707 domain users    0 Oct  7  2024 map96 -rw-------. 1 root       root                     1662 Nov 26  2024 prd1ins1 -rw-------. 1 db2admin   db2iadm1     1340 Dec  9  2024 db2admin (2)  [root@db2prd603 cron]# stat /var/spool/cron/db2admin   File: /var/spool/cron/db2admin   Size: 1340            Blocks: 8          IO Block: 4096   regular file Device: 802h/2050d      Inode: 50495680    Links: 1 Access: (0600/-rw-------)  Uid: ( 1002/db2admin)   Gid: ( 1003/db2iadm1) Context: unconfined_u:object_r:user_cron_spool_t:s0 Access: 2025-06-22 09:50:55.848724797 -0500 Modify: 2024-12-09 10:13:33.904942888 -0600 Change: 2024-12-09 10:13:33.905942976 -0600  ...

 mysqladm-myhvrdb602.tmw.com::/usr/opt/app/mysql/home>mysql -uroot -pDaKua#Ma0zi mysql> show processlist; Check for Blocking Queries:  Use the SHOW PROCESSLIST command to identify any long-running or blocking queries.  SHOW PROCESSLIST;  Identify the blocking process and kill it if necessary.  KILL <process_id>; Analyze InnoDB Status: Use SHOW ENGINE INNODB STATUS  to get detailed information about the locks and transactions. SHOW ENGINE INNODB STATUS\G; 1. Increase Lock Wait Timeout You can increase the innodb_lock_wait_timeout value to give transactions more time to complete. SET GLOBAL innodb_lock_wait_timeout = 100; 2. Optimize Queries and Indexes Ensure that your queries are optimized and that appropriate indexes are in place to reduce lock contention CREATE INDEX idx_customer_account_import_id ON customer (account_import_id); 3. Adjust Transaction Isolation Level Changing the transaction isolation level can help reduce lock contention. Con...

  set serveroutput on declare v_unformatted_blocks number; v_unformatted_bytes number; v_fs1_blocks number; v_fs1_bytes number; v_fs2_blocks number; v_fs2_bytes number; v_fs3_blocks number; v_fs3_bytes number; v_fs4_blocks number; v_fs4_bytes number; v_full_blocks number; v_full_bytes number; begin dbms_space.space_usage ('&SCHEMA_NAME', '&TABLE_NAME', 'TABLE', v_unformatted_blocks, v_unformatted_bytes, v_fs1_blocks, v_fs1_bytes, v_fs2_blocks, v_fs2_bytes, v_fs3_blocks, v_fs3_bytes, v_fs4_blocks, v_fs4_bytes, v_full_blocks, v_full_bytes); dbms_output.put_line('Unformatted Blocks = '||v_unformatted_blocks); dbms_output.put_line('FS1 Blocks = '||v_fs1_blocks); dbms_output.put_line('FS2 Blocks = '||v_fs2_blocks); dbms_output.put_line('FS3 Blocks = '||v_fs3_blocks); dbms_output.put_line('FS4 Blocks = '||v_fs4_blocks); dbms_output.put_line('Full Blocks = '||v_full_blocks); end; / Where: unformatted_blocks  :  To...

 >mysqldump -uroot -pnew-password --database databasename < filenamedump.sql  mysql.exe --defaults-file="C:\Users\gm15\AppData\Local\Temp\tmp_wb05k3l.cnf"  --protocol=tcp --ssl-cert=O:\Users\GM15\keys\mysql-wordpress-wpproddb_client-cert.pem --ssl-ca=O:\Users\GM15\keys\mysql-wordpress-wpproddb_server-ca.pem --ssl-key=O:\Users\GM15\keys\mysql-wordpress-wpproddb_client-key.pem --host=10.40.25.160 --user=root --port=3306 --default-character-set=utf8 --comments --database=blog  < "H:\\blog_dump_singlexn.sql"

 >mysqldump -uroot -pnew-password --routines --database mysql > dumpfilename.sql users, privileges, passwords are usually stored in the mysql database