NAV: SLTechnology News&Howtos > Database >

• 

  Mysql-5.1.72 installation configuration

  System environment a, system Centos 6.5x64-bit [root@mytest] # uname-aLinux mytest 2.6.32-431.el6.x86_64 # 1 SMP Fri Nov

  2022-06-01 10:14:38 Views: 245
• 

  JDBC technology

  A brief introduction to JDBC JDBC,Java Ddatabase Connection,Java database connection. In order to simplify and unify the operation of the database, Sun has defined a set of specifications for Java to operate the database, which is called JDBC. What is driving?

  2022-06-01 10:14:21 Views: 254
• 

  Sql server 2008 or above shrinks transaction logs

  About logging transaction logs in SQL Server are undoubtedly one of the most important parts of SQL Server. Because SQL SERVER uses transaction logs to ensure persistence (Durability) and transaction rollback (Rollback). Thus return part of it.

  2022-06-01 10:14:20 Views: 229
• 

  The difference of variable assignment (SET and SELECT) in T-SQL

  There are two ways to assign values to defined variables in SQL Server, which are SET and SELECT. The following is a comparison of the differences between the two assignment methods: if setselect assigns multiple variables at the same time, it does not support the expression to return more than one value.

  2022-06-01 10:14:20 Views: 279
• 

  Oracle snooping starts

  1: enter su-oracle under root user to switch to oracle user 2: enter: sqlplus / nolog3: enter oracle under oracle user: conn / as sysdba4: stop the database or

  2022-06-01 10:13:50 Views: 209
• 

  Sqlserver 2008 backup and recovery practice

  One content shows that the most important thing in sqlserver database is database backup and restore. When the database is destroyed catastrophically, we need to have the best recovery plan, data recovery and recovery plan. For databases that have completed database backups, you need to organize recovery drills on a regular basis in order to

  2022-06-01 10:13:50 Views: 258
• 

  Db2 v10.5 HADR Rapid deployment Manual

  First, directory preparation mkdir-p / home/db2inst1/db2_backupmkdir-p / home/db2inst1/db2_archivemkdir-p / home/db2inst1/d

  2022-06-01 10:13:50 Views: 287
• 

  Mysql database connection query

  Mysql database connection query connection is the main feature of relational database model. Join query is the most important query in relational database, including inner join, outer join and so on. Multiple table queries can be realized through join operation. When querying data, the join operation is used to query the no stored in multiple tables.

  2022-06-01 10:13:20 Views: 235
• 

  Hot block contention caused by frequently changing table invalid indexes

  There is an alarm of ultra-high number of session connections in the customer number management system, which causes database performance problems and affects the business processing of the whole network. The alarm occurred between 20:00 and 21:00 on November 7. Check the buffer busy waits with the highest waiting time at that time. Query the corresponding wait event

  2022-06-01 10:12:58 Views: 243
• 

  Redis backup and recovery

  Redis backup and recovery 1.redis backup [root@caosm103 redis] # redis-cli-h 192.168.24.129-p 6379 # Connect to server 192.168.24

  2022-06-01 10:12:57 Views: 291
• 

  Centos6.7mini builds rsyslog+loganalyzer (to be continued)

  Rsyslog is the logging software that comes with linux and can also collect syslog logs from local and other devices; loganalyzer is a log viewing system based on the lamp platform. But when I checked after the installation, the refresh of the log content was very slow. I don't know what it is.

  2022-06-01 10:12:48 Views: 251
• 

  Mysql field encryption

  First of all, let's take a look at the data of type blob. The fields of type BLOB are used to store binary data in MySQL. BLOB is a family of types, including: TinyBlob, Blob, MediumBlob, LongBlob.

  2022-06-01 10:12:40 Views: 202
• 

  Backup and restore of MySQL data and data repair

  Why backup    backup in daily production environment can make the data in production recover effectively: hardware failure, software failure, natural disaster, misoperation testing and other data loss scenarios. Backup points should be able to tolerate the maximum amount of data lost and how long it will take to recover the data

  2022-06-01 10:12:36 Views: 301
• 

  Optimization method of plsql statement

  Experience sharing ORACLESQL sentence optimization: choose the most efficient table name order: you should choose the table with the least number of records as the base table! Because the processing order of the Oracle parser is from right to left. When ORACLE processes multiple tables, it is joined by sorting and merging

  2022-06-01 10:12:36 Views: 261
• 

  [uncover the secret] the database interview sunflower treasure book, let you interview once

  You can call me Lao Zhang, screen name superZS! Has been engaged in the database industry for more than 10 years, working in a database service company, and a senior database lecturer, with regard to the more confused database problems encountered during the interview, and students who have just entered the database field, I will give you a detail here.

  2022-06-01 10:12:35 Views: 245
• 

  [MongoDB] transaction

  Transaction Transactions [TOC] translator: data model definition comparison: MySQLMongoDB row document table collection library group replication replication set proper noun translation convention: Chinese original text read consistency readConcern write consistency writeCon

  2022-06-01 10:12:31 Views: 283
• 

  Python of hbase uses thrift to operate hbase data and shell operations

  Frontier: used to use mongodb, but the quantity is large, mongodb seems not so reliable, changed to hbase to support an order of magnitude. HBase is the database of Apache Hadoop, which can provide random, real-time read and write access to large data. HBas

  2022-06-01 10:12:31 Views: 237
• 

  Win7 install mysql-5.7.18

  1. Go to the mysql official website to download mysql5.7.18-win64.zip (the latest version) and decompress it. Https://dev.mysql.com/downloads/windows/installer/5.7.

  2022-06-01 10:12:30 Views: 232
• 

  PosegreSql download and verification

  Source package download: download address: https://www.postgresql.org/ftp/source/ download version 10.3: the version is available in .bz2 and .gz formats. Generally, the smaller .bz2 format is selected after compression.

  2022-06-01 10:12:21 Views: 285
• 

  The listener supports no services The command completed successfully

  The following error message occurred when starting monitoring and the service could not be found. Error message is as follows: [oracle@dg1 admin] $lsnrctl statusLSNRCTL for Linux: Version 11.2.0.1.0-

  2022-06-01 10:12:21 Views: 205