AWS RDS is showing very high wait/synch/mutex/sql/ values and EXPLAIN statements in performance insights

I’m running a CRON script which checks the database for work and executes anything that needs to be done. It does this across ~500 customers per minute, but we are using AWS RDS with a 16 vCPU machine which, until recently, has been plentiful to keep it happy (normally plugging along under 20%).

This weekend we updated customers to the latest version of the code and implemented some tooling, and since then we’ve started seeing these huge waits: enter image description here

Further I’m seeing that about half of our busiest queries are EXPLAIN statements, somewhere illustrated here: enter image description here

Nowhere in our code base is an "EXPLAIN" performed (though we are using AWS RDS performance insights, ProxySQL and New Relic for monitoring). I did notice that in the past week our number of DB connections was previously baselined around 10 and is now closer to 90. enter image description here

Any ideas on where I should be digging to find the cause of these waits and explain statements? And if they could justify the large number of open connections?

git reflog is showing plain text password used as a secret texts or files in Jenkins

We are using Jenkins Freestyle Project to the push the changes on the remote server. We are executing shell script on remote host using ssh for it. To pull the changes on remote host, we are using origin url with git username and git password. The credentials should not be visible in plain text in the url that’s why we have stored them in variables using ‘secret text(s) or file(s)’ option of ‘Build Environment’.

The git credentials are not visible to the users who are using Jenkins for other projects but the remote server is showing git credentials in plain text. Any user with ssh access of the remote server is able to run the git reflog command in the project directory.

Port 22 cannot be opened on the server where gitlab is deployed so we cannot use ssh keys method to create the build in Jenkins. We can use only http method to pull the changes.

Is there any way so we could implement to avoid showing the git credentials in plain text in the project directory.

ANYDICE – Help with a dice pool showing success against a range of target numbers

I’m having a hard time coding an anydice script to show what I want.

Let me contextualize the mechanic I’m trying to simulate:

You roll a POOL of d10 against a TARGET number. If at least one die from the POOL is equal to or higher than the TARGET, the roll is a success. The count of such dice is the degree of success, but that isn’t my focus at the moment.

I’d like to have a graph for the chances of success of various POOLs of different sizes up to 10 (1d10, 2d10, 3d10…10d10) against different TARGETs from 2 to 10 (2, 3, 4… 10).

The caveat is: I’d like the graph to be layed out in such a way that:

  • the x axis represents the TARGETs;
  • the y axis represents the chances of at least 1 success;
  • each line represents a POOL,

so I can see the chances that each POOL has to succeed against a whole range of TARGETs.

Can any anydice wizard help me with this, please?

Google Search Console not showing proper other pages results (they are indexed)

i have a website and than i have a wordpress blog in /blog route of that site they are kind of independent for now since i havent done any internal linking on them so i created this new post n my blog and submitted it for indexing it got positive results and its also showing up on google but i cant see its results on google search console does any one know why?

side note: i havent submitted site map for now.(and if its because of site map than is it possible to view results without sitemap?)

How to handle a party member spontaneously not showing up?

I am the GM of a party that consists of two family fathers, one guy working on a oil platform and another freelancer working in the film industry. So it happens quite often that one member spontaneously cancels. If we are in a dungeon and it is all about fighting, this usually is not a big problem – I just tune the encounter down a bit – but concerning role-playing and storyline, I have a bit of a hassle.

Let me give you an example: The party travels to Cheliax. The elf becomes alcohol-addicted since he could not handle the death of another party member. The orc and the human decided to bring him back to a rehab center in Absalom. I already prepared the adventure, but the elf’s player gets a call from his boss and has to work spontaneously. So he cancels 2 hours before we start.

How can such a situation be handled?

My WordPress Website is Hacked, Showing unknown post which has not been posted by me [closed]

My WordPress Website is Hacked, This is my website blog link: https://bugyalvalley.com/blog/

Showing unknown post which has not been posted by me.. The name of the spam post is "Site De Rencontre Gratuit En Algerie" I don’t know what is this..

in dashboard category the post is hidden.. i am not able to see..

please help me to remove the post

screenshot of that post

Plot3D showing nothing

I tried to plot f(x,y) = cos(x + y) + sin a(x-y) where 0<=a<=10. I used Plot3D[f[x, y], {x, 0, 10}, {y, 0, 10}, AxesLabel -> {"x", "y"},ColorFunction -> GrayLevel]and it’s not working and I think it’s because I left out the condition for ‘a’. I am also unsure how to include ‘a’ inside the Plot3D function.