NAV: SLTechnology News&Howtos > Database >

• 

  How to use mysql data types and field properties

  This article mainly shows you how to use mysql data types and field properties, the content is easy to understand, I hope you can learn, after learning there will be gains, the following let Xiaobian take you to take a look at it. Data type: the data type of mysql is the class in which the data is stored

  2022-06-01 08:02:48 Views: 243
• 

  LAMP Architecture-(introduction and practice)

  Source code compilation installation LAMP1.Apache website service 2.MySQL service 3.LAMP architecture application example Apache Origin: 1. Originated from A Patchy Server, the famous open source Web service software for 2.1995 years

  2022-06-01 08:02:26 Views: 253
• 

  The usage of three paradigms of Mysql Database Design

  This article mainly explains the use of the three paradigms of Mysql database design, the content is clear, interested friends can learn, I believe it will be helpful after reading. Three paradigm 1NF: fields cannot be divided; 2NF: there is primary key, non-primary key field depends on primary key; 3NF: non-primary key

  2022-06-01 08:02:20 Views: 279
• 

  Oracle tool-csscan

  Reproduced from: http://blog.itpub.net/4227/viewspace-706635/ tool csscan is used to check whether the data in the database will be lost or truncated when it is converted from one character set to another. This job.

  2022-06-01 08:02:20 Views: 286
• 

  How to realize distributed Lock

  This article mainly explains how to achieve distributed lock, the content is clear, interested friends can learn, I believe it will be helpful after reading. There are three ways to realize distributed lock: 1. Implement distributed lock based on database; 2. Implement distribution based on cache (Redis, etc.)

  2022-06-01 08:02:13 Views: 248
• 

  SQL statements commonly used in oracle dataguard

  Select log_mode,open_mode, database_role from vault database;-- View the status of dataguard master / slave database select status from v$ins

  2022-06-01 08:02:13 Views: 276
• 

  SQL server basic statement

  SQL server database basic statement 1. Experimental requirements: 1. Query the information of all the students in the student table select * from student as shown in the figure 2. Query the "name", "class" and "score" columns in the student table.

  2022-06-01 08:01:47 Views: 274
• 

  What prerequisites need to be installed before OpenStack deployment

  Security the following table gives a list of services that require passwords and their relationships in the guide: password password name description database password (no variables can be used) root password ADMIN_PASSadmin user password CEILOMETER_DBPA

  2022-06-01 08:01:43 Views: 213
• 

  Use NID to modify DBID and DBName of database in Oracle12.1 [actual combat]

  After the off-machine recovery is complete, use NID to modify the DBID and DBName of the database and restart the database. The main steps are as follows: 1. Open the database: SQL > startupORA-32004: obsolete or depreca

  2022-06-01 08:01:38 Views: 273
• 

  I have to tell you the principle of MySQL optimization 2.

  If some students finish reading the last article about MySQL, there are two very open questions at the end of the article. If you are interested, you can think about it in your head. This article will also try to answer these two questions, hoping to give you some reference. Now you can think about a question, if the amount of data is very large, you choose according to the business

  2022-06-01 08:01:38 Views: 281
• 

  Real-time view of the number of MySQL connections

  1. View the connection details in real time so that they are dynamic and updated every other second, and the changed values are highlighted. If you don't want to view it again, you can press Ctrl+C to exit 2. Check the connection status in real time, same as above, and update it every second. Okay, this is how MySQL looks at the connection.

  2022-06-01 08:01:38 Views: 260
• 

  Why use database caching

  Memcached usage background: in most Web applications, data is saved to a relational database, where the WWW server reads the data and displays it in the browser. However, with the increase of the amount of data and the concentration of visits, there will be an increased burden of relational data, slow database response and websites.

  2022-06-01 08:01:36 Views: 215
• 

  Mongodb index correlation

  1. Introduction to the index: monggodb's index is also a balanced binary tree, so most of the index optimization techniques in traditional databases are available. Note: mongodb can traverse data in any direction (unlike indexes in relational databases)

  2022-06-01 08:01:06 Views: 292
• 

  Oracle 11g RAC modifies the archive from ASM to local

  1. Environment description AIX platform, Oracle 11g 2-node RAC, archiving using ASM format is also stored under ASM. 2. The purpose of modification is to modify 2-node archiving to the local file system, node 1 archived to / arch2 node 2 archived to / ar

  2022-06-01 08:00:39 Views: 241
• 

  Detailed explanation of the principle of monogdb replication

  Replication introduces that replication is the process of synchronizing data between multiple servers. Replication not only provides redundancy for data, but also improves the availability of data. Because there are multiple data mirrors on different database servers, replication can effectively prevent data loss caused by the failure of a single server. Complex

  2022-06-01 08:00:34 Views: 241
• 

  Understand the execution plan

  Check the method of the execution plan Explain Plan For SQL does not actually execute the SQL statement, the generated plan may not be the real execution plan must have plan_table is a means but not the best SQLPLUS AUTOTRAC

  2022-06-01 08:00:10 Views: 215
• 

  Centos 6 installs Cacti to monitor network traffic

  Centos 6 installation Cacti monitoring network traffic 1, operating system installation, this need not write tutorials (slightly) I personally use CentOS6.5 to minimize the installation of the system after the installation of the firewall and selinux#service iptables

  2022-06-01 08:00:10 Views: 209
• 

  MySql bulk insert and unique Index problem

  The problem of MySQL bulk insertion in the development project, because there are some basic data of the old system that need to be imported in advance, I did a batch import operation during import, but because the size of an acceptable SQL statement in MySQL is limited, I only have 500pieces per batch, but according to

  2022-06-01 08:00:04 Views: 268
• 

  A complete Collection of mysql commands under linux

  Command to start mysql under 1.linux: mysqladmin start/ect/init.d/mysql start (previous installation path for mysql) Command to restart mysql under 2.linux: mysqlad

  2022-06-01 07:59:46 Views: 275
• 

  Advanced MySQL Database (5)-- triggers

  MySQL Database Advanced (5)-trigger 1, trigger introduction 1, trigger introduction trigger is a special stored procedure associated with a table that can trigger execution when inserting, deleting or modifying data in the table, and has more refined and complex data control capabilities than the standard functions of the database itself. 2 、

  2022-06-01 07:59:46 Views: 300