Mastodawn

[ERROR] /usr/sbin/mysqld: The table ‘/tmp/ramdisk/ is full
https://virtual-dba.com/blog/error-usr-sbin-mysqld-the-table-tmp-ramdisk-sql-is-full/
#mysql

[ERROR] /usr/sbin/mysqld: The table '/tmp/ramdisk/#sql*' is full

MySQL temporary tables running out of space? Learn how to troubleshoot, optimize, and boost performance in 4 easy steps. Read now.

Virtual-DBA Remote DBA Services & Support - Certified Database Experts

Show thread

BLACKVOID ⚫️12h ago

Reason why a test migration (that took 5-6h with troubleshooting) is needed is because the production one then is done in 15 min.

PROD Mattermost now on Postgres as well.

#ChatGPT5 agrees as well :P

#mysql #postgres #database #mattermost #docker #chat #selfhosting #selfhosted

Tony Salerno 1d ago

[ERROR] [MY-012271] [InnoDB] The innodb_system data file ‘ibdata1’ must be writable
https://virtual-dba.com/blog/error-my-012271-innodb/
#mysql

[ERROR] [MY-012271] [InnoDB] The innodb_system data file 'ibdata1' must be writable

MySQL ibdata1 not writable? Fix path conflicts in your my.ini and get your database running again. Follow our troubleshooting guide.

Virtual-DBA Remote DBA Services & Support - Certified Database Experts

Tony Salerno 2d ago

Jumpstarting Your BI Journey with Oracle Linux and MySQL
https://virtual-dba.com/blog/jumpstarting-your-bi-journey-with-oracle-linux-and-mysql/
#mysql #linux #jaspersoft

Jumpstarting Your BI Journey with Oracle Linux and MySQL

XTIVIA helps jumpstart your BI and reporting journey with Oracle Linux, MySQL Enterprise, and Jaspersoft setup.

Virtual-DBA Remote DBA Services & Support - Certified Database Experts

Show thread

CubeRootOfTrue 2d ago

@MartinEscardo This is true. I'm suggesting that this is not just a computer engineering thing. I'm saying that at base, nature itself is non-binary, and we are non-binary, and we abstract things we don't understand into black and white distinctions to make them easier to understand. It's fast and efficient to ignore certain problems. There are still problems with binary logic.

Did you know that SQL is one of the few computer languages to use 3-valued logic? Databases are highly exposed to the problems of inconsistent or missing information. But we can use binary logic to simulate 3-valued logic (MySQL uses the paraconsistent logic LP by Graham Priest, but you can use that to create a fully relevant implication as in RM3, it's just a longer expression)

#rm3 #mysql #relevance #paraconsistent

Neustradamus :xmpp: :linux:3d ago

#MariaDB 12.0.2 has been released (#SQL / #MySQL / #DBMS / #RDBMS / #Database / #DB) https://mariadb.org/

MariaDB Foundation - MariaDB.org

… Continue reading "MariaDB Foundation"

MariaDB.org

Neustradamus :xmpp: :linux:3d ago

#MariaDB 11.8.3 (#LTS) has been released (#SQL / #MariaDBLTS / #MySQL / #DBMS / #RDBMS / #Database / #DB) https://mariadb.org/

MariaDB Foundation - MariaDB.org

… Continue reading "MariaDB Foundation"

MariaDB.org

mastodon.raddemo.host 3d ago

How to Install #MySQL 8 on #VPS Server

This article provides a guide for how to install #MySQL 8 on VPS server.

Database Management Systems (DBMSs) are applications designed to store and organize data in an organized fashion, usually as part of an e-commerce or data warehousing application. One such DBMS is MySQL, an open-source and highly scalable free DBMS that's free and open source; we will cover how to install MySQL 8 onto a VPS server so you ...
Continued 👉 https://blog.radwebhosting.com/how-to-install-mysql-8-on-vps-server/?utm_source=mastodon&utm_medium=social&utm_campaign=mastodon.raddemo.host

How To Install MySQL 8 On VPS Server - VPS Hosting Blog | Dedicated Servers | Reseller Hosting

This guide demonstrates how to install MySQL 8 on VPS server. First login to the VPS as root user and run the appropriate commands based on Linux distro:

RadWeb, LLC

pgEdge Distributed PostgreSQL 4d ago

#Postgres DBAs: cold page reads eating up query execution time on full table scans?

Some config params that help reduce I/O latency by 40%:

effective_io_concurrency = 200 (SSDs)
random_page_cost = 1.1
max_parallel_workers = 8

These changes (and others!) resulted in a 30% improvement in checksum time. Explore our latest blog for before/after EXPLAIN ANALYZE output + explanations behind each param at the DB and OS level.

https://www.pgedge.com/blog/optimising-cold-page-reads-in-postgresql

#tech #data #SQL #oracle #mysql #sqlserver #DBA