NAV: SLTechnology News&Howtos > Database >

• 

  Linux Monitoring system _ Zabbix installation steps and configuration v1.1 (3)

  Environment: use one host to configure Server / Web GUI / Database # C7R3 172.16.79.73 and another host as monitored host # C7R4 172.16.79.74 here with zabbix my

  2022-06-01 07:23:31 Views: 222
• 

  Mysql insert cache ​

  In indodb_ 's storage engine, the primary key is the unique identifier. Typically, the order in which row records are inserted in an application is mysql > create table t (an int auto_incremen) in the order in which the primary key is incremented.

  2022-06-01 07:23:30 Views: 291
• 

  Unable to start error report after upgrading Zabbix proxy to 3.0.2

  A problem description crashes directly after upgrading a zabbix proxy from 2.4.5 to 3.0.2. The error message is as follows: 2367 One child process died 20160508 Switzerland 153246.830

  2022-06-01 07:23:29 Views: 205
• 

  Common sentences in sql

  Here are mainly sql statements for mysql: ①-MyBatis SQL xml handles less than and greater signs when we need to process sql statements in xml format, we often use symbols such as <, < =, >, > =, but it's easy.

  2022-06-01 07:23:29 Views: 293
• 

  Log in to the specified instance by sqlplus under multiple oracle instances of windows

  When multiple oracle services are installed under windows, the last installed database instance will be set by default. To switch instances to log in to sqlplus, under the CMD window, modify the value of ORACLE_SID (set ORACLE_SID=xx).

  2022-06-01 07:23:21 Views: 244
• 

  Plsql developer cannot log in to Oracle

  Plsql developer login prompt: solution: the reason for this prompt is that the installation path of Oracle has changed and you need to reconfigure ORACLE_HOME and "OCI Librar in PLSQL Developer.

  2022-06-01 07:23:14 Views: 231
• 

  SQLite incremental primary key (Autoincrement)

  Https://www.sqlite.org/autoinc.html Overview 1 self-incrementing primary key (TheAUTOINCREMENT keyword) takes up additional CPU, memory, disk space, and increases the overhead of disk Icano

  2022-06-01 07:23:03 Views: 260
• 

  Hbase stand-alone Building under Linux-HBase (pseudo-distributed) Learning Notes

  1. Linux to build Hbase1, environment system: CentOs6.6 download address: http://mirrors.neusoft.edu.cn/centos/6.6/isos/x86_64/Hbase Hbase1

  2022-06-01 07:23:03 Views: 257
• 

  Mycat Learning practice-Mycat's zookeeper Cluster Model

  Mycat Learning practice-Mycat's zookeeper Cluster Model Learning mycat mysqlMycat Learning practice-Mycat's zookeeper Cluster Model 1. Introduction to ZooKeeper 2. ZooKeeper role

  2022-06-01 07:23:03 Views: 266
• 

  Operation of Redis string type

  Set key value [ex seconds] / [px milliseconds] [nx] / [xx] such as: set a 1 ex 10, 10 seconds valid Set a 1 px 9000, 9 seconds valid Note: if ex,px is the same

  2022-06-01 07:22:57 Views: 288
• 

  Data table type

  Data table type 1. Create a data table CREATE TABLE IF NOT EXISTS user (id INT UNSIGNED AUTO_INCREMENT PRIMARY KEY,name VARCHAR)

  2022-06-01 07:22:57 Views: 265
• 

  Install mysql-5.7.24-1.el7.x86_64 on centos7.4 with rpm package

  CentOS7.4 system Information [root@localhost iso] # uname-aLinux localhost.localdomain 3.10.0-693.el7.x86_64 # 1 SMP

  2022-06-01 07:22:49 Views: 269
• 

  Mysql5.7 change password

  Update mysql.user set authentication_string=password ('12345') where user='root' and Host = 'localhos

  2022-06-01 07:22:48 Views: 240
• 

  Implementation Plan of Oracle fixed SQL (2)-SPM

  I wrote a blog about using SQL Profile to adjust and stabilize the execution plan of the target SQL, even if the SQL text of the target SQL cannot be modified. But SQL Profile is really just a remedial, passive technical means applied to those who implement the plan.

  2022-06-01 07:22:44 Views: 244
• 

  Several database Sql statements

  (1) there may be tare weight records of multiple cars in the same table. I want to update the earliest record, that is, to update their tare weight. In sqlite3, it is as follows: update CarNoTable set TareWeight = '9080'-where

  2022-06-01 07:22:43 Views: 244
• 

  Several important views of PostgreSQL statistics

  1. Pg_stat_databaseyzs=# select * from pg_stat_database;- [RECORD 1]-+--

  2022-06-01 07:22:43 Views: 294
• 

  MariaDB 10.2.26 xtrabackup important step record

  1. Create the test case library table Welcome to the MariaDB monitor. Commands end with; or\ g.Your MariaDB connection id is 11

  2022-06-01 07:22:43 Views: 258
• 

  SHUTDOWN: waiting for active calls to complete

  Shut down the database, alert log: Active call for process 36176016 user 'oracle' program' oracle@aix'Active call for pro

  2022-06-01 07:22:42 Views: 290
• 

  OGG single table initialization operation steps

  Sometimes the data at both ends of the ogg are inconsistent, and the amount of data is large, and manual modification is more complex, so we need to initialize these tables. The general idea of initialization is to stop the OGG on both ends. If the business cannot be stopped for a long time, you need to configure the target process to pause the synchronization of these problem tables.

  2022-06-01 07:22:42 Views: 295
• 

  Common operations of MySql at work

  Log in to MySQL, and if you connect to a remote database, you need to specify hostname with-h. # mysql-h hostname-uroot-p#mysql-uroot-p-S / data/3306/mysql.

  2022-06-01 07:22:42 Views: 206