Adult Script Pro Community Forums

Create, help and share your ideas with the community!

You are not logged in.

#1 2017-05-29 10:37:59

Jadmanx
Member
Registered: 2012-05-25
Posts: 127

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)

Offline

#2 2017-05-31 13:20:36

symtab
Administrator
Registered: 2010-08-23
Posts: 7,359
Website

Re: Creating sort index

how many videos do you have?


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

Offline

#3 2017-06-01 12:50:39

Jadmanx
Member
Registered: 2012-05-25
Posts: 127

Re: Creating sort index

1,6millions

Offline

#4 2017-06-01 23:53:14

Jadmanx
Member
Registered: 2012-05-25
Posts: 127

Re: Creating sort index

there a way to fix this???

Offline

#5 2017-06-05 16:22:06

Jadmanx
Member
Registered: 2012-05-25
Posts: 127

Re: Creating sort index

hellllo???

Offline

#6 2017-06-07 13:46:26

symtab
Administrator
Registered: 2010-08-23
Posts: 7,359
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 - PopAds

Offline

#7 2017-06-07 13:46:38

symtab
Administrator
Registered: 2010-08-23
Posts: 7,359
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 - PopAds

Offline

Board footer

Powered by FluxBB