MariaDB [pandanote]> select regexp_replace(post_content,'(?s)<div class=”code”>((?!<\/div>).)*?<\/div>’,”) from wp_posts where id = 997;<\/div>\n
\u3059\u308b\u3068\u3001\u5b9f\u884c\u7d50\u679c\u304c\u8868\u793a\u3055\u308c\u305f\u5f8c\u306bWarning\u304c\u51fa\u529b\u3055\u308c\u307e\u3057\u305f\u3002\u3088\u304f\u8abf\u3079\u3066\u307f\u308b\u3068\u8a18\u4e8b\u306e\u5f8c\u534a\u306b\u3042\u308b\u30b3\u30de\u30f3\u30c9\u306e\u5b9f\u884c\u7d50\u679c\u4f8b\u304c\u524a\u9664\u3067\u304d\u3066\u3044\u307e\u305b\u3093\u3067\u3057\u305f\u3002<\/p>\n
1 row in set, 1 warning (0.02 sec)<\/p>\n
MariaDB [pandanote]> show warnings;
\n+———+——+——————————————————————–+
\n| Level | Code | Message |
\n+———+——+——————————————————————–+
\n| Warning | 1139 | Got error ‘pcre_exec: recursion limit of 521 exceeded’ from regexp |
\n+———+——+——————————————————————–+
\n1 row in set (0.02 sec)<\/p><\/div>\n
<\/p>\n
\u305d\u3053\u3067\u3001Google\u5148\u751f\u306b\u805e\u3044\u3066\u307f\u305f\u3068\u3053\u308d\u3001\u300c\u3053\u306e\u3088\u3046\u306a\u8b66\u544a\u304c\u51fa\u529b\u3055\u308c\u308b\u3068\u304d\u306b\u306f\u3001thread_stack\u306e\u5024\u3092\u5897\u3084\u3059\u3068\u3088\u3044\u3002\u300d\u3089\u3057\u3044\u3053\u3068\u304c\u308f\u304b\u3063\u305f\u306e\u3067\u3001\u307e\u305a\u3001\u30c7\u30d5\u30a9\u30eb\u30c8\u306e\u5024\u3092\u8abf\u3079\u307e\u3059\u3002MariaDB 10.1.26\u3067\u306f289K\u306e\u3088\u3046\u3067\u3059\u3002<\/p>\n
MariaDB [pandanote]> show variables like ‘%thread_stack%’;
\n+—————+——–+
\n| Variable_name | Value |
\n+—————+——–+
\n| thread_stack | 295936 |
\n+—————+——–+
\n1 row in set (0.01 sec)\n<\/div>\n
<\/p>\n
\u3053\u308c\u3088\u308a\u3082\u5927\u304d\u306a\u5024\u306b\u3059\u308c\u3070\u3088\u3044\u3068\u3044\u3046\u3053\u3068\u3067\u3001mariadb-server.cnf\u306b\u4ee5\u4e0b\u306e\u884c\u3092\u8ffd\u52a0\u3057\u3001MariaDB\u30b5\u30fc\u30d0\u3092\u518d\u8d77\u52d5\u3057\u307e\u3059\u3002<\/p>\n
thread_stack=1M<\/div>\n
<\/p>\n
\u5c11\u3057\u5927\u304d\u3059\u304e\u308b\u3088\u3046\u306a\u6c17\u3082\u3057\u307e\u3059\u304c\u3001\u3053\u308c\u3067Warning\u306f\u51fa\u529b\u3055\u308c\u306a\u304f\u306a\u308a\u3001\u8a2d\u5b9a\u30d5\u30a1\u30a4\u30eb\u3001\u30d7\u30ed\u30b0\u30e9\u30e0\u4f8b\u53ca\u3073\u30b3\u30de\u30f3\u30c9\u306e\u51fa\u529b\u7d50\u679c\u306a\u3069\u3092\u9664\u5916\u3059\u308b\u3053\u3068\u304c\u3067\u304d\u308b\u3088\u3046\u306b\u306a\u308a\u307e\u3057\u305f\u3002<\/p>\n
\u3044\u3088\u3044\u3088\u672c\u756a\u3002<\/h2>\nSQL\u6587\u306e\u4f5c\u6210\u3002<\/h3>\n
\u52d5\u4f5c\u78ba\u8a8d\u304c\u3067\u304d\u305f\u3068\u3053\u308d\u3067\u3001\u3044\u3088\u3044\u3088\u4ee5\u4e0b\u306e\u30b3\u30fc\u30c9\u306b\u8a2d\u5b9a\u30d5\u30a1\u30a4\u30eb\u3001\u30d7\u30ed\u30b0\u30e9\u30e0\u4f8b\u53ca\u3073\u30b3\u30de\u30f3\u30c9\u306e\u51fa\u529b\u7d50\u679c\u306a\u3069\u3092\u9664\u5916\u3059\u308b\u305f\u3081\u306eregexp_replace\u95a2\u6570\u3092\u8ffd\u52a0\u3057\u307e\u3059\u3002
\n