NAV: SLTechnology News&Howtos > Database >

• 

  Skills and points for attention in oracle sql sorting and comparison (1)

  In sql sorting, oracle defaults to binary sorting. There are different values in uppercase and lowercase, with uppercase values at the top. Sometimes, what we need to deal with is that we want to sort by ignoring case. There are several ways to do this: set the NLS environment variable alter se

  2022-06-01 16:52:27 Views: 252
• 

  Pt-table-sync Common referenc

  Pt-table-sync is an excellent tool to solve the inconsistency between master and slave data. It can also be used to synchronize data between two non-master-slave databases. Ddl can not be synchronized, but data can only be synchronized. The following are common examples: hackers 192.168.56.101 is the source, hackers 192

  2022-06-01 16:52:27 Views: 266
• 

  Installation and configuration of cacti

  one。 Create a virtual host 1.vim / etc/httpd/conf.d/vhost.conf which is a new file or can be added at the end of / etc/httpd/conf/httpd.conf as: / fixed format ip and end

  2022-06-01 16:52:26 Views: 228
• 

  TIMED OUT WAITING FOR OHASD MONITOR

  RHEL 7.2 install Oracle 11g RAC on startup the journal "Created alert: (: OHAS00117:): TIMED OUT WAITING FOR OHASD MON"

  2022-06-01 16:52:15 Views: 265
• 

  Zabbix Monitoring mongdb

  Found a lot of monitoring articles, but still encountered a lot of problems, there are no successful examples according to the article. The purpose of this article is to explain the problems encountered and the solutions. Download the plug-ins and templates for mongodb at the following link: http://mikoomi.g

  2022-06-01 16:52:15 Views: 288
• 

  Compiling and installing Enterprise MariaDB Database based on the latest Source Code package of CentOS 6.8platform

  Installation environment system: CentOS 6.8 x86_64MariaDB:enterprise 10.1.16 Resources for MariaDB Enterprise Edition download, visit https://mariadb.com/my_porta

  2022-06-01 16:52:15 Views: 226
• 

  Synchronization error repair of database multi-source replication

  The error report goes like this: it is found that a database has reported an error. The error is as follows. Coordinator stopped because there were error (s) in the worker (s). The most r

  2022-06-01 16:52:15 Views: 256
• 

  Check if msyql is case sensitive

  Mysql defaults to the case-sensitive value of show Variables like'% table_names%'lower_case_table_names, with 0 for differentiation and 1 for indistinction.

  2022-06-01 16:52:14 Views: 206
• 

  Mongodb 3.0 configuration

  Mongodb 3.0 is a revolutionary version, thanks to the new version of the storage engine WiredTiger, which greatly improves performance as well as data compression (300%). For performance comparison, see: https://comerford.cc/2

  2022-06-01 16:52:14 Views: 215
• 

  Timer job of oracle

  1. Create a stored procedure my_proc (); 2. Create a timer, which means that the JOB has already been run when it is created; declare test_job number;beginsys.dbms_job.submit (te

  2022-06-01 16:52:14 Views: 224
• 

  The basic scheme of mongodb optimization

  1 create an index to create an index on a query or sort field, you can improve query efficiency 2 limit the number of results returned using limit limit the size of the returned result set 3 only the fields used by the query, not all fields

  2022-06-01 16:52:14 Views: 251
• 

  Centos6 installation oracle 11g

  1. The software package required to install oracle (according to the official oracle documentation) can be installed using # yum-y install binutils* compat-lib* gcc-* glibc-* ksh libgcc

  2022-06-01 16:52:13 Views: 269
• 

  MySQL master-slave replication exception .md

  MySQL 5. 6 > > MySQL 5. 7 error message: Last_Error:... The slave coordinator and worker threads are stopped, p

  2022-06-01 16:52:13 Views: 226
• 

  Where statements and sort operations of Oracle

  Where features: 1, used for data filtering 2, can be compared, logical operation 3, where needs to be placed after from = =

  2022-06-01 16:52:13 Views: 282
• 

  [MySQL] use binlog to roll back DML operation

  Introduction: misoperation will inevitably occur during the operation of the database, especially in the test environment developers or testers sometimes delete or update some data mistakenly. At this point, you can use the binlog flashback DML operation. Condition: 1.mysql binlog must exist and be a row lattice

  2022-06-01 16:52:01 Views: 277
• 

  Installation of MongoDB under RHEL6.5

  Check the version number of the operating system 2. Upload the downloaded software to the specified directory 3. Extract the file 4. Check the unzipped directory 5. Make a soft link to the directory 5. View the generated soft link directory 6. Set the environment variable 7. Create a directory to save the database 8. Start MongoDB

  2022-06-01 16:52:01 Views: 272
• 

  Database separation

  Database separation: on web: cd / home/oldboy/tools/ exports the wordpress database on web01 and packages mysqldump-uroot-poldboy123 wordpress-B |

  2022-06-01 16:51:32 Views: 220
• 

  Django development configuration

  The company's business provides API data interface calls, but developers do not have time to develop data statistics, so they write a python scheduled task script to do statistics every day and send statistical results to the relevant personnel. Manual statistics are needed to solve temporary problems, to view historical calls and precise point-in-time searches. So I wanted to write.

  2022-06-01 16:51:32 Views: 250
• 

  Redis sentinel master-slave handover (failover) solution, detailed configuration

  Master-slave replication is simply to synchronize data from one redis database to another redis database, and according to the data flow, the sender of the data is called master, and the receiver of the data is called slave (the division of master/slave is not

  2022-06-01 16:51:32 Views: 282
• 

  The method of recording the IP address of connected users by Oracle

  We all know that the machine name of the client is recorded in v$session, but without IP, how can we get IP information to be recorded in v$session? 1. First, using the DBMS_SESSION process package, execute: BEGIN DBM

  2022-06-01 16:51:31 Views: 297