NAV: SLTechnology News&Howtos > Database >

• 

  [AlwaysOn] create SQL Server high availability group T-SQL syntax: REPLICA ON clause

  REPLICA ON specifies from 1 to 5 SQL Server instances to host availability copies in the new availability group. Specifies from one to five SQL server instances to host

  2022-06-01 06:28:40 Views: 226
• 

  Data pump export and import

  For many reasons, we expect to extract a large amount of data and associated object definitions from one database and load that data into another database in an easier way. Backup is one of the important reasons, and it may also be necessary between production and test environments or between online systems and data warehouses.

  2022-06-01 06:28:38 Views: 243
• 

  Dameng database error: rollback record version is too old to get user record

  The phenomenon describes that when we make a large query, we often encounter this error: the version of the rollback record is too old to obtain user records. How can we solve this problem? There are three ways to choose the machine to perform the appropriate adjustment of undo_retention and consider enabling it.

  2022-06-01 06:28:38 Views: 275
• 

  Oracle 19c Virtual key automatic indexing Test

  1. Oracle recently held a series of online sharing about testing, and one of the new features of 19c is automatic indexing. I tested it in docker and failed. [oracle@8aa96a41b58b ~] $sqlplus / as s

  2022-06-01 06:28:37 Views: 233
• 

  PHP Mysql support: is it mysql or mysqlnd?

  You are using one of the alternate repositories to install a modern version of php, and suddenly you are faced with a puzzling choice. You want to support mysql (mysqli or PDO-mysql) in the php program. What would you choose? First, you should probably use PDO. And m

  2022-06-01 06:28:37 Views: 269
• 

  MySQL query metadata information

  MySQL5.0 then provides a new database, information_schema, which is used to record the metadata information in MySQL. It is worth noting that it is a virtual database, and physically there are no related directories and files, similar to the actions of ORACLE.

  2022-06-01 06:28:37 Views: 262
• 

  Enq of Oracle waiting event: TM-contention

  During DML, in order to prevent modifications to DML-related objects, the process executing DML must acquire a TM lock on the table. P1 = name | modeP2 = object # P3 = table/partitionSQL >

  2022-06-01 06:28:37 Views: 285
• 

  Mysql Export user Rights

  When migrating a MySQL database, it is sometimes necessary to migrate users and permissions in the source database. For this migration, we can obtain the relevant permissions of the user from the mysql.user table to generate the corresponding SQL statement, and then execute the generated SQL on the target server

  2022-06-01 06:28:36 Views: 254
• 

  Transfer: thread_cache and table_cache detailed explanation of MySQL performance optimization configuration parameters

  Http://www.jb51.net/article/51828.htm 1. In order to improve the performance of the client request connection creation process, THREAD_CACHEMySQL provides a connection pool, namely Thread_Cach.

  2022-06-01 06:28:36 Views: 214
• 

  Research on garbled mysql character set

  Environment description: the ip of Qingyun's mysql instance is 192.168.0.254, and Qingyun's springboard host. We install mysql service on the springboard host and connect mysql in the following way: [root@i-iivphroy ~] # m

  2022-06-01 06:28:36 Views: 299
• 

  Anti-crash of MySQL replication slave node

  In previous versions of MySQL5.6, run-time data replication information was saved in two files in the slave node data directory, master.info and relay-log.info. It is still stored in the data directory by default after MySQL5.6, but it can

  2022-06-01 06:28:36 Views: 301
• 

  [Mysql] modify mysql time zone

  First you need to check the current time zone of mysql, using the time_zone parameter mysql > show global variables like'% zone%';+-+-

  2022-06-01 06:28:35 Views: 276
• 

  Rapid development platform is gradually replacing the traditional development model.

  The emergence of the Internet has changed some people's way of life, and with the popularity of the Internet, more and more enterprises are preparing or have to transfer the traditional application system model to the Internet. This transfer will greatly reduce the manpower, financial resources and cost of enterprises to maintain large distributed application systems.

  2022-06-01 06:28:33 Views: 286
• 

  Oracle 12c non-cdb upgraded to cdb mode

  Oracle 12c non-cdb upgrade to cdb mode under the same host, there is a non-cdb database, and then create an instance of cdb. SQL > select name,cdb from vested database

  2022-06-01 06:27:55 Views: 212
• 

  Explore the event-driven model and command execution process of Redis design and implementation of 10:Redis

  This article is transferred from the Internet. This series of articles will be sorted out in my "Java interview Guide" warehouse on GitHub. For more wonderful content, please go to my warehouse to check out https://github.com/h3pl/Java-Tutorial if you like.

  2022-06-01 06:27:55 Views: 295
• 

  Fragmentation of MongoDB

  1. Environment operating system information: IP operating system MongoDB10.163.91.15RHLE6.5_x64mongodb-linux-x86_64-rhel62-3.4.7.tgz10.163.91.16RHLE

  2022-06-01 06:27:54 Views: 256
• 

  Why are you so ugly when you take pictures on Huawei's mobile phone? These four functions are not enabled, are they?

  The camera function of Huawei's mobile phone has been liked by photographers in the industry. But when you use the same Huawei phone to take pictures, why are you so ugly? Did you not turn on these four functions? 1. The capture function is the most beautiful moment that can be preserved. Many people always miss this moment, so they can't get what they want.

  2022-06-01 06:27:47 Views: 251
• 

  MySQL: how to quickly view Innodb data files

  Welcome to follow my "in-depth understanding of MySQL Master and Slave principle 32", as follows: if the picture can not be displayed, please see the following link: https://www.jianshu.com/p/d636215d767f Note: the output format of this article is all hexadecimal.

  2022-06-01 06:27:46 Views: 261
• 

  Mysql 5.5Parameter-- innodb_read (write) _ io_threads

  # in version 5.1, the FILE_IO MYSQL only uses 4 threads to process IO;#, but on 5.5, with stronger support for multithreading; INNODB also strengthens support for IO read and write threads; take advantage of multithreading; # IO thread default

  2022-06-01 06:27:46 Views: 206
• 

  MongoDB starts Linux memory large pages (Huge Page) alarm off

  In the Linux environment, starting MongoDB by default will have a lot of alarm messages. If we install the database just for simple testing and learning, there won't be too many problems. However, if we are building a formal production environment, or the system may have higher performance

  2022-06-01 06:27:46 Views: 204