mysql
(42)
Tuning MariaDB for Optimal Performance: Key Settings for InnoDB Tables
Introduction
MariaDB, a popular open-source database management system, offers powerful features to ensure high performance and reliability. For applications relying on InnoDB tables, fine-tuning specific settings can make a substantial difference in performance. This article provides a comprehensiv...
24 July
·
6
· 20
·
Den W.
Exploring SQL's HAVING Clause for Advanced Filtering
When delving into SQL, mastering the HAVING clause alongside the GROUP BY statement becomes crucial for nuanced data manipulation. This feature empowers users to refine result sets post-grouping, part...
01 April
·
8
· 65
·
Den W.
dbForge Studio for MySQL: Why I Switched to This Easy, All-Rounder GUI Tool
Learning MySQL introduced me to the command line interface and MySQL Workbench. While I find these tools enough for most tasks, I feel that my productivity is not good enough. So, I looked for another...
29 August 2022
·
4
· 194
·
Edwin Sanchez
What is SQL Server: pros and cons of using
Databases are repositories that contain large amounts of information. You can send requests, receive information from them using DBMS - control systems. A popular DBMS developed by Microsoft is SQL Se...
27 July 2022
·
3
· 196
·
Alex
Best Free Database Management Software For Windows & Mac
A database refers to an electronic method of storing and organizing data. There are various types of databases, such as relational databases, hierarchical databases, object databases, network database...
29 April 2022
·
2
· 333
·
Alex
Database Weekly Digest. September 11, 2020
The CMU Database of Databases — An online encyclopedia of 714 (and counting) database systems, thanks to Carnegie Mellon University. We might have to spend some time going through this! It...
11 September 2020
·
1
· 113
·
Alex
The Worst Typo I Ever Made
The “onosecond” is the second after you make a terrible mistake. The second when you realise what you just did and that there’s nothing you can do about it, the second when all the...
01 June 2020
·
1
· 263
·
Den W.
How to Export and Import a MySQL Database Using the Dump or IDE
Data import and export tasks, being an integral part of database management and operation, are vital for software and database developers, as well as data analysts, and many other IT professionals.
E...
21 June
·
0
· 1
·
John Fuller
MySQL Select Database
Chances are that you have multiple databases on the MySQL Server instance you're connected to; and when you need to manage several databases at once, you need to make sure you have selected the correc...
17 June
·
0
· 2
·
John Fuller
How to list the users in a MySQL/MariaDB database and Manage Permissions
User management involves granting database access, setting user permissions, and monitoring activities. This process, traditionally handled via command-line utilities, includes creating, modifying, an...
30 May
·
0
· 2
·
John Fuller
A Single Killer Feature You Need For Collaborative Database Development: Source Control For MySQL
Database development is a complex process that requires quality planning, technical skills, experience, and collaboration. Regardless of the project scope and the development team size, efficient part...
29 May
·
0
· 1
·
John Fuller
Show running processes in MySQL
The KILL command terminates a connection thread by ID along with the related active query, if there is one. Then, to identify queries for deletion, you need to see processes on the server - and the SH...
23 May
·
0
· 1
·
John Fuller
How to Kill Running Process, Query, or Session in MySQL
Every database developer and administrator strives to maintain optimal performance and stability for their databases. There are tasks that need to be done every single day to keep things the way they...
22 May
·
0
· 1
·
John Fuller
Best Navicat alternative for MySQL and MariaDB databases
Navicat is a popular brand of GUI tools that help handle a number of tasks related to database development and management. Moreover, these tools work across a wide variety of the world's biggest relat...
21 May
·
0
· 1
·
John Fuller
Tune Performance using MySQL Query EXPLAIN Plan
MySQL EXPLAIN plan helps you understand how MySQL queries are executed and what indexing techniques are better for running queries efficiently. The EXPLAIN plan is a handy statement, especially when y...
14 May
·
0
· 1
·
John Fuller
How to Add, Show, and Drop MySQL Foreign Keys
What is a foreign key in MySQL?
We’ll start with the definition. A foreign key is a column or a group of columns that allow cross-referencing related data across tables in a database. A foreign...
12 May
·
0
· 1
·
John Fuller
How to grant and revoke privileges in MySQL
When it comes to keeping databases and data secure, it is recommended to use privileges. They can help you control who can access database data and do not allow users without specified permissions to...
25 April
·
0
· 1
·
John Fuller
How to run a SQL script or file in MySQL & MariaDB
In database development, it is important to test the database with different data scenarios to ensure its functionality, performance, and reliability. Data import facilitates the population of test da...
23 April
·
0
· 1
·
John Fuller
TOP 10 IDEs for SQL Database Management & Administration [2024]
Modern organizations heavily rely on databases, with SQL databases being the predominant option. Daily workflows involve numerous database-related tasks, which database specialists must handle using s...
15 April
·
0
· 1
·
John Fuller
![TOP 10 IDEs for SQL Database Management & Administration [2024]](https://img.techplanet.today/250x150,q90,jpeg/https://techplanet.today/storage/posts/2024/04/15/16/5AE8MMrL7KEwO64YBzEgPpB6gSj7gX0L0YNDrxGM.jpg)
How to Remove Duplicate Rows in MySQL
Can it happen that the data stored in databases include identical records? Yes, it happens frequently. However, having duplicate records in databases is a scenario that should be avoided. Duplicates p...
12 April
·
0
· 8
·
John Fuller
