NAV: SLTechnology News&Howtos > Database >

• 

  Mysql replication

  The hot standby 1.log-bin of one master and one slave must be enabled for mysql viewing. If ON is enabled, OFF means to disable show variables like'% log_bin%';2. Set log-bin to

  2022-06-01 06:43:49 Views: 248
• 

  Interpretation of PostgreSQL Source Code (180)-Kernel Development # 4 (how to implement custom system functions)

  This section takes the implementation of the add_months function in Oracle as an example to introduce how to implement custom system functions by modifying the kernel. 1. Basic knowledge before implementation, it is necessary to introduce some basic knowledge, including Oid/ function registration and so on. OidOid is Object id

  2022-06-01 06:43:48 Views: 237
• 

  How to verify linear consistency

  Linear consistency (Linearizability) is a common consistency guarantee in distributed systems. So how to verify that the system provides linear consistency services correctly? This article hopes to start from "what is linear consistency", "how to verify linear consistency", problem complexity, common

  2022-06-01 06:43:45 Views: 231
• 

  MySQL5.5 tuning in Enterprise Environment

  With reference to the my.cnf sorted out by Tencent Cloud and ucloud my.cnf and the materials found on the Internet, any parameters modified later will continue to be updated also during the test phase of the physical machine: ubuntu14.04 configuration 8core 32Gmysq

  2022-06-01 06:43:44 Views: 277
• 

  Oracle data file migration

  Environment: win 2008 oracle 11g migrates local automap data files to the array at the request of the developer. Database non-archiving mode data file migration: SQL > select name from vault datafileterD:

  2022-06-01 06:43:44 Views: 281
• 

  MySQL-- data integrity

  -data type principle: try to use integers with a narrow range of values and save storage space: int, bit decimal: decimal represents floating point decimal (5,2) a total of 5 digits, decimal accounts for 2-digit string: varchar (variable length string)

  2022-06-01 06:43:42 Views: 277
• 

  A brief introduction to the principle of MySQL two-stage submission process

  MySQL uses two-phase commit to solve the problem of data consistency between binlog and InnoDB redo log. Two-phase submission diagram: two-phase submission principle description: phase 1:InnoDB redo log write disk, InnoDB

  2022-06-01 06:43:42 Views: 222
• 

  The use of MySQL's Archive table type in DW fact table

  Watching Nicholas's blog today, I was encouraged to see an article that uses Mysql as a fact table in a data warehouse. Mysql is enough to build a large data warehouse. In this article, Nicholas gives an example of one of his clients. The customer uses the

  2022-06-01 06:43:41 Views: 221
• 

  [Mysql] JDB2 results in high disk io utilization and high mysql latency

  Reference connection: http://www.bubuko.com/infodetail-971804.html background: the latency of the slave database of a project is very large, combined with the large value of wsec/s in iostat, you can basically determine I.

  2022-06-01 06:43:41 Views: 293
• 

  Remember: never use UTF-8 in MySQL

  It takes about 3.6 minutes to read this article. Http://suo.im/4zBuvs from: http://ju.outofmemory.cn recently I met a bug, and I tried to use Rails in the M encoded with "utf8"

  2022-06-01 06:43:41 Views: 215
• 

  Complete Optimization of mysql Database under linux High load (transfer)

  Under linux high load, mysql database is completely optimized (transferred) [@ more@] at the same time, online access continues to increase. When the server with 1G memory obviously feels the strain, it even crashes every day or the server gets stuck from time to time. This problem has bothered me for more than half a month.

  2022-06-01 06:43:41 Views: 229
• 

  Principle of mysql master-slave replication

  Environment: 3306 master library 3307 sets the server-id value from library 1 and enables binlog function parameters to edit the configuration file of mysql / data/3306/ my.cnf [mysqld] server-id = 6-use

  2022-06-01 06:43:36 Views: 285
• 

  How big is the query database setting and how much space is left in MYSQL (turn)

  How big is the query database setting in MYSQL, how much is the remaining space (transfer) [@ more@] how to query the database setting in MYSQL, and how much is the remaining space? Can you find out from the table whether engine is innodbinnodb is based on the concept of space, such as

  2022-06-01 06:43:36 Views: 202
• 

  Management of SQL database and table

  SQL database and table management (2) use SSMS database management tools to log in to the database to create a database called db_class to automatically shrink the database to separate the database so that the migration of database files separates the database to set a limit of 0-20 points for credits

  2022-06-01 06:43:36 Views: 252
• 

  PostgreSQL Source Code interpretation (48)-query statement # 33 (query_planner function # 9)

  The subfunctions remove_useless_joins, reduce_unique_semijoins and add_placeholders_to_base_re of the function query_planner have been introduced in the previous chapter.

  2022-06-01 06:43:35 Views: 255
• 

  Configure the default backup types backupset and image copy

  The backup command can create backup sets or mirror copies of two backup types. On disk, we can back up as backup sets or mirror copies. The default backup type is an uncompressed backup set. "on disk, the backup type can only be a backup set, not a mirrored copy." Configure the default backup type

  2022-06-01 06:43:35 Views: 260
• 

  MySQL data type DECIMAL usage

  When we need to store decimals and have precision requirements, such as storage amount, we usually consider using the DECIMAL field type. Perhaps most students only have a slight understanding of the DECIMAL type, and the details are not very clear. This article will tell you about DEC from scratch.

  2022-06-01 06:43:35 Views: 270
• 

  Oracle Least Recently Used Chains

  LRU Chains (or LRU lists) has their related algorithms modified many times in the past. Although the algorithm has been modified, the function of LRU chain remains the same: to help the frequently accessed buffer is built into cache and help server

  2022-06-01 06:43:35 Views: 212
• 

  [Oracle12C] 11GR2 upgrade to 12CR1 and insert CDB

  Published on July 08, 2013 by Xifenfei contact: mobile phone (+ 86 13429648788) QQ (107644445) title: 11GR2 upgrade to 12CR1 and insert CDB author: Xifenfei ©all rights reserved

  2022-06-01 06:43:30 Views: 220
• 

  Optimization of waiting event LOG FILE SYNC (awr) for oracle

  Log file sycn is one of the most common waiting events in ORACLE. In general, the waiting time of log file sycn is very short 1-5ms, so there will be no problem, but when something goes wrong, it is often difficult to solve. When will log f be generated?

  2022-06-01 06:43:14 Views: 224