Adult Script Pro Community Forums

The forum is here for legacy reasons. No new posts will be created. User registration is disabled! If you have any questions, please email us or check https://www.adultscriptpro.com for more details!

You are not logged in.

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

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)

Offline

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

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

Offline

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

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

Re: Creating sort index

1,6millions

Offline

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

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

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: 128

Re: Creating sort index

hellllo???

Offline

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

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

Offline

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

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

Offline

Board footer

Powered by FluxBB