地产网站建设互动营销,有效的网站优化,优化网站推广,做视频网站注意什么经常听说mysql数据库是集成在系统中#xff0c;也一直不太明白集成的概念。今天才明白集成的概念就是将mysql所有的文件放到一个文件夹下放到系统中#xff0c;也就是将mysql采用目录迁移部署的方式进行安装。在上一篇研究了mysql的数据存储结构之后#xff0c;也研究了mysq…经常听说mysql数据库是集成在系统中也一直不太明白集成的概念。今天才明白集成的概念就是将mysql所有的文件放到一个文件夹下放到系统中也就是将mysql采用目录迁移部署的方式进行安装。在上一篇研究了mysql的数据存储结构之后也研究了mysql作为目录部署以及安装为mysql服务的方法。1.mysql目录安装mysql目录安装也就是将mysql必须的一些文件放到一起然后通过配置文件的配置即可实现。mysql主要的目录也就是data目录以及bin(存mysql的可执行文件)、lib(存放mysql的dll库)、share(存放mysql的语言支持库)、uploads(一般作为mysql的导出目录)、my.ini(mysql的端口以及其他全局配置文件)。例如我的目录安装的一个目录:bin、lib、share、Uploads是直接从mysql5.7的安装目录下拷贝过来的Data目录也是拷贝的上篇文章已经讲解过Data目录下存放具体的Mysql的数据库以及表结构与表数据查看Data的目录如下(是在原来的数据库迁移古来所以如果集成部署成功数据库应该与原来一样):my.ini文件:(注意标红位置的修改)[client]no-beepport3307[mysql]default-character-setutf8# server_type3[mysqld]# The TCP/IP Port the MySQL Server will listen onport3307# Path to installation directory. All paths are usually resolved relative tothis.# basedirC:/Program Files/MySQL/MySQL Server 5.7/# Path to the database rootdatadirG:\mysql572\Data# Thedefault character set that will be used when a new schema or table is# created and no characterset isdefinedcharacter-set-serverutf8# Thedefault storage engine that will be used when create newtables whendefault-storage-engineINNODB# Set the SQL mode to strictsql-modeSTRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION# Enable Windows Authentication# plugin-loadauthentication_windows.dll# General and Slow logging.log-outputFILEgeneral-log0general_log_fileMicroWin10-1535.logslow-query-log1slow_query_log_fileMicroWin10-1535-slow.loglong_query_time10# Binary Logging.log-errorMicroWin10-1535.err# Server Id.server-id1# Secure File Priv.secure-file-privG:\mysql572\Uploadsmax_connections151query_cache_size0table_open_cache2000tmp_table_size34Mthread_cache_size10myisam_max_sort_file_size100Gmyisam_sort_buffer_size60Mkey_buffer_size8Mread_buffer_size64Kread_rnd_buffer_size256K#*** INNODB Specific options ***# innodb_data_home_dir0.0# Usethis option ifyou have a MySQL server with InnoDB support enabled# but youdonot plan to use it. This will save memory and disk space# and speed up some things.# skip-innodb# Ifset to 1, InnoDB will flush (fsync) the transaction logs to the# disk at each commit, which offers full ACID behavior. If you are# willing to compromisethissafety, and you are running small# transactions, you mayset this to 0 or 2 to reduce disk I/O to the# logs. Value0 means that the log isonly written to the log file and# the log file flushed to disk approximately once per second. Value2# means the logiswritten to the log file at each commit, but the log# fileisonly flushed to disk approximately once per second.innodb_flush_log_at_trx_commit1# The size of the buffer InnoDB usesfor buffering log data. As soon as# itis full, InnoDB will have to flush it to disk. As it isflushed# once per second anyway, it does not make sense to have it very large# (even withlongtransactions).innodb_log_buffer_size1M# InnoDB, unlike MyISAM, uses a buffer pool to cache both indexes and# row data. The bigger youset this the less disk I/O isneeded to# access datain tables. On a dedicated database server you may set this# parameter up to80% of the machine physical memory size. Do not setit# too large, though, because competition of the physical memory may# cause paginginthe operating system. Note that on 32bit systems you# might be limited to2-3.5G of user level memory per process, so donot#setit too high.innodb_buffer_pool_size8M# Size of each log filein a log group. You should setthe combined size# of log files to about25%-100%of your buffer pool size to avoid# unneeded buffer pool flush activity on log file overwrite. However,# note that a larger logfile size will increase the time neededforthe# recovery process.innodb_log_file_size48M# Number of threads allowed inside the InnoDB kernel. The optimal value# depends highly on the application, hardwareas well asthe OS# scheduler properties. A too high value may lead to thread thrashing.innodb_thread_concurrency9# The increment size (in MB) for extending the size of an auto-extend InnoDB system tablespace file when it becomes full.innodb_autoextend_increment64# The number of regions that the InnoDB buffer poolisdivided into.# For systems with buffer poolsin the multi-gigabyte range, dividing the buffer pool into separate instances can improve concurrency,# by reducing contentionasdifferent threads read and write to cached pages.innodb_buffer_pool_instances8# Determines the number of threads that can enter InnoDB concurrently.innodb_concurrency_tickets5000# Specifies howlong inmilliseconds (ms) a block inserted into the old sublist must stay there after its first access before# it can be moved to thenewsublist.innodb_old_blocks_time1000# It specifies the maximum number of .ibd files that MySQL can keep open at one time. The minimum valueis 10.innodb_open_files300# Whenthis variable isenabled, InnoDB updates statistics during metadata statements.innodb_stats_on_metadata0# When innodb_file_per_tableis enabled (the default in 5.6.6 and higher), InnoDB stores the data and indexes foreach newly created table#in a separate .ibd file, rather than inthe system tablespace.innodb_file_per_table1innodb_checksum_algorithm0back_log80flush_time0join_buffer_size256Kmax_allowed_packet4Mmax_connect_errors100open_files_limit4161query_cache_type0sort_buffer_size256Ktable_definition_cache1400binlog_row_event_max_size8Ksync_master_info10000sync_relay_log10000sync_relay_log_info100002.启动上面的mysql并且进行连接G:\mysql572\binmysqld --defaults-fileG:\mysql572\my.ini新开cmd窗口查看进程信息:C:\Users\liqiangtasklist |findstr mysqlmysqld.exe1912 Services 0 228,348Kmysqld.exe325752 Console 9 208,488Kmysql.exe325984 Console 9 5,328KC:\Users\liqiangnetstat -ano | findstr 3307TCP0.0.0.0:3307 0.0.0.0:0 LISTENING 325752TCP [::]:3307 [::]:0 LISTENING 325752TCP [::1]:3307 [::1]:61234 ESTABLISHED 325752TCP [::1]:61234 [::1]:3307 ESTABLISHED 325984连接上面启动的3307端口的mysql:C:\Users\liqiangmysql -uroot -p -P3307Enter password:******Welcome to the MySQL monitor. Commands end with ; or \g.Your MySQL connectionid is 2Server version:5.7.10-log MySQL Community Server (GPL)Copyright (c)2000, 2015, Oracle and/or its affiliates. All rights reserved.Oracle is a registered trademark of Oracle Corporation and/or itsaffiliates. Other names may be trademarks of their respectiveowners.Type‘help;‘ or ‘\h‘ for help. Type ‘\c‘ to clearthe current input statement.mysql show variables like ‘log_error‘;--------------------------------------| Variable_name | Value |--------------------------------------| log_error | .\MicroWin10-1535.err |--------------------------------------1 row in set, 1 warning (0.01sec)mysql show variables like ‘datadir‘;----------------------------------| Variable_name | Value |----------------------------------| datadir | G:\mysql572\Data\ |----------------------------------1 row in set, 1 warning (0.00 sec)3.将上面目录安装的mysql安装为windows服务需以管理员身份执行cmdC:\Windows\system32G:\mysql572\bin\mysqld --install mysql572 --defaults-fileG:\mysql572\my.iniService successfully installed.查看上面安装的服务:C:\Windows\system32sc qc mysql572[SC] QueryServiceConfig 成功SERVICE_NAME: mysql572TYPE :10WIN32_OWN_PROCESSSTART_TYPE :2AUTO_STARTERROR_CONTROL :1NORMALBINARY_PATH_NAME : G:\mysql572\bin\mysqld--defaults-fileG:\mysql572my.ini mysql572LOAD_ORDER_GROUP :TAG :0DISPLAY_NAME : mysql572DEPENDENCIES :SERVICE_START_NAME : LocalSystem安装成功之后即可像正常的服务一样使用启动可以用sc start mysql删除服务也与平时删除服务一样:sc delete mysql572或者采用mysqld方式移除系统服务mysqld--remove MySQL57至此mysql集成安装完成在实际的项目中我们可以采用这种方式将mysql嵌入到系统中进行部署安装。下面附一份实际项目中的my.ini的配置:原文https://www.cnblogs.com/qlqwjy/p/9484582.html
