Optimizing Queries in MySQL: Optimizing Reads
In this blog, we’re going to walk you through how to solve the issues posed by that concern. At the end of the article, we’ll also walk you through some DDL operations to load test data.
2023-03-15
MySQL
Backing up MySQL Part 1: mysqldump
mysqldump is one of the most popular database backup tools in the MySQL world. The tool is prevalent partly because it’s very basic and quite powerful – mysqldump database backup tool is command line-based, very simple and very straightforward to use. As far as MySQL or its flavors (MariaDB and Percona Server) are concerned, this command line-based tool is one of the top choices for junior and senior database engineers across the world alike.
2022-11-09
Introducing the MySQL INSERT statement
In the previous article in this series, I introduced you to the SELECT statement, one of several SQL statements that fall into the category of data manipulation language (DML), a subset of statements used to query and modify data. Another DML statement is the INSERT statement, which lets you add data to MySQL tables, both permanent and temporary. This article covers the INSERT statement and the different ways you can use it to add data.
2022-11-02
Introducing the MySQL SELECT statement
Use SELECT statements to query a MySQL database. In this article, Robert Sheldon explains how.
2022-09-07
Security in MySQL: Part Two
There’s more to security in MySQL than user account privileges. In this article, Lukas Vileikis explains the other components of MySQL security
2022-08-01
Security in MySQL: Part One
There are several tools available to keep a MySQL database secure. In this article Lukas Vileikis discuses access control and user privileges.
2022-06-27
Optimizing my.cnf for MySQL performance
Database systems often need tuning for best performance. Lukas Vileikis explains to how to optimize my.cnf for MySQL performance.
2022-06-08
Working with MySQL stored functions
Stored functions in MySQL return a scalar value and can be used in a SQL statement. In this article, Robert Sheldon explains how to create and use a MySQL stored function.
2022-06-06
The nuances of MySQL indexes
Indexes are critical for database performance. In this article, Lukas Vieikis explains the many types of indexes available with MySQL.
2022-05-16
A MySQL story: Can system engineers solve database issues using system tools?
A story about how a system engineer solved a MySQL performance issue written by Rajeshkumar Sasidharan
2022-05-11
Blogs
Experimenting with RedisGraph on Docker and Windows
By Steve Jones
I have been experimenting a bit with graph databases, trying to learn more about...
Resources for Adding Graph Structures to Your Database at VS Live
By Steve Jones
Thanks to everyone who attended my talk at VS Live Las Vegas 2023 on...
Resources for Architecting Zero Downtime Deployments
By Steve Jones
I delivered my talk on Architecting Zero Downtime Deployments yesterday at VS Live Las...
Forums
How to Connect SQL Server and Create C# Objects for Data Management
Comments posted to this topic are about the item How to Connect SQL Server...
Adjusting DOP based on Feedback
Comments posted to this topic are about the item Adjusting DOP based on Feedback
How Important is Zero Downtime?
Comments posted to this topic are about the item How Important is Zero Downtime?
Ask SSC