我最近从mysql切换到mariadb，有些查询不再工作了。
示例：我有一个包含150000行的表，并执行以下查询： SELECT * FROM table LIMIT 122000,100 当然，那需要几秒钟，但应该有用。在mysql上，它可以正常工作，但是在mariadb中，查询不断加载，什么也没有发生（当然，服务器负载会增加）。我使用的是同一个引擎（myisam），不知道如何修复它。有人知道配置中是否有我可以更改的东西使其工作吗？我有点困惑，因为它与mysql一起工作，但与mariadb不一样。
提前谢谢。
一些附加信息：
显示创建表格帖子 CREATE TABLEposts(idmediumint(8) unsigned NOT NULL AUTO_INCREMENT,user_hashbinary(20) NOT NULL DEFAULT '0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0',titlevarchar(255) CHARACTER SET utf8 DEFAULT NULL,searchtext CHARACTER SET utf8 DEFAULT NULL,forumidtinyint(3) unsigned NOT NULL DEFAULT 0,timecountbigint(20) unsigned NOT NULL DEFAULT 0,addedint(11) unsigned NOT NULL DEFAULT 0,poststatusenum('open','closed') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'open',likesint(10) unsigned NOT NULL DEFAULT 0,commentstinyint(3) unsigned NOT NULL DEFAULT 0,viewssmallint(5) unsigned NOT NULL DEFAULT 0,hitssmallint(5) unsigned NOT NULL DEFAULT 0,thankssmallint(5) unsigned NOT NULL DEFAULT 0,upvotessmallint(5) unsigned NOT NULL DEFAULT 0,downvotessmallint(5) unsigned NOT NULL DEFAULT 0,last_answerint(11) unsigned NOT NULL DEFAULT 0,hiddenenum('yes','no') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'no',useridmediumint(8) unsigned NOT NULL DEFAULT 0,last_editint(11) unsigned NOT NULL DEFAULT 0,usernamevarchar(40) CHARACTER SET utf8 DEFAULT NULL,extralinkvarchar(255) CHARACTER SET utf8 DEFAULT NULL,editreasonvarchar(100) CHARACTER SET utf8 DEFAULT NULL,last_voteint(11) unsigned NOT NULL DEFAULT 0,styleenum('legacy','modern','default') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'default',genrevarchar(100) CHARACTER SET utf8 DEFAULT NULL,last_thanksint(11) unsigned NOT NULL DEFAULT 0,last_reply_usernamevarchar(40) CHARACTER SET utf8 DEFAULT NULL,approved_atint(11) unsigned NOT NULL DEFAULT 0,startint(11) unsigned NOT NULL DEFAULT 0,endint(11) unsigned NOT NULL DEFAULT 0,thread_statusenum('default','removed','awaiting') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'default',refered_byvarchar(10) COLLATE utf8_unicode_ci DEFAULT NULL,cidint(11) unsigned DEFAULT 0,optionsint(10) unsigned DEFAULT 1,ratingfloat(3,1) unsigned DEFAULT NULL,tagsvarchar(100) COLLATE utf8_unicode_ci DEFAULT NULL, PRIMARY KEY (id), UNIQUE KEYuser_hash(user_hash), UNIQUE KEYtitle(title), KEYusername(username), KEYvisible(visible), KEYadded(added), KEYupvotes(upvotes), KEYdownvotes(downvotes), KEYlast_answer(last_answer), KEYlikes(likes), KEYcomments(comments), KEYthanks(thanks), KEYhits(hits), KEYlast_reply_username(last_reply_username), KEYlast_thanks(last_thanks), KEYstatus(status), KEYrefered_by(refered_by), KEYbrowse_index(forumid,hidden,style), KEYforumid(forumid), KEYstyle(style), KEYlast_vote(last_vote), KEYhidden(hidden,style), KEYcid(cid), KEYoptions(options), FULLTEXT KEYtitle(title), FULLTEXT KEYsearch(search), FULLTEXT KEYgenre(genre), FULLTEXT KEYtags(tags) ) ENGINE=MyISAM AUTO_INCREMENT=610700 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci 显示类似“posts”的表状态 { "data": [ { "Name": "posts", "Engine": "MyISAM", "Version": 10, "Row_format": "Dynamic", "Rows": 146228, "Avg_row_length": 251, "Data_length": 36803536, "Max_data_length": 281474976710655, "Index_length": 80322560, "Data_free": 0, "Auto_increment": 610707, "Create_time": "2018-11-08 00:21:32", "Update_time": "2018-11-09 00:46:14", "Check_time": "2018-11-08 00:27:52", "Collation": "utf8_unicode_ci", "Checksum": null, "Create_options": "", "Comment": "", "Max_index_length": 288230376151710720, "Temporary": "N" } ] } 哪个客户端正在发出查询？
我试过不同的客户。这个问题与客户无关。
哪个版本的mariadb？
10.3.10