MySQL *

Open-source relational database management system (RDBMS)

6,09

Rating

ArticlesPostsNewsAuthors

habrconnect Feb 18 at 12:09

Relation Normalization. Six Normal Forms

8 min

1.7K

MySQL * SQL *

Translation

In this topic, I will cover the 6 normal forms and the methods for bringing tables into these forms.

The process of designing a database using the NF method is iterative and consists of sequentially converting a relation from 1NF to a higher-order NF according to certain rules. Each subsequent NF is constrained by a specific type of functional dependency and the elimination of corresponding anomalies when performing operations on database relations, as well as preserving the properties of the preceding NFs.

deepakchauhan Jul 29 2023 at 13:30

How to partition a MySQL table

6 min

5.8K

MySQL * SQL *

From sandbox

Alright, folks! Get ready to dive into the world of MySQL table partitioning. In this guide, we'll cover why partitioning is so darn important for your MySQL tables. Plus, we'll dish out all the juicy benefits you can expect from partitioning a table. So, buckle up, and let's get started!

numbrCodeHbr Jul 17 2021 at 20:43

Speed Dating with the CodeIgniter 4 on GitHub

2 min

3.8K

PHP * MySQL * CodeIgniter * GitHub *

Tutorial

From sandbox

Getting acquainted with the CodeIgniter 4 PHP framework is quite simple.

Spend the evening following the instructions in the «Build Your First Application» section. Since the documentation is written in a good, technically understandable language, it is even possible to get some aesthetic pleasure in the process of familiarizing yourself with this and other sections.

The feeling of airiness and consistency of the CodeIgniter 4 project will be present with you everywhere now.

What is so attractive about CodeIgniter 4?

Dradmin Apr 30 2021 at 05:33

MySQL 8 Performance Benchmark

3 min

11K

MySQL * IT Infrastructure * *nix * Server Administration * Database Administration *

In this article, we benchmark the performance of MySQL 8 default configuration vs. innodb_dedicated_server enabled configuration vs. the configuration recommended by MySQL Performance Tuning Service.

Wendigoo Oct 5 2020 at 07:38

Mysql 8.x Group Replication (Master-Slave) with Docker Compose

5 min

6.9K

MySQL * Database Administration * DevOps *

This post is handling the following situation - how to setup up simple Mysql services with group replication being dockerized. In our case, we’ll take the latest Mysql (version 8.x.x)

FYI: all mentioned code (worked and tested manually) located here.

I will skip not interested steps like ‘what is Mysql, Docker and why we choose them, etc’. We want to set up possibly trouble proof DB. That’s our plan.

KRRGuest Jul 10 2020 at 10:11

Machine Learning CPython library 'VKF'

14 min

1.5K

MySQL * Python * Machine learning *

Previous article describes a web server for Machine Learning system 'VKF' based on Lattice Theory. This paper is an attempt to explain details of using the CPython library directly. We reproduce working sessions of experiments on datasets 'Mushroom' and 'Wine Quality' from UCI Machine Learning repository. The structures of input files are discussed too.

KRRGuest Jul 3 2020 at 18:45

Web server for Machine Learning 'VKF-solver'

20 min

Machine learning * MySQL * Python *

Nowadays most people identify Machine Learning with training of various kinds of neural networks. At the beginning there were fully connected networks, then convolutional and recurrent networks replace them, now there exist a quite exotic variants of networks such that GAN and LTSM networks.

Their training requires constantly increasing volume of samples, and they also do not be able to explain why a particular decision was made. Structural approaches to Machine Learning avoiding these drawbacks exist, the software implementation of one of which is described in the article. This is an English translation of original post by the author.