NAV: SLTechnology News&Howtos > Database >

• 

  Index of mysql database

  Day04 MySQL database index 1, index overview: the index is composed of one or more columns in a table, and the purpose of creating the index is to optimize the management of our database tables and improve the speed of our query using database tables. Index 1. Classification of indexes: indexes are divided into several types.

  2022-06-01 12:04:11 Views: 201
• 

  Sqlplus / as sysdba error ORA-010

  There are pits everywhere, but fortunately, there is a certain ability to fill in the pits ~ ~ sqlplus / as sysdba can not log in to the system, it is the wrong user password. If you know the principle, you will know how to deal with it. Solution: use operating system authentication (RHEL6/7) $cd

  2022-06-01 12:04:10 Views: 259
• 

  Oracle 11gR2 RAC Service-Side TAF configuration example

  Service-Side TAFService-Side TAF configuration reference: How To Configure Server Side Transparent Application Failover

  2022-06-01 12:04:10 Views: 231
• 

  MySQL data Management 7

  Deploy mysql highly clustered mysql-mmm + mysql master-slave synchronization environment preparation (four database servers 12 11 10 9) systemctl stop firewalldsetenforce 0 configure YU

  2022-06-01 12:04:10 Views: 223
• 

  Trove makes mysql5.6 Image based on centos7

  This document is to manually create the trove image of mysql5.6, the openstack version is newton1, create a basic virtual machine, log in to openstack to create a virtual machine, this virtual machine is used to create a trove image, and the root disk of the virtual machine will eventually be uploaded to

  2022-06-01 12:04:10 Views: 206
• 

  Build apache and subversion (SVN) under RHEL6.4

  1. Description: build apache+svn2 under rhel6.4 system and implement 1) install and configure SVN service on the server; 2) SVN service supports svnserve independent service mode access; 3) SVN service supports http mode access of Apache. 3 、

  2022-06-01 12:03:57 Views: 206
• 

  Installation parameters of oracle 11hg rac under centos 6.4,

  Cat / etc/security/limits.conf < > / etc/pam.d/loginecho "options hangcheck-timer hangcheck_tick=30 han

  2022-06-01 12:03:54 Views: 272
• 

  The reason and treatment method that oracle ORA-01653 tablespace can't grow automatically

  Background: the table space has been set to grow automatically, but it will still be reported to ORA-01653 when it reaches a certain size. Solution process: access to relevant information, most only give the solution, but this solution has been verified is also temporary, to a certain size will still report an error, and then can only take the same approach again

  2022-06-01 12:03:54 Views: 217
• 

  Comparison of database structure between mysql

  Adapt to the environment: upgrade the product in the project, design to two versions of the database structure and use different tools: Navicat1, prepare two versions of the database 2, open the tool Navicat3, connect to two databases respectively, click "tools-structure synchronization" 5, select two connections in general

  2022-06-01 12:03:54 Views: 273
• 

  Compilation and installation of Percona-XtraDB-Cluster

  Environment: operating system centos7.4,mysql is installed under / data/mysql, mysql belongs to mysql users, pxc-5.7.19 1, download source package: 1.1 download pxc-5.7.19mkdir-p / ho

  2022-06-01 12:03:54 Views: 278
• 

  OPEN RESETLOGS, report to ORA-00392 ORA-00312 in Oracle12c

  [phenomenon] SQL > alter database open resetlogs;alter database open resetlogs*ERROR at line 1:ORA-00392: log

  2022-06-01 12:03:53 Views: 238
• 

  Oracle 11g expdp backup solves the problem that empty tables cannot be backed up

  Previously, exp was used to make oracle backups, but there was a problem with exp on 11g, that is, empty tables could not be exported. Recently, to do oracle data migration, we need to export the empty table together. After searching, we found expdb, so we have this article. This article is for the record only.

  2022-06-01 12:03:53 Views: 207
• 

  MySQL DELETE statement

  MySQL DELETE statement you can use the SQL DELETE FROM command to delete records from the MySQL data table. You can execute this command at the mysql > command prompt or in the PHP script. The syntax below is SQL

  2022-06-01 12:03:53 Views: 250
• 

  [simple guestbook] is implemented with the database added by HTML.

  [simple guestbook] use the database added by HTML to implement WEB guestbook var datatable = null;var db = openDatabase ('Mydata','','My Databa

  2022-06-01 12:03:53 Views: 287
• 

  MongoDB Log switching (Rotate Log Files) Guid

  MongoDB log switching (Rotate Log Files) guidelines MongoDB does not automatically switch rotation logs by default, which will cause the log to grow day by day. Under busy business, the log growth is very large. Such a large log file, check out one day

  2022-06-01 12:03:52 Views: 273
• 

  MySQL Resize System Tablespace

  MySQL version: 5.7.18 main content: what is the other functions of system tablespacesystem tablespace extension system tablespace what is system tablesp

  2022-06-01 12:03:52 Views: 222
• 

  Remarks on oracle History knowledge

  V_sql_time: = lpad (trunc ((v_beg_time-sysdate) * 24 * 60 * 60) / 3600), 2 trunc 0') | |':'| lpad (trunc (

  2022-06-01 12:03:52 Views: 208
• 

  The case of Oracle Study-Oracle Block address (Block Address)

  The case of Oracle Study-- Oracle Block address (Block Address) Oracle access data is based on block. This paper briefly introduces how to get the required b in memory through Block Address.

  2022-06-01 12:03:52 Views: 208
• 

  Mariadb-10.1.22mariadb compilation and installation

  Official download address: https://mirrors.tuna.tsinghua.edu.cn/mariadb//mariadb-10.1.22/source/mariadb-10.1.22.tar.gz1,

  2022-06-01 12:03:51 Views: 233
• 

  Introduction and use of JDBC

  1. Introduction to JDBC    jdbc provides a unified programming interface for java developers to use the database, which consists of a set of java classes and interfaces.    access database process    in the process of connecting, generally speaking, MySQL and java are on the same computer for beginners.

  2022-06-01 12:03:46 Views: 298