NAV: SLTechnology News&Howtos > Database >

• 

  Introduction to the use of MySQL rollback tool binlog2sql

  Parameter description: refer to the official website address: https://github.com/danfengcao/binlog2sql downloads the software package directly from the official website, according to the method given on github, although the installation can be successful, but the following life report error, because of this

  2022-06-01 21:54:46 Views: 247
• 

  A small change that leads to data loss

  Preface unwittingly, the story of the technical life series of me and the data center has come to the tenth issue, and Xiao y has met with you again! Earlier, we shared a lot of practical cases of Oracle database failure and optimization, and a friend asked if Xiao y could share some practical cases of data recovery without backup.

  2022-06-01 21:54:46 Views: 206
• 

  Mysql installation Mini record

  Error giving MySQL: install: permissions: chown-R mysql:mysql mysql/:. / mysql.server startStarting MySQL.Logging to'/ home/mysq

  2022-06-01 21:54:45 Views: 277
• 

  Analysis of Oracle OCP Certification examination item Bank 052-1

  QUESTION 1You notice that the performance of the database has degraded because of frequent checkpoin

  2022-06-01 21:54:45 Views: 294
• 

  Hbase java sample

  Maintain tables (create, delete tables) import org.apache.hadoop.conf.Configuration;import org.apache.hadoop.hbase.HB through HBaseAdmin

  2022-06-01 21:54:45 Views: 203
• 

  Linux + pyodbc + freetds + uni

  The operating system is RHEL6.2 installation unixodbc and dependency package yum-y install gcc gcc-c++ unixodbc unixODBC-devel python-devel installation freetd

  2022-06-01 21:54:31 Views: 205
• 

  MYSQL query-aggregate function query

  The most important feature of aggregate function queries is that they find a value based on a set of data. The result value of the aggregate function is calculated only based on the non-NULL value in the selected row, and the null value is ignored. COUNT () function COUNT () function, for any parameter other than "*", returns

  2022-06-01 21:54:31 Views: 218
• 

  Installation of ScyllaDB1.6 under centos7.3

  ScyllaDB installation configuration 1. Description: scylladb supports centos7.2 64-bit and above related information: http://docs.scylladb.com/getting-started/centos_

  2022-06-01 21:54:31 Views: 286
• 

  MongoDB grouping query

  1. View the collection show collections2. Add multiple data db.runoob.insertMany ([{'title':'MongoDB Overview','description':'Mongo]

  2022-06-01 21:54:16 Views: 216
• 

  Some basic skills for creating content of digital signage

  Digital signage, which has the most flexible and customizable way to convey information to customers, has become a more economical and modern alternative to printed signage. Digital signage is popular because it can help them make decisions and make purchases. For businesses, digital signage can be powerful

  2022-06-01 21:54:13 Views: 205
• 

  Java.lang.OutOfMemoryE encountered by HBASE

  To share briefly, the solution to a similar problem has just encountered this problem in the downloading test of xxx users on a certain machine, and even xxx can not be entered, which means that xxx users cannot create more threads (of course, root users do not have this problem) the maximum number of threads that the system can create: (MaxP

  2022-06-01 21:54:12 Views: 244
• 

  MySQL 8.0.19 supports entering incorrect passwords for 3 times and locking accounts.

  MySQL 8.0.19 supports entering incorrect passwords and locking accounts for 3 times. Example: > CREATE USER 'hechunyang'@'localhost' IDENTIFIED BY' 123456' FAILED_

  2022-06-01 21:54:12 Views: 226
• 

  MongoDB uses examples to learn aggregation operations

  The official Mongodb website provides a United States demographic data, downloaded from the following http://media.mongodb.org/zips.json data example: [root@localhost cluster] # head

  2022-06-01 21:54:12 Views: 240
• 

  HBase-1.0.1 Learning Notes (2) use of HBase Shell tool

  In Lu Chunli's work notes, good memory is not as good as bad writing hbase (main): 017create 0 > create'tasking domaining, 'c_domain'0 row (s) in 0.4520 seconds= > Hbase:

  2022-06-01 21:54:09 Views: 208
• 

  An example of using sqlServer variables

  1. Define the variable declare @ startTime varchar (255)-2. Set the variable set @ startTime = convert (VARCHAR (10), dateadd (day,-1,ge)

  2022-06-01 21:54:08 Views: 234
• 

  Brief installation steps of Huawei Gauss

  Groupadd dbgrpuseradd-g dbgrp ommpasswd ommmkdir-p / opt/gaussdb/appmkdir-p / opt/gaussdb/datachown

  2022-06-01 21:54:08 Views: 286
• 

  Abnormal downtime of MongoDB and parameter cacheSizeGB

  Recently, a MongoDB abnormal downtime failure was handled, related to the MongoDB engine parameter cacheSizeGB, which is used to limit the amount of memory used by MongoDB's wiredTiger engine. The following is the troubleshooting process, which can be used as a reference for future problem handling.

  2022-06-01 21:53:51 Views: 211
• 

  Mysql mathematical function

  SELECT ROUND (3.14); # rounding SELECT ROUND (3.1415); # the second parameter is the number of places reserved for decimal places SELECT CEIL (1.2); # the smallest integer SELEC greater than 1.2

  2022-06-01 21:53:50 Views: 293
• 

  Mysql row subquery

  # case: query the employee information with the lowest employee number and the highest salary SELECT * FROM employeesWHERE (employee_id,salary) = (SELECT MIN (employee_id))

  2022-06-01 21:53:50 Views: 265
• 

  MYSQL .ibd file data recovery

  Restore the .ibd file in mysql. 1. Create the same database table structure first. 2. Delete the tablespace ALTER TABLE "+ dbName+" DISCARD TABLESPACE;3, and copy the xxxxx.ibd file to

  2022-06-01 21:53:41 Views: 290