Eight Common Misuses of MySQL

Preface MySQL maintained a strong database popularity growth trend in 2016. More and more customers are building their applications on MySQL databases, even migrating from Oracle to MySQL. But there are also some cases that some customers encounter in the process of using MySQL database, such as slow response time, full CPU and so on. Aliyu ...

Posted on Fri, 23 Aug 2019 23:41:59 -0700 by vlince

Online Music Player

Online Music Player Online Music Player mysql Database Creation Statement Online music player oracle database creation statement SQL Server database creation statement for online music player Online music player mysql database version s ...

Posted on Thu, 22 Aug 2019 20:28:11 -0700 by rdawson

Online Video Playing Website

Online Video Playing Website mysql Database Creation Statement for Online Video Player Website oracle Database Creation Statement for Online Video Player Website SQL Server database creation statement for online video playback website O ...

Posted on Thu, 22 Aug 2019 04:27:12 -0700 by Sakujou

Initial level Oracle 12C database migration to Oracle 18C and some basic data query methods

The good news is that the assessment project has been completed independently, but it has exceeded the scheduled date. I don't know what the final evaluation will be. My heart is still a little cold! However, in the future, I will not simply take the needs of the company as my own needs to develop, but will follow the trend to learn useful know ...

Posted on Mon, 29 Jul 2019 04:50:28 -0700 by gilbertwang

Two interfaces of mybatis-plus and their introduction

 1. IService package com.baomidou.mybatisplus.service; import java.io.Serializable; import java.util.Collection; import java.util.List; import java.util.Map; import com.baomidou.mybatisplus.mapper.Wrapper; import com.baomidou.mybatisplus.plugins.Page; /**  * <p>  * Top-level Service  * &lt ...

Posted on Wed, 24 Jul 2019 22:35:40 -0700 by Chronos

SQL Index Manager - Free GUI Tool for Index Maintenance on SQL Server and Azure

I have worked as a SQL Server DBA for more than eight years to manage and optimize server performance. In my spare time, I want to do something useful for the universe and my colleagues. This is how we ultimately provide free index maintenance tools for SQL Server and Azure. Idea Every once in a wh ...

Posted on Sat, 20 Jul 2019 07:02:36 -0700 by jshowe

Introduction of quasi-real-time synchronization between Oracle and Hadoop cluster based on OGG

The structured data stored in Oracle is exported to Hadoop system for offline computing, which is a common data processing method. Recent scenarios need to do real-time import of Oracle to Hadoop system. Here is a case to introduce. As a commercial database solution, Oracle is difficult to acquire database transaction log spontaneously. Therefo ...

Posted on Wed, 17 Jul 2019 12:29:17 -0700 by ChaosXero

Oracle 12c Reading Notes (2): Oracle Database Architecture

  Analysis in 11g Database instances include: SGA and a series of background management, monitoring abbreviations The database contains three files: data file, control file, redo log file Database instances and databases are the core parts of Orale's database system   Oracle Server and Instance Example: consists of some in-memory and backgroun ...

Posted on Wed, 17 Jul 2019 10:30:23 -0700 by Jack_Slocum

Question Record of redis in ELK

At present, redis used in ELK often have some problems, such as: Connections in redis exceed the limit. For example, 10.120.31.142 uses redis-cli to enter the operation when the number of connections exceeds the threshold. The default setting is 10000, set in the redis.conf file in the redis directory, with the parameter named maxclients. ERR ...

Posted on Tue, 09 Jul 2019 14:43:18 -0700 by musicdirector

oracle environment configuration and basic operations

I. Configuring System Environment 1. View and install base packages [root@localhost ~]# rpm -qa |grep make make-3.81-3.el5 automake16-1.6.3-8.el5.1 automake-1.9.6-2.3.el5 automake17-1.7.9-7.el5.2 imake-1.0.2-3 automake15-1.5-16.el5.2 automake14-1.4p6-13.el5.1 Installation of other base packages yum -y install make, glibc, libaio,compat-l ...

Posted on Mon, 08 Jul 2019 11:43:24 -0700 by ibelimb