-
数据库相关知识整理
MySQL 与SqlServer 的一些常用用法的差别 MySQL 备份和恢复 MySQL 存储过程和触发器使用释疑 MySQL 索引背后的数据结构及算法原理 数据库综合知识 项目开发周期与数据库设计对比 IBM 数据库设计文章推荐 大型数据库...文章 2017-11-26 2174浏览量 -
Migrating EventLog Analyzer Data from MySQL to ...
If the database of the Managed Server is changed from MySQL to MSSQL,it has to be re-registerd with Admin Server as Managed Server with MSSQL. After changing the database,when the Managed Server is ...文章 2011-02-24 923浏览量 -
MySQL5.6导入数据时的错误分析
check the manual that corresponds to your MySQL server version for the right syntax to use near '*/' at line 1 打开文件的13327行，发现这个是一个触发器的SQL语句带有/*!不仔细看以为创建triggers失败 但是...文章 2017-11-07 1288浏览量 -
mysql ssh 导入时注意问题
1.MySQL错误 ERROR 2006(HY000):MySQL server has gone away 问题产生： 导入SQL 文件过大时报错 SQL文件140M source/sql.sql ERROR 2006(HY000):MySQL server has gone away No connection.Trying to reconnect. ...文章 2016-06-14 1628浏览量 -
Master-Slave Synchronization for MySQL
the master server thread is activated and pushes the binary log to the slave server,signaling the slave server thread to run.8.The slave server SQL thread executes the binary log and then sleeps. ...文章 2017-11-13 2770浏览量 -
RDS Best Practices—Fast and Stable Migration to ...
users can only dump user databases as a SQL file and then source the SQL file to RDS:migrating data to RDS–MySQL by using the MySQL dump tool and migrating data to RDS–SQL Server by using the SQL ...文章 2017-12-13 1717浏览量 -
PostgreSQL 与 MS SQL(SQL Server)类型映射关系
https://wiki.postgresql.org/wiki/Converting_from_other_Databases_to_PostgreSQL#Microsoft_SQL_Server https://wiki.postgresql.org/wiki/Microsoft_SQL_Server_to_PostgreSQL_Migration_by_Ian_Harding ...文章 2019-04-14 1244浏览量 -
Java spring boot 2.0连接mysql异常：The server time...
java.sql.SQLException:The server time zone value 'Öйú±ê׼ʱ¼ä' is unrecognized or represents more than one time zone.You must configure either the server or JDBC driver(via the ...文章 2019-01-27 7235浏览量 -
check the manual that corresponds to your MySQL s
check the manual that corresponds to your MySQL server version for the right syntax to use near at line 3 MySQL 5.6，Navicat For MySQL 10.0.10 中执行SQL语句时提示此错误，在CMD中执行SQL文件中的语句时...文章 2015-06-18 1274浏览量 -
线程相关内存参数sort_buffer/join_buffer等的内存...
12 0x00000000015adcae in mysql_parse(thd=0x7fff2c000b70,parser_state=0x7ffff035b600)at/root/mysql5.7.14/percona-server-5.7.14-7/sql/sql_parse.cc:5836 13 0x00000000015a1b6d in dispatch_command(thd=0x7...文章 2017-12-26 1392浏览量 -
十五：MySQL层事务提交流程简析（笔记）
5 0x00000000015ac64f in mysql_execute_command(thd=0x7fff2c000b70,first_level=true)at/root/mysql5.7.14/percona-server-5.7.14-7/sql/sql_parse.cc:5239 6 0x00000000015adcae in mysql_parse(thd=0x7fff2c000...文章 2019-11-22 891浏览量 -
mysql编译报错解决办法之一
[73%]Building CXX object sql/CMakeFiles/mysql_tzinfo_to_sql.dir/tztime.cc.o Linking CXX executable mysql_tzinfo_to_sql [73%]Built target mysql_tzinfo_to_sql [73%]Generating sql_yacc.cc,sql_yacc.h [73%...文章 2017-11-22 3929浏览量 -
MySQL 字符串转double转换栈帧（可能丢失精度）
10 0x00000000018040ed in Sql_cmd_insert:execute(this=0x7ffedc006d80,thd=0x7ffedc000b90)at/mysqldata/percona-server-locks-detail-5.7.22/sql/sql_insert.cc:3121 11 0x00000000015cc753 in mysql_execute_...文章 2019-11-22 4675浏览量 -
How To Install Zabbix Server 3.0 on CentOS/RHEL 7/...
You have added zabbix yum repository in above step.Now use following command to install Zabbix server with mysql database support packages on your system. yum install zabbix-server-mysql zabbix-web-...文章 2017-10-09 1275浏览量 -
【已解决】mysql8.0.x 初始化root密码（错误：1251、...
check the manual that corresponds to your MySQL server version for the right syntax to use near '('123456')where `user`='root'' at line 1按【错误：1251】的解决方法试一下>net stop mysql#停止mysql...文章 2023-01-10 37浏览量 -
[玩转MySQL之一]MySQL体系架构简介
MySQL是一个典型的C/S架构程序，MySQL Server提供数据库服务，完成客户端的请求和操作，Client负责连接到Server。MySQL和其他关系型数据库不一样的地方在于它的弹性以及可以通过插件形式提供不同种类的存储引擎，...文章 2018-09-04 2468浏览量 -
MySQL安装错误后的解决
使用yum mysql-server后然后remove掉mysql-server yum install mysql-server yum remove mysql-server 然后重新解压安装，上述错误没有。本文转自 妙曼 51CTO博客，原文链接：...文章 2017-11-15 1345浏览量 -
MySQL:Innodb:innodb_flush_log_at_trx_commit参数...
10 0x00000000015adcd6 in mysql_parse(thd=0x7fff2c000b70,parser_state=0x7ffff0158600)at/root/mysql5.7.14/percona-server-5.7.14-7/sql/sql_parse.cc:5836 11 0x00000000015a1b95 in dispatch_command(thd=0x7...文章 2018-10-17 1943浏览量 -
MySQL server has gone away 解决方法
The problem on Windows is that in some cases MySQL doesn't get an error from the OS when writing to the TCP/IP connection to the server,but instead gets the error when trying to read the answer from ...文章 2017-12-04 2118浏览量 -
The Main Features of MySQL
line programs such as mysqldump and mysqladmin,and graphical programs such as MySQL Workbench.MySQL Server has built-in support for SQL statements to check,optimize,and repair tables.These ...文章 2016-08-16 1267浏览量 -
ubuntu azkaban4.0.0链接mysql(5.1/8.0)数据库配置
Mysql Packet Size may need to be re-configured.MySQL may have,by default,a ridiculously low allowable packet size.To increase it,you’ll need to have the property max_allowed_packet set to a higher ...文章 2022-12-12 25浏览量 -
CentOS下mysql 卸载，安装，测试全过程
error:'Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock'(2)' Check that mysqld is running and that the socket:'/var/lib/mysql/mysql.sock' exists!解决： 2.1》/etc/rc.d/init...文章 2017-11-12 1526浏览量 -
OGG-00769的解决
WARNING OGG-00769 MySQL Login failed:.SQL error(2002).Can't connect to local MySQL server through socket '/tmp/mysql.sock'(2). ERROR:Failed to connect to MySQL database engine for HOST localhost,...文章 2017-12-06 1379浏览量 -
MySQL：一个简单insert语句的大概流程
349 T@2:|THD:enter_stage:'checking permissions'/root/mysql5.7.14/percona-server-5.7.14-7/sql/auth/sql_authorization.cc:843 359 T@2:|THD:enter_stage:'Opening tables'/root/mysql5.7.14/percona-server-...文章 2018-06-07 4395浏览量 -
Mysql异常'SET OPTION SQL_SELECT_LIMIT=DEFAULT'
check the manual that corresponds to your MySQL server version for the right syntax to use near 'OPTION SQL_SELECT_LIMIT=DEFAULT' at line 1 异常分析 我用的数据库版本是5.7但是用的驱动版本是5.1.8的，...文章 2018-07-23 3471浏览量 -
Scala 连接mysql 时出现的BUG
Thu Nov 16 22:01:40 GMT+08:00 2017 WARN:Establishing SSL connection without server's identity verification is not recommended.According to MySQL 5.5.45+,5.6.26+and 5.7.6+requirements SSL connection ...文章 2017-11-16 1757浏览量 -
数据库必知词汇：SQL Server
Introduction,History,Editions,Instances https://www.guru99.com/sql-server-introduction.htmlArchived MSDN and TechNet Blogs https://docs.microsoft.com/zh-cn/archive/blogs/Introductionto SQL Server ...文章 2020-02-23 570浏览量 -
PostgreSQL通过mysql_fdw访问MySQL数据库
query:An SQL query to define the data set on the MySQL server. table:The name of a table(quoted and qualified as required) on the MySQL table. Note that the query and table paramters are mutually ...文章 2017-12-31 1999浏览量 -
about MySQL Workbench的基本使用及运用操作
easy to use solution for migrating Microsoft SQL Server,Microsoft Access,Sybase ASE,PostreSQL,and other RDBMS tables,objects and data to MySQL.Developers and DBAs can quickly and easily convert ...文章 2017-12-08 1863浏览量 -
Centos 6 Zabbix:Install
Install MySQL server,refer to here. [4] Install some other required packages and Zabbix repository. [root@dlp~]# yum-y install php-mysql php-gd php-xml php-bcmath [root@dlp~]# yum-y install ...文章 2017-10-09 1127浏览量
