NAV: SLTechnology News&Howtos > Database >

• 

  Is it annoying that there are too many websites? Macz editor tells you how to block any website on Chrome.

  Are you often attracted by unimportant websites when browsing websites, wasting valuable time? Today, the editor of macz will tell you in detail how to block any website on Chrome. Chrome is undoubtedly the most popular browser in the world.

  2022-06-01 06:12:19 Views: 247
• 

  More than one new partition at a time and dismantling one partition

  ALTER TABLE emp_part ADD PARTITIONPARTITION p4 VALUES LESS THAN (35000), PARTITION p5 VALUES LESS THA

  2022-06-01 06:12:19 Views: 278
• 

  Memcache security configuration

  The memcached-d-m 100-u root-l x.x.x.x-p 11211-c 512-P / tmp/memcached.pid parameter indicates that the-d option is to start a daemon, and-m is the allocation

  2022-06-01 06:12:18 Views: 284
• 

  Mysql's performance optimization tool (from Master Han Feng, modified for 5.7)

  Master Han Feng shared a mysql performance optimization tool, a python script that can automatically collect all kinds of information related to SQL optimization, which can save a lot of trouble for optimizers. After trying it out, I found that it won't work under mysql5.7, but it's better to have details.

  2022-06-01 06:12:18 Views: 282
• 

  Database popularity ranking in July 2019: a big increase in the return of the king of Oracle

  2019 is halfway through, and DB-Engines 's database popularity ranking was released in July, which can be regarded as the half-yearly report of database popularity. The star product in July is Oracle, whose score increased by 22 points, an increase of 43% over the same period last year.

  2022-06-01 06:12:13 Views: 271
• 

  A Better Finder Attributes 7 for Mac (File bulk renaming tool)

  There are too many folders, is it too troublesome to rename them in turn? A Better Finder Attributes 7 Mac is a file batch renaming tool on MacOS that allows you to change JPEG and RAW shooting dates and JPEG EXIF metadata tags

  2022-06-01 06:12:10 Views: 288
• 

  The sys account caused by mixed case of Oracle SID cannot log in.

  Oracle installation, especially in Linux/Unix environments, is a challenge for every beginner. There are many operation steps, various configuration projects are complex and many details, as long as there is an error in one step, it may bring problems to the subsequent installation or operation. Sometimes some people ask

  2022-06-01 06:12:01 Views: 211
• 

  Wechat multi-assistant WeChatPlugin for mac (Wechat assistant)

  Wechat multi-open assistant WeChatPlugin for Mac is a Wechat multi-open plug-in on macos, users using Apple Wechat multi-open assistant Mac version can install multiple official Wechat fen, while running non-interference, Wechat multi-open assistant Apple version is easy to operate, as long as one click points

  2022-06-01 06:12:01 Views: 218
• 

  Best practices for database high availability scenarios for MySQL MGR+ Consul

  MySQL MGR+ Consul database high availability best practice background: based on the fact that there are many MySQL database single points of failure, traditional MHA,PXC and other schemes can achieve strong data consistency based on database by switching between VIP and DNS.

  2022-06-01 06:11:50 Views: 239
• 

  Revenue growth is declining, product structure is single, Blue Moon IPO is optimistic?

  Recently, "laundry liquid" Blue Moon submitted a prospectus to the Hong Kong Stock Exchange for listing on the main board of Hong Kong stocks, with co-sponsors Merrill Lynch, CICC and Citigroup. It is reported that this IPO, Blue Moon wants to raise funds for capacity expansion, brand awareness, sales and distribution network, etc., but for the specific scale of fund-raising

  2022-06-01 06:11:45 Views: 228
• 

  Modify MySQL high availability module to receive custom VIP parameters

  All MySQL DBA must have heard of MHA high availability solutions, and many companies achieve MySQL high availability through secondary development of MHA. If MHA is not combined with VIP, each switching of the main library requires the program to modify the configuration of the connected database, so it is more difficult.

  2022-06-01 06:11:45 Views: 286
• 

  1000 lines of MySQL study notes, everyone has a copy, it is recommended to collect!

  This article is reproduced from: lattice author: Jioby original text: https://url.cn/5psTHf7Windows Service-- start MySQL net start mysql-- to create Windows Service sc

  2022-06-01 06:11:45 Views: 209
• 

  [architecture] kernel.shmmax and kernel.shmall settings for Oracle

  1. Kernel.shmmax: is one of the most important core parameters and is used to define the maximum value of a single shared memory segment. The setting should be large enough to accommodate the entire SGA under one shared memory segment, and setting too low may result in the need to create multiple shared memory

  2022-06-01 06:11:40 Views: 237
• 

  Command fallback in Oracle SQL> mode

  Connecting sqlplus does not go through the history as mysql does, by installing rlwrap1 and installing rlwrap-0.37.tar.gztar zxvf rlwrap-0.37.tar.gzcd rlwrap-0.37.

  2022-06-01 06:11:40 Views: 285
• 

  (transfer) Dirty Page and Redo log of InnoDB

  Author: Su Pu | [be sure to indicate the original origin and author information of the article and this statement in the form of hyperlink when reprinting] address: http://rdc.taobao.com/blog/dba/html/317_innodb-dirty-page-

  2022-06-01 06:11:40 Views: 250
• 

  Overview of LOG FILE SYNC (first article)

  For nearly half a year, I have been dealing with log file sync. Every time I check the TOP 5 waiting events during the system stress test, log file sync is firmly in the first place, and the average response time has reached 10ms.

  2022-06-01 06:11:39 Views: 301
• 

  Analysis on the implementation principle of distributed transaction XA in MySQL Database

  1 principle about the distributed transaction XA of MySQL database, the principle of distributed transaction implementation, see [3]; for the explanation of MySQL XA, see [1] [2]. MySQL XA is divided into two categories. Internal XA and external XA; internal XA are used to span multiple instances under the same instance.

  2022-06-01 06:11:39 Views: 267
• 

  MySQL 5.7Master-Slave replication based on GTID

  MySQL 5.7 prepares three MySQL instances mysqld-- initialize-insecure-- user=mysql-- basedir=/usr/ based on GTID master-slave replication 1 and build process 1.1

  2022-06-01 06:11:39 Views: 301
• 

  [RMAN] different machine recovery experiment

  First, the preparatory work 1. Environment setting source library: IP 192.168.131.100 SID:orcl target library: IP 192.168.131.101 install the same version of the database software as the source database (do not create an instance) 2. Preparation work source database creation

  2022-06-01 06:11:39 Views: 299
• 

  Summary of use cases of B-Tree, Bitmap and functional indexing in Oracle

  Catalog 1, Index introduction 1, the index is an independent database object, just like the data table table. In Oracle, the database object object is represented by a segment segment structure. In the data dictionary dba_segment, we can use the indexed

  2022-06-01 06:11:33 Views: 208