NAV: SLTechnology News&Howtos > Database >

• 

  MySQL memory footprint calculation formula

  Maximum available memory for MySQL (M): select (@ @ key_buffer_size + @ @ innodb_buffer_pool_size + @ @ tmp_table_size + @ @ max_conn

  2022-06-01 06:13:45 Views: 213
• 

  MyCAT High availability scenario and Architecture Diagram

  The advantages of MyCAT are developed based on Ali's open source Cobar products. Cobar's stability, reliability, excellent architecture and performance, as well as many mature use cases make MYCAT have a good starting point from the very beginning. Standing on the shoulders of giants, we can see further. Industry excellence

  2022-06-01 06:13:45 Views: 267
• 

  MySQL 5.5-innodb_lock_wait Lock waiting

  Remember in the past, when there was: ERROR 1205 (HY000): Lock wait timeout exceeded; try restarting transaction, it was a troublesome thing to solve; especially

  2022-06-01 06:13:44 Views: 291
• 

  Galera Cluster for MySQL Monitoring status description

  Monitoring status description Cluster integrity check: wsrep_cluster_state_uuid: the values of all nodes in the cluster should be the same. Nodes with different values indicate that they are not connected to the cluster. Wsrep _ cluster_conf_id: normal

  2022-06-01 06:13:44 Views: 292
• 

  Script for querying TOP SQL when the MYSQL slow query log is stored in a table

  Sort by execution time and use reverse order to find the slow query SQLt_slow.sqluse mysql;select * from (select * from slow_log where start_) of TOP 10

  2022-06-01 06:13:44 Views: 211
• 

  2020 database celebrities platform held on June 18, Ali Tencent Dameng many database celebrities gathered together!

  In the last database giant forum, with the theme of "focusing on new infrastructure, domestic databases ushered in new opportunities for development" as the theme, we invited many big names to discuss the new requirements for IT infrastructure construction put forward by the new situation, which received enthusiastic response. This time, we have invited large Internet companies and domestic companies

  2022-06-01 06:13:41 Views: 303
• 

  [AlwaysOn] create SQL Server high availability group T-SQL syntax: BACKUP_PRIORITY parameter

  BACKUP_PRIORITY = n specifies the priority for this copy to perform backups over other copies in the same availability group. Specifies your priority for performing backups on th

  2022-06-01 06:13:40 Views: 206
• 

  ORA-19909 (a failure caused by DataGuard Failover

  A hospital customer, the core database has two reserve databases. Because I want to use one of the standby hosts for testing, I want to switch the database to read-write mode. In this way, the failover action of preparing the library is involved. This failover is in another standby database, and the main database is still alive.

  2022-06-01 06:13:40 Views: 228
• 

  Look up one of the meanings of linux tcp kernel parameter kernel parameter tcp_max_syn_backlog

  Preface mysql database in order to run stably and efficiently, it is necessary to optimize the performance of the database from many aspects, and the effect will be obvious. One of the important links involves the optimization of the operating system. This article only talks about linux operating system, because linux is the main platform for running mysql and is the most representative.

  2022-06-01 06:13:37 Views: 300
• 

  Talking about how to install MySQL Database under UNIX system

  Talking about how to install MySQL database (transfer) [@ more@] CODE: # cd / usr/src# tar-zvxf mysql-3.22.25-pc-linux-gnu-i686.tar under UNIX system.

  2022-06-01 06:13:37 Views: 275
• 

  The use of oracle instr function

  In Oracle, you can use the instr function to determine whether a string contains a specified character. Finds the specified character in a string and returns the position of the specified character found. Syntax: instr (sourceString,dest

  2022-06-01 06:13:36 Views: 213
• 

  [Oracle] the following table structure, initialization data and table creation statements for scott users

  Table structure EMP employee table number column name data type description constraint 1EMPNONUMBER (4 BYTE 0) employee number Primary Key2ENAMEVARCHAR2 (10 BYTE) employee name 3JOBVARCHAR2 (9 BYTE

  2022-06-01 06:13:36 Views: 256
• 

  Index Series 7-the low height of index characteristics is a sharp tool for optimization.

  Sqlplus ljb/ljbdrop table t1 purge;drop table t2 purge;drop table t3 purge;drop table t4 purge;drop

  2022-06-01 06:13:36 Views: 289
• 

  Detailed explanation of Flashback Data Archive principle

  The flashback data archive available in the Flashback Data Archive11g version of Oracle database can view the status of any previous timesheet. Use flashback da

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

  Oracle11g database parameter file erroneous deletion recovery

  In this paper, we test the recovery method after mistakenly deleting spfile,pfile,init.ora and other files, consider a variety of scenarios, and restore parameter files in different scenarios. Step 1: connect to the database and view the path where the spfile file is located [oracle@ora11g

  2022-06-01 06:13:30 Views: 212
• 

  Oracle ADG ora-30927

  Environment: centos6.8 11.2.0.3.10 (64bit) originally did not have this problem, but due to recent adjustments to the read-only library, after rebooting, it was found that the bug was triggered. This bug has appeared before, by restarting the read-only library

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

  Oracle 11GR2 (11.0.2.4.0) Combo OJVM PSU+GI PSU (11.2.0.4.180116) patched

  Patch 27282436 Combo OJVM PSU 11.2.0.4.180116 and GI PSU 11.2.0.4.180116 < one > Patch 27107360 GI PSUOra

  2022-06-01 06:13:19 Views: 202
• 

  Big data is the key point, Oracle, SQL Server become yesterday's yellow flower?

  Introduction someone left a message on an official account that focuses on SQL as follows: disdain for SQL Server leads to a very sensitive question: is there a future for relational databases? Now it is 2020, the block chain is hot, AI talent has been "surplus", big data has become sparse

  2022-06-01 06:13:19 Views: 217
• 

  Is it really bad to use a thousand yuan machine? That's because you didn't get the right model, such as these.

  Is it really bad to use a thousand yuan machine? For example, when the 5G era is approaching and the 4G network is about to withdraw, many people choose some thousand-yuan phones as transitional models in order to enjoy the 5G network, but the experience after getting started is not very satisfactory. Is it a thousand yuan?

  2022-06-01 06:13:19 Views: 288
• 

  Mongodb Learning (installation): installation under centos

  Installation # download the decompressed file [root@192 lamp] # wget http://fastdl.mongodb.org/linux/mongodb-linux-i686- 2.2.2.tgz###

  2022-06-01 06:13:18 Views: 263