|
إنضمامك إلي منتديات استراحات زايد يحقق لك معرفة كل ماهو جديد في عالم الانترنت ...
انضم الينا
#1
| ||
| ||
Hello, We have vbulletin 3.8.6 Posts: 4,679,968, Members: 73,762 There is a web server and a separate database server. We are running the default vbulletin search, which is slow. We'd like to speed it up and therefore implement FULLTEXT search. To do this we are supposed to run the queries ALTER TABLE vb3_post ADD FULLTEXT INDEX (title,pagetext); ALTER TABLE vb3_thread ADD FULLTEXT INDEX (title); I duplicated my database to run these queries in case there was a problem. I went to the command line and in mysql ran the first query. It ran for 20 minutes and then the database server was locked up with 'too many connections.' I canceled the query and then because the server was still saying 'too many connections', I restarted mysql and it was fine. Is there a way to run the queries so that they don't use up so much resources? Will turning off vbulletin make a difference to the duration of the query? How long do you think the query would take? Would it help if I doubled my database server's memory? Its currently 4GB. __DEFINE_LIKE_SHARE__ |
مواقع النشر (المفضلة) |
أدوات الموضوع | |
انواع عرض الموضوع | |
| |