NAV: SLTechnology News&Howtos > Database >

• 

  PHP programmer's learning route

  The first stage: basic stage (basic PHP programmer) focus on: proficient in LNMP (core is the basic operation of installation and configuration) goal: to be able to complete basic LNMP system installation, simple configuration and maintenance; to be able to do basic simple system PHP development; to be able to support some in a PHP medium-sized system

  2022-06-01 14:02:33 Views: 275
• 

  Modify the password of the user (root) of MySQL under Linux

  Modify the password of the MySQL user (root) under Linux 1 has the root password method of the old MySQL-outside the mysql system, use mysqladmin# mysqladmin-u root-p password

  2022-06-01 14:02:32 Views: 229
• 

  Deployment in production environment: zabbix3.2.1 (ubuntu system)

  Configure the role IP hostname virtual IPZabbixserver master node 10.36.1.55Compute5110.36.1.101Zabbixserver slave node 10.36.1.56Compute52mysql

  2022-06-01 14:02:32 Views: 234
• 

  Common additions, deletions, modifications and queries in sql

  Operation data (DML) 2.1insert data (add) insert statement: insert only one row at a time. INSERT INTO table_name (column1,column2,column3...) VALUES (valu

  2022-06-01 14:02:32 Views: 270
• 

  MySQL Master-Slave replication (2)

  Master-slave architecture: the slave node does not accept w operations, otherwise it may lead to data inconsistency. First, the problems that should be paid attention to in the replication architecture: 1. Limit slave to read-only mode can be set in the startup parameters. > show global variables lik

  2022-06-01 14:02:31 Views: 229
• 

  Sql Optimization of Oracle to improve performance

  1. In order to optimize the query, we should avoid full table scanning as far as possible, and we should first consider establishing indexes on the columns involved in where and order by. two。 Try to avoid judging the null value of a field in the where clause, otherwise it will cause the engine to give up using the index

  2022-06-01 14:02:31 Views: 299
• 

  Centos 6.5Source Code Compiler installs Mysql 5.7.13

  Install the software dependency package yum-y install gcc gcc-c++ ncurses ncurses-devel cmake download package cd / usr/local/srcwget https://down

  2022-06-01 14:02:26 Views: 269
• 

  Retrieve information from a data table

  The contents of this chapter include: using select statements to retrieve information from one or more database tables using arithmetic expressions to calculate using WHERE clauses to filter rows retrieved from tables to sort rows retrieved from tables, single table query data SELECT statements are used to retrieve information from database tables.

  2022-06-01 14:02:26 Views: 207
• 

  Import and export of mysql

  The MySQL command line exports database 1 and goes to the bin folder under the MySQL directory: the directory to the bin folder in cd MySQL is like the command line I entered: cd C:\ Program Files\ MySQL\ MySQL Server

  2022-06-01 14:02:23 Views: 270
• 

  Mysql Advanced (3) MHA High availability Cluster

  Introduction: 1. MHA is currently a relatively mature solution in terms of high availability of MySQL, which is the highly available software for failover and master-slave promotion under the high availability environment of MySQL. 2. MHA can complete the failover in a short time and ensure the consistency of data to the maximum extent to achieve true.

  2022-06-01 14:02:22 Views: 263
• 

  Update MongoDB 2.6 to 3.0 via Yum

  Update MongoDB 2.6 to 3.0 through Yum due to the previous use of MongoDB 2.6 installed by yum (according to the official website, if you are going to upgrade from 2.4, you need to upgrade to version 2.6 before upgrading to 3.0), in order to use

  2022-06-01 14:02:16 Views: 216
• 

  SaltStack-job management

  1. The execution result of salt is returned to Master1 and job cache storage location # Directory to store job and cache data:# This directory may co by default.

  2022-06-01 14:02:16 Views: 276
• 

  How to install navicat112_premium_cs_x64 in Ubuntu and solve the problem of garbled code

  First, go to the official website to download the navicat112_premium_cs_x64 for linux version 2. Extract the installation package with tar. 3. Decompress the navicat and then go directly to the decompressed directory, and then run start_navi with'. /'.

  2022-06-01 14:02:16 Views: 246
• 

  Oracle11g and Oracle12c rman clone database

  1. Oracle12c rman cloning step 1, generation environment information query 1) instance status information 2) data file information 3) log file information 4) parameter file information 2) test environment preparation: 0) database software installation and configuration 1) pfile parameter file 2) password file

  2022-06-01 14:02:16 Views: 302
• 

  Installation and simple management of mysql database (redhat linux7 system)

  Learn to master the basic myslq database Linux basic use master LINUX system common services use + database management: set up database server management database server +

  2022-06-01 14:02:15 Views: 260
• 

  ORACLE-RMAN: backup script (full library, increment)

  1. Full library backup: # script:BackupFull.sh# creater:yangyuefei# date:2014/5/14# desc:backup full database datafil

  2022-06-01 14:02:15 Views: 238
• 

  MySQL statement Analysis and sql process View

  Configure it in the my.cnf file: slow_query_log=1slow_query_log_file=mysql.slowlong_query_time=10 can record more than the default 10s execution time

  2022-06-01 14:02:15 Views: 249
• 

  The files created by each user can be modified and viewed by each user, but only roo

  Knowledge storage: special permissions: SUID: when running a program, the owner of the corresponding process is the owner of the program file itself, not the initiator; (it is often used for ordinary users to have administrator privileges to execute certain commands, which is very dangerous) chmod Utility FILEchmod UMAR FI

  2022-06-01 14:02:15 Views: 276
• 

  forty-one。 Deploy the LNMP platform source code

  Source code deployment LNMPv environment requirements: turn off the firewall, set a static IP address, deploy the YUM library # systemctl stop firewalld # close the firewalld firewall # systemctl disable fi

  2022-06-01 14:02:14 Views: 255
• 

  Implementation of GUI Automation Framework based on Python+selenium+unittest

  Framework design illustration: preparation before the implementation of the framework: installation under Windows with 1.Python version 2.7.11. two。 The latest version of selenium under the command line (the editor uses version 2.53.0, which is compatible with the latest Firefox, IE, chrome

  2022-06-01 14:02:11 Views: 256