NAV: SLTechnology News&Howtos > Database >

• 

  The source code installation shell script for PHP in Linux

  #! / bin/bash# install PHPrpm-e php php-cli php-ldap php-common php-mysql-- nodepsyum-y install zlib-devel

  2022-06-01 11:45:14 Views: 258
• 

  Analyze the architecture of MySQL and learn Mysql storage engines MyISAM and InnoDB

  Mysql architecture: composed of connection pool component, management service and tool component, sql interface component, query analyzer component, optimizer component, buffer component, plug-in storage engine, physical file. Mysql is a unique plug-in architecture, and each storage engine has its own characteristics.

  2022-06-01 11:45:14 Views: 246
• 

  Join Summary in SQL

  The syntax format of SQL in oracle is as follows: select table1.column, table2.columnfrom table1 [natural join table2] | [join table2]

  2022-06-01 11:45:14 Views: 266
• 

  Collation of Redis common commands

  The Redis basic command command describes whether ping is used to detect whether the redis service starts info to view redis information select select a different keyspace, or databasekeys * view all the current keyspace

  2022-06-01 11:45:13 Views: 296
• 

  Summary of Memcached

  Memcached distributed memory object caching system; memory caching; caching the fetched objects or data in memory; these data cached in memory are accessed through API; the data is like a HASH table, existing in the way of key-value pairs. Used to reduce data.

  2022-06-01 11:45:13 Views: 238
• 

  Backup and restore of PostgreSQL Database (7)

  There are three ways to back up the database: SQL dump file system level backup. Keep archiving. The SQL dump uses the SQL command to generate a file. Backup usage: pg_dump dbname > dumpfilepg_dump is a regular PostgreSQL

  2022-06-01 11:45:13 Views: 237
• 

  Two Writing methods of creating Monitoring users in zabbix

  What's the difference between the database version 5.7.X? GRANT USAGE,SELECT,PROCESS,REPLICATION CLIENT,REPLICATION SLAVE ON *. * TO 'zabbix'

  2022-06-01 11:45:13 Views: 202
• 

  Centos7-mysql-cnf profile optimization

  Mysql optimization is the most common my.cnf file configuration optimization limit thread, access and so on max_connections = 151. each version of the limit is different, limit the maximum number of connections, more concurrent access, you can appropriately increase the back_log = value, such as

  2022-06-01 11:45:12 Views: 255
• 

  The use and concept of indexes, stored procedures and triggers in SQLserver databases

  Indexes, stored procedures and triggers can process and query some advanced data, so as to better realize the operation, diagnosis and optimization of the database. one。 The index index provides a pointer to the data value specified in the table, and the index of the database is similar to the catalog in a book without reading

  2022-06-01 11:44:42 Views: 246
• 

  In a Redis cluster, do you choose odd or even nodes? (theory)

  Let's analyze through a set of examples: 3-node environment: 1 master, 2 slave storage space: the maximum is equal to the capacity of 1 node. (if it is 2 master, then part of the data will be lost.) redundancy: 1 node failure is allowed. 4-node environment: 2

  2022-06-01 11:44:18 Views: 271
• 

  Infortrend launches DaVinci Resolve database

  Small and medium-sized media studios supporting Apple Final Cut Pro and Adobe Premiere in radio and television industry application storage equipment to build IT infrastructure, in order to meet the cooperation of multiple people, it is often necessary to deploy an additional database server with a dedicated

  2022-06-01 11:44:18 Views: 266
• 

  MySQL locks in RC and RR modes

  InnoDB locking mechanism: the database is used to support better concurrency and provide data integrity and consistency. InnoDB is a storage engine that supports locks. The types of locks are: shared lock (S), exclusive lock (X), intended shared lock (IS), intentional exclusive lock (IX). For

  2022-06-01 11:44:18 Views: 239
• 

  Rapid emergency solution to major accidents in online Mysql

  As many companies do not have their own DBA staff to save costs, most of them are developers or operation and maintenance personnel to operate the database, but the database is the top priority. After the company reaches a certain scale, the database has an accidental accident, which is likely to make the company return to the pre-liberation period. So when the company is small,

  2022-06-01 11:44:17 Views: 257
• 

  Mysql basic character function

  # View the current character set SHOW VARIABLES LIKE'% char%';# one-line function USE myemployees;# character function SELECT LENGTH ('') # get the number of parameter bytes SELECT C

  2022-06-01 11:44:17 Views: 249
• 

  The system reports an error at work: what if the database connection fails?

  Select count (*) from vicious processpower-query current database connections show parameter processes;-- query the maximum number of connections set by the database if the current number of connections is full, then fix it

  2022-06-01 11:44:10 Views: 258
• 

  Redis of NoSQL (persistence strategy)

  Introduction to 1.rdb mode (1): by default, redis persists data to disk through snapshots. (2) conditions for persistence: one write in 900 seconds, or 10 writes in 300 seconds, or 10000 writes in 60 seconds. (3) persistent storage directory dbf

  2022-06-01 11:44:10 Views: 246
• 

  Implementation of Oracle incomplete recovery on different machines

  1. Transfer the database full backup set and archive log backup set to the Oracle server performing the recovery # to the transit server scp-P 2222 database.20181030.5* 218.17.56.50:/tmp/bac

  2022-06-01 11:44:10 Views: 216
• 

  Oracle views the information of the table

  View basic information such as the creation time of the table select * from user_objects owhere o.objectfully typewritten tables' AND o.object_name LIKE 'user name%' O

  2022-06-01 11:44:10 Views: 257
• 

  The leftmost prefix principle of MySQL index leads to system paralysis.

  Around 09:30 in the morning, the business staff reported that their pages opened slowly, and the subsequent pages appeared at 502. Then I received an alarm. I logged in to the database server (4-core cpu) to check cpu 400% load 30 or so. I went into the database and found that there were a lot of slow queries.

  2022-06-01 11:44:06 Views: 226
• 

  On the Optimization of text and blob types of InnoDB Storage engine

  When we optimize the database, we see that some tables use text or blob fields in their design. If the storage space of a single table reaches nearly 100 gigabytes or tens of gigabytes, it is very difficult to change and optimize this situation. 1. In order to understand the impact of large fields on performance, we need to

  2022-06-01 11:44:00 Views: 253