NAV: SLTechnology News&Howtos > Database >

• 

  [Mysql] mysql quickly preheat innodb_buffer_pool

  Quickly preheat buffer_poolmysql management, optimize P82 page # # innodb_buffer_pool_dump_at_shutdown=1#innodb_buffer_pool_dump_now=1

  2022-06-01 06:23:29 Views: 282
• 

  How to improve server data security?

  Method 1: the significance of regular backup data backup is that when accidents such as network attacks, virus intrusions, power failures or operation errors occur, the original system can be restored completely, quickly, simply and reliably to ensure the normal operation of the system within a certain range. Some people attach importance to backup data.

  2022-06-01 06:23:28 Views: 244
• 

  MySQL package grab tool: MySQL Sniffer

  In the past two days, I have seen an open source software in the group, which is a tool for MYSQL to capture packages in real time. Immediately let me think of some of the requirements for fault location before, before for the connection to the database connection information for audit positioning, have done MYSQL's own audit function on (there are many holes, use with caution)

  2022-06-01 06:23:28 Views: 240
• 

  MySQL sub-database sub-table

  Types of sub-database and sub-table: the sub-database sub-table here refers to physically splitting the data in the database into multiple instances or servers, rather than the native Partitioining of MySQL. The official Partitioning of MySQL can divide the database of a table.

  2022-06-01 06:23:28 Views: 215
• 

  [Mongo] the problem of mongos shard unique index

  1. Documents that have been uniquely indexed by sharding mongos > db.testmongo.ensureIndex ({'age':1,'name':1}, {"unique": 1}) {"raw": {"sh"

  2022-06-01 06:23:22 Views: 215
• 

  Shen Jian, CTO of Kuaigou Taxi: best practices for Database Schema consistency

  This article is based on Shen Jian's live speech at the 10th China Conference of system Architects (SACC2018) on October 18, 2018. Lecturer introduction: Shen Jian, Fast Dog Taxi CTO, Internet architecture technology expert, author of "architect's Road" official account. Used to be a senior member of Baidu

  2022-06-01 06:23:22 Views: 269
• 

  OJVM+GI PSU patch upgrade

  Execute it on DataGuard first. After all nodes of DataGuard are upgraded successfully, it will be executed on production. Dg does not need to run scripts after upgrading, but only needs to execute on a node of master database after patches of master and backup database. When the master database needs to stop transferring logs to standby database before upgrade, standby

  2022-06-01 06:23:22 Views: 243
• 

  Steps for Oracle to rebuild awr

  1. For the sake of safety, it is recommended to stop and rebuild 2. For rac environment, you need to modify the following parameters: alter system set cluster_database = false scope = spfile;3. Execute the following script to start cleaning

  2022-06-01 06:23:22 Views: 230
• 

  OLTP under the speculum and our findings (1)

  Author: Stavros Harizopoulos, Daniel J. Abadi, Samuel Madden, Michael Stonebraker online transaction processing (OLTP) database contains a series of

  2022-06-01 06:23:18 Views: 239
• 

  Practice of real-time synchronization of Mysql data

  How much do you know about the database used internally by Xiaomi? Background because of its simplicity, efficiency and reliability, Mysql has become the most widely used database in Xiaomi, but when the amount of data reaches the level of 10 million / 100 million, the related operation of mysql will become very slow; if there is any real at this time

  2022-06-01 06:23:14 Views: 210
• 

  Solution: ORA-00845: MEMORY_TARGET not supported on thi

  ORA-00845: the shm size of MEMORY_TARGET not supported on this systemRA:Linux system is smaller than that set by SGA. SGA is set to 4G, while shm only has 1G solution.

  2022-06-01 06:23:13 Views: 284
• 

  Number----char (to_char)

  1Byte of positive number is used to store the preceding'+ 'SQL > select length (23), length (- 23) fro when the format is specified.

  2022-06-01 06:23:13 Views: 215
• 

  Fields are suppressed using functional indexes

  Use the function on the index field and the index of that field will be suppressed. The following example: view the table structure: click (here) to collapse or open mysql > show create table test06\ G*

  2022-06-01 06:23:13 Views: 261
• 

  An OCM exam that I experienced personally.

  I took the 11G OCM exam in late December 2017 and received an email from ORACLE to pass the exam in mid-January 2018. Thank my family for their support and dedication. Thanks to Mr. Zhao, Mr. Han, Mr. Huang from the School of continuing Education of Shanghai Jiaotong University, and all those who prepared for the exam together.

  2022-06-01 06:23:07 Views: 223
• 

  The reason why the xampp cannot be accessed by the external network

  When a local area network or an external network accesses xampp, the following error is reported: New XAMPP security concept:Access to the requested directory is only availabl

  2022-06-01 06:23:07 Views: 261
• 

  Summary of Oracle downtime cases (1)

  Summary of Oracle downtime cases (1) case 1: UNDO bad block causes Oracle to fail to Open scenario: Friday will be off, R & D feedback database can not be connected, because it is the company's internal database, all the data comes from other libraries through expdp/impdp

  2022-06-01 06:23:07 Views: 302
• 

  [giant sequoia database Sequoiadb] whether the self-increasing sequence Serial in PostgrepSQL can be used

  [solution] currently (v3.0.1), when mapping PostgreSQL external tables, specify the field as the serial field type of PostgreSQL to achieve the requirement of PostgreSQL self-increment field. But it's important to note that this is

  2022-06-01 06:23:07 Views: 288
• 

  Oracle DB related common sql summary 7 [manually bind sql execution plan]

  SPO coe_xfr_sql_profile.log;SET DEF ON TERM OFF ECHO ON FEED OFF VER OFF HEA ON LIN 2000 PAGES 100 L

  2022-06-01 06:23:06 Views: 249
• 

  Latch causes MySQL Crash

  Dong Hongyu, a senior database expert of Walk Technology, an overview of the problem recently we encountered a MySQL problem, which is very representative after analysis and specially wrote it for your reference. The problem is that the database is first set to read-only, and then after a period of time, MySQL is directly Crash.

  2022-06-01 06:23:06 Views: 274
• 

  Windows silently installs the Oracle11G script

  The copyright of the article is Jusin Hao (luckyfriends), which supports originality. For reprint, please indicate @ echo offcd c:\ md Oracle "C:\ Program Files (x86)\ WinRAR\ win.

  2022-06-01 06:23:05 Views: 270