NAV: SLTechnology News&Howtos > Database >

• 

  [MySQL] parameters worth paying attention to

  Availability back_log if the number of threads connected at the same time exceeds the max_connections, the excess will not immediately reject the connection, but will be put into a stack waiting for the main thread to be processed, and connections that exceed the number of back_log will be rejected directly. M

  2022-06-01 21:53:41 Views: 296
• 

  [PostgreSQL] Database replication

  Asynchronous flow replication [root@wallet01 ~] # su-postgres [postgres@wallet01 ~] $vi / var/lib/pgsql/9.6/data/pg_hba.confho

  2022-06-01 21:53:40 Views: 272
• 

  Mysql data migration

  HeidiSQL, a tool that can easily analyze the size of the tables in the database in preparation for migration. After the analysis, first migrate the small table, then migrate the large table and so on. Refer to https://my.oschina.net/u/2371923/blog/1836 for this article.

  2022-06-01 21:53:40 Views: 299
• 

  The basic part of SQL sentence summary

  Create database CREATE DATABASE database name; delete database DROP DATABASE database name; create new table create table table name (column type, column type,..)

  2022-06-01 21:53:40 Views: 231
• 

  MongoDB import and export and database backup

  MongoDB data Import and Export 1: export tool: mongoexport concept: the mongoexport tool in mongoDB can export an collection to JSON format or CSV format file. You can specify a guide through parameters

  2022-06-01 21:53:40 Views: 204
• 

  A panicked noon

  Ha, today I finally remembered that I have a blog! Http://fanjinlong.com/2016/04/28/%E4%B8%80%E4%B8%AA%E6%85%8C%E9%87%8C%E6%85%8C%E5%B

  2022-06-01 21:53:40 Views: 299
• 

  How to find the SQL database table where the value is located through a value

  Declare @ cloumns varchar (40) declare @ tablename varchar (40) declare @ str varchar (40) declare @ counts in

  2022-06-01 21:53:39 Views: 299
• 

  MongoDB report instance-Hidden member Scheme

  Hidden members of a replication set are configured as priority: 0, and to prevent them from being elected, set hidden: true to prevent clients from connecting to the replication set to route read operations to it, even if they specify a read preference of secondary. From a hidden

  2022-06-01 21:53:39 Views: 282
• 

  Using DBCC CHECKIDENT command to query and change the identified values in tables in Sql-server 2008

  DBCC CHECKIDENT (tablename,NORESEED) tablename needs to change the name of the data table to be queried. This statement is the current identity value and the current number of columns in the query table. DBCC CHECKIDENT (tabl

  2022-06-01 21:53:39 Views: 287
• 

  Do you really know anything about the most popular server, Tomcat?

  As a core project of the Jakarta project of the Apache Software Foundation, Tomcat is deeply loved by Java lovers and recognized by some software developers because of its advanced technology, stable performance and free, so it has become a popular Web.

  2022-06-01 21:53:36 Views: 258
• 

  The case of Oracle Study-- RMAN ORA-1992

  Oracle Study case-RMAN ORA-19921 error system environment: operating system: AIX5.3Oracle: Oracle 10gR2 error phenomenon: database encountered the following error when connecting through rman: [11:0

  2022-06-01 21:53:35 Views: 260
• 

  MGR single master startup error processing ERROR 3092

  Environment description: three-node MGR cluster, single master mode, ready to shut down the master node for database maintenance, there is an error message. 1. Close the database mysql > shutdown;Query OK, 0 rows affected (0.00s)

  2022-06-01 21:53:35 Views: 255
• 

  The method of dealing with the excessive tempdb of Kingdee CLOUD Star Cloud

  -1. Find out the largest execution time of spiduse tempdbgoSELECT top 20 t1.sessionessioniddirectoryt3.totalroomelapse _ object _

  2022-06-01 21:53:35 Views: 250
• 

  Mysql Operation Mode and 1690 error handling

  Mysql operation mode and 1690 error handling MySQL said: Documentation1690-BIGINT UNSIGNED value is out of range in pass through

  2022-06-01 21:53:35 Views: 273
• 

  One-click automatic installation of zabbix services

  Aim to install zabbix service automatically with one click. Environment OS:CentOS 6.2zabbix version: 2.2.4 configuration #! / bin/bash# script name: one-click automatic installation of zabbix service # Note: # 1. This script is only available in Ce

  2022-06-01 21:53:35 Views: 223
• 

  Zookeeper+hbase research

  Google chubby paper English original paper: http://wenku.baidu.com/view/472d27a0284ac850ad0242ee.html Chinese paper: http://wenku.ba

  2022-06-01 21:53:34 Views: 262
• 

  ADG database data file damage handling

  1. Describe the single instance ADG database. If the system01.dbf file of the slave database is damaged, you need to restore the data file to ensure that the data of the main database is consistent. 2. Process 1. The database is started to mount status Recovery Manager: Release

  2022-06-01 21:53:34 Views: 245
• 

  Time stamp, it's the right way to use it.

  Timestamp field is often used in MySQL. For example, when we need to record the time when a row of data is created or modified, we usually use the timestamp that is the timestamp field. This article mainly introduces the use of timestamp field and related parameters.

  2022-06-01 21:53:34 Views: 220
• 

  Hbase shell command

  Enter hbase shell console [hadoop@mylab2 hbase] $. / bin/hbase shell2016-09-18 15 bin/hbase shell2016 01purl 36773 WARN [main] ut

  2022-06-01 21:53:34 Views: 226
• 

  HBase Full GC downtime

  Recently, the HBase cluster is being expanded, but everything is not going well: 1. One of the newly added machines actually restarted for no reason, which was directly referred to the system department. two。 After the deployment of HDFS and HBase, there was no problem with startup, but after one night, all the HBase nodes were down.

  2022-06-01 21:53:33 Views: 237