News
Entertainment
Science & Technology
Life
Culture & Art
Hobbies
News
Entertainment
Science & Technology
Culture & Art
Hobbies
Using Dolphie for MySQL focus monitoring & performance tuning. | MySQL-Med
We can use so many different observability tools to get notifications, alerts, react, generate reports, etc. from so many different companies, using agents, proxies, repositories, and so on and so forth. And after exchanging experiences with dolphie's author himself, Charles, the idea here is to go that little bit further in monitoring MySQL.
MySQL Rename Table: Different Ways to Change Table Name
Learn different ways to rename tables in MySQL, from the RENAME TABLE query and ALTER TABLE statement to tools like MySQL Workbench and dbForge Studio. Includes step-by-step instructions for renaming tables in phpMyAdmin, with tips for avoiding downtime and precautions to take before renaming.
Efficient MySQL Performance In 10 Sentences
Don’t have time to read Efficient MySQL Performance? Here’s the book (10 chapters) in one-liners. Performance is query response time. Proper left-most indexing is required for performance. The less data, the better. Access patterns (part of the workload) help or hinder performance. Sharding is how to scale writes when single-node performance is truly reached. Server metrics reflect how the app workload causes MySQL to work. Replication lag is data loss. Locks are held until a transaction commits, so commit quickly. There are many other challenges that you might need to address—sorry. MySQL in the cloud is slower and more expensive, so performance is more important than ever.
preFOSDEM MySQL Belgian Days 2025 - save the dates - lefred blog: tribulations of a MySQL Evangelist
For people to prepare for their travel to Belgium, we want to announce that the preFOSDEM fringe event known as the MySQL Belgian Days will take place the Thursday and Friday, January 30 and 31, before FOSDEM.
FOSDEM 2025 MySQL Devroom - call for participation - lefred blog: tribulations of a MySQL Evangelist
We are pleased to announce the Call for Participation (CfP) for the FOSDEM 2025 MySQL Devroom. The Devroom will be held on February 2 (Sunday), 2025 in Brussels, Belgium. The submission deadline for talk proposals is December 1, 2024. FOSDEM is a free event for software developers to meet, share…
Enable and Configure MySQL Query Logging: A Comprehensive Guide
Learn how to enable, configure, and use MySQL query logging effectively. This guide covers steps to set up general and slow query logs, analyze logs using mysqldumpslow, and manage logs with dbForge Studio for MySQL by Devart. Optimize your MySQL performance with these essential logging techniques.