NAV: SLTechnology News&Howtos > Database >

• 

  PostgreSQL 11 tpcc Test (1.03 million tpmC on ECS)-use sysbench-tpcc by Percona-Lab

  Background Environment Ali Cloud Virtual Machine [root@pg11-test] # lscpu Architecture: x86 cloud 64 CPU op-mode (s): 32-bit

  2022-06-01 06:59:28 Views: 291
• 

  Let's talk about MySQL master-slave replication.

  Environment: win10 (there is little difference between linux and windows in terms of master and slave configuration), MySQL-5.7.161. First of all, we need two MySQL instances, which I have here are 3307 3308, of which 3307 is used as master,3308 as s.

  2022-06-01 06:59:21 Views: 214
• 

  LIST INCARNATION OF DATABASE meaning

  The http://blog.itpub.net/7259433/viewspace-2146710/Resetlogs command represents the end of one database logical lifetime and the beginning of another database logical lifetime, each time Resetl is used

  2022-06-01 06:59:18 Views: 268
• 

  2011-10-25 NULL and cycle

  What will appear on the screen after the code block below the http://www.itpub.net/thread-1499223-8-1.html80 is executed? DECLARE v_number NUMBER;BEGIN

  2022-06-01 06:59:17 Views: 234
• 

  Mysql import and export

  Backup database: (command is executed under the mysqlbin directory of DOS) mysqldump-- opt school > school.bbb Note: back up the database school to the school.bbb file, school.b

  2022-06-01 06:59:17 Views: 296
• 

  A summary of commonly used MySQL middleware URLs

  Atlas (Qihoo 360) https://github.com/Qihoo360/Atlas Meituan Dianping's DBProxy https://github.com/Meituan-Dianping/DBP

  2022-06-01 06:59:17 Views: 259
• 

  Use ErrorStack for error tracking and diagnosis!

  In the process of using oracle database, you may encounter a variety of errors or exceptions, and many exception prompts are not specific, so it is necessary to understand the ErrorStack tracking method of oracle. ErrorStack is a kind of right and wrong provided by oracle.

  2022-06-01 06:59:11 Views: 322
• 

  A preliminary study on MySQL data backup and backup principle

  I believe that through the previous article, "data loss is like a slap on the head, data backup is as heavy as a mountain!" Many people have a deep understanding of the importance of data backup. This article will take MySQL as an example to further understand the principle and preliminary practice of data backup. Depending on the requirements, there is no way to back up data.

  2022-06-01 06:59:11 Views: 246
• 

  Analysis of library cache lock caused by delayed Authentication of Oracle11g password

  In Oracle 11g, in order to improve security, Oracle introduced a new feature of "password delayed authentication". The effect of this feature is that if the user enters the wrong password to try to log in, the time of verification before login will increase with the increase of the number of login errors.

  2022-06-01 06:59:04 Views: 231
• 

  Efficient SQL (an example of functional index optimization VIEW)

  Efficient SQL (one example of functional index optimization VIEW) original Oracle author: lovehewenyu time: 2016-07-12 14:57:43 242efficient SQL (functional index optimization VIEW example) business staff reflection system

  2022-06-01 06:59:04 Views: 258
• 

  LREG process added to oracle 12c and its dynamic registration process

  As we happen to encounter the problem of 12c snooping registration, I would like to share some previous learning articles about the oracle 12c lreg process: in the oracle database, the pmon process has been undertaking a lot of work, such as cleaning up the process and monitoring registration, etc.

  2022-06-01 06:58:56 Views: 245
• 

  Oracle optimization-table optimization (temporary table)

  First, create temporary tables and regular tables SQL > CREATE GLOBAL TEMPORARY TABLE TMP_TEST ON COMMIT PRESERVE ROWS AS SELECT * FROM emp

  2022-06-01 06:58:55 Views: 201
• 

  In-depth understanding of distributed database and cache double write consistency scheme analysis

  Introduction Why did you write this article? First of all, caching has been widely used in projects because of its high concurrency and high performance. In terms of read cache, there is no doubt that the business operation is carried out according to the process shown in the figure below. Cdn2.b0.upaiyun.com/2018/0

  2022-06-01 06:58:55 Views: 220
• 

  Oracle 11g rac expdp exported Times error: ORA-31694, ORA-31617, ORA-19505, ORA-27037

  Rac expdp exported Times error: ORA-31693: Table data object "scott". "dept" failed to load/unload and is being skippe

  2022-06-01 06:58:55 Views: 245
• 

  The general ledger is traced back to each module R12

  All kinds of transactions in the modules of receivables, payables, inventory, procurement (receiving) and so on will generate the corresponding general ledger accounting information through the sub-ledger. We can view the corresponding transaction operations and interfaces through the traceability function of the general ledger journal line. So what if they are related? The association between the general ledger and each module

  2022-06-01 06:58:54 Views: 249
• 

  How to add Firebase Analytics to a NativeScript mobile application

  We all know this when you want to release mobile apps as soon as possible. You've been working for months, and after testing, it looks good, and your VIPs even like it. The last thing you need to do between you and the released application is more work. However, adding analysis to your application is a

  2022-06-01 06:58:43 Views: 280
• 

  Mini Diary for mac (easy to use electronic diary)

  MiniDiary for mac is an electronic diary, MiniDiary has a simple UI, only a few buttons, text fields, calendar and search functions. You really don't need anything else to write down your thoughts today. Mini Diary Mac version is simple.

  2022-06-01 06:58:41 Views: 277
• 

  DBA look before you leap

  1: physical analysis of test environment and formal environment, do not open both test maintenance window and production window.

  2022-06-01 06:58:41 Views: 267
• 

  Weighting of tables involved in dblink

  User user_a above A has DBLINK,B_dblink that accesses B, and execute the following authorization on user user_a of library A, authorizing table1 of dblink to user_bgrant select on table1@ of library A.

  2022-06-01 06:58:35 Views: 243
• 

  Glyphs 2 for Mac the most professional font design and editing software

  Glyphs 2 for Mac is a very powerful font design and editing tool, which not only has a simple operation interface and very convenient editing view, but also automatically writes the corresponding coding for the characters when adding glyphs, which greatly reduces the threshold of making font and makes it very easy to make font.

  2022-06-01 06:58:35 Views: 293