摘要：Binlog was disabled at last week, this improve the I/O efficiency.Besides, I've done a minor changes for myisam buffer, changed from 64M to 128M at last week.query_cache_size=64Mquery_cache_limit=2Mjoin_buffer_size=4Mtmp_table_size=128Mmax_heap_table_size=128Mkey_buffer_size=90MORquery_cache_siz 阅读全文

摘要：1 SELECT * 2 FROM `users` 3 WHERE `name` LIKE CONVERT( _utf8 '%\\_1@%'）注意，使用的是LIKE%string%,如果条件中包含特殊字符，请加转义符\ 阅读全文

摘要：http://tech.it168.com/db/m/2007-04-18/200704182228406_1.shtml 阅读全文

摘要：1 SELECT CASE WHEN status=1 THEN 0 ELSE 1 END FROM {access} WHERE type = '%s' AND LOWER('%s') LIKE LOWER(mask) ORDER BY status DESC 阅读全文

摘要：MySQL同主机不同数据库的复制命令：注意运行在Terminal中，不运行在MySQL命令行中。1 mysqldump Portal_DEV -u root -ppassword1$ --add-drop-table | mysql Portal_Optimize -u root -ppassword1$在复制过程中，出现如下报错：1 ERROR 1153 (08S01) at line 1160: Got a packet bigger than 'max_allowed_packet' bytes2 mysqldump: Got errno 32 on write需要将my 阅读全文

摘要：援引至以下链接。1 blog.51yip.com/mysql/1042.html#more-1042 阅读全文

摘要：援引至以下链接。1 http://www.gosoa.com.cn/mysql-%E9%94%81%E8%A1%A8%E6%9C%BA%E5%88%B6%E5%88%86%E6%9E%90/解决的方案： MySQL读写分离。 阅读全文

摘要：1 update content_type_center set field_center_url_value = replace(field_center_url_value,'_https://portal.xxx.com','_http://www.yyy.com'); 阅读全文