NAV: SLTechnology News&Howtos > Database >

• 

  Mysql master-slave principle

  The principle of replication: A. Two threads are generated from the library, one is the I _ binlog O thread and the other is the SQL thread; the I _ no thread requests the binlog of the main library and writes the resulting binlog log to the relay log (Relay Log) file; the SQL thread reads the SQL

  2022-06-01 21:38:53 Views: 206
• 

  [book Review: Oracle query Optimization rewriting] Chapter 4

  [book Review: Oracle query Optimization rewriting] Chapter 4 BLOG document structure figure 1. 1 introduction to technical enthusiasts, after reading this article, you can master the following skills, you can also learn some other knowledge that you do not know, ~ O (∩ _ ∩) oPCll: the special use of ① check

  2022-06-01 21:38:50 Views: 204
• 

  Implementation of managing rsyslog logs based on MySQL

  Lab summary: this lab host is installed by default with the Centos 6.9host1 host as the remote log client: rsyslog (default installation) and rsyslog-mysqlhost2 host as the log server installation: mysql (default)

  2022-06-01 21:38:44 Views: 238
• 

  How to install database MySQL and MySQL workbench on liunx system

  With the development of the Internet, more and more people have entered the IT industry, so how to install database MySQL and MySQL workbench in the liunx system? You know what? In order to let you know more about SQL database, the editor summarizes the following contents.

  2022-06-01 21:38:37 Views: 299
• 

  Hive failed to create table, drop table failed

  1. Hive failed to create table. Error: CREATE TABLE pokes (foo INT, bar STRING); FAILED: Execution Error, return code 1 from

  2022-06-01 21:38:29 Views: 264
• 

  Summary of Worktile Technical Architecture

  In fact, I should have written this blog a long time ago. I have been saying that I am busy with my work and have no time. In fact, there will always be time squeeze. Maybe it is because I am lazy. From November 2013 until now, I am actually not very good at writing a technical blog, because my language expression ability and literary talent are not very good, and I don't know every time I write a blog.

  2022-06-01 21:38:25 Views: 271
• 

  What should I do when there is a month with invalid ora01843?

  Today, what the editor shares with you is how to deal with the months when ora01843 is invalid. Many people don't know much about it. Today, in order to let you know more about the months when ora01843 is invalid, I summarized the following contents for you. Let's look down together. I'm sure you'll get something.

  2022-06-01 21:38:20 Views: 288
• 

  Introduction to snapshot mode (RDB) in Redis persistence

  Today's editor to share with you is about Redis persistence snapshot way (RDB) introduction, many people do not understand, today editor in order to let you know more about Redis persistence, so to sum up the following content, let's look down. I'm sure you'll get something. Red

  2022-06-01 21:38:03 Views: 296
• 

  Install redis (3.2.9)

  Install redis (3.2.9) 1.redis official website address: https://redis.io/2. Deployment and installation of redis3.2.9 Experimental Environment: centos 6.5wget http://download.red

  2022-06-01 21:38:03 Views: 253
• 

  Introduction to the method of starting and connecting redis

  Today, the editor shares with you the introduction of the method of redis startup and connection, which is not well understood by many people. Today, in order to give you a better understanding of the method of redis startup and connection, I have summarized the following content for you. Let's look down together. I'm sure you'll get something. 1 、 Red

  2022-06-01 21:37:54 Views: 294
• 

  Oracle_071_lesson_p9

  Set operation UNION and UNION ALLUNION: column name, data type should be the same, the result will be automatically sorted by default ASC UNION ALL: the result will not be duplicated, not sorted, and others will use similar to_char (null) like UNION.

  2022-06-01 21:37:51 Views: 295
• 

  Introduction to Oracle DataBase

  1. A brief introduction to Relational databases the basic concepts of relational data (relational database) are very simple and easy to understand. A relational database is a collection of related information that has been organized into a table structure. Each table contains many rows, which are further organized

  2022-06-01 21:37:50 Views: 249
• 

  Oracle:swap performance tuning

  Goal: to solve the problem that a large number of Log writes take up a lot of File Cache, and inadequate content utilization leads to the basic principles of swap: try to use memory and reduce swap. At the same time, flush to external memory as soon as possible and release memory for writing cache as soon as possible. -especially in continuous writing

  2022-06-01 21:37:47 Views: 293
• 

  Oracle10g only exports database tables owned by a user

  Export the database table owned by a user: exp user name / password @ database network name file= storage location\ storage file name. dmp log= storage location\ storage file name. log owner= owner user name import imp user name / password @ data

  2022-06-01 21:37:47 Views: 239
• 

  Database space required for zabbix-- computing

  There are three types of data: historical data (recorded once per second) saved days * data processed per second * 86400 (seconds) * 50Bytes (size of each data) trend data (recorded once per hour) saved days * data processed per hour * 24 (hours) * 128Byt

  2022-06-01 21:37:47 Views: 270
• 

  Using maxscale database middleware to solve read load balancing

  Install: .100 server establish mysql account and authorize: establish routing module account (need to read mysql permission information): .102 server: configure encryption password to configuration file: (according to real cpu core) (configure specific server) (monitoring module configuration) (read and write

  2022-06-01 21:37:25 Views: 298
• 

  Redis actual combat

  Mainly used as a cache function, not as a database and message server to build a single point of server 1: download release package: wget http://download.redis.io/releases/redis-4.0.11.tar.gz

  2022-06-01 21:37:25 Views: 225
• 

  MySQL services start: some services stop automatically when they are not used by other services or programs

  These days, because of the work demand, we need to invite the MySQL out, so the dusty MySQL will be started. But things went against my wishes. Maybe I hadn't visited MySQL for a long time. MySQL ignored me angrily and threw out bursts of error reports. 1. One of them is: Window

  2022-06-01 21:36:57 Views: 258
• 

  Use python to operate mysql database (bulk insert data)

  #! / usr/bin/env python#-*-coding: utf-8-*-import MySQLdb# establish a connection conn = MySQLdb.connect (host='127.0.0.

  2022-06-01 21:36:57 Views: 209
• 

  Mycat realizes MySQL's sub-database and table, read-write separation and master-slave switching.

  Recently, I have mainly invested in the project of Ping an Cloud MySQL DRDS. I am mainly responsible for the configuration of zookeeper module and the writing of background scripts. In order to deepen the understanding of the overall architecture of DRDS, I think it is necessary to manually build Mysql distributed numbers based on Mycat implementation.

  2022-06-01 21:36:55 Views: 202