NAV: SLTechnology News&Howtos > Database >

• 

  Look at the essential skills of engineers-Technical Life Series No. 51-the story of me and the data center

  In the twinkling of an eye, time has come to June, and the series of articles on technical life have not been updated for half a year. In the past six months, the authors of our series of articles on technical life have been working hard on the front line of work, and do not forget to accumulate and summarize at the same time. Provide more profound details for our articles; now, the Department of Technical Life

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

  Centos6.5 source code installation zabbix3.0.8

  1. Install PHP and expansion package rpm-Uvh http://mirror.webtatic.com/yum/el6/latest.rpmyum-y install php56w php56w-gd php

  2022-06-01 07:20:09 Views: 286
• 

  A sql Optimization problem of MYSQL Ali

  The level of originality is limited, if there is any mistake, please point out that after studying innodb things today, my colleague Tian Xingchun told me that there was an optimization question sent by Ali, and gave me the table and sentence, and told me that there was an implicit transformation in the sentence. Someone in the group also said this problem yesterday, but never had time to read it.

  2022-06-01 07:20:07 Views: 242
• 

  INNODB page node data storage mode, data link, deletion chain learning and experimental summary

  Previous article: about MYSQL INNODB index page header Learning and Experimental Summary http://blog.itpub.net/7728585/viewspace-2063921/ about INNODB S

  2022-06-01 07:20:06 Views: 280
• 

  Why can Apache Flink become the new generation of big data computing engine?

  As we all know, Apache Flink (hereinafter referred to as Flink) was first born in Europe and was donated to the Apache Foundation by its founding team in 2014. Like other early projects, it's fresh, it's open source, and it adapts to the speed that is more important in a fast-changing world.

  2022-06-01 07:20:06 Views: 227
• 

  Setting of root password after installing MySQL under Linux

  Method 1: the easiest way is to install MySQL, according to the method prompted by the system, use mysqladmin to complete. Shell > mysqladmin-u root password "newpwd" shell > m

  2022-06-01 07:20:05 Views: 270
• 

  Mysql database backup and recovery script

  #! / bin/bash#mysql database backup and restore the script# define config variablehost=localhostuser=r

  2022-06-01 07:20:05 Views: 295
• 

  Let's listen to the father of AWR interpret the AWR report.

  AWR report is an important reference for database performance evaluation and optimization. It shows the quantified form of database problems and brings a lot of convenience to DBA. However, there is a lot of content in AWR. How to interpret the AWR report in the best way and find out the performance problems of the database most efficiently?

  2022-06-01 07:19:47 Views: 206
• 

  [Mysql] into outfile error reporting problem

  Error mysql > select * from server into outfile'/ tmp/tt.txt';ERROR 1045 (28000): Access den when you have select permission

  2022-06-01 07:19:46 Views: 282
• 

  Oracle_ transaction control statement

  A transaction is a logical unit of database operation, which can contain one or more DML (data manipulation language), DDL (data definition language) and DCL (data Control language) statements in a transaction, which form a logical whole. The execution of a transaction has only two results: either all

  2022-06-01 07:19:46 Views: 295
• 

  Failed to start MySQL

  1. Error log: [mysql@host-172-24-115,217,217] $service mysql restartShutting down MySQL.. SUCCESS!Starting My

  2022-06-01 07:19:46 Views: 255
• 

  Error while restoring from 32-bit database to 64bit database open

  RMAN > alter database open resetlogs; database openedRMAN-06900: WARNING: unable to generate V$RMAN_S

  2022-06-01 07:19:46 Views: 233
• 

  Creative Convert for Mac (File format conversion tool) v1.3.3

  Creative Convert for Mac is a file format conversion tool used on Mac, which can convert PDF, AI, psD and / or Eps files to a separate graphics file format without requiring a PDF reader or image editor to save each page.

  2022-06-01 07:19:43 Views: 250
• 

  Virtual machine centos installation mysql encountered Couldn't resolve host 'mirror

  I looked it up on the Internet and said it was a DNS server error. So modify / etc/resolv.conf to add a nameserver 8.8.8.8 to complete the installation of MySql server:1. Download and install yum install-y

  2022-06-01 07:19:42 Views: 257
• 

  Under RAC, alter system kill session reports an error ORA-00030: User session ID does not exist

  In the RAC environment, the KILL SESSION Times is wrong about ORA-00030 User session ID does not exist. Problem reproduction: NODE2: [oracle@node2 ~] $sqlplus

  2022-06-01 07:19:42 Views: 229
• 

  Online redefinition of Online Redefinition (2)-- A case of single table complexity

  In the previous blog post (Online Redefinition online redefinition (1)), we briefly introduced the Oracle online redefinition feature to change the online structure of the data table. This blog post will demonstrate a more complex case, which is reproduced online in the complex changes of the case.

  2022-06-01 07:19:42 Views: 216
• 

  Main architecture of Oracle 11G RAC GRID

  CRSD (Cluster ready service daemon) Management High level (Application) Resources OCROHASD (Oracle high availability daemon) Management low level Resources Startup requirements

  2022-06-01 07:19:41 Views: 293
• 

  SQLSERVER backup BCP command description

  There are four actions to choose from in bcp. (1) Import. This action is done using the in command, followed by the name of the file to be imported. (2) Export. This is done using the out command, followed by the name of the file to be exported. (3) use SQL statement to export. This action uses Q

  2022-06-01 07:19:41 Views: 227
• 

  Modern natural hand-painted font Smithrose

  Inspired by single-line signature letters, Smithrose is a natural and modern handwritten signature font. Smithrose has 85 hyphens and a slash at the end. Suitable for logo and text, wall decoration, nursery, graphic design, activities, promotions, invitations, banners, stickers, cards

  2022-06-01 07:19:35 Views: 215
• 

  GBASE Nanjing University General Database completes compatibility Mutual Certification 7 double hits

  In July 2020, the GBase 8s V8.8 product of NTU General Security Database Management system completed the mutual certification of product compatibility with a number of manufacturers. This product has a fully intellectual property, mature and stable, 100 TB financial grade domestic security database. GBase 8s V8.8

  2022-06-01 07:19:32 Views: 223