NAV: SLTechnology News&Howtos > Database >

• 

  Ora_Security-1 create and manage database users

  1. User account attribute 1. The user name is composed of (letters, numbers $_) with less than 30 characters. Words cannot be reserved for. Letters are not case-sensitive. Once the user name is created, modification is not allowed. If you have to change it, you must delete the account before creating one. Note: user name specified in double quotation marks

  2022-06-01 19:19:58 Views: 262
• 

  MySQL-5.6 replication based on GTID and multithreading

  GTID (Global Transaction IDs) introduced by MySQL 5.6makes the configuration, monitoring and management of its replication functions easier to implement and more robust. To use replication in MySQL 5.6, its service configuration segment [mys

  2022-06-01 19:19:58 Views: 299
• 

  Configuration of ORACLE multiple instance snooping

  There are three configurations for multi-instance listening: 1. One listener listens to multiple instances on one IP port 2, one listener listens to multiple instances on different IP ports 3, and multiple listeners listen to multiple instance 1:listener.ora files: # listener.o

  2022-06-01 19:19:58 Views: 301
• 

  Use clone to complete the installation of Oracle software

  First, prepare the operating system with the same conditions, RHEL 5.8 X64Oracle 11.2.0.3.0 check the Oracle patch status $$ORACLE_HOME/OPatch/opatch ls in the environment where Oracle software has been installed

  2022-06-01 19:19:58 Views: 205
• 

  Pt-summary is mainly used to count machine information, pt-mysql-summary analysis, mysq database

  This section shows the current date and time, as well as an overview of the server and operating system. Percona Toolkit System Summary Report this segment is extracted from / proc/cpuinfoProcessor memory information. Generated from fr

  2022-06-01 19:19:57 Views: 256
• 

  Basic knowledge of SQL-identify seed overflow

  DBCC CHECKIDENT (Transact-SQL) Checks the current identity value for the specified table in SQL Serve

  2022-06-01 19:19:39 Views: 208
• 

  Performance Optimization of mysql (2)

  Mysql performance optimization (2) limitations of query cache external query sql statements in all subqueries will not be included by cache (cached) in procedure,function and query in trigger are not included by cache

  2022-06-01 19:19:34 Views: 240
• 

  RAC modifies single instance DG redo size log

  The solution is to add standby redo to the primary library to delete the old standby redo, then add standby redo to the main library to delete the old standby redo, add new redo to the main library to delete the old standby redo, and finally add re to the standby library.

  2022-06-01 19:19:33 Views: 290
• 

  MySQL5.7 installation and configuration MGR tutorial

  This article mainly gives you a brief introduction to MySQL5.7 installation and configuration MGR tutorials. You can check the relevant professional terms on the Internet or find some related books to supplement them. We will not dabble here. Let's go straight to the topic. I hope this article on MySQL5.7 installation and configuration MGR tutorials can be used.

  2022-06-01 19:19:30 Views: 234
• 

  How to use percona-toolkit tools to check and repair master inconsistencies in MySQL databases

  The following is mainly about how to use the percona-toolkit tool to check and repair the main inconsistency of the MySQL database. I hope these contents can be of practical use to you. This is how I use the percona-toolkit tool to check and repair MyS.

  2022-06-01 19:19:28 Views: 259
• 

  What are the common ways to associate MySQL tables

  This article mainly introduces the common ways of MySQL table association, the contents of the article are carefully selected and edited by the author, with a certain pertinence, the reference significance for everyone is still relatively great, the following with the author to understand the common ways of MySQL table association there are several kinds of it. Build tables and

  2022-06-01 19:19:22 Views: 288
• 

  Simple idea of basic Design and Optimization of Mysql

  The following together to understand the Mysql basic design and optimization of simple ideas, I believe that you will benefit a lot after reading, the text is not much in the essence, hope that Mysql basic design and optimization of simple ideas this short article is what you want. 1. Fixed length and indefinite length should be distinguished. 2. Rare columns and commonly used columns should be distinguished.

  2022-06-01 19:19:19 Views: 217
• 

  Using single instance binary method to install SuSE11 system MySQL5.7.22

  This article is mainly about using single instance binary method to install SuSE11 system MySQL5.7.22. You can look up the relevant professional terms on the Internet or find some related books to supplement them. We will not dabble here. Let's go straight to the topic and hope to use single instance binary.

  2022-06-01 19:19:16 Views: 278
• 

  Master the simple method of operating mysql foreign keys

  The following mainly brings you to master simple ways to operate mysql foreign keys. I hope these contents can bring you practical use, which is also the main purpose of this article for my editor to master simple ways to operate mysql foreign keys. All right, don't talk too much nonsense, let's just read the following. 1. Create foreign keys, associate

  2022-06-01 19:19:15 Views: 288
• 

  Introduction to the methods of how to install, deploy, initialize and create instances in mysql5.7

  This article mainly introduces how to install, deploy, initialize and create instances of mysql5.7. The content of the article is carefully selected and edited by the author, which is of certain pertinence and is of great significance to everyone's reference. Let's learn how to install and deploy mysql5.7 with the author.

  2022-06-01 19:19:13 Views: 219
• 

  Master the knowledge related to learning mysql

  Let's learn about mysql-related knowledge. I believe you will benefit a lot after reading it. The text is not much in essence. I hope this short article about mysql knowledge is what you want. Connection MySQL format: mysql-h host address-u user name-p user password

  2022-06-01 19:19:10 Views: 304
• 

  How to install mysql 5.6 with binary package on centos system

  This article mainly tells you how to install mysql 5.6using binary package in centos system. You can look up the relevant professional terms on the Internet or find some related books to supplement them. We will not dabble here. Let's go straight to the topic and hope that centos system can be used in two.

  2022-06-01 19:19:09 Views: 204
• 

  Master MySQL semi-synchronous replication technology handle_slave_io function calls read_event function method

  The following talk about mastering MySQL semi-synchronous replication technology handle_slave_io function calls read_event function method, the secret of the text is close to the topic related. So, let's not talk about gossip. let's just read the following. I believe it's the same to master MySQL after reading.

  2022-06-01 19:19:09 Views: 282
• 

  How to deal with the error when compiling and installing zabbix MySQL library not found

  The following mainly brings you how to deal with the error MySQL library not found when compiling and installing zabbix. I hope these contents can bring you practical use. This is why my editor reported an error MySQL l when compiling and installing zabbix.

  2022-06-01 19:19:09 Views: 232
• 

  How to change the root password of MYSQL database

  The following together to understand how to modify the MYSQL database root password, I believe that we will benefit a lot after reading, the text is not much in the essence, hope that how to modify the MYSQL database root password this short content is what you want. Windows version stops MYSQL first.

  2022-06-01 19:19:05 Views: 218