Skip to content

Instantly share code, notes, and snippets.

@vparihar01

vparihar01/daily_utility.sh

Last active May 24, 2022 08:16
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save vparihar01/fb4dfacf5a4eb8425a9f to your computer and use it in GitHub Desktop.
Save vparihar01/fb4dfacf5a4eb8425a9f to your computer and use it in GitHub Desktop.
Download ZIP
Useful commands
Raw
daily_utility.sh
1. pods spec edit podname |> pods spec edit opencv will open the podspecs.json file which we can edit to our needs. Like changing the download url of PODS.
2. history |> list all the command have been used in command line.
3. netstat -tulpn | grep fms |> list all processes running on the system with their PIDs.
4. To view the current transaction:
SELECT` `* ``FROM` `information_schema.innodb_trx \G
5. To view the currently locked transactions:
SELECT` `* ``FROM` `INFORMATION_SCHEMA.INNODB_LOCKS;
6. To view the transactions currently waiting for a lock:
SELECT` `* ``FROM` `INFORMATION_SCHEMA.INNODB_LOCK_WAITS;
5. SHOW ENGINE INNODB STATUS \G
6. Show processlist
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment