NAV: SLTechnology News&Howtos > Database >

• 

  Centos6.5@MySQL cracked the password

  Other Linux versions are similar! Modify MySQL login settings vim / etc/my.cnf for example: [mysqld] datadir=/var/lib/mysqlsocket=/var/lib/mysql/mysql

  2022-06-01 07:29:35 Views: 249
• 

  Memcached+magent implements Master-Slave synchronization + keepalived High availability Cluster

  It caches data in memory and

  2022-06-01 07:29:21 Views: 238
• 

  MySQL Monitor graphic visual monitoring tool for R & D personnel

  Brief introduction of MySQL Monitor graphic visual monitoring tools for R & D personnel: at present, the commonly used open source monitoring tools are nagios,zabbix,grafana, but these are for professional DBA, but for business R & D personnel, there is no professional MyS.

  2022-06-01 07:29:16 Views: 272
• 

  Using Amoeba to realize MySQL master-slave replication and read-write separation

  In the actual production environment, if the database is read and written in the same database server, it can not meet the actual needs in terms of security, high availability, high concurrency and so on. Therefore, generally speaking, it is through master-slave replication (Master-Slave).

  2022-06-01 07:29:16 Views: 229
• 

  Instructions for the use of max function in Mysql

  The Max () function in MySQL is used to find the record with the maximum value in the recordset; note: for character data, the maximum value is arranged in the order of the first letter by Abeliz, and the later, the higher the value. Of course, for Chinese characters, they are arranged according to their full pinyin, and if the first character is the same, it is better than

  2022-06-01 07:29:15 Views: 215
• 

  RMAN recovery cases-incomplete recovery error cases

  RMAN recovery case-incomplete recovery error case RMAN recovery case: incomplete recovery due to an error in the previous data file backup, resulting in recovery failure. [oracle@rh7 ~] $rman target / Recovery Manag

  2022-06-01 07:29:15 Views: 243
• 

  Remember a series of errors after changing the sga size

  After recording a series of errors after modifying the sga size, after modifying the sga size of the oracle, a series of errors were encountered. 00844 and 00851 error reports SQL > startup;ORA-00844: Parameter not

  2022-06-01 07:29:15 Views: 230
• 

  Centos7 installs single-node mysql (source package installation)

  1. Check whether the bread is installed. If so, uninstall # rpm-qa | grep mariadb# rpm-qa | grep postfix# rpm-ev postfix-2.10.1-6.el7.x8.

  2022-06-01 07:29:14 Views: 222
• 

  Differences and implementation of sharding, partitioning and replication (mongodb, mysql)

  The difference between slicing and partition: a. Slicing: to solve the problem of insufficient physical disk space (if indexed, you can also optimize the query to achieve the function of partition) b. Partitioning: optimize queries to prevent slow queries caused by too much data in a table. Replication: prevent the loss caused by database crash, guarantee

  2022-06-01 07:29:08 Views: 290
• 

  Slow SQL Optimization caused by Case:MySQL Federated Storage engine

  I didn't encounter this case, but I use the federated storage engine in my production environment, so document it. Before optimization, a SQL partially intercepts the content as follows, and it takes about 268 seconds to get the result: after optimization, you can see m in the execution plan of this SQL.

  2022-06-01 07:29:08 Views: 211
• 

  Install and configure Oracle11G R2 under CentOS6.7 system

  1. Setting up the environment before installing Oracle 11G this experiment is based on Linux (CentOS6.7_64) to build oracle 11g environment. Choosing CentOS to install oracle is not the best choice here, you can choose different Li according to your needs.

  2022-06-01 07:29:04 Views: 283
• 

  Regular sub-database backup of mysql database (local + remote)

  Introduction-Qiu Yuetao's new project is launched, and a full network backup is established today. Now this records the partial backup mode of mysql: full + binlog backup location: local + remote backup time: 0: 00 every day, cut binlog log 1, environment introduction: [root@jm1j-n

  2022-06-01 07:29:01 Views: 241
• 

  Master-slave synchronization configuration of Mongodb database under Linux

  Description: there are two Mongodb database servers that have been installed. Now you need to set one as the master library and the other as the slave database to achieve master-slave synchronization. Operating system: CentOS 7.064-bit MongoDB database version: mongodb-linu

  2022-06-01 07:28:50 Views: 252
• 

  The execution of mysql error injection Learning Note statement

  Learn that the mysql database is injected using error reporting, and sort out some personal study notes, which are limited to personal understanding. Database name-the injection statement gets the database name and (select 1 from (select count (*))

  2022-06-01 07:28:45 Views: 227
• 

  The unique and standard writing method of oracle table connection

  Oracle table join supports standard writing, but there is also a special oracle writing method. These two writing methods may be different in some scenarios. It is recommended to use standard writing method. Here we only introduce the standard syntax of table join and understand the special writing method of oracle. Standard join syntax: select t

  2022-06-01 07:28:45 Views: 255
• 

  MysQl basic data types of 2Python full stack path series

  Defining the types of data fields in the MySQL basic data type MySQL of the Python full stack series is very important for optimizing your database. MySQL supports a variety of types, which can be roughly divided into three categories: numeric types, date and time types, string types, numeric types, sizes, and

  2022-06-01 07:28:41 Views: 230
• 

  A glimpse of InnoDB Online DDL

  The InnoDB Online DDL feature was introduced in MySQL version 5.6 and is based on the version 5.5 Fast Index Creation feature. When the datasheet is changed, the operation is allowed to proceed in place without copying the data, or concurrent D.

  2022-06-01 07:28:33 Views: 245
• 

  Detailed explanation of Redis configuration file (redis.conf) parameters

  Redis configuration file parameter description: 1. Redis does not run as a daemon by default. You can modify it by using this configuration item to enable the daemon daemonize no2. When Redis runs as a daemon, Redis defaults to setting the

  2022-06-01 07:28:33 Views: 230
• 

  The method of accessing data by ORACLE

  This article is a review of oracle's method of accessing table data. In an oracle database, if you want to access the data stored in the database, you have to go through the following steps: SQL to be executed-> parse-> optimizer processing-> generate

  2022-06-01 07:28:33 Views: 266
• 

  Install and deploy PhxSQL tutorials

  . Demand: a software of the company has been deployed in 3 computer rooms using phxsql. Now it is necessary to add a phxsql node in the new computer room. The following is the operation process. Because of privacy protection, 4 IP are 1.1.1.12.2.2.23.3.3.3 and the new ip is 4.4.4.

  2022-06-01 07:28:33 Views: 211