Welcome to the GoFuckYourself.com - Adult Webmaster Forum forums. You are currently viewing our boards as a guest which gives you limited access to view most discussions and access our other features. By joining our free community you will have access to post topics, communicate privately with other members (PM), respond to polls, upload content and access many other special features. Registration is fast, simple and absolutely free so please, join our community today! If you have any problems with the registration process or your account login, please contact us. |
|
Discuss what's fucking going on, and which programs are best and worst. One-time "program" announcements from "established" webmasters are allowed. |
|
Thread Tools |
04-16-2012, 09:02 AM | #1 |
Confirmed User
Join Date: Jan 2009
Location: Texas
Posts: 523
|
Tip : Check SQL Index Fragmentation
Just noticed while doing some spring cleaning in the site's database that a lot of our most used tables had 70% + fragmentation on their indexes.
Made sure to rebuild and reorganize all of them, and they're now sitting around 0-.1% fragmented. Our DB is in SQL Server, but should apply to you MYSQL guys as well. Pretty interesting that I believe our site is pretty optimized, but you can still stumble upon something like this |
04-16-2012, 11:24 AM | #2 |
MFBA
Industry Role:
Join Date: Mar 2003
Location: PNW
Posts: 7,230
|
optimization is never over.
|
04-16-2012, 11:46 AM | #3 |
Damn Right I Kiss Ass!
Industry Role:
Join Date: Dec 2003
Location: Cowtown, USA
Posts: 32,349
|
Optimize....
|
04-16-2012, 12:04 PM | #4 |
Confirmed User
Join Date: Jan 2009
Location: Texas
Posts: 523
|
Then the host has a network issue... LOL
|
04-16-2012, 12:14 PM | #5 |
Confirmed User
Join Date: Feb 2002
Posts: 2,527
|
how do you do that on a wordpress without fucking up the db?
|
04-16-2012, 01:50 PM | #6 |
Too lazy to set a custom title
Industry Role:
Join Date: Sep 2005
Location: Springfield
Posts: 13,826
|
login at phpmyadmin -> select all database -> select all tables -> select optimize from drop down list -> confirm
you're done
__________________
Make a bank with Chaturbate - the best selling webcam program Ads that can't be block with AdBlockers !!! /// Best paying popup program (Bitcoin payouts) !!! PHP, MySql, Smarty, CodeIgniter, Laravel, WordPress, NATS... fixing stuff, server migrations & optimizations... My ICQ: 27429884 | Email: |
04-16-2012, 02:29 PM | #7 |
Confirmed User
Join Date: Jan 2009
Location: Texas
Posts: 523
|
LOL, that makes it too easy
|