mysqld.cc

最新推荐文章于 2021-01-19 02:26:24 发布
转载 最新推荐文章于 2021-01-19 02:26:24 发布 · 179 阅读 · 0
文章标签：

#数据库

在mysqld.cc里定义了所有的sql_mode.

还定义了记录各种统计状态信息的变量以及统计信息的类型;SHOW_VAR status_vars[]= {...);

mysql_init_variables: 初始化各种参数;

mysqld_get_one_option: 这个函数用来获得某个变量的值.

struct my_options定义了mysql里所有的my.cnf里的配置信息.

create_thread_to_handle_connection: 这个函数通过调用pthread_create方法为connection创建一个新线程. 同时设置thread_created, threads, wake_thread的值;

handle_connections_sockets()这个函数会调用create_new_thread(). 不知道create_new_thread()跟create_thread_to_handle_connection()有什么区别;

大概的方式是这样: 当用户请求登陆mysql的时候, mysql会去创建一个线程, 来处理这个连接所有的语句.

主要使用的文件有: mysqld.cc和sql_connect.cc;

具体的待续...

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/7682812/viewspace-668427/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/7682812/viewspace-668427/

css2015
关注
ERROR 2002 (HY000): Can‘t connect to local MySQL server through socket ‘/var/run/mysqld/mysqld.sock‘
big_bug1的博客
12-27 1691
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)，说明 MySQL 服务未正常启动，或者其套接字文件
mysql cc_mysqld.cc
weixin_42501785的博客
01-27 224
在mysqld.cc里定义了所有的sql_mode.还定义了记录各种统计状态信息的变量以及统计信息的类型;SHOW_VAR status_vars[]= {...);mysql_init_variables: 初始化各种参数;mysqld_get_one_option: 这个函数用来获得某个变量的值.struct my_options定义了mysql里所有的my.cnf里的配置信息.create_...
MySQL启动分析 --> /MySQL5.6/sql/mysqld.cc
疯狂程序员
07-28 1467
命令mysqld 入口文件 extern int mysqld_main(int argc, char **argv); int main(int argc, char **argv) {   return mysqld_main(argc, argv); }
mysql源码启动_Mysql源码阅读mysqld启动（一）
weixin_36189159的博客
01-19 352
为了研究SELECT * FROM xx 语句查询慢的本质原因，打算从Mysql源码看起，探查SELECT语句的执行流程。本次就成mysqld启动开始查看。本文以Mysql-5.7.19版本来进行研究。我们都知道C/C++都是从main函数开始调用, 可以从sql/main.cc开始看起。int main(int argc, char **argv){return mysqld_main(argc...
mysql5.7.19源码，在mysqld.cc 中调用 srv0srv.h，会出现如下错误，请问该如何解决？
qiaoduobian9789的博客
07-02 152
MySQL解析（1）---mysqld中的线程
Laudon的专栏
07-25 1347
mysqld启动后， 除主线程外，会创建几个新线程：大约在mysqld.cc的3500行左右，有这样的语句：start_signal_handler();.....create_shutdown_thread();create_maintenance_thread();它们分别启动如下线程：1）signal handle thread这个线程的作用在于截获多种信号，包括
In file included from /usr/local/software-mysql/mysql-5.6.50/include/violite.h:33:0, from /usr/local/software-mysql/mysql-5.6.50/sql/sql_acl.h:27, from /usr/local/software-mysql/mysql-5.6.50/sql/sql_parse.h:27, from /usr/local/software-mysql/mysql-5.6.50/sql/mysqld.cc:35: /usr/local/software-mysql/mysql-5.6.50/sql/mysqld.cc: In function ‘void handle_connections_sockets()’: /usr/local/software-mysql/mysql-5.6.50/include/mysql/psi/mysql_socket.h:506:65: error: invalid conversion from ‘size_socket* {aka int*}’ to ‘socklen_t* {aka unsigned int*}’ [-fpermissive] inline_mysql_socket_accept(__FILE__, __LINE__, K, FD, AP, LP) ^ /usr/local/software-mysql/mysql-5.6.50/sql/mysqld.cc:6387:17: note: in expansion of macro ‘mysql_socket_accept’ new_sock= mysql_socket_accept(key_socket_client_connection, sock, ^ /usr/local/software-mysql/mysql-5.6.50/include/mysql/psi/mysql_socket.h:1015:1: error: initializing argument 6 of ‘MYSQL_SOCKET inline_mysql_socket_accept(const char*, uint, PSI_socket_key, MYSQL_SOCKET, sockaddr*, socklen_t*)’ [-fpermissive] inline_mysql_socket_accept ^ make[2]: *** [sql/CMakeFiles/sql.dir/mysqld.cc.o] Error 1 make[1]: *** [sql/CMakeFiles/sql.dir/all] Error 2 make: *** [all] Error 2
07-09
在 MySQL 5.6.50 的编译过程中，出现的 `invalid conversion from 'int*' to 'socklen_t*'` 错误是一个典型的类型不兼容问题。此错误通常出现在使用较新版本的系统库（如 glibc）时，而 MySQL 5.6.50 源码中某些部分...
2025-10-28T21:51:25.143820+08:00 61 [ERROR] InnoDB: Operating system error number 32 in a file operation. 2025-10-28T21:51:25.144814+08:00 61 [ERROR] InnoDB: The error means that another program is using InnoDB's files. This might be a backup or antivirus software or another instance of MySQL. Please close it to get rid of this error. 2025-10-28 21:51:35 0x4e50 InnoDB: Assertion failure in thread 20048 in file handler0alter.cc line 7404 InnoDB: Failing assertion: error == DB_SUCCESS 2025-10-28T21:51:35.146746+08:00 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 9706ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.) InnoDB: We intentionally generate a memory trap. InnoDB: Submit a detailed bug report to http://bugs.mysql.com. InnoDB: If you get repeated assertion failures or crashes, even InnoDB: immediately after the mysqld startup, there may be InnoDB: corruption in the InnoDB tablespace. Please refer to InnoDB: http://dev.mysql.com/doc/refman/5.7/en/forcing-innodb-recovery.html InnoDB: about forcing recovery. 13:51:35 UTC - mysqld got exception 0x80000003 ; This could be because you hit a bug. It is also possible that this binary or one of the libraries it was linked against is corrupt, improperly built, or misconfigured. This error can also be caused by malfunctioning hardware. Attempting to collect some information that could help diagnose the problem. As this is a crash and something is definitely wrong, the information collection process might fail. key_buffer_size=536870912 read_buffer_size=131072 max_used_connections=52 max_threads=600 thread_count=52 connection_count=52 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 761977 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. Thread pointer: 0x168dca9d300 Attempting backtrace. You can use the following information to find out where mysqld died. If you see no messages after this, something went terribly wrong... 7ff657099812 mysqld.exe!my_sigabrt_handler()[my_thr_init.c:449] 7ff65743e349 mysqld.exe!raise()[winsig.c:587] 7ff65743d240 mysqld.exe!abort()[abort.c:82] 7ff657199b08 mysqld.exe!ut_dbg_assertion_failed()[ut0dbg.cc:67] 7ff65727f72f mysqld.exe!ha_innobase::commit_inplace_alter_table()[handler0alter.cc:8275] 7ff656a11443 mysqld.exe!mysql_inplace_alter_table()[sql_table.cc:7449] 7ff656a0f17a mysqld.exe!mysql_alter_table()[sql_table.cc:9538] 7ff656b3565e mysqld.exe!Sql_cmd_alter_table::execute()[sql_alter.cc:316] 7ff656996aa5 mysqld.exe!mysql_execute_command()[sql_parse.cc:3521] 7ff65699938a mysqld.exe!mysql_parse()[sql_parse.cc:5525] 7ff65699239d mysqld.exe!dispatch_command()[sql_parse.cc:1432] 7ff6569933aa mysqld.exe!do_command()[sql_parse.cc:999] 7ff6569581e4 mysqld.exe!handle_connection()[connection_handler_per_thread.cc:301] 7ff65737cd92 mysqld.exe!pfs_spawn_thread()[pfs.cc:2191] 7ff65709967b mysqld.exe!win_thread_start()[my_thread.c:38] 7ff65743ddbf mysqld.exe!_callthreadstartex()[threadex.c:376] 7ff65743e00a mysqld.exe!_threadstartex()[threadex.c:354] 7ffaba1f84d4 KERNEL32.DLL!BaseThreadInitThunk() 7ffabc6ee871 ntdll.dll!RtlUserThreadStart() Trying to get some variables. Some pointers may be invalid and cause the dump to abort. Query (168df559740): ALTER TABLE formmain_0495 DROP COLUMN field0028 Connection ID (thread ID): 61 Status: NOT_KILLED The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains information that should help you find out what is causing the crash.
10-29
嗯，用户遇到了MySQL执行ALTER TABLE DROP COLUMN时InnoDB报错甚至崩溃的问题，这确实是个棘手的生产环境故障。结合用户提供的三个引用材料，核心矛盾点应该在online DDL的日志限制和锁冲突上。...
terribly wrong... stack_bottom = 0x0 thread_stack 0x49000 mysys/stacktrace.c:175(my_print_stacktrace)[0x5623cfdb70ee] sql/signal_handler.cc:231(handle_fatal_signal)[0x5623cf80695f] sigaction.c:0(__restore_rt)[0x7f12f9a615f0] :0(__GI_raise)[0x7f12f96ba337] :0(__GI_abort)[0x7f12f96bba28] os/os0file.cc:5188(os_file_handle_error_cond_exit)[0x5623cfa1b8e5] include/os0file.inl:170(pfs_os_file_create_func)[0x5623cfbc1af5] fsp/fsp0sysspace.cc:452(SysTablespace::create_file(Datafile&))[0x5623cfbc7566] fsp/fsp0sysspace.cc:897(SysTablespace::open_or_create(bool, bool, unsigned long*, unsigned long*))[0x5623cfbc8822] srv/srv0start.cc:1694(srv_start(bool))[0x5623cfab7d86] handler/ha_innodb.cc:4377(innodb_init(void*))[0x5623cf9af8bf] sql/handler.cc:549(ha_initialize_handlerton(st_plugin_int*))[0x5623cf8090c4] sql/sql_plugin.cc:1435(plugin_initialize(st_mem_root*, st_plugin_int*, int*, char**, bool))[0x5623cf635820] sql/sql_plugin.cc:1717(plugin_init(int*, char**, int))[0x5623cf6369aa] sql/mysqld.cc:5472(init_server_components())[0x5623cf56488a] sql/mysqld.cc:6091(mysqld_main(int, char**))[0x5623cf56b07e] /lib64/libc.so.6(__libc_start_main+0xf5)[0x7f12f96a6505] /data/mces/mysql/bin/mysqld(+0x56c8e1)[0x5623cf55e8e1] The manual page at https://mariadb.com/kb/en/how-to-produce-a-full-stack-trace-for-mysqld/ contains information that should help you find out what is causing the crash. Writing a core file... Working directory at /data/mces/data Resource Limits: Limit Soft Limit Hard Limit Units Max cpu time unlimited unlimited seconds Max file size unlimited unlimited bytes Max data size unlimited unlimited bytes Max stack size 8388608 unlimited bytes Max core file size 0 unlimited bytes Max resident set unlimited unlimited bytes Max processes 14989 14989 processes Max open files 10035 10035 files Max locked memory 65536 65536 bytes Max address space unlimited unlimited bytes Max file locks unlimited unlimited locks Max pending signals 14989 14989 signals Max msgqueue size 819200 819200 bytes Max nice priority 0 0 Max realtime priority 0 0 Max realtime timeout unlimited unlimited us Core pattern: core Kernel version: Linux version 3.10.0-1062.el7.x86_64 (mockbuild@kbuilder.bsys.centos.org) (gcc version 4.8.5 20150623 (Red Hat 4.8.5-36) (GCC) ) #1 SMP Wed Aug 7 18:08:02 UTC 2019 250707 18:20:25 mysqld_safe mysqld from pid file /data/mces/mysql/mysqld.pid ended
07-08
gdb /usr/sbin/mysqld core bt ``` 堆栈跟踪信息有助于判断具体出错的函数位置。 #### 升级或打补丁 如果确认是MySQL自身的bug，可参考官方发布的Changelog或Bug追踪系统，确认是否已有对应的修复版本。升级到最新...
java的MySQL安装的时候打开mysqld.exe电脑闪烁一个终端，也就是打开后立马关闭，这是怎么回事
最新发布
11-17
- 需安装对应版本的 [Visual C++ Redistributable](https://support.microsoft.com/en-us/topic/the-latest-supported-visual-c-downloads-2647da03-1eea-4433-9aff-95f26a218cc0) 5. **权限问题** - 数据目录...
mysql源码阅读（启动一）
Martin201609的博客
09-11 561
源代码版本和系统 mysql5.7.27 带boost的基于linux系统的源代码 mysqld的启动 尝试源码阅读 入口函数：sql\main.cc extern int mysqld_main(int argc, char **argv); //告诉编译器，下面是C语言的函数。经常在C++混编的程序中看到 int main(int argc, char **argv) { return ...
mysql源代码_MySQL源代码解读（一）
weixin_39535557的博客
01-18 2164
MySQL启动流程主要代码在sql/mysqld.cc中，精简后的代码如下：int main(int argc, char **argv) //标准入口函数MY_INIT(argv[0]);//调用mysys/My_init.c->my_init()，初始化mysql内部的系统库logger.init_base(); //初始化日志功能init_common_variables(MYSQL_...
mysqld工程学习（一）:两个基本函数的学习strmov和int10_to_str
走出憧憬的专栏
03-15 4429
   以下特指WINDOW平台下MYSQL源码。要使用mysql数据库来作为我们的数据管理工具，我们首先要安装mysql或下载一个压缩包解压。但不管是那一种方式，都需要启动mysqld服务，使用过mysql的都知道。（在mysql的bin目录下有一个文件mysqld.exe文件.）mysql服务器启动后我们才能够连接到数据库进行数据的增删插改等查找。今天对mysqld的源码进行了了解，其主要就是实现了创建和安装window服务,并开启业务处理线程。先看看mysqld工程下的目录文件。nt_servc.h头文
1 从mysqld的main()函数开始
tz_sz的专栏
12-18 2746
一、sql/main.cc extern int mysqld_main(int argc, char **argv); int main(int argc, char **argv) { return mysqld_main(argc, argv); }这就是mysqld的main()函数，它只是调用了mysql_main()。 二、mysqld_main mysqld_ma
VS2015+MySQL数据库
baidu_15952103的博客
01-09 2922
要实现VS2015与MySQL数据库的连接需要经过以下几个步骤的配置： 1.配置头文件，右键点击工程项目 选择属性。 然后在附加包含目录里添加C:\Program Files\MySQL\MySQL Server 5.6\include，即数据库安装文件夹下的include文件 2.接着配置附加库目录 3.然后在链接器下的输入中找到附加依赖项，添加libmysql.lib ...
mysqld执行的函数栈
innobase的博客
05-03 706
我是在mysql中的row_search_for_mysql的函数设置断点，该函数式存储引擎入口函数       以上为调试程序的当前上所有的线程，线程的函数栈信息如下 Thread 25 (Thread 0x7fffdfa0e700 (LWP 8232)): #0 row_search_for_mysql (buf=0x2112930 "\377", mode=1, prebuilt
mysql 5.7源码 启动监听过程
pzqingchong的专栏
06-03 1815
sql/mysqld.cc mysqld_main  启动主函数
关于MYSQL 5.7 新连接建立流程源码接口(和5.6不同)
cri5768的博客
05-29 175
原创 水平有限 今天在看运维内参第三章源码的时候，发现书上很多代码入口函数和我用的5.7.14的源码对不上，然后再看了一下5.6的源码， 书上写的基本都是5.6的源码(书是2015年开始写的)5.7.14在连接这一块做了...
MySQL系列之源码浅析
魔幻世界
10-12 7235
源码才是王道。 真正的高手从来不是临场发挥，随机应变是外人看来的错觉。 1. 主函数sql/mysqld.cc中，代码如下：int main(int argc, char **argv) //标准入口函数 { MY_INIT(argv[0]);//调用mysys/My_init.c->my_init()，初始化mysql内部的系统库 logger.init_base(); //
评论
成就一亿技术人!
拼手气红包6.0元
还能输入1000个字符  | 博主筛选后可见
 
红包 添加红包
表情包 插入表情
表情包 代码片
 条评论被折叠 查看
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值