Modify the default storage path of MySQL

Modify the default storage path of MySQL MySQL is a good choice for storing data in Linux. The default storage path of MySQL is/var/lib/mysql. In the past, the database was not very large, with a total size of around 10 Gb, and there was no pressure

View the MySQL show profile (profiling Report)

View the MySQL show profile (profiling Report) The show profil command is provided by MySQL to analyze the resource consumption of statement execution in the current session. It can be used for SQL optimization measurement. 1. Enabling and disabling

Shell batch import MySQL database, batch delete database

Shell batch import MySQL database, batch delete database Due to project collaborative development, my colleague sent an SQL file of the project and opened it in a directory containing hundreds of databases. Each database is used as a separate

How to handle Oracle lock wait

How to handle Oracle lock wait Management of lock wait is a problem that database administrators encounter in their daily work. Generally, large ERP lock wait processes are relatively small, there will be a relatively large number of lock waits for

MySQL InnoDB shared tablespace and independent tablespace

MySQL InnoDB shared tablespace and independent tablespace MySQL is always used to be compared with Oracle databases. When learning the storage structure of MySQL InnoDB, it is inevitable to compare it with Oracle. Oracle Data Storage includes

MySQL slow Query

MySQL slow Query The slow query (slow log) helps us locate specific SQL statements for SQL statement optimization. For example, the slow query log records the SQL statements whose execution time exceeds the given value, locate the problem. Enable

Test and failure of Oracle Materialized View

Test and failure of Oracle Materialized View Description: The Materialized View (Materialized Views) is the query result set. Changes to all original tables and Views will invalidate the Materialized view, recently, I found a problem that

Handling of ORA-39700 with UPGRADE option errors

Handling of ORA-39700 with UPGRADE option errors Scenario: Use rman to recover a database from a different machine, and perform the most critical step. An error is reported when the database is opened. The details are as follows: SQL> startup mount;

Silent Installation of Oracle databases on Oracle Linux 7.0

Silent Installation of Oracle databases on Oracle Linux 7.0 Silent Installation is rarely used, and basically does not require Silent Installation. Xmanager is used to redirect graphics even for text-installed systems. But there is always an

Redis full-Memory Operation

Redis full-Memory Operation In some scenarios, we do not need to use Redis persistence. Instead, we need to use redis's memory database feature to achieve full memory operation and high performance. Redis itself supports persistence. By

Redis data persistence

Redis data persistence In general, there are two persistence solutions: RDB and AOF.The RDB method creates a time point-based snapshot for the dataset at a certain interval.The AOF method records the write operations received by the Server to log

Use Gearman to synchronize data from MySQL to Redis

Use Gearman to synchronize data from MySQL to Redis For data that frequently changes, if you still use the traditional static cache method (Memocached, File System, and so on) to display data, there may be a huge overhead in cache access, but Redis,

Install MySQL 5.6.21 in CentOS 6.5

Install MySQL 5.6.21 in CentOS 6.5Install MySQL MySQL is the most widely used database in Linux. The version installed using the online yum method lags behind several minor versions on the MySQL website. This section tests and installs the new

Compiling and installing Redis in Linux

Compiling and installing Redis in Linux Introduction Redis is a key-value storage system. Similar to Memcached, Memcached supports more storage value types, including string, list, set, and zset) and hash (hash type ). These data types support

Sysobjects table and mssqlsysobjects table in mssql

Sysobjects table and mssqlsysobjects table in mssql The database (constraints, default values, logs, rules, stored procedures, etc.) can be found in the sysobjects table. Column name Data Type Description Name Sysname

InoReader -- webpage cannot be opened, and inoreader cannot.

InoReader -- webpage cannot be opened, and inoreader cannot. Recently, when using InoReader, I found that the webpage could not be opened. The error message is as follows: other webpages can be opened, but this webpage cannot be opened. Such a page

Mssql Job, mssql

Mssql Job, mssql 1. What is a job? A job is a series of specified operations performed by the SQL Server Agent in sequence. A job can execute various types of activities, including running Transact-SQL scripts, command prompt applications,

Navicat shortcut, navicat

Navicat shortcut, navicatHot Keys Mian windows   Keys Action CTRL + G SettingsLocationFolder CTRL + # (# represents0to 9) Open Object Window from Favorites List F6 Console CTRL + H History

Principles and usage of Oracle rownum and oraclerownum

Principles and usage of Oracle rownum and oraclerownumFor each row returned by the query, a number is returned using the rownum pseudo column, indicating the order in which oracle selects rows from the table or adds rows. The first row rownum is 1,

Oracle Performance Optimization Operation 10: decomposing complex queries, replacing variables with constants, and optimizing oracle Performance

Oracle Performance Optimization Operation 10: decomposing complex queries, replacing variables with constants, and optimizing oracle Performance For complex Where condition combinations, Where contains multiple indexed fields, use the IF statement

Total Pages: 1013 1 .... 300 301 302 303 304 .... 1013 Go to: GO

Alibaba Cloud 10 Year Anniversary

With You, We are Shaping a Digital World, 2009-2019

Learn more >

Apsara Conference 2019

The Rise of Data Intelligence, September 25th - 27th, Hangzhou, China

Learn more >

Alibaba Cloud Free Trial

Learn and experience the power of Alibaba Cloud with a free trial worth $300-1200 USD

Learn more >

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.