destoon7.0数据库优化,实现秒级打开
数据库 实现 优化 打开 秒级
2023-09-14 08:57:34 时间
附上自己使用的destoon7.0数据库优化,让打开和查询速度更快,暂用内存更少
ALTER TABLE `destoon_sell_5` ADD INDEX ( `status` ) ;ALTER TABLE `destoon_sell_5` ADD INDEX ( `vip` ) ;ALTER TABLE `destoon_sell_5` ADD INDEX ( `thumb` ) ;ALTER TABLE `destoon_sell_5` ADD INDEX ( `addtime` ) ;ALTER TABLE `destoon_sell_5` ADD INDEX ( `ip` ) ; ALTER TABLE `destoon_mall` ADD INDEX ( `status` ) ;ALTER TABLE `destoon_mall` ADD INDEX ( `vip` ) ;ALTER TABLE `destoon_mall` ADD INDEX ( `thumb` ) ;ALTER TABLE `destoon_mall` ADD INDEX ( `addtime` ) ;ALTER TABLE `destoon_mall` ADD INDEX ( `ip` ) ; ALTER TABLE `destoon_buy_6` ADD INDEX ( `status` ) ;ALTER TABLE `destoon_buy_6` ADD INDEX ( `vip` ) ;ALTER TABLE `destoon_buy_6` ADD INDEX ( `thumb` ) ;ALTER TABLE `destoon_buy_6` ADD INDEX ( `addtime` ) ;ALTER TABLE `destoon_buy_6` ADD INDEX ( `ip` ) ; ALTER TABLE `destoon_quote` ADD INDEX ( `status` ) ;ALTER TABLE `destoon_quote` ADD INDEX ( `thumb` ) ; ALTER TABLE `destoon_quote` ADD INDEX ( `ip` ) ; ALTER TABLE `destoon_group` ADD INDEX ( `status` ) ;ALTER TABLE `destoon_group` ADD INDEX ( `vip` ) ;ALTER TABLE `destoon_group` ADD INDEX ( `thumb` ) ;ALTER TABLE `destoon_group` ADD INDEX ( `addtime` ) ;ALTER TABLE `destoon_group` ADD INDEX ( `ip` ) ; ALTER TABLE `destoon_exhibit` ADD INDEX ( `status` ) ;ALTER TABLE `destoon_exhibit` ADD INDEX ( `thumb` ) ;ALTER TABLE `destoon_exhibit` ADD INDEX ( `ip` ) ; ALTER TABLE `destoon_news` ADD INDEX ( `status` ) ; ALTER TABLE `destoon_info_22` ADD INDEX ( `status` ) ;ALTER TABLE `destoon_info_22` ADD INDEX ( `vip` ) ;ALTER TABLE `destoon_info_22` ADD INDEX ( `thumb` ) ;ALTER TABLE `destoon_info_22` ADD INDEX ( `addtime` ) ;ALTER TABLE `destoon_info_22` ADD INDEX ( `ip` ) ; ALTER TABLE `destoon_brand_13` ADD INDEX ( `status` ) ;ALTER TABLE `destoon_brand_13` ADD INDEX ( `vip` ) ;ALTER TABLE `destoon_brand_13` ADD INDEX ( `thumb` ) ;ALTER TABLE `destoon_brand_13` ADD INDEX ( `addtime` ) ;ALTER TABLE `destoon_brand_13` ADD INDEX ( `ip` ) ; ALTER TABLE `destoon_job` ADD INDEX ( `status` ) ;ALTER TABLE `destoon_job` ADD INDEX ( `vip` ) ;ALTER TABLE `destoon_job` ADD INDEX ( `addtime` ) ;ALTER TABLE `destoon_job` ADD INDEX ( `ip` ) ; ALTER TABLE `destoon_know` ADD INDEX ( `status` ) ;ALTER TABLE `destoon_know` ADD INDEX ( `thumb` ) ;ALTER TABLE `destoon_know` ADD INDEX ( `ip` ) ; ALTER TABLE `destoon_photo_12` ADD INDEX ( `status` ) ;ALTER TABLE `destoon_photo_12` ADD INDEX ( `thumb` ) ;ALTER TABLE `destoon_photo_12` ADD INDEX ( `ip` ) ; ALTER TABLE `destoon_video_14` ADD INDEX ( `status` ) ;ALTER TABLE `destoon_video_14` ADD INDEX ( `thumb` ) ;ALTER TABLE `destoon_video_14` ADD INDEX ( `ip` ) ; ALTER TABLE `destoon_down_15` ADD INDEX ( `status` ) ; ALTER TABLE `destoon_down_15` ADD INDEX ( `thumb` ) ;ALTER TABLE `destoon_down_15` ADD INDEX ( `ip` ) ; ALTER TABLE `destoon_404` ADD INDEX ( `url` ) ;ALTER TABLE `destoon_404` ADD INDEX ( `addtime` ) ; ALTER TABLE `destoon_company` ADD INDEX ( `catid` ) ;LTER TABLE `destoon_company` ADD INDEX (`catids`); ALTER TABLE `destoon_company` ADD FULLTEXT (`catids`); ALTER TABLE `destoon_upload_0` ADD INDEX ( `addtime` ) ;ALTER TABLE `destoon_upload_0` ADD INDEX ( `username` ) ;ALTER TABLE `destoon_upload_1` ADD INDEX ( `addtime` ) ;ALTER TABLE `destoon_upload_1` ADD INDEX ( `username` ) ;ALTER TABLE `destoon_upload_2` ADD INDEX ( `addtime` ) ;ALTER TABLE `destoon_upload_2` ADD INDEX ( `username` ) ;ALTER TABLE `destoon_upload_3` ADD INDEX ( `addtime` ) ;ALTER TABLE `destoon_upload_3` ADD INDEX ( `username` ) ;ALTER TABLE `destoon_upload_4` ADD INDEX ( `addtime` ) ;ALTER TABLE `destoon_upload_4` ADD INDEX ( `username` ) ;ALTER TABLE `destoon_upload_5` ADD INDEX ( `addtime` ) ;ALTER TABLE `destoon_upload_5` ADD INDEX ( `username` ) ;ALTER TABLE `destoon_upload_6` ADD INDEX ( `addtime` ) ;ALTER TABLE `destoon_upload_6` ADD INDEX ( `username` ) ;ALTER TABLE `destoon_upload_7` ADD INDEX ( `addtime` ) ;ALTER TABLE `destoon_upload_7` ADD INDEX ( `username` ) ;ALTER TABLE `destoon_upload_9` ADD INDEX ( `addtime` ) ;ALTER TABLE `destoon_upload_9` ADD INDEX ( `username` ) ; ALTER TABLE `destoon_category` ADD INDEX ( `parentid` ) ;ALTER TABLE `destoon_category` ADD INDEX ( `listorder` )ALTER TABLE `destoon_category` ADD INDEX ( `item` ) ; ALTER TABLE `destoon_area` ADD INDEX ( `parentid` ) ;ALTER TABLE `destoon_area` ADD INDEX ( `listorder` ) ; ALTER TABLE `destoon_comment_stat` ADD INDEX ( `moduleid` ) ;ALTER TABLE `destoon_comment_stat` ADD INDEX ( `itemid` ) ; ALTER TABLE `destoon_message` ADD INDEX ( `ip` ) ;ALTER TABLE `destoon_message` ADD INDEX ( `typeid` ) ;ALTER TABLE `destoon_message` ADD INDEX ( `status` ) ;ALTER TABLE `destoon_message` ADD INDEX ( `addtime` ); ALTER TABLE `destoon_message` ADD INDEX ( `isread` ) ;ALTER TABLE `destoon_message` ADD INDEX ( `issend` ); ALTER TABLE `destoon_online` ADD INDEX ( `lasttime` ) ; ALTER TABLE `destoon_guestbook` ADD INDEX ( `status` ) ; ALTER TABLE `destoon_keyword` ADD INDEX ( `status` ) ;ALTER TABLE `destoon_keyword` ADD INDEX ( `updatetime` ) ;ALTER TABLE `destoon_keyword` ADD INDEX ( `month_search` ) ;ALTER TABLE `destoon_keyword` ADD INDEX ( `total_search` ) ;ALTER TABLE `destoon_keyword` ADD INDEX ( `week_search` ) ;ALTER TABLE `destoon_keyword` ADD INDEX ( `today_search` ) ; ALTER TABLE `destoon_alert` ADD INDEX ( `status` ) ;ALTER TABLE `destoon_alert` ADD INDEX ( `addtime` ) ; ALTER TABLE `destoon_webpage` ADD INDEX ( `item` ) ;ALTER TABLE `destoon_webpage` ADD INDEX ( `listorder` ) ; ALTER TABLE `destoon_announce` ADD INDEX ( `listorder` ) ; ALTER TABLE `destoon_link` ADD INDEX ( `status` ) ; ALTER TABLE `destoon_member` ADD INDEX ( `regtime` ) ; ALTER TABLE `destoon_ad` ADD INDEX ( `status` ) ;ALTER TABLE `destoon_ad` ADD INDEX ( `username` ) ;ALTER TABLE `destoon_spread` ADD INDEX ( `username` ) ;ALTER TABLE `destoon_spread` ADD INDEX ( `status` ) ;#下面为全文索引 destoon_club_data 类似的模块内容全文最好都开启 其它的后台有提示 ALTER TABLE `destoon_club_data` ADD FULLTEXT (`content`);ALTER TABLE `destoon_cron` ADD INDEX ( `nexttime` );ALTER TABLE `destoon_online` ADD INDEX ( `username` ); #公司 供应 模块增加全文索引 建议用ngram版ALTER TABLE `destoon_company` ADD FULLTEXT (`company`);ALTER TABLE `destoon_company` ADD FULLTEXT (`business`);ALTER TABLE `destoon_company_data` ADD FULLTEXT (`content`); ALTER TABLE `destoon_sell_5` ADD FULLTEXT (`title`);ALTER TABLE `destoon_sell_data_5` ADD FULLTEXT (`content`); #用中文检索分词插件ngram版 MySQL 5.7.6以上版本 中文识别友好 要修改程序ALTER TABLE `destoon_keyword` ADD FULLTEXT (`keyword`) WITH PARSER ngram;ALTER TABLE `destoon_company` ADD FULLTEXT (`company`,`business`) WITH PARSER ngram;ALTER TABLE `destoon_sell_5` ADD FULLTEXT (`title`,`introduce`)WITH PARSER ngram;
相关文章
- SQL开发知识:MySQL 数据库如何实现存储时间
- Oracle数据库实现数据加锁机制(oracle数据加锁)
- 优化MySQL数据库存储优化:实现高效快速存储(mysql数据库存储)
- 优化MySQL数据库实现数据数量优化的策略(mysql数据数量)
- MySQL数据库的JDBC连接实现(jdbcmysql连接)
- MySQL 数据库连接——实现快速便捷(mysql数据库连接包)
- 『优化Oracle数据库实现大数据管理』(oracle大数据量优化)
- MySQL JAR驱动包:实现跨平台数据库连接(mysqljar驱动包)
- MySQL数据库优化:实现最佳性能(mysql数据库优化方案)
- 轻松实现MySQL读写分离,提升数据库效率!(mysql读写分离实现)
- Oracle 数据库:轻松实现结果合并(oracle合并结果)
- 的优化MySQL优化结果集:实现数据库性能最优化(mysql对结果集)
- 从结构使用MySQL数据库实现主主复制的最佳实践(mysql数据库主主)
- 如何进行MySQL内核调优?25个关键字教你实现数据库性能优化!(mysql内核调优)
- 如何实现SQL Server数据库的迁移(sqlserver据迁移)
- 利用SQLServer实现微信的数据库服务(sqlserver微信)
- 使用Oracle EXPBD实现数据库迁移(oracle expdb)
- MSSQL标识例修改:简单实现数据库性能优化(mssql 标识例修改)
- 使用CLINQ与MySQL实现高效数据库查询(c linq mysql)
- Oracle数据库实现信息共享与协同办公(db oracle)
- 使用DBMS Oracle 实现数据库性能优化(dbms_ oracle)
- 精通Oracle主键技术,实现数据库优化(oracle主键使用)
- Oracle数据库主键索引实现移动加速(oracle主键移动索引)
- Oracle实现快速切换为数据库优化提速(oracle swith)
- 使用Oracle SCN脚本实现数据库安全性优化(oracle scn脚本)
- Oracle GDS配置指南实现数据库性能优化(oracle gds配置)