my.ini
[mysqld]
#綁定IPv4
bind-address = 0.0.0.0
# 設(shè)置mysql的安裝目錄,即你解壓縮安裝包的位置
basedir = D:\\server\\mysql-5.7.21-winx64
# 設(shè)置mysql數(shù)據(jù)庫的數(shù)據(jù)的存放目錄
datadir = D:\\server\\mysql-5.7.21-winx64\\data
# 設(shè)置端口號
port = 3306
# 允許最大連接數(shù)
max_connections = 1000
# 設(shè)置字符集為utf8
loose-default-character-set = utf8
# 開啟查詢緩存
# explicit_defaults_for_timestamp = false
# 不區(qū)分大小寫
lower_case_table_names=1
sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
#執(zhí)行文件大小
max_allowed_packet = 1000M
[client]
#設(shè)置客戶端字符集
port=3306
default-character-set = utf8
[WinMySQLadmin]
Server = D:\\server\\mysql-5.7.21-winx64\\bin\\mysqld.exe
報錯
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=8388608
read_buffer_size=131072
max_used_connections=3
max_threads=1000
thread_count=2
connection_count=2
It is possible that mysqld could use up to
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 404356 K bytes of memory
Hope that's ok; if not, decrease some variables in the equation.
Thread pointer: 0x138e30c0
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...
7fef5cc5c01 MSVCR120.dll!pow()
13f6641ba mysqld.exe!get_sweep_read_cost()[handler.cc:7215]
13fc1c3d7 mysqld.exe!ror_intersect_add()[opt_range.cc:5461]
13fc12139 mysqld.exe!get_best_ror_intersect()[opt_range.cc:5642]
13fc1e6c5 mysqld.exe!test_quick_select()[opt_range.cc:3108]
13f7ca81e mysqld.exe!get_quick_record_count()[sql_optimizer.cc:5949]
13f7c926d mysqld.exe!JOIN::estimate_rowcount()[sql_optimizer.cc:5695]
13f7cbff9 mysqld.exe!JOIN::make_join_plan()[sql_optimizer.cc:5052]
13f7cdb6b mysqld.exe!JOIN::optimize()[sql_optimizer.cc:368]
13f81dfc9 mysqld.exe!st_select_lex::optimize()[sql_select.cc:1009]
13f8301d5 mysqld.exe!st_select_lex_unit::optimize()[sql_union.cc:703]
13f81dfe7 mysqld.exe!st_select_lex::optimize()[sql_select.cc:1015]
13f81bfed mysqld.exe!handle_query()[sql_select.cc:164]
13f6859a7 mysqld.exe!execute_sqlcom_select()[sql_parse.cc:5156]
13f6878d6 mysqld.exe!mysql_execute_command()[sql_parse.cc:2792]
13f68b358 mysqld.exe!mysql_parse()[sql_parse.cc:5588]
13f6843f4 mysqld.exe!dispatch_command()[sql_parse.cc:1461]
13f68541a mysqld.exe!do_command()[sql_parse.cc:1001]
13f62bcac mysqld.exe!handle_connection()[connection_handler_per_thread.cc:300]
140089772 mysqld.exe!pfs_spawn_thread()[pfs.cc:2193]
13fd9c2dc mysqld.exe!win_thread_start()[my_thread.c:38]
7fef5c54f7f MSVCR120.dll!_beginthreadex()
7fef5c55126 MSVCR120.dll!_endthreadex()
76fef56d kernel32.dll!BaseThreadInitThunk()
77223281 ntdll.dll!RtlUserThreadStart()
Trying to get some variables.
Some pointers may be invalid and cause the dump to abort.
Query (13a35880): SELECT
bh.end_date
FROM
booth_hire bh
WHERE bh.booth_no = 'AJ23,AJ24,AJ25,'
AND bh.vender_id = 18383
AND bh.status = 0
LIMIT 1
Connection ID (thread ID): 2
Status: NOT_KILLED
sql有問題?
試試這個
SELECT
s.id,
s.name,
s.price,
s.unit
from sample as s where id = 20205
EDITED
應(yīng)該MySQL的bug
https://bugs.mysql.com/bug.ph...
https://bugs.mysql.com/bug.ph...
與你的報錯很類似
terribly wrong...
7ff744872571 mysqld.exe!pow()[pow.asm:1616]
7ff743d8da3a mysqld.exe!get_sweep_read_cost()[handler.cc:7200]
7ff74434f3a7 mysqld.exe!ror_intersect_add()[opt_range.cc:5440]
7ff7443453a9 mysqld.exe!get_best_ror_intersect()[opt_range.cc:5621]
建議提交Bug
北大青鳥APTECH成立于1999年。依托北京大學(xué)優(yōu)質(zhì)雄厚的教育資源和背景,秉承“教育改變生活”的發(fā)展理念,致力于培養(yǎng)中國IT技能型緊缺人才,是大數(shù)據(jù)專業(yè)的國家
北大青鳥中博軟件學(xué)院創(chuàng)立于2003年,作為華東區(qū)著名互聯(lián)網(wǎng)學(xué)院和江蘇省首批服務(wù)外包人才培訓(xùn)基地,中博成功培育了近30000名軟件工程師走向高薪崗位,合作企業(yè)超4
中公教育集團(tuán)創(chuàng)建于1999年,經(jīng)過二十年潛心發(fā)展,已由一家北大畢業(yè)生自主創(chuàng)業(yè)的信息技術(shù)與教育服務(wù)機(jī)構(gòu),發(fā)展為教育服務(wù)業(yè)的綜合性企業(yè)集團(tuán),成為集合面授教學(xué)培訓(xùn)、網(wǎng)
達(dá)內(nèi)教育集團(tuán)成立于2002年,是一家由留學(xué)海歸創(chuàng)辦的高端職業(yè)教育培訓(xùn)機(jī)構(gòu),是中國一站式人才培養(yǎng)平臺、一站式人才輸送平臺。2014年4月3日在美國成功上市,融資1
浪潮集團(tuán)項(xiàng)目經(jīng)理。精通Java與.NET 技術(shù), 熟練的跨平臺面向?qū)ο箝_發(fā)經(jīng)驗(yàn),技術(shù)功底深厚。 授課風(fēng)格 授課風(fēng)格清新自然、條理清晰、主次分明、重點(diǎn)難點(diǎn)突出、引人入勝。
曾工作于聯(lián)想擔(dān)任系統(tǒng)開發(fā)工程師,曾在博彥科技股份有限公司擔(dān)任項(xiàng)目經(jīng)理從事移動互聯(lián)網(wǎng)管理及研發(fā)工作,曾創(chuàng)辦藍(lán)懿科技有限責(zé)任公司從事總經(jīng)理職務(wù)負(fù)責(zé)iOS教學(xué)及管理工作。
精通HTML5和CSS3;Javascript及主流js庫,具有快速界面開發(fā)的能力,對瀏覽器兼容性、前端性能優(yōu)化等有深入理解。精通網(wǎng)頁制作和網(wǎng)頁游戲開發(fā)。
具有10 年的Java 企業(yè)應(yīng)用開發(fā)經(jīng)驗(yàn)。曾經(jīng)歷任德國Software AG 技術(shù)顧問,美國Dachieve 系統(tǒng)架構(gòu)師,美國AngelEngineers Inc. 系統(tǒng)架構(gòu)師。