NAV: SLTechnology News&Howtos > Database >

• 

  Table building and sql irregularities cause the server to be almost unresponsive

  Table creation and sql irregularities led to almost no response on the server description: 1) the developer said that the test library session was full and requested to increase the maximum number of connections. A large number of session (1944) are found in the database. The statements are basically the same, SELECT * FROM

  2022-06-01 06:27:46 Views: 246
• 

  Restore a library and a table from a MySQL full backup

  Restore a library and a table from a MySQL full-library backup-A [root@mha2 backup] # mysqldump-uroot-p123456-- default-character-set=utf

  2022-06-01 06:27:45 Views: 215
• 

  Research on my.cnf priority of multiple Parameter option Files in mysql

  My.cnf is the file name of the default configuration file for mysql servers on the unix platform. Enter my_print_defaults to get the order of the my.cnf read when mysql server starts: (usually the four, according to the installer

  2022-06-01 06:27:44 Views: 265
• 

  PostgreSQL DBA (17)-XLOG Record data internal structure

  XLOG Record data for DML below describes the above sections one by one, by using the hexdump tool to view the relevant data. 1 、 XLogRecordBlockHeaderuint8 id [xdb@localho

  2022-06-01 06:27:41 Views: 266
• 

  Oracle improves query performance-the creation of simple range partitioning tables

  Advantages of partitioned tables: 1. Improve query performance: only specific partitions need to be searched, not the entire table, which improves query speed. two。 Save maintenance time: data loading, index reconstruction, backup, and maintenance of a single partition are far less than the maintenance time of the entire table. Let's take the first step in creating a partition table:

  2022-06-01 06:27:41 Views: 278
• 

  Hibernate many-to-many relational mapping

  Students and courses are a many-to-many mapping, so how to configure many-to-many relationships in hibernate? And something to pay attention to? A simple test. Build table entity configuration file and mapping test 1. Using oracle, create a table sqlcreate t

  2022-06-01 06:27:35 Views: 301
• 

  Walker Micro Lecture Hall | Oracle Cluster Technology (3): misreported cluster self-startup

  This course | Oracle Cluster Technology (3): misreported Cluster self-start Lecturer | produced by Yang Yuhang Walk Technology Senior Database Technology expert | Walk Technology-Yang Yuhang-Walk Technology Senior Database Technology expert is familiar with the internal mechanism of Oracle database, rich

  2022-06-01 06:27:35 Views: 238
• 

  Test on changing the default value of the AUTO_INCREMENT column

  In fact, it is a very simple operation, but suddenly someone asked me that I just can't remember, so I'll just take a note here. Mysql > create table test2 (id int (2) AUTO_INCREMENT,name varchar (

  2022-06-01 06:27:35 Views: 274
• 

  Explore the Design and implementation of Redis 6:Redis Internal data structure in detail-- skiplist

  This article is transferred from the Internet. This series of articles will be sorted out in my "Java interview Guide" warehouse on GitHub. For more wonderful content, please go to my warehouse to check out https://github.com/h3pl/Java-Tutorial if you like.

  2022-06-01 06:27:31 Views: 203
• 

  Basic recommendations for oracle table and index design

  Basic suggestions for physical design of the table: 1. Except for special requirements, it is recommended to use a common heap table (heap table). 2. When creating each table, it is recommended to establish the tablespace instead of the default tablespace. 3. It is recommended that according to the value of dml operation frequency, if update operation

  2022-06-01 06:27:31 Views: 249
• 

  UTL_FILE.PUT writes txt over 32k ORA-29285: file write error

  The clob field in the table is generated into a txt file, and it is found that as long as it is written over 32k, an error will be reported. Use UTL_FILE.PUT to write buffer to the file, but find that once a field exceeds 32K, the above ora06512 is reported when it is just over 32k.

  2022-06-01 06:27:27 Views: 272
• 

  Essays: some of the information in MySQL setup_instruments cannot be modified

  My friend told me that I cannot modify mysql > update setup_instruments set enabled='no' where name='memory/performance_schema/ by doing the following.

  2022-06-01 06:27:24 Views: 222
• 

  Comparison of Modularization and Micro Services MircoService VS OSGI

  This article compares the differences between micro-services and modular overall architecture (modularized monolith). Now people are moving from monolithic monolith to microservices, but is this shift really right for your company? The whole monolithic monolith does have

  2022-06-01 06:27:24 Views: 262
• 

  Oracle 12.2 BUG: ORA-600 KKPOFPCD3 caused by partition maintenance

  Original link: https://www.modb.pro/db/23449?xy Abstract: in Oracle 12.2, online partition consolidation, maintenance and other work led to the introduction of a BUG. In Oracle 12.2

  2022-06-01 06:27:24 Views: 293
• 

  Mysql 5.7Gtid Internal Learning (IV) changes in mysql.gtid_executed Table Previous gtid Event

  Brief book address: http://www.jianshu.com/p/1f4f9c07ce0b describes the role of the mysql.gtid_ execute table together with the changes to Previous gtid Event

  2022-06-01 06:27:22 Views: 300
• 

  Introduction and use of official pressure testing tool mysqlslap

  Mysqlslap is an official stress testing tool that can simulate multiple clients for concurrent testing. For example, how much concurrency can be simulated, how many times it can be executed, for a certain storage engine. Wait, wait,

  2022-06-01 06:27:22 Views: 238
• 

  OCP-051-006

  6. Examine the structure of the SHIPMENTS table: check the structure of the table SHIPMENTS name Null TypePO_ID NOT NULL NUMBER (

  2022-06-01 06:27:21 Views: 222
• 

  Mysql 5.5Database startup shutdown command

  Start the MySQL service. / bin/mysqld_safe-- defaults-file=/etc/my.cnf & [1] 21698 [root@localhost bin] # 160402 05:57:

  2022-06-01 06:27:21 Views: 223
• 

  The whole process of fault analysis of MySQL restart caused by the crash of semi-sync plug-in

  Introduction to the whole process of fault analysis of MySQL restart caused by the crash of semi-sync plug-in. Author: Liu an is now a senior test engineer with rich experience in automatic test development. He has worked as a test engineer in Pactera and Splunk. First, cause: testing in the company

  2022-06-01 06:27:20 Views: 284
• 

  Database knowledge notes

  1. Force decimal to store decimals instead of float and double to prevent precision loss. If the stored data exceeds the range of decimal, it is recommended to split the data into integers and decimals and store them separately. This is also Ali's mandatory development specification. 2. Efficient score

  2022-06-01 06:27:19 Views: 229