NAV: SLTechnology News&Howtos > Database >

• 

  Expansion method of table space in MySQL system

  1. System table space expansion method 1: add the autoextend parameter innodb_data_file_path=ibdata1:12M: autoextended after the innodb_data_file_path parameter

  2022-06-01 08:27:43 Views: 278
• 

  ProxySQL 2.0.X installation

  1. Set yum repocat < < EOF for proxysql 2.0.x | tee / etc/yum.repos.d/ proxysql.repo [proxysql _ repo] name= Proxy

  2022-06-01 08:27:40 Views: 263
• 

  Python operates the insert data of mysql

  I wrote an article about python querying mysql data before, and today I write about inserting data into mysql database through python. 1. Build database, table and user mysql > CREATE DATABASE tda DEFAULT CH first.

  2022-06-01 08:27:10 Views: 207
• 

  SSMA--MySQL to MsSQL migration assistant installation using concise tutorials

  The SQL Server Migration Assistant (SSMA) team developed a migration assistant for MySQL, Microsoft SQL Server Migration Assistant 2008 for MySQL. Microsoft also released

  2022-06-01 08:27:10 Views: 269
• 

  Oraclelinux system udev configuration

  There are two ways to configure udev. First, according to the value of scsi_id, in the vmware virtual machine, the scsi_id of the scsi disk will not be displayed by default. Close the virtual machine, open the xmv file of the virtual machine, and add the parameter disk.EnableUUID at the end of the file.

  2022-06-01 08:27:01 Views: 235
• 

  Mysql's skills in cleaning up binary logs

  1: the binary log records all DDL (data definition language) and DML (data manipulation language) statements, but does not record statements including data queries. Statement is saved in the form of an "event", which describes the process of changing the data, and this log recovers the data in the event of a disaster

  2022-06-01 08:27:01 Views: 294
• 

  Mysql profile my-small.cnf parsing, Chinese translation, configuration

  # sample Example MySQL config file for small systems.# database minimum system configuration file # This is for a system with little memor

  2022-06-01 08:27:00 Views: 291
• 

  Mongodb aggregate multiple grouping conditions

  When grouping using aggregate, multiple grouping conditions are as follows: native sql:db.test.aggregate ({$group: {_ id: {name:'$name',pro:'$pro}, total: {$sum:

  2022-06-01 08:27:00 Views: 215
• 

  Locking Mechanism of mysql

  Locks summarize the characteristics of mysql locking mechanism: different storage engines support different locking mechanisms. MyISAM and MEMORY storage engines support table-level locks; BDB storage engines use page locks; and InnoDB storage engines support row-level locks. Table-level lock: low overhead, fast locking, no death

  2022-06-01 08:27:00 Views: 263
• 

  Multi-tenancy: migration from Non-CDB to PDB in Oracle12.2, migration from PDB to another CDB

  1. PDB migrating from PDB or Non-CDB to another CDB is ready to migrate from PDB or Non-CDB to PDB in the CDB container database. Because the steps for PDB and Non-CDB to migrate to CDB are almost the same, PDB and Non-CDB migration is not

  2022-06-01 08:27:00 Views: 297
• 

  Detailed description of MySQL database configuration

  The following is a detailed description of the configuration of MySQL in my production environment: [mysqld] mysql server configures server-id=1 service ID. If the service ID of each service is different, you can log-bin=mysql-bin define the location and name of the bin_log.

  2022-06-01 08:26:53 Views: 283
• 

  Binary installation mysql 5.7and mariadb (with yum installation mode)

  This article takes mariadb as an example to explain, install mysql in the same way, and pass the test. Look for the relevant packages installed on the system (rpm-qa | grep-e "mysql"-e "mariadb") and uninstall them before installation. 1. Prepare m

  2022-06-01 08:26:53 Views: 231
• 

  Aliases and connectors in the list of SQL foundations (2)

  The main function of a column alias is to use a column alias when the name is too long or when a SQL statement is too long to use a column name repeatedly: renaming a column header makes it easy to calculate the column name (you can also add the keyword 'AS' between the column name and the alias). If it contains spaces or special characters, or if it is

  2022-06-01 08:26:48 Views: 234
• 

  Operating Access database to display data in C #

  We will introduce how to use the database on the basis of the previous article. First, we add a table named TestTable to the test database. The screenshot is as follows. Then, add the following data to the table and add li to the form.

  2022-06-01 08:26:41 Views: 238
• 

  Mysql5.7.18 installation

  Download linux source package name mysql-5.7.18.tar.gz other versions are not source packages for example: i386 is 32 compiled, x86i64 is 64-bit yum-y install boostcmake-DC

  2022-06-01 08:26:40 Views: 240
• 

  RMAN-04006: error from auxiliary database

  In the process of building Oracle11g RAC + DG, the duplicate Times error in preparing the database is as follows: [oracle@xxxx-dg:/u01/app/oracle/11.2/db_1/dbs] $rman ta

  2022-06-01 08:26:40 Views: 223
• 

  Backup and restore of SQL Server database

  1. Database backup and restore between the same SQL Server version (2008 as an example) (1) Database backup and restore between the same SQL Server server version is relatively simple. First, find the database instance that needs to be backed up, and [right]-

  2022-06-01 08:26:40 Views: 271
• 

  Introduction to the use of compact database Apache Derby

  1. Derby introduced that the reason for focusing on the small Derby is pure green, lightweight, and small memory footprint. It is very convenient to run on your machine every minute and do some code that needs to connect to the database. Although Mysql is OK, isn't it good to have one more choice? A

  2022-06-01 08:26:34 Views: 296
• 

  Oracle series: (13) Multi-table query

  Multi-table query, including equivalent join, non-equivalent join, external join, self-join. Internal connections, including equivalent connections and non-equivalent connections. Cartesian set of employee table emp and department table dept (Cartesian set table = sum of columns, product of rows, some data in Cartesian table does not meet the requirements)

  2022-06-01 08:26:16 Views: 216
• 

  Mybatis-config detailed configuration instructions

  2022-06-01 08:26:16 Views: 277