This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
[alias] | |
## | |
# One letter alias for our most frequent commands. | |
# | |
# Guidelines: these aliases do not use options, because we want | |
# these aliases to be easy to compose and use in many ways. | |
## | |
a = add |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
1. I see that most of your connections and queries are running on the master(writer) database instance itself without much load on the reader instance. You can consider dividing your workload such that read-only queries/workloads are directed to the reader instance, and only write queries are handled by your writer instance. This will help alleviate the large undo logs(RollbackSegmentHistoryListLength) due to long running queries and in itself this should mitigate a lot of the performance issues. | |
One way to achieve splitting of Reads and Writes is by making use of a third party software Proxy solution which can split reads and writes to the appropriate endpoints. Below are a few example software solutions which you can consider: | |
[+] ProxySQL - https://proxysql.com/ | |
[+] Heimdall Data - https://www.heimdalldata.com/ | |
2. If and where possible, try to split large transactions into multiple smaller transactions. This will again reduce the growth of the undo log which seems to be the main cause of t |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
#!/usr/bin/env groovy | |
final List<String> environments = Env.values().collect() { it.name() } | |
pipeline { | |
agent { | |
label any | |
} | |
parameters { |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
def getProjectName() { | |
return 'JenkinsPipeline' | |
} | |
def getJDKVersion() { | |
return 'jdk1.8.0_101' | |
} | |
def getMavenConfig() { | |
return 'maven-config' |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
#!/bin/bash -xe | |
QUERIED_RELEASE="emr-5.29.0" | |
REGION="us-east-1" | |
LIST_CLUSTERS_COMMAND="aws emr list-clusters --region $REGION" | |
COUNTER=0 | |
function CALL_API() { | |
if [ ! -v NEXT_TOKEN ]; then | |
CLI_OUTPUT=$($LIST_CLUSTERS_COMMAND) |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# Installs a git helper function which retrieves the password or developer token from Secrets Manager | |
# directly for cloning a repository from a private git repo or pushing back changes upstream. | |
# Storing passwords and tokens in Secrets Manager eliminates the need to store any sensitive information on EFS. | |
# Steps: | |
# 1. Add your password or personal developer token to Secret Manager | |
# 2. Set the secret name, key & email in the script below | |
# 3. Clone your repository via HTTP with the user name in the url, e.g. "git clone http://username@github.com/...." | |
#!/bin/bash |
- Context variables - availability varies based on workflow step
- github e.g. ${{ github.actor }}
- env
- vars
- job, jobs
- steps
- runner
- secrets
- strategy
- matrix
S3
- Enable Storage Lens
- Enable Intelligent Tiering
- Delete Incomplete Multipart Uploads
- Expire Non-Current Versioned Objects
- Add Lifecycle Rules
Lambda
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
/* Get currently running transactions */ | |
select * from information_schema.innodb_trx | |
/* Get currently running transactions where tables in use */ | |
select * from information_schema.innodb_trx where trx_tables_in_use = 1 | |
/* show locked tables */ | |
show open tables where in_use > 0 ; | |
SHOW ENGINE INNODB STATUS; |
NewerOlder