NAV: SLTechnology News&Howtos > Database >

• 

  Original MySQL database, install multi-instance tutorial

  # mkdir-v / usr/share/mysql/mysql-filesmkdir-vp / data/mysql_data {1.. 4} * modify the MySQL binary package directory after the mysql installation script is installed

  2022-06-01 08:06:02 Views: 268
• 

  VMware virtual machine configuration

  VMware virtual machine configuration 1, create a new virtual machine: 2, select hardware compatibility, next. 3. Choose to install the operating system later. 4. Choose Linux for the operating system and Oracle Linux 64-bit for the version. 5. the naming and storage location of the virtual machine. 6. Virtual machine

  2022-06-01 08:06:02 Views: 208
• 

  MySQL5.7 password change has no password field and 1820 error, and deploy zabbix and monitor mysql

  For the newly installed MySQL5.7, the password was prompted to be incorrect when logging in, but the password was not changed during installation. Later, the password was changed by logging in without a password, and enter update mysql.user set password=password ('1234).

  2022-06-01 08:05:32 Views: 246
• 

  How to use mysql custom functions

  This article mainly explains how to use the mysql custom function, the content is clear, interested friends can learn, I believe it will be helpful after reading. What is a function: a function stores a series of sql statements that are executed at once when a function is called. So the letter

  2022-06-01 08:05:32 Views: 286
• 

  How to use mysql variables

  What the editor wants to share with you this time is how to use mysql variables. The article is rich in content. Interested friends can learn about it. I hope you can get something after reading this article. System variable user variable local variable launch date: 2018-04-18 system

  2022-06-01 08:05:29 Views: 274
• 

  Manually start database archiving

  -check the instance process to see if there is an archiving process [oracle@edsir1p8-PROD4 ~] $ps-ef | grep PROD4SQL > archive log list;Database log mod

  2022-06-01 08:05:28 Views: 293
• 

  RHEL7.3 compilation and installation of mariadb10.2.6

  1. Uninstall MySql or mariadb and boost [root@rhel7 ~] # rpm-qa | grep mysql [root@rhel7 ~] # rpm-qa | grep maria

  2022-06-01 08:05:28 Views: 282
• 

  In MariaDB 10.0.X, dynamic columns support JSON format to get data.

  In MariaDB 10.0.X, the dynamic column (Dynamic Columns) can support JSON format to get data. To be compatible with traditional SQL syntax, MariaDB 10 and MySQL5.7 support native JSON format, that is, relationships

  2022-06-01 08:05:28 Views: 277
• 

  Rapid deployment of LAMP

  The construction process of LAMP is explained in detail: (1) install the package first, as shown below; CentOS 7:Modules: package, httpd, php, php-mysql, mariadb-serverFastCGI: program

  2022-06-01 08:05:20 Views: 243
• 

  Mysql logical backup mysqldump

  MySQL logical backup mysqldump is a common backup method, so what is the backup principle of myqldump? How do you ensure the consistency of backup data? To observe what mysql does when logically backing up mysqldump

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

  The usage of common functions in mysql

  This article mainly explains the use of common functions of mysql, the content is clear, interested friends can learn, I believe it will be helpful after reading. Introduction to the mysql function: to simplify the operation, mysql provides a large number of functions for programmers to use (such as you

  2022-06-01 08:05:00 Views: 250
• 

  Automatic initialization of SQL Server 2017 AlwaysOn AG (13)

  Other things you need to know during automatic seed setting the transaction log cannot be truncated. Automatic seed setting delays log truncation. If the database load on the primary replica is high, a significant number of logs will be generated, and there may be a risk of filling up the log files. Of course, in most cases, log files are set to grow automatically.

  2022-06-01 08:05:00 Views: 258
• 

  How to use mysql Index

  This article mainly shows you how to use the mysql index, the content is easy to understand, I hope you can learn, after learning, there will be a harvest, the following let the editor to take a look at it. What is an index: an index can help you find data quickly, but basically all indexes need to be unique

  2022-06-01 08:04:54 Views: 228
• 

  Methods of using mysql triggers

  This article mainly explains the method of using mysql trigger, the content is clear, interested friends can learn, I believe it will be helpful after reading. What is a trigger: a trigger is used to perform some actions "automatically" after certain actions. (for example, the insertion of new studies

  2022-06-01 08:04:50 Views: 200
• 

  [methods] the login problem when the password of Oracle user contains special characters

  [methods] login problem when Oracle user password contains special characters 1.1 BLOG document structure figure 1.2.2 related article link [password] Oracle user password series: http://blog.itpub.net/26736162/v

  2022-06-01 08:04:43 Views: 213
• 

  How to use the mysql view

  This article mainly explains how to use the mysql view, the content is clear, interested friends can learn, I believe it will be helpful after reading. What is a view: a view is a virtual table based on query results, and the table from which the data comes from is called the base table. Creation and deletion of views

  2022-06-01 08:04:42 Views: 249
• 

  Installation and configuration of cacti based on LAMP & & problem handling (1)

  Cacti installation and configuration based on LAMP & & problem handling (1) background introduction: 1. Cacti is a software implemented in php language. Its main function is to obtain data with snmp services. When users need to view data, use rrdtool to generate charts and present them to

  2022-06-01 08:04:29 Views: 278
• 

  JDBC (Java Data Base Connectivity)

  1.JDBC Quick start 1, JDBC (Java Data Base Connectivity) 1, database driver: a set of jar packages provided by database manufacturers to facilitate developers to operate the database from the program, which can be adjusted by importing this jar package.

  2022-06-01 08:04:28 Views: 234
• 

  Too many connections error

  Today, it reflects that our website down has been dropped, and the log error is too many connections error. Let's investigate the root cause. The initial suspicion is that the max_connections setting is too small. Why has this error not occurred before?

  2022-06-01 08:04:28 Views: 277
• 

  SQL_MODE is a special report on data security in strict mode

  The topic description describes in detail the risk of data errors that may occur when SQL_MODE is in strict mode. Question 1: if the default date is' 0000-00-0000: 0000: 00, an error will be reported directly when querying. Caused by: java.sql.SQLEx

  2022-06-01 08:04:22 Views: 271