NAV: SLTechnology News&Howtos > Database >

• 

  Redmine deployment and installation manual under Centos system environment

  1 install mysql, download mysql-5.0.51b.tar.gz to the directory / home/oemplat/, create a new directory after mysql installation / home/oemplat/mysql/, extract the files and install the configuration command as follows: cd

  2022-06-01 15:20:47 Views: 248
• 

  On the principle of message queue

  You must be familiar with the scene of what is a message queue: after Xiao Wang went to M to order, the waiter gave him a number plate and asked him to wait in front of the counter table to pick up the meal. Everyone queued up to call the number in the order of the number they paid for. No matter how many people in the shop, it will not appear disorderly. On

  2022-06-01 15:20:38 Views: 286
• 

  SQL Server Note 1

  Database engine is the core service provided by SQL Server, which allows users to store, retrieve, process and protect data. Database engine service enables users to build high-performance online transaction processing applications and support online analytical processing. Storage engine is SQL Server

  2022-06-01 15:20:20 Views: 226
• 

  (pressure sharing) (MYSQL) Database one-write-many-read experiment

  For the master-slave configuration of four virtual machines, please query the MYSQL read-write separation reference documentation before it. I won't repeat it here. Detailed description of amoeba configuration file writing: in the course of the experiment, in order to test the internal operation of the service, shut down the slave server, and then turn on slave.

  2022-06-01 15:20:20 Views: 278
• 

  Mariadb database

  # # configuring Network vim/etc/sysconfig/network-scripts/ifcfg-eth0 Writing Network configuration File systemctl restart network restart Network # # configuring yum Source vim

  2022-06-01 15:19:50 Views: 282
• 

  Redis Learning 1 Murray-single Node installation configuration

  1. Install the basic package yum install gcc gcc-c++-y2, compile and install redismkdir-p / data/usr/srctar-zxf redis-4.0.11.tar.gz-C / d

  2022-06-01 15:19:49 Views: 249
• 

  Mysql common commands

  Check innodb's transaction table INNODB_TRX to see if there is a transaction thread SELECT * FROM information_schema.INNODB_TRX; that is locking if ID exists in show full proce

  2022-06-01 15:19:49 Views: 269
• 

  How mha- works

  The working principle of mha 1. Check phase < 1 >. Maser goway < 2 > detected. Multi-route detection < 3 >. Repeat 4 times (this number is fixed and cannot be modified) < 4 >. Check whether ssh is normal or not < 5 >. Check the configuration (mainly detect which machines are in the cluster

  2022-06-01 15:19:34 Views: 271
• 

  Install sqldeveloper connection oracle

  Install sqldeveloper connection oracle---- (this installation method has been carried out in windoxs32bit) uploaded http://down.51cto.com/data/2213695 installation sqldevel

  2022-06-01 15:19:23 Views: 247
• 

  Database operation of flask learning

  Database operation using sqlalchemy module installation (need to install MySQL-python/python-devel) pip install flask-sqlalchemy directory structure ├── app │ ├── _ _

  2022-06-01 15:19:22 Views: 296
• 

  Centos 6.5-Log system Rsyslog

  Centos 6.5. interpretation of the related concepts of the Rsyslog log of the log system: log the historical events that occur according to the time series: the time of occurrence of the event, the level of the log such as the content of the event: the criticality of the occurrence of the event in the Linux system

  2022-06-01 15:18:52 Views: 276
• 

  SQL Server database mirroring key performance counters

  SQL Server database mirroring key performance counters basically monitor database mirroring in the following five ways: 1. Configure database mirroring monitor and set alarm threshold. two。 Configure WMI EVENT ALERT to configure actions or alarms after the image status is modified. 3.

  2022-06-01 15:18:52 Views: 212
• 

  Mysql master-slave delay setting

  Mysql Master / Slave delay setting Mysql (version 5.6 or above) delayed replication configuration is achieved by setting the MASTER TO MASTER_DELAY parameter on Slave: CHANGE MASTER TO MASTER_DELA

  2022-06-01 15:18:52 Views: 270
• 

  Implementation process of adding memory to database server

  1.1 the operating system is Red Hat 6.6 Enterprise Edition, and Oracle 11.2.0.4 version RAC is installed and deployed. Due to performance problems, it is necessary to add the physical memory of the PC server, and then adjust the database memory parameters to improve the performance of the database. The following is done for the test environment

  2022-06-01 15:18:51 Views: 270
• 

  Oracle learning route for beginners

  Initial stage: you can start with OCP textbooks, as well as Administrator's Guide, Concepts, Performance Tuning Guide, Backup and Recovery Ad in the documentation.

  2022-06-01 15:18:51 Views: 264
• 

  What are the new features of EntityFramework Core 1.1?

  In the preface, EntityFramework Core is used in the project. We will find problems and test them in time. In private, we will use our leisure time to learn other features that we have never encountered or used before. In this section, we will talk about EntityFramework Co.

  2022-06-01 15:18:34 Views: 303
• 

  Differences between mysql database engine MyISAM and InnoDB

  1. Storage structure MyISAM: each MyISAM is stored as three files on disk. The name of the first file starts with the name of the table, and the extension indicates the file type. The .frm file stores the table definition. The data file has the extension .MYD (MYData). Of the index file

  2022-06-01 15:18:34 Views: 213
• 

  PGA_AGGREGATE_LIMIT of 12c new features

  11g [root@roidb1] # su-oracle$sqlplus / as sysdbaSQL*Plus: Release 11.2.0.4.0 Production on Wed De

  2022-06-01 15:18:28 Views: 213
• 

  Sqlite_fdw usage

  Postgresql provides the function of foreign key table. The only regret of sqlite_fdw is that it can only be select. I hope it can be updated on github as soon as possible. Now I will introduce how to use sqlite_fdw! 1. Download sqlite_fdw

  2022-06-01 15:18:28 Views: 273
• 

  Redis cannot connect externally

  Environment: redis server IP:192.168.84.130Redis Desktop Manager client installed in 192.168.84.100 problem description: after deploying and installing redis, it is found that you can only use 12 locally

  2022-06-01 15:18:28 Views: 251