NAV: SLTechnology News&Howtos > Database >

• 

  Analyze the problems and solutions under the concurrency of MySQL

  1. Background for the database system, it has always been the goal of the database system to improve the concurrency under the condition of multi-user concurrency while ensuring the consistency of the data. not only to meet the needs of a large number of concurrent access, but also to ensure the security of data under this condition, in order to meet this goal, most databases use locks

  2022-06-01 02:59:13 Views: 225
• 

  The method of dealing with the problem of full flashback space based on ORA-19815

  The problem of full flashback area is also a common problem. The most important thing is that the flashback setting size and archive are stored in the flashback directory by default. Coincidentally, when we encounter this problem again today, we record the processing steps for reference only to those who encounter such problems. 1. Description of error phenomenon 1) error message Err on the application side

  2022-06-01 02:59:12 Views: 231
• 

  Detailed explanation of the function and usage of MySQL common storage engine

  This paper gives an example to describe the function and usage of MySQL common storage engine. Share with you for your reference, the details are as follows: MySQL storage engine has two main categories: 1. Transaction security table: InnoDB, BDB. two。 Non-transactional security tables: MyISAM, MEMORY,

  2022-06-01 02:59:12 Views: 302
• 

  Perfect solution for MYSQL5.7.24 installation without data directory and my-default.ini and services cannot be started

  Download address of mysql official website: after the new https://dev.mysql.com/downloads/mysql/ installation package is decompressed, there is no data folder and my-default.ini mentioned in the online tutorial, as shown in the following figure.

  2022-06-01 02:59:07 Views: 268
• 

  Linux installs mysql and configures instances of public network access

  Configuration step 1. Check whether to configure DNS if you do not configure DNS refer to the previous configuration DNS configuration related if you do not configure DNS yum command can not find the Linux software library DNS configuration free DNS1=114.114.114.114, you can also

  2022-06-01 02:59:06 Views: 242
• 

  Oracle series: (31) Oracle SQL statement optimization

  (01) choose the most efficient order of table names (written test) ORACLE's parser processes the table names in the FROM clause from right to left. The table written at the end of the FROM clause will be processed first. In the case of multiple tables in the FROM clause, you must select the number of entries.

  2022-06-01 02:59:06 Views: 259
• 

  DotConnect for Oracle getting started Guide (3): creating database objects

  [download the latest version of dotConnect for Oracle] dotConnect for Oracle (formerly known as OraDirect.NET) is based on ADO.NET technology and provides services for applications based on Oracle databases

  2022-06-01 02:59:06 Views: 256
• 

  CentOS 7.3 install Zabbix 3.2.6 record

  1. Install zabbix to prepare for this article using the operating system: CentOS7.3 x64 requires epel source wget https://mirrors.tuna.tsinghua.edu.cn/epel/epel-releas

  2022-06-01 02:59:06 Views: 302
• 

  MySQL slow query log

  Note content: MySQL slow query log Note date: 2017-12-10MySQL log file system composition general query log slow query log like most relational databases, log files are an important part of the MySQL database. There are several different MySQL

  2022-06-01 02:58:59 Views: 262
• 

  Using PL/SQL to export and import data from Oracle database

  This paper gives you an example of how to export and import data from Oracle database using PL/SQL for your reference. The details are as follows. Export data: method 1: tools-> Export user objects-> Export .sql File Note: this way exports table statements and stores

  2022-06-01 02:58:48 Views: 237
• 

  Oracle two tables are associated with batch updating of data from one of the tables

  Method 1 (recommended): UPDATE Table 2 SET Table 2.C = (SELECT B FROM Table 1 WHERE Table 1.A = Table 2.A) WHERE EXISTS (

  2022-06-01 02:58:48 Views: 287
• 

  Redis is suitable for scene summary at eight points.

  What scenarios is redis suitable for? 1. Caching is now a must-kill for almost all medium and large websites. Reasonable use of caching can not only improve the speed of website access, but also greatly reduce the pressure on the database. Redis provides key expiration and flexible key elimination strategies, so

  2022-06-01 02:58:33 Views: 264
• 

  Ali Cloud ECS CVM (linux system) cannot connect remotely after installing mysql (treading pit)

  Yesterday bought a year's Ali cloud server, the system is linux Centos7, full of longing to install a mysql, the following day let me almost doubt life. I don't say much about how to install mysql. Anyway, I installed it three times, and every time I can connect data locally on Ali Cloud.

  2022-06-01 02:58:33 Views: 291
• 

  An example of a method for implementing mysql cascade replication

  The so-called cascading replication is the master server, which synchronizes the data to only one slave server, and then the slave server synchronizes the data to all the back-end slave servers, reducing the write pressure on the master server, and the network IO of replicating the data. First, configure mast

  2022-06-01 02:58:27 Views: 239
• 

  The method of installing and uninstalling Mongodb Database in Centos7

  MongoDB is a database based on distributed file storage. Written in C++ language. Designed to provide scalable high-performance data storage solutions for WEB applications. MongoDB is a product between relational database and non-relational database, which is a function of non-relational database.

  2022-06-01 02:58:27 Views: 245
• 

  Set up ORACLE automatic memory management

  Article reference: ORACLE 11g official document [Managing Memory] Preface: after setting up the database cluster environment before, the maintenance staff on the site did not know when to change to manual memory management, and the parameter setting was unreasonable, which led to the error report of the customer plsql execution, as follows

  2022-06-01 02:58:27 Views: 218
• 

  Mysql startup error (InnoDB: Operating system error number 1

  Mysql startup error (InnoDB: Operating system error number 13) Environment: mysq 5.6.35, centos 7.3.problem description: after development this afternoon, the development library cannot be connected.

  2022-06-01 02:58:27 Views: 299
• 

  Es-sql_jdbc link query using

  Package org.nlpcn.es4sql;import com.alibaba.druid.pool.DruidDataSource;import com.alibaba.druid.pool

  2022-06-01 02:58:24 Views: 207
• 

  Fix Suspended Database steps,and reset mirroring

  -- RemovemirroringALTER DATABASE token SET PARTNER off-- dropdatabase on secondarydrop DATABASE toke

  2022-06-01 02:58:24 Views: 228
• 

  Explanation of the method of optimizing MySQL performance through MySQL slow query

  With the increase of the number of visits, the pressure on the MySQL database becomes greater. Almost most web applications using MySQL architecture will have performance problems on the database. It is very useful to track problematic queries through the mysql slow query log. It can be analyzed that there are resource-consuming applications in the current program.

  2022-06-01 02:58:24 Views: 268