NAV: SLTechnology News&Howtos > Database >

• 

  Innodb_force_recovery forcibly fixes MySQL abnormal shutdown problem

  1. Add the following code to the configuration file my.cnf of mysql: [mysqld] innodb_force_recovery=1 # can set 1-6innodb_purge_thread=0 # if the configuration value above

  2022-06-01 21:13:08 Views: 254
• 

  Oracle11g dataguard complete manual

  Foreword: there are many articles about the configuration of dataguard on the network, but many articles with oracle11g can only be run on 9-10, for example, FAL_CLIENT has been abandoned in 11g, but now the articles on the network do not mark this.

  2022-06-01 21:13:08 Views: 232
• 

  If you miss these four high-quality APP, you will get seven or eight thousand iPhone X for nothing.

  In everyone's mobile phone, there are always a few APP that you can't bear to delete, so what good APP do you have in your phone? The editor will come first to introduce several high-quality APP that Apple users are reluctant to delete. 1. Beautiful scenery listen to pro Beautiful View pro is a cool Chinese voice guide application.

  2022-06-01 21:13:07 Views: 249
• 

  MySQL manual compilation and installation (MySQL5.7 with links to software package resources)

  1. Preface ​ the last article mainly introduces the related concepts of database. As we know, databases are mainly divided into relational databases and non-relational databases, and some mainstream databases are also listed in the last article. So, this time we will introduce the relevant knowledge of MySQL database. data

  2022-06-01 21:12:49 Views: 238
• 

  An option for the pt-online-schema-change tool

  Use pt-online-schema-change to change the length of a field in the data table, and when finished, look at the table structure definition, but there is garbled code. Table structure of data table zzzz. MySQL > show create table zzz

  2022-06-01 21:12:49 Views: 245
• 

  MySQL storage engines MyISAM and InnoDB

  Introduction to the concept of storage engine the data in MySQL is stored in files using a variety of different technologies, each of which uses different storage mechanisms, indexing techniques, locking levels, and ultimately provides different functions and capabilities. These different technologies and supporting functions are called storage engine storage in MySQL.

  2022-06-01 21:12:49 Views: 235
• 

  Oracle11g builds the library manually

  1. Set the environment variable [oracle@HE3~] $vi .bash _ profileexportPATHexportEDITOR=viexportORACLE_SID=orclexportORACLE_BA

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

  Centos6.7 install oracle 12c R1 (1)

  Yesterday, I just received a phone call from a colleague and the leader asked to install and deploy an oracle12c. They didn't even know what c meant. There was no way to install it. Who told us to be technical, that is, to solve technical problems? nonsense. Here are the records of my installation: first, I installed the centos system.

  2022-06-01 21:12:27 Views: 296
• 

  LAMP environment-installation and configuration of a single-tier architecture

  The environment states that the system used to set up the nat translation Lamp environment on the router is Red Hat Enterprise Linux 5.8 x86 translation 64 kernel version 2.6.18-308.el5Lamp provided with the hostname ww

  2022-06-01 21:12:09 Views: 236
• 

  Create user-defined functions in mysql

  There is always some complex logic that we need to use in many places, which shows the importance of the function. Mysql function name parameter list function body return value definition syntax create function fun_name (parameter list) returns return value

  2022-06-01 21:12:09 Views: 231
• 

  Java uses jdbc to connect to database

  Java uses jdbc to connect to the database to prepare to install mysql download mysql-connector-java-5.1.40-bin.jar driver package steps to create a jdbc project to import mysql-connector-java-5.

  2022-06-01 21:12:09 Views: 269
• 

  Memcached, MongoDB, Redis and tokyotyrant

  Mongodb and memcached are not in the same category. Mongodb is a document-based non-relational database, which has the advantage of powerful query function and can store large amounts of data. There is no question of who replaces who in mongodb and memcached, M.

  2022-06-01 21:12:08 Views: 284
• 

  Saltstack (the return value is written to the database)

  1. Target (targeting Minions) 1. Match Minions Id matches all (*) [root@node1 salt] # salt'* 'test.pingnode2.minion:True matches

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

  Mysql conditional query, logical query, fuzzy query, wildcard, escape character

  Unequal wildcards represent null condition query select query list from table name where filter condition; category: filter by conditional expression =,! = filter and or not fuzzy queries like, between a by logical expression

  2022-06-01 21:12:08 Views: 301
• 

  How to be a qualified DBA

  Recently, because of my work, I have come into contact with a lot of friends who want to be a DBA or have been in contact with the database for some time and want to develop in the direction of DBA, but on the whole, I feel that people may not know very much about the work of DBA and how to become a qualified DBA.

  2022-06-01 21:11:52 Views: 279
• 

  Oracle object management

  1. User management 1. Create tablespace create tablespace school # specify tablespace name datafile'/ orc/app/oracle/oradata/school01.dbf'

  2022-06-01 21:11:52 Views: 219
• 

  Several methods of transferring Oracle General Table to Partition Table

  There are four ways to convert a plain table to a partitioned table: 1) Export/import method2) Insert with a subquery method3) Partition exchange method (

  2022-06-01 21:11:37 Views: 273
• 

  The serious occupation of memory by mongodb and its solution

  When I first started using mongodb, I didn't pay much attention to the memory use of mongodb, but through checking the data, I found that mongodb takes up a huge amount of memory. In the local test server, the 8G memory is actually occupied 45%. Sweat. In this article, we will analyze mongo.

  2022-06-01 21:11:37 Views: 213
• 

  Use Navicat to regularly back up mysql databases and create reports and send mail automatically

  Nowadays, with the rapid development of modern computers, database backup is becoming more and more important. Programmers often ignore backup data because they do not pay attention to it, resulting in data loss and very serious consequences. There is no doubt that regular backup is the best way to solve the backup. This paper mainly uses Navicat to automatically back up the database and

  2022-06-01 21:11:37 Views: 256
• 

  MongoDB to view the current operation db.currentOp ()

  MongoDB looks at the document where the current operation db.currentOp () defines db.currentOp () to return information about the operations that are running on the database instance. The db.currentOp () method has the following format: db.currentOp ()

  2022-06-01 21:11:37 Views: 234