Database Administrator

Commonly used SQLite database statements and SQLite visualization tool on MAC MeasSQLlite SQLite is an open-source embedded relational database. Its compact, concise, and fast features are very easy to use in mobile application data management. I.

WAS _ initiate mbind: Invalid argument, mbindargument **************************************** ******************************** *************************************** Original Works are from the blog of "Deep Blue blog". You are welcome to repost

Pentaho Report Designer getting started tutorial (3), pentahodesigner Pentaho Report Designer getting started tutorial (3) Pentaho Report Designer5.1 is the latest version. I. Installation and introduction This section describes how to install jdk,

Install the Vbox extension package and the Vbox extension package **************************************** ******************************** ************** Original Works are from the blog of "Deep Blue blog". You are welcome to repost them. Please

Specification of memory size in different Oracle versions, different oracle versions  **************************************** ******************************** ************** Original Works are from the blog of "Deep Blue blog". You are welcome to

[Course sharing] This article introduces how to transplant and develop an embedded linux system (Environment setup, uboot porting, and embedded Kernel configuration and compilation), and how to implement uboot. Embedded linux system porting and

Oracle session blocking, oracle sessionSession blocking for a single instance Simulate 232 sessions being blocked by 1224 sessions select * from V$SESSION_BLOCKERS; SID SESS_SERIAL# WAIT_ID WAIT_EVENT WAIT_EVENT_TEXT

Preface Indexes are one of the most important objects in relational databases. They can significantly reduce disk I/O and logical read consumption and improve the query performance of SELECT statements. However, it is a double-edged sword. Improper

When calling the dynamic performance view related to Oracle in a process, package, function, or trigger, you must grant appropriate permissions. Otherwise, you will receive an error message indicating that the table and view do not exist. Even if

When big data talks about this, there are a lot of nonsense and useful words. This is far from the implementation of this step. In our previous blog or previous blog, we talked about our position to transfer data from traditional data mining to the

Tutorial on implementing recursive query in PostgreSQL, postgresql Recursion Introduction I am working on a program in nilint32 (Open Source !) It is used to design and initiate surveys. The following is an example of a survey: Internally, it

(Illustration) mysql client mysqlworkbench in windows connects to the mysql server CentOS on the virtual machine, and the virtual machine installs centos I have installed the mysql server in CentOS Linux and mysql client mysqlworkbench in Windows,

MySQL encoding format. mysql modifies the encoding format. I. Problem Introduction When mysql is installed, the encoding format is configured as UTF-8. Therefore, mysql character_set_client, character_set_connection, character_set_database,

1. First, you must understand what an execution plan is? An execution plan is a query solution made by the database based on the statistics of SQL statements and related tables. This solution is automatically generated by the query optimizer, for

Redis Research (14th)-management tools, redis research toolsTo do well, you must first sharpen your tools. When using Redis, if you can effectively use various Redis management tools, it will greatly facilitate development and management. I.

MongoDB (2)-learn about the installation configuration and mongodb installation Configuration I introduced the general theoretical knowledge of MongoDB. This article will install and use MongoDB on windows and linux. Of course, we will install

[MongoDB] building a Mongo database replica set (similar to a cluster) on the windows platform (III), mongodbmongo I have written two blogs about how to build a Mongo database replica set on windows. Article 1: How to build a Mongo database replica

Mysql-related log summary and mysql Log Summary As an important means of querying problems, log should be recorded as much as possible for you to query some problems. MySQL has the following types of logs:Error log:-log-err Query log:-log Slow query

I. background DB2 joint database is a special form of distributed database management. In the federated database system, you can use an SQL command to send command requests to multiple data sources. Before copying data between DB2 and non-DB2

This article will introduce several major steps for SQL Server Profiler to analyze deadlocks. This is also to help you better manage your databases. In two or more SQL Server processes, a deadlock occurs when each process locks the resources that