NAV: SLTechnology News&Howtos > Database >

• 

  MySQL, just read this one.

  No.1 database concept what is a database? Database is a kind of special file, which stores needed data internally. RDBMS is a database based on relational model. With the help of mathematical concepts and methods such as set algebra to deal with the data in the database, SQLSQL is

  2022-06-01 14:57:31 Views: 282
• 

  Clean up mysql problems encountered in server space

  Background: the company's production environment server space alarm, more than 80%, emergency inspection found that it is a mysql backup server, there is a large table recording details, occupying about 150G of space. If you find a problem, you have to solve it. Plan to remove this table, create a new empty table, and continue to record. In operation

  2022-06-01 14:57:30 Views: 283
• 

  What is innodb in mysql

  What is innodb in mysql? In view of this problem, this article introduces the corresponding analysis and answers in detail, hoping to help more partners who want to solve this problem to find a more simple and feasible way. About innodb InnoDB, the database engine of MySQL

  2022-06-01 14:57:22 Views: 252
• 

  Hibernate persists the entity using save and then changes the value of the entity

  Public static void addStudent () {sessionFactory=new AnnotationConfiguration () .configure () .bui

  2022-06-01 14:57:22 Views: 207
• 

  Oracle 12c pdb uses expdp/impdp to import and export

  12C introduced pluggable databases, where multiple database pdb exists simultaneously in the form of multi-tenancy in a container cdb. When doing data pump import and export for pdb, it is slightly different from the traditional database. 1. You need to add tansnames2 for pdb and us for import and export.

  2022-06-01 14:57:22 Views: 238
• 

  How does mysql achieve isolation level

  How does mysql achieve the isolation level? In view of this problem, this article introduces the corresponding analysis and answers in detail, hoping to help more partners who want to solve this problem to find a more simple and feasible way. Isolation level transaction specifies an isolation level that defines that a transaction must be identical to the one specified by the

  2022-06-01 14:57:21 Views: 228
• 

  MySQL incremental backup and recovery-- experiment

  1. Create a complete innobackupex-- defaults-file=/etc/my.cnf-- user=root-- password=root-- socket=/home/mysql/3306

  2022-06-01 14:57:16 Views: 259
• 

  Compare HBase, Memcached, MongoDB, Redis and Solr

  NameHBaseMemcachedMongoDBRedisSolrDescriptionWide-column store based on Apache Hadoop and on concept

  2022-06-01 14:57:15 Views: 290
• 

  Source code compilation and installation of LAMP environment

  1. Please describe a complete http request processing process. 2. What are the processing models supported by httpd and which environments are used respectively. 3, the source code compiles and installs the LAMP environment (based on the wordpress program), and writes out the detailed installation, configuration and testing process.

  2022-06-01 14:57:04 Views: 218
• 

  Package Pdksh-5.12 missing

  Package Pdksh-5.12 missing installation environment 1.Redhat6.6 2.Standlone server GI (problem is not limited to standlone) problem description reason explanation 1. Install GI with OUI

  2022-06-01 14:56:57 Views: 301
• 

  MySql table partitioning (based on time datetime)

  Timestamp type partition Please move = > MySql table partition (based on time timestamp) Environment: MySql8.0.18 (unvalidated in 5.6,5.7) the field type of the partition condition is the language of datetime complete sql operation table partition

  2022-06-01 14:56:54 Views: 216
• 

  CentOS6.8 install oracle11gR2

  Before, when I installed oracle under windows, I felt that it went smoothly, but when I installed it on Linux, it appeared a false impression that the installation was successful, but the configuration file, sqlplus, etc., were not successful. O

  2022-06-01 14:56:31 Views: 279
• 

  What is the redis cache avalanche?

  In this issue, the editor will bring you the cache avalanche of redis. The article is rich in content and analyzes and narrates it from a professional point of view. I hope you can get something after reading this article. 1. What is an avalanche cache avalanche refers to a large number of data in the cache to the expiration time, while querying data

  2022-06-01 14:56:28 Views: 261
• 

  Common SQL commands (oracle) for operation and maintenance

  Replication table structure and table data: create table table_name_new as select * from table_name_old replication table structure: create table table_name_n

  2022-06-01 14:56:28 Views: 225
• 

  001. Redis stand-alone installation

  one。 Compile and install # extract redis to / opt tar zxvf redis-3.0.7.tar.gz-C / opt# into the redis directory and compile cd / opt/redis-3.0.7 & & make M

  2022-06-01 14:56:27 Views: 235
• 

  Upgrade from Oracle database 11.2.0.1 to 11.2.0.3

  First download Oracle 11.2.0.3 Patchset http://yunpan.cn/cHgQuIuxUTThS access password 043f and upload Patchset to the server [oracle@localhost

  2022-06-01 14:56:07 Views: 207
• 

  The size of the data file OS block

  In the previous BLOG, I talked about how to calculate the size of the data file, ls-l / 8192-1. In fact, the 8192 here is incorrect, only in general cases. Here is the official document given by MOS. You are welcome to join us on the size of the OS block under each platform.

  2022-06-01 14:56:02 Views: 234
• 

  Oracle12C multi-tenant management

  -- go to cdbsqlplus / nologconn sys/sys as dba-- to view the basic information of the database, select name,cdb from vault database, view the related information of the container, select.

  2022-06-01 14:56:02 Views: 279
• 

  Support "go to O" database evaluation through self-developed database portrait tool

  "going to O" has been a hot topic in recent years, which has given rise to all kinds of doubts, including existing database evaluation, technology selection and so on. Going to O is a systematic project and needs to be fully evaluated. Through self-research tools, this paper generates database portraits to provide first-hand data for de-O evaluation. I hope to give it to you.

  2022-06-01 14:55:49 Views: 249
• 

  Installation Oracle11gR2 RAC--- modifies the online log

  Connect to the database server, query existing online log group information, and add online log groups. Connected to Oracle Database 11g Enterprise Edition Release 11.2.0.4.0C

  2022-06-01 14:55:48 Views: 203