jriou, 8 days ago to random

Today, I had an alert on a #servicenow self-hosted database running on #MySQL with 1TB of RAM and 18TB of NVMe (in RAID10-like). 100% i/o write usage. 3k connections. Why on earth do we need that amount of resources? There must be something wrong in the design.

mobileatom, 9 days ago to random

The Ultimate Guide to Navigating SQL Server With SQLCMD. #MySQL

https://www.sitepoint.com/mastering-sql-server-command-line-interface/?utm_source=flipboard&utm_medium=activitypub

Posted into Coding is Living @coding

adminmagazine, 9 days ago to opensource

Free Focus Guide: To harness the power of data, you need a database management system that offers flexibility and freedom. Download this new focus guide and get up to speed on the open source database ecosystem. https://mailchi.mp/admin-magazine.com/open-source-databases
#OpenSource #database #Percona #MongoDB #MySQL #MariaDB #PostgreSQL #Firebird #CUBRID #NoSQL #JanusGraph #Redis #CouchDB #DBMS #SQL #ApacheCassandra

kubikpixel, 11 days ago to PostgreSQL

SQL Injection Cheatsheet:

This is an SQL injection cheatsheet with tried and true payloads / techniques that cover the 5 most popular database variants and their derivatives.

🔧 https://tib3rius.com/sqli

—
#MySQL #PostgreSQL #MSSQL #SQL #Server #Oracle #SQLite #cheatsheet #injection #data

mikestreety, 15 days ago (edited 15 days ago) to php

I'm looking for a solution to branch-based previews for a #PHP / #MySQL stack. We have nearly 60 sites we want to set this up for (a lot of services I find either charge $1000s or don't even support that many).

I don't want anything fancy, I don't need to edit in the browser. I would like to push a branch to gitlab and have the option to spin up an environment to preview.

I have considered doing it myself, but I was hoping to not have to support my own infrastructure.

FlohEinstein, 17 days ago to infosec

Days without DATETIME / TIMESTAMP incident:

#infosec #mysql #development

mobileatom, 19 days ago to random

How to Check MySQL Database and Table Sizes. #MySQL

https://releem.com/blog/check-mysql-database-table-size?utm_source=flipboard&utm_medium=activitypub

Posted into SYMFONY FOR THE DEVIL @symfony

to3k, 29 days ago to Blog

For my #blog, I also observed this problem. This is not very disturbing, but after publishing information about the new post, the site temporarily stops working and throws the error of exceeding the #MySQL query limit, because the blog is based, of course, on #Wordpress.
via #unknowNews
https://news.itsfoss.com/mastodon-link-problem/