怎么查看慢日志完整sql

[c_return (忘情的侠客)]

请问：INFORMATION_SCHEMA.SLOW_QUERY。慢日志里的query语句太长，有什么办法看到完整sql的吗

[龙雪刚-PingCAP (春风)]

这个问题貌似重复提了。

[zz-jason (Jian Zhang@PingCAP)]

在即将发布的 2.1.16 中 query 字段从 varchar(4096) 修改成了 longblob，应该能够看到完整 SQL 了

[mao_siyu (毛巳煜)]

你说的没错，我也去查看了表结构，我现在使用的是 TiDB 3.0.2版本

实际情况我的sql确实只有一半

"SELECT
	DcOrganizationMaster.paas_id AS paasId,
	DcOrganizationMaster.paas_is_del AS paasIsDel,
	DcOrganizationMaster.paas_create_user AS paasCreateUser,
	DcOrganizationMaster.paas_create_time AS paasCreateTime,
	DcOrganizationMaster.paas_update_user AS paasUpdateUser,
	DcOrganizationMaster.paas_update_time AS paasUpdateTime,
	DcOrganizationMaster.paas_version_no AS paasVersionNo,
	DcOrganizationMaster.paas_is_disable AS paasIsDisable,
	DcOrganizationMaster.address AS address,
	DcOrganizationMaster.organ_code AS organCode,
	DcOrganizationMaster.organ_name AS organName,
	DcOrganizationMaster.property_one AS propertyOne,
	DcOrganizationMaster.merge_to AS mergeTo,
	DcOrganizationMaster.parent_id AS parentId,
	DcOrganizationMaster.organ_type AS organType,
	DcOrganizationMaster.LEVEL AS LEVEL,
	DcOrganizationMaster.nature AS nature,
	DcOrganizationMaster.organ_used_names AS organUsedNames,
	DcOrganizationMaster.drugstore_type AS drugstoreType,
	DcOrganizationMaster.is_territory AS isTerritory,
	DcOrganizationMaster.su AS su,
	DcOrganizationMaster.bai AS bai,
	DcOrganizationMaster.erp_code_one AS erpCodeOne,
	district.name_cn AS district,
	( SELECT city.name_cn FROM dc_geography city WHERE city.province_code = district.province_code AND city.geography_type = '3' ) AS city,
	(
CASE
	
	WHEN ( SELECT province.name_cn FROM dc_geography province WHERE province.province_code = district.province_code AND province.geography_type = '7' ) IS NOT NULL THEN
	( SELECT province.name_cn FROM dc_geography province WHERE province.province_code = district.province_code AND province.geography_type = '7' ) /*非直辖市*/
	
	WHEN ( SELECT province.name_cn FROM dc_geography province WHERE province.province_code = district.province_code AND province.geography_type = '9' ) IS NOT NULL THEN
	( SELECT province.name_cn FROM dc_geography province WHERE province.province_code = district.province_code AND province.geography_type = '9' ) /*直辖市*/
ELSE NULL 
END 
	) AS province 
FROM
	dc_organization_master DcOrganizationMaster
	LEFT JOIN dc_geography distr"(len:2133);

[mao_siyu (毛巳煜)]

没找到答案啊，麻烦给个连接，谢谢你

[zzzzzz (Tz)]

在 tidb.yml 中有一个配置项可以调整这个 log

[mao_siyu (毛巳煜)]

非常感谢

[张鱼小丸子-PingCAP (zhangyuxiaowanzi)]

如果别人的回答有帮助，可以标记为解决方案✅，这样其他有同样问题的人也可以快速找到答案～

[c_return (忘情的侠客)]

嗯，好的。多谢提醒