NAV: SLTechnology News&Howtos > Database >

• 

  MYSQL5.7.22 source code installation master-slave build

  Operating system version of CENTOS7.6MYSQL5.7.22 what? Why my operating system does not have an iso installation image, alas, can not get a local yum source, then get a network. It's just that you can't use it by default, so do it yourself, cd / etc/yu.

  2022-06-01 07:40:56 Views: 239
• 

  Data Security solution of a Provincial Development and Reform Commission

  1. After years of development, the construction of the computer room of the Provincial Development and Reform Commission is beginning to take shape, on which runs the online examination and approval supervision platform for the province's investment projects, the "two bases" management platform for the province's fixed assets investment projects, and the province's credit information public service platform. The construction of the information system applies the current mainstream hard.

  2022-06-01 07:40:56 Views: 274
• 

  Analyze deadlocks caused by SIX locks and lock partitions

  What is a SIX lock? The official document lock mode says: intentional exclusive sharing (SIX): protects shared locks that are requested or acquired for some, but not all, lower-level resources in the hierarchy, and intended exclusive locks for some (but not all) lower-level resources. Top-level resources allow you to make

  2022-06-01 07:40:50 Views: 229
• 

  How to copy PDB online through dblink in 12.2.0.1

  Reference, how to copy PDB online through dblink in 12.2.0.1 (document ID 24726-43.1) for libraries with a small amount of data, this function is simple and easy to operate, and you can have a try. Source DB: cdb-orcl, p

  2022-06-01 07:40:49 Views: 275
• 

  A Collection of Oracle TNS error reports

  1. The tnsnames.ora file name has been modified TNS-03505: Failed to resolve name2, IP or hostname cannot ping TNS-12543: TNS:destination

  2022-06-01 07:40:49 Views: 212
• 

  MongoDB practice (11) Sharding fragmentation (part I)

  This is a large amount of data horizontally expanded database cluster system data sub-table stored on each node of sharding users can easily build a distributed MongoDB cluster through simple configuration. The data segmentation of MongoDB is called chunk.

  2022-06-01 07:40:26 Views: 261
• 

  Smultron for Mac (web text editing tool) 12.1.1 inactive version

  Are you still looking for a useful web text editing tool? Smultron for Mac is a web page text editing tool used on Mac. Its elegance and simplicity help everyone to be creative, and write and edit all kinds of texts. It is a software designed for beginners and experts.

  2022-06-01 07:40:23 Views: 205
• 

  IndexedDB database

  Connection databases A Web site can have multiple indexedDB databases, but the name of each database is unique. We need to connect to a specific database through the database name. Var request = indexedDB.open ('dbNam

  2022-06-01 07:40:23 Views: 224
• 

  The new MySQL5.7 feature changes the index name without locking the table

  MySQL5.7 does not lock the table when changing the index name. The test process is as follows: click (here) to collapse or open mysql > select count (*) from user

  2022-06-01 07:40:23 Views: 256
• 

  Large table count (*) causes downtime

  Do the select count (*) from tbname; exception message to the table as follows: click (here) to collapse or open 016-03-24 21:37:28 17887 [ERROR] InnoDB: Tried to r

  2022-06-01 07:40:22 Views: 280
• 

  Database error "system01.dbf needs more recovery to maintain consistency, database cannot be opened"

  The fault description is mainly manifested in the error of opening the database, which reads: "system01.dbf needs more recovery to maintain consistency, and the database cannot be opened." After testing the database files, we can draw the following conclusions: sysaux01.dbf has bad blocks, sy

  2022-06-01 07:40:02 Views: 263
• 

  HBase-1.0.1 Learning Notes (4) MapReduce Operation HBase

  Lu Chunli's work notes, who said that programmers should not have literary style? Environment: hadoop-2.6.0hbase-1.0.1zookeeper-3.4.61, Hadoop cluster configuration process; 2, Zookeeper cluster configuration process; 3, H

  2022-06-01 07:39:53 Views: 284
• 

  Solving the problem of data abnormality when the field data in PHP exceeds 4113 characters

  Environment information: operating system: LNMP1.6PHP version: 5.3.29 (NTS) Damon client version: DM_V7.6.0.161 client PHP module: libphp53_dm.soPHP configuration extension_dir

  2022-06-01 07:39:50 Views: 210
• 

  Detailed explanation of Oracle High Water level Line (HWM)

  HWM: high water mark, the dividing line between available space and used space, marking the use of segment space. All oracle segments (segments, here, for ease of understanding, it is recommended to use segment as a synonym for tables) have an upper limit to hold data within the segment.

  2022-06-01 07:39:50 Views: 295
• 

  [Oracle] script to create DB

  C:\ Users\ Admin > set ORACLE_HOME=E:\ oracle11g\ product\ 11.2.0\ dbhome_1C:\ Users\ Admin > set ORACLE_SID=bru

  2022-06-01 07:39:49 Views: 221
• 

  Oracle Redo and Undo

  Oracle Redo and Undo "Oracle Core Essential Internals for DBAs and Developers" in my opinion, the most important feature of Oracle is

  2022-06-01 07:39:44 Views: 265
• 

  DML operation experiment and conclusion of main table child table of foreign key without index

  If the insert operation on the child table is not committed, it will block the subsequent update, delete and insert operations on the primary table (for the operation that contains the primary key column). Both the master table and the child table are TM locks. The blocking problem is eliminated after the foreign key is indexed. Create tabl

  2022-06-01 07:39:43 Views: 215
• 

  Analysis of Oracle basic data type storage format-- date type TIMESTAMP WITH TIME ZONE

  Original link: https://www.modb.pro/db/22143?cyn abstract: describe TIMESTAMP WITH TIME ZONE and TIMESTAMP WITH LOCAL TIME ZONE

  2022-06-01 07:39:43 Views: 270
• 

  Record a magical Mysql deadlock troubleshooting

  Background talking about Mysql deadlock, I wrote a basic introduction to Mysql locking before, and I have a simple understanding of some basic Mysql locks or deadlocks. You can read this article why developers need to understand distributed locks. With the above experience, I thought that for death

  2022-06-01 07:39:31 Views: 206
• 

  Summary of MySQL highly available MHA installation, deployment and failover details

  1. Introduction to 1.1mha introduction MHA, namely MasterHigh Availability Manager and Tools for MySQL, is a script manager written in Perl language by an MySQL expert in Japan

  2022-06-01 07:39:31 Views: 254