Compile and install MySQL in Linux
I have been studying Mysql recently. of course, I have to install it on the machine first. Record the operation and deepen the memory for future reference.
Preparations:
Linux: Redhat Linux 6.4
Mysql version
MySQLWorkbench6.1.6GAhasbeenreleased May 16,201 4-pm by MySQL Release Team
The MySQL developer tools team announces 6.1.6 as our GA releaseMySQL Workbench 6.1.
MySQL Workbench 6.1.6 is a maintenance release and contains over 30Fixes and minor
Reading 1: I personally prefer to watch news and information, such as huxiu, 36kr, and sports news of science and technology, which is also useful for related apps, toutiao.com is doing a good job. many people around it are using it. However, after
MySQL uses a plug-in storage engine.
The storage engines include MyISAM, Innodb, NDB Cluster, Maria, Falcon, Memory, Archive, Merge, and Federated.
The most widely used storage engines are MyISAM and Innodb, so I will give a brief introduction to
Log table design example analysis
In the final analysis, there are two aspects to the design of a relational table.
First, it is designed completely according to the paradigm Theory. generally, it is enough to reach the third paradigm, or you can
Mysql stored procedure application
MySQL
Create a stored procedure
(1). Format
Format of MySQL stored PROCEDURE creation: create procedure process name ([process parameter [,...])[Features...] process body
Here is an example:
Mysql> DELIMITER //
Limits % forwrite-boundloads During limit L's Percona Live MySQL Conference and Expo 2014, I attended atalkon MySQL 5.7 performance an scalability given by Dimitri Kravtchuk, the Oracle MySQL benchmark specialist. he mentioned at some point that the
MySQL startup error solution: the latest MySQL 5.6 startup error is installed on RedHatLinux due to the project's need:
[Root @ tserver mysql] #/etc/init. d/mysql startStarting MySQL. The server quit without updating PID file
Basic mysql operations, SQL skills, and common SQL optimization
I. common operations
1. copy the table structure create table t2 like t1Copy table data insert into t2 select * from t1
2. mysql index
Alter table is used to create a common index,
MySQL's GroupBy group has been widely used in Oracle for a long time.
MySQL grouping is always a bit strange.
The experiment is as follows:
Create table sod_artist_category_relation (
Songid int,
CategoryID int
);
Insert into sod_artist_
Using Journalfilesystem and Doublewritebuffer to improve InnoDB plugin performance Percona's "How to improve InnoDB performance by 55% for write-bound loads" article discusses Journal filesystem and InnoDB's Double write buffer.
First, let's look
MySQLbug: server-id is automatically set to 1 by default. when my colleague called the Master node yesterday, the slave database reports the following error:
Got fatal error 1236 from master when reading data from binary log: 'misconfigured
Ubuntu14.04LTS installing LNMPNginxPHP5 (PHP-FPM) MySQL lnmp1_tung.pdf
I recently encountered a problem when installing the LNMP one-key installation package in Ubuntu14.04 LTS. The PHP 5 service was not started and I had to use Ubuntu official
FromPerconaServertoMySQLandbacktoPerconaServer: bewareofcrashsafereplicationinfo We're re migrating some of our "vanilla" MySQL 5.5 servers to Percona Server 5.5. one of the major incentives is thecrash-safe replicationfeature, allowing slaves to
MySQLEnterpriseMonitor3.0: viewingQueryAnalyzerfor5.5.xservers. so, the good thing about MEM 3.0 is that it's agentless, I. e. you don't need an agent to use Query Analyzer data and see when performance is at it's worth and pe into the offending SQL'
OurSQLEpisode186: DataatOSCon This week we talk with former co-host Sarah Novotny about Data atOSCon. ear Candy is about SQL Courses, and At the Movies is a two and a half hour tutorial about MySQL Scaling Strategies for Developers.
EventsDB
MariaDB10.0.11OverviewandHighlights MariaDB
MariaDB 10.0.11 was recently released, and is available for download here:
Https://downloads.mariadb.org/mariadb/10.0.11/
This is the second GA release of MariaDB 10.0, and 12th overall release of
The concept of MySQL database learns some knowledge about the database, writes a blog to facilitate sorting and consolidate knowledge. Let's take an example of what a database is. it may not be accurate enough to understand the general meaning. to
Summary 2
Summary 2
1. description: copy a table (only copy structure, source table name: a new table name: B) (Access available)
Method 1: select * into B from a where 1 <> 1
Method 2: select top 0 * into B from
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.
A Free Trial That Lets You Build Big!
Start building with 50+ products and up to 12 months usage for Elastic Compute Service