Adult Script Pro Community Forums

Jadmanx

Member

Registered: 2012-05-25

Posts: 128

Creating sort index

i have real big darabase 6gb and my server get down everytime on "Creating sort index "
what this mean? and how to fix this?
thanks

| 4952995 | xxxX   | localhost | xxxX         | Query   | 8368 | Creating sort index | SELECT v.video_id, v.title, v.slug, v.rating, v.rated_by, v.duration, v.thumb,
                      |
| 4953005 | xxxX   | localhost | xxxX      | Query   | 8417 | Creating sort index | SELECT v.video_id, v.title, v.slug, v.likes, v.rating, v.rated_by, v.duration, v.thumb,

Last edited by Jadmanx (2017-05-29 10:38:32)

symtab

Administrator

Registered: 2010-08-23

Posts: 7,501

Website

Re: Creating sort index

how many videos do you have?

---

Adult Scripts: Adult Script Pro - Adult Search Script
Adult Advertising/Traffic: Plug Rush - EXOClick - PopAds

Jadmanx

Member

Registered: 2012-05-25

Posts: 128

Re: Creating sort index

1,6millions

Jadmanx

Member

Registered: 2012-05-25

Posts: 128

Re: Creating sort index

there a way to fix this???

Jadmanx

Member

Registered: 2012-05-25

Posts: 128

Re: Creating sort index

hellllo???

symtab

Administrator

Registered: 2010-08-23

Posts: 7,501

Website

Re: Creating sort index

from mysql you can do the following:

repair table video; optimize table video

---

Adult Scripts: Adult Script Pro - Adult Search Script
Adult Advertising/Traffic: Plug Rush - EXOClick - PopAds

symtab

Administrator

Registered: 2010-08-23

Posts: 7,501

Website

Re: Creating sort index

Also you could migrate the video table to innodb.

---

Adult Scripts: Adult Script Pro - Adult Search Script
Adult Advertising/Traffic: Plug Rush - EXOClick - PopAds