技术标签: Linux 运维 MySQL MariaDB mysql 云计算
CentOS 7下mariadb-10.1.22 源码编译安装过程笔记,希望对大家有帮助。
下载文件https://mariadb.com/
或
https://downloads.mariadb.org/mariadb/10.2.11/
下载链接:
https://mirrors.tuna.tsinghua.edu.cn/mariadb//mariadb-10.2.11/source/mariadb-10.2.11.tar.gz
[root@begin mariaDB]# wget https://mirrors.tuna.tsinghua.edu.cn/mariadb//mariadb-10.2.11/source/mariadb-10.2.11.tar.gz
--2018-01-01 23:31:27-- https://mirrors.tuna.tsinghua.edu.cn/mariadb//mariadb-10.2.11/source/mariadb-10.2.11.tar.gz
Resolving mirrors.tuna.tsinghua.edu.cn (mirrors.tuna.tsinghua.edu.cn)... 101.6.6.178, 2402:f000:1:416:101:6:6:178
Connecting to mirrors.tuna.tsinghua.edu.cn (mirrors.tuna.tsinghua.edu.cn)|101.6.6.178|:443... connected.
HTTP request sent, awaiting response... 200 OK
Length: 72772830 (69M) [application/octet-stream]
Saving to: ‘mariadb-10.2.11.tar.gz’
100%[====================================================================================================================>] 72,772,830 22.0MB/s in 3.2s
2018-01-01 23:31:31 (22.0 MB/s) - ‘mariadb-10.2.11.tar.gz’ saved [72772830/72772830]
[root@begin mariaDB]# ll -h
total 70M
-rw-r--r-- 1 root root 70M Nov 27 18:09 mariadb-10.2.11.tar.gz
[root@begin mariaDB]#
[root@begin mariaDB]# tar -xf mariadb-10.2.11.tar.gz
[root@begin mariaDB]# ll
total 71072
drwxrwxr-x 33 mysql mysql 4096 Nov 27 18:09 mariadb-10.2.11
-rw-r--r-- 1 root root 72772830 Nov 27 18:09 mariadb-10.2.11.tar.gz
[root@begin mariaDB]# cd mariadb-10.2.11/
[root@begin mariadb-10.2.11]#
[root@haiyuan mariaDB]# yum grouplist | grep Tools
There is no installed groups file.
Maybe run: yum groups mark convert (see man yum)
Console Internet Tools
Development Tools
Graphical Administration Tools
Security Tools
System Administration Tools
[root@haiyuan mariaDB]# yum groupinstall Development Tools -y
Loaded plugins: fastestmirror
There is no installed groups file.
Maybe run: yum groups mark convert (see man yum)
Loading mirror speeds from cached hostfile
Warning: group Tools does not exist.
Resolving Dependencies
--> Running transaction check
---> Package autoconf.noarch 0:2.69-11.el7 will be installed
--> Processing Dependency: m4 >= 1.4.14 for package: autoconf-2.69-11.el7.noarch
--> Processing Dependency: perl(Data::Dumper) for package: autoconf-2.69-11.el7.noarch
......
Installed:
autoconf.noarch 0:2.69-11.el7 automake.noarch 0:1.13.4-3.el7 bison.x86_64 0:3.0.4-1.el7 byacc.x86_64 0:1.9.20130304-3.el7
cscope.x86_64 0:15.8-10.el7 ctags.x86_64 0:5.8-13.el7 diffstat.x86_64 0:1.57-4.el7 doxygen.x86_64 1:1.8.5-3.el7
flex.x86_64 0:2.5.37-3.el7 gcc-c++.x86_64 0:4.8.5-16.el7_4.1 git.x86_64 0:1.8.3.1-12.el7_4 indent.x86_64 0:2.2.11-13.el7
intltool.noarch 0:0.50.2-7.el7 libtool.x86_64 0:2.4.2-22.el7_3 patchutils.x86_64 0:0.3.3-4.el7 rcs.x86_64 0:5.9.0-5.el7
rpm-sign.x86_64 0:4.11.3-25.el7 subversion.x86_64 0:1.7.14-11.el7_4 swig.x86_64 0:2.0.10-5.el7 systemtap.x86_64 0:3.1-4.el7_4
Dependency Installed:
apr.x86_64 0:1.4.8-3.el7_4.1 apr-util.x86_64 0:1.5.2-6.el7 boost-date-time.x86_64 0:1.53.0-27.el7
dyninst.x86_64 0:9.3.1-1.el7 efivar-libs.x86_64 0:31-4.el7 emacs-filesystem.noarch 1:24.3-20.el7_4
gettext-common-devel.noarch 0:0.19.8.1-2.el7 gettext-devel.x86_64 0:0.19.8.1-2.el7 libdwarf.x86_64 0:20130207-4.el7
libgnome-keyring.x86_64 0:3.12.0-1.el7 libstdc++-devel.x86_64 0:4.8.5-16.el7_4.1 m4.x86_64 0:1.4.16-10.el7
mokutil.x86_64 0:12-1.el7.centos neon.x86_64 0:0.30.0-3.el7 pakchois.x86_64 0:0.4-10.el7
perl-Data-Dumper.x86_64 0:2.145-3.el7 perl-Error.noarch 1:0.17020-2.el7 perl-Git.noarch 0:1.8.3.1-12.el7_4
perl-TermReadKey.x86_64 0:2.30-20.el7 perl-Test-Harness.noarch 0:3.28-3.el7 perl-XML-Parser.x86_64 0:2.41-10.el7
subversion-libs.x86_64 0:1.7.14-11.el7_4 systemtap-client.x86_64 0:3.1-4.el7_4 systemtap-devel.x86_64 0:3.1-4.el7_4
systemtap-runtime.x86_64 0:3.1-4.el7_4
Dependency Updated:
cpp.x86_64 0:4.8.5-16.el7_4.1 gcc.x86_64 0:4.8.5-16.el7_4.1 gcc-gfortran.x86_64 0:4.8.5-16.el7_4.1 gettext.x86_64 0:0.19.8.1-2.el7
gettext-libs.x86_64 0:0.19.8.1-2.el7 libgcc.x86_64 0:4.8.5-16.el7_4.1 libgfortran.x86_64 0:4.8.5-16.el7_4.1 libgomp.x86_64 0:4.8.5-16.el7_4.1
libquadmath.x86_64 0:4.8.5-16.el7_4.1 libquadmath-devel.x86_64 0:4.8.5-16.el7_4.1 libstdc++.x86_64 0:4.8.5-16.el7_4.1 rpm.x86_64 0:4.11.3-25.el7
rpm-build.x86_64 0:4.11.3-25.el7 rpm-build-libs.x86_64 0:4.11.3-25.el7 rpm-libs.x86_64 0:4.11.3-25.el7 rpm-python.x86_64 0:4.11.3-25.el7
Complete!
[root@haiyuan mariaDB]# yum install -y ncurses-devel openssl-devel openssl
相关命令如下:
yum groupinstall “Development Tools”
yum install -y ncurses-devel openssl-devel openssl
可以去cmake 官网进行下载:
https://cmake.org/download/
[root@haiyuan mariaDB]# wget https://cmake.org/files/v3.10/cmake-3.10.1.tar.gz
--2018-01-02 22:06:59-- https://cmake.org/files/v3.10/cmake-3.10.1.tar.gz
Resolving cmake.org (cmake.org)... 66.194.253.19
Connecting to cmake.org (cmake.org)|66.194.253.19|:443... connected.
HTTP request sent, awaiting response... 200 OK
Length: 7824043 (7.5M) [application/x-gzip]
Saving to: ‘cmake-3.10.1.tar.gz’
100%[=================================================================================================================>] 7,824,043 118KB/s in 28s
2018-01-02 22:07:29 (270 KB/s) - ‘cmake-3.10.1.tar.gz’ saved [7824043/7824043]
[root@haiyuan mariaDB]# ll
total 78716
-rw-r--r-- 1 root root 7824043 Dec 14 22:09 cmake-3.10.1.tar.gz
drwxrwxr-x 33 1001 1001 4096 Nov 27 18:09 mariadb-10.2.11
-rw-r--r-- 1 root root 72772830 Nov 27 18:09 mariadb-10.2.11.tar.gz
[root@haiyuan mariaDB]# tar -xf cmake-3.10.1.tar.gz
[root@haiyuan mariaDB]# cd cmake-3.10.1
[root@haiyuan cmake-3.10.1]# ls
Auxiliary CMakeGraphVizOptions.cmake CompileFlags.cmake CTestConfig.cmake Help README.rst Utilities
bootstrap CMakeLists.txt configure CTestCustom.cmake.in Licenses Source
CMakeCPack.cmake CMakeLogo.gif CONTRIBUTING.rst DartConfig.cmake Modules Templates
CMakeCPackOptions.cmake.in cmake_uninstall.cmake.in Copyright.txt doxygen.config Packaging Tests
[root@haiyuan cmake-3.10.1]# ./bootstrap
---------------------------------------------
CMake 3.10.1, Copyright 2000-2017 Kitware, Inc. and Contributors
Found GNU toolchain
C compiler on this system is: gcc
C++ compiler on this system is: g++ -std=gnu++1y
Makefile processor on this system is: gmake
[root@haiyuan cmake-3.10.1]# make && make install
Scanning dependencies of target cmsys
[ 0%] Building C object Source/kwsys/CMakeFiles/cmsys.dir/ProcessUNIX.c.o
[ 0%] Building C object Source/kwsys/CMakeFiles/cmsys.dir/Base64.c.o
================
3.1.准备目录
[root@haiyuan cmake-3.10.1]# mkdir -pv /data_linux/mysql/3306/{data,logs/{binlog,relaylog}}
mkdir: created directory ‘/data_linux/mysql’
mkdir: created directory ‘/data_linux/mysql/3306’
mkdir: created directory ‘/data_linux/mysql/3306/data’
mkdir: created directory ‘/data_linux/mysql/3306/logs’
mkdir: created directory ‘/data_linux/mysql/3306/logs/binlog’
mkdir: created directory ‘/data_linux/mysql/3306/logs/relaylog’
[root@haiyuan cmake-3.10.1]#
3.2.添加用户
[root@haiyuan cmake-3.10.1]# groupadd mysql
[root@haiyuan cmake-3.10.1]# useradd -s /sbin/nologin -g mysql -M mysql
Group 'mail' not found. Creating the user mailbox file with 0600 mode.
[root@haiyuan cmake-3.10.1]# chown mysql:mysql /data_linux/mysql/3306/ -R
[root@haiyuan cmake-3.10.1]#
==============
[root@haiyuan mariadb-10.2.11]# cmake -DCMAKE_INSTALL_PREFIX=/usr/local/mysql -DMYSQL_DATADIR=/data_linux/mysql/3306/data -DSYSCONFDIR=/etc -DWITH_INNOBASE_STORAGE_ENGINE=1 -DWITH_ARCHIVE_STORAGE_ENGINE=1 -DWITH_BLACKHOLE_STORAGE_ENGINE=1 -DWITH_READLINE=1 -DWITH_SSL=system -DWITH_ZLIB=system -DWITH_LIBWRAP=0 -DMYSQL_UNIX_ADDR=/tmp/mysql.sock -DDEFAULT_CHARSET=utf8 -DDEFAULT_COLLATION=utf8_general_ci -DMYSQL_UNIX_ADDR=/tmp/mysql.sock -DENABLED_LOCAL_INFILE=1 -DWITH_PARTITION_STORAGE_ENGINE=1 -DWITH_DEBUG=0 -DWITHOUT_MROONGA_STORAGE_ENGINE=1
......
CMake Deprecation Warning at cmake/for_clients.cmake:15 (CMAKE_POLICY):
The OLD behavior for policy CMP0007 will be removed from a future version
of CMake.
The cmake-policies(7) manual explains that the OLD behaviors of all
policies are deprecated and that a policy should be set to OLD only under
specific short-term circumstances. Projects should be ported to the NEW
behavior and not rely on setting a policy to OLD.
Call Stack (most recent call first):
CMakeLists.txt:415 (INCLUDE)
-- Configuring done
-- Generating done
-- Build files have been written to: /data_linux/mariaDB/mariadb-10.2.11
[root@haiyuan mariadb-10.2.11]# make
[root@haiyuan mariadb-10.2.11]# make install
如果上面make需要修改参数,重新编译 可以删除原来本目录下的CMakeCache.txt
mv CMakeCache.txt CMakeCache.txt.bak
[root@haiyuan mariadb-10.2.11]# chmod +w /usr/local/mysql/
[root@haiyuan mariadb-10.2.11]# chown -R mysql:mysql /usr/local/mysql/
[root@haiyuan mariadb-10.2.11]#
[root@haiyuan mariadb-10.2.11]# cp support-files/my-large.cnf /etc/my.cnf
cp: overwrite ‘/etc/my.cnf’? y
[root@haiyuan mariadb-10.2.11]#
vim /etc/my.cnf
增加如下:
datadir = /data_linux/mysql/3306/data
innodb_flush_log_at_trx_commit = 2
innodb_file_per_table = ON
skip_name_resolve = ON
=======
查看配置文件当前有效配置:
[root@haiyuan mariadb-10.2.11]# sed -e "s/#.*//g" /etc/my.cnf | awk '{if (length !=0) print $0}'
[client]
port = 3306
socket = /tmp/mysql.sock
[mysqld]
port = 3306
socket = /tmp/mysql.sock
skip-external-locking
key_buffer_size = 256M
max_allowed_packet = 1M
table_open_cache = 256
sort_buffer_size = 1M
read_buffer_size = 1M
read_rnd_buffer_size = 4M
myisam_sort_buffer_size = 64M
thread_cache_size = 8
query_cache_size= 16M
thread_concurrency = 8
log-bin=mysql-bin
binlog_format=mixed
server-id = 1
datadir = /data_linux/mysql/3306/data
innodb_data_home_dir = /data_linux/mysql/3306/data
innodb_data_file_path = ibdata1:10M:autoextend
innodb_log_group_home_dir = /data_linux/mysql/3306/data
innodb_buffer_pool_size = 256M
innodb_log_file_size = 64M
innodb_log_buffer_size = 8M
innodb_flush_log_at_trx_commit = 2
innodb_lock_wait_timeout = 50
innodb_file_per_table = ON
skip_name_resolve = ON
[mysqldump]
quick
max_allowed_packet = 16M
[mysql]
no-auto-rehash
[myisamchk]
key_buffer_size = 128M
sort_buffer_size = 128M
read_buffer = 2M
write_buffer = 2M
[mysqlhotcopy]
interactive-timeout
[root@haiyuan mariadb-10.2.11]#
[root@haiyuan mariadb-10.2.11]# scripts/mysql_install_db --user=mysql --basedir=/usr/local/mysql/ --datadir=/data_linux/mysql/3306/data/ --defaults-file=/etc/my.cnf
WARNING: The host 'haiyuan' could not be looked up with /usr/local/mysql//bin/resolveip.
This probably means that your libc libraries are not 100 % compatible
with this binary MariaDB version. The MariaDB daemon, mysqld, should work
normally with the exception that host name resolving will not work.
This means that you should use IP addresses instead of hostnames
when specifying MariaDB privileges !
Installing MariaDB/MySQL system tables in '/data_linux/mysql/3306/data/' ...
2018-01-02 23:28:50 140467365218368 [Warning] 'THREAD_CONCURRENCY' is deprecated and will be removed in a future release.
2018-01-02 23:28:50 140467365218368 [ERROR] /usr/local/mysql//bin/mysqld: unknown variable 'innodb_additional_mem_pool_size=20M'
2018-01-02 23:28:50 140467365218368 [ERROR] Aborting
Installation of system tables failed! Examine the logs in
/data_linux/mysql/3306/data/ for more information.
The problem could be conflicting information in an external
my.cnf files. You can ignore these by doing:
shell> scripts/mysql_install_db --defaults-file=~/.my.cnf
You can also try to start the mysqld daemon with:
shell> /usr/local/mysql//bin/mysqld --skip-grant --general-log &
and use the command line tool /usr/local/mysql//bin/mysql
to connect to the mysql database and look at the grant tables:
shell> /usr/local/mysql//bin/mysql -u root mysql
mysql> show tables;
Try 'mysqld --help' if you have problems with paths. Using
--general-log gives you a log in /data_linux/mysql/3306/data/ that may be helpful.
The latest information about mysql_install_db is available at
https://mariadb.com/kb/en/installing-system-tables-mysql_install_db
MariaDB is hosted on launchpad; You can find the latest source and
email lists at http://launchpad.net/maria
Please check all of the above before submitting a bug report
at http://mariadb.org/jira
[root@haiyuan mariadb-10.2.11]#
查看初始化结果:
[root@haiyuan mariadb-10.2.11]# ll /data_linux/mysql/3306/data/
total 206880
-rw-rw---- 1 mysql mysql 16384 Jan 2 23:28 aria_log.00000001
-rw-rw---- 1 mysql mysql 52 Jan 2 23:28 aria_log_control
-rw-rw---- 1 mysql mysql 2717 Jan 2 23:28 ib_buffer_pool
-rw-rw---- 1 mysql mysql 77594624 Jan 2 23:28 ibdata1
-rw-rw---- 1 mysql mysql 67108864 Jan 2 23:28 ib_logfile0
-rw-rw---- 1 mysql mysql 67108864 Jan 2 23:28 ib_logfile1
drwx------ 2 mysql root 4096 Jan 2 23:28 mysql
-rw-rw---- 1 mysql mysql 0 Jan 2 23:28 mysql-bin.index
drwx------ 2 mysql root 4096 Jan 2 23:28 test
[root@haiyuan mariadb-10.2.11]#
[root@haiyuan mariadb-10.2.11]# cp support-files/mysql.server /etc/rc.d/init.d/mysqld
[root@haiyuan mariadb-10.2.11]# chmod +x /etc/rc.d/init.d/mysqld
[root@haiyuan mariadb-10.2.11]# chkconfig --add mysqld
[root@haiyuan mariadb-10.2.11]# /etc/init.d/mysqld restart
Restarting mysqld (via systemctl): [ OK ]
[root@haiyuan mariadb-10.2.11]#
####9.添加环境变量
[root@haiyuan mariadb-10.2.11]# vim /etc/profile
##export PATH=$PATH:/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/root/bin:/usr/local/mysql/bin
[root@haiyuan mariadb-10.2.11]# source /etc/profile
[root@haiyuan mariadb-10.2.11]#
[root@haiyuan mariadb-10.2.11]# mysql
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 10
Server version: 10.2.11-MariaDB-log Source distribution
Copyright (c) 2000, 2017, Oracle, MariaDB Corporation Ab and others.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
MariaDB [(none)]> use mysql;
Database changed
MariaDB [mysql]> select user,host,password from mysql.user;
+------+-----------+----------+
| user | host | password |
+------+-----------+----------+
| root | localhost | |
| root | haiyuan | |
| root | 127.0.0.1 | |
| root | ::1 | |
| | localhost | |
| | haiyuan | |
+------+-----------+----------+
6 rows in set (0.00 sec)
MariaDB [mysql]> update user set password=PASSWORD('newpassword') where user='root';
Query OK, 4 rows affected (0.00 sec)
Rows matched: 4 Changed: 4 Warnings: 0
MariaDB [mysql]> delete from user where user='';
Query OK, 2 rows affected (0.00 sec)
MariaDB [mysql]> select user,host,password from mysql.user;
+------+-----------+-------------------------------------------+
| user | host | password |
+------+-----------+-------------------------------------------+
| root | localhost | *6BB4837EB74329105EE4568DDA7DC67ED2CA2AD9 |
| root | haiyuan | *6BB4837EB74329105EE4568DDA7DC67ED2CA2AD9 |
| root | 127.0.0.1 | *6BB4837EB74329105EE4568DDA7DC67ED2CA2AD9 |
| root | ::1 | *6BB4837EB74329105EE4568DDA7DC67ED2CA2AD9 |
+------+-----------+-------------------------------------------+
4 rows in set (0.00 sec)
MariaDB [mysql]>
文章浏览阅读5k次,点赞11次,收藏43次。统计检验_统计测试 cd diagrams
文章浏览阅读332次。购物车_购物车案例请求数据地址
文章浏览阅读603次。DOTween 使用方法_tween number
文章浏览阅读1.2w次,点赞13次,收藏138次。F28335 ADC模块ADC转换模块A/D转换器(ADC)将模拟量转换为数字量通常要经过四个步骤:采样、保持、量化和编码。采样:将一个时间上连续变化的模拟量转化为时间上离散变化的模拟量。保持:将采样结果存储起来,直到下次采样,这个过程称作保持。一般,采样器和保持电路一起总称为采样保持电路。量化:将采样电平归化为与之接近的离散数字电平,这个过程称作量化。ADC关键指标分辨率:指数字量变化一个最小量时模拟信号的变化量,定义为满刻度与2^n的比值。分辨率又称为精度,通常以数字信号的位_dsp2833x_adc.c
文章浏览阅读1.8k次。 路径规划问题是机器人学研究的一个重要领域,它是指给定操作环境以及起始和目标的位置姿态,要求选择一条从起始点到目标点的路径,使运动物体(移动机器人或机械臂)能安全、无碰撞地通过所有的障碍物而达到目标位置。路径规划从研究对象上可分为关节式机械臂和移动机器人。一般来讲前者具有更多的自由度,而后者的作业范围要更大一些,这两类对象具有不同的特点,因此在研究方法上略有不同。在V-rep学习笔记:机器人路..._collision pairs
文章浏览阅读1.5k次。1.环境:U8与本地某程序。跨服务器、跨数据库。2.问题:U8的存货同步到本地时,报“数据库可能存在相同的编码”。3.原因:在确认了U8程序正常、本地程序正常、U8数据库正常、本地数据库正常、链接服务器正常、触发器本身正常后,回到了问题的本身:为何原来的同步执行正常,但是现在的存货保存却异常,怀疑是最新的存货有问题。所以先停了触发器,然后用U8做了一个存货,正常保存后。启用触发器,直接用刚_数据库可能已经存在相同的编码等
文章浏览阅读368次。DB2支持以下两种类型的表空间: 1、 系统管理存储器表空间(SMS-SYSTEM MANAGED STORAGE) 2、 数据库管理存储器表空间(DMS-DATABASE MANAGED STORAGE) SMS、DMS用户表空间的特性对照 特性 ..._db2
文章浏览阅读84次。正在开发中的游戏有个全屏功能--可以在window桌面背景上运行,就像一些视频播放器在桌面背景上播放一样的,花了个上午整了个Demo放出来留个纪念。实现功能:显示图标,双击图标执行相应的程序,右击图标弹出该图标对应得菜单,点击非图标区则弹出桌面菜单。需要完整工程可以点此下载:DesktopWindow.rar。程序效果图如下:在这个程序里,定义了一个XShellItem..._模拟实现windows桌面效果
文章浏览阅读944次。https://www.byhy.net/tut/webdev/django/01/_byhy.net
文章浏览阅读5.8k次,点赞13次,收藏57次。业务场景介绍:H5移动端支持微信支付 [ 微信支付分为微信内支付(JSAPI支付官方API)和微信外支付(H5支付官方API)] && 支付宝支付 [手机网站支付转 APP 支付 官方API ]订单生成逻辑:前端请求后端提交订单,后端去和微信或者支付宝对接生成订单(后续支付都是这个逻辑进行的对接)一、移动端微信支付,vue中如何玩?在移动端微信支付分为微信内支付和微信外支付。1.在订单组件中选择支付方式之后在支付页面先去判断是否是在微信内://判断是否微信 is__移动端支付宝微信支付vue项目怎么写
文章浏览阅读2k次,点赞5次,收藏9次。深度学习编译器主要为解决不同框架下训练的模型部署到指定的某些设备上时所遇到的一系列复杂的问题,即将各种深度学习训练框架的模型部署到各种硬件所面临的问题;_tvm编译器
文章浏览阅读2.8w次,点赞7次,收藏22次。要想检测移动硬盘的读写速度和是否有坏道,可使用HD Tune Pro硬盘工具软件。除了硬盘传输速率、健康状况、温度、随机存取、磁盘错误扫描、文件基准检测等常见功能外,该软件还能检测硬盘的固件版本、序列号、容量、缓存以及当前的Ultra DMA模式等。此外,目前市场上主流的2.5英寸320GB移动硬盘的数据读取速度大多在30MB/s左右;写入速度稍微慢一点,一般在25MB/s左右。..._怎么检测移动硬盘是不是新的