MySQL 5.7 features MySQL 5.7 is the best release ever of the world’s most popular open source database and provides a new, advanced feature set designed to enable those who are building the next generation of web-based and embedded applications and services. — Ref. https://www.mysql.com/why-mysql/white-papers/whats-new-mysql-5-7/ Multi-source Replication 3x Faster Performance New Optimizer Native JSON Support GIS … Read more
MySQL service uptime Sometimes, we need to check the uptime for MySQL in our server. There are multiple method to check the uptime status of mysql server. Let see some of them. mysqladmin status [root@localhost ~]# mysqladmin -u root -p********* status Uptime: 225921 Threads: 10 Questions: 18469911 Slow queries: 0 Opens: 12466 Flush tables: 1 … Read more
Replication with Different Master and Slave Storage Engines It does not matter for the replication process whether the source table on the master and the replicated table on the slave use different engine types. In fact, the default_storage_engine and storage_engine system variables are not replicated. Even this provides a number of benefits in the replication … Read more
Executing SQL Statements from a Text File The mysql client typically is used interactively, like this: shell> mysql db_name However, it is also possible to put your SQL statements in a file and then tell mysql to read its input from that file. To do so, create a text file text_file that contains the statements … Read more
MySQL : Dumping Data in SQL Format with mysqldump By default, mysqldump writes information as SQL statements to the standard output. You can save the output in a file: shell> mysqldump [arguments] > file_name To dump all databases, invoke mysqldump with the –all-databases option: shell> mysqldump –all-databases > dump.sql To dump only specific databases, name them on the command line … Read more
RANGE Partitioning in MySQL What is Partitioning? Partitioning is a way in which a database (MySQL in this case) splits its actual data down into separate tables, but still get treated as a single table by the SQL layer. When partitioning, it’s a good idea to find a natural partition key. You want to ensure … Read more
Download HeidiSQL Installer, 32/64 bit combined Portable version (zipped): 32 bit , 64 bit Microsoft Store App, 32 bit Sourcecode HeidiSQL runs fine on Windows XP, Vista, 7, 8 and 10. Running on Wine requires to override Wine’s builtin Direct2D library with the native one. Previous installers can be downloaded here. HeidiSQL is a useful and … Read more
MySQL engine type for a specific database SHOW GLOBAL VARIABLES LIKE ‘storage_engine’ [xyz-ihs snippet=”Discuss”]
Summary: in this tutorial, you are going to learn about MySQL View. We will explain how MySQL implements views. MySQL supports database views or views since version 5.X. In MySQL, almost features of views conform to the SQL: 2003 standard. MySQL process queries to the views in two ways: MySQL creates a temporary table based on the view definition … Read more
mysqld, also known as MySQL Server, is the main program that does most of the work in a MySQL installation. mysqld, is MySQL server daemon program which runs quietly in background on MySQL Database Server. MySQL Server manages access to the MySQL data directory that contains databases and tables. The data directory is also the … Read more