by winestock » Wed Feb 20, 2013 11:49 pm
$this->bbcode_second_pass_quote('rty', 'J')ust an update....
Using MariaDB I am now able to execute my own PHP script that parses 8000+ lines of a .aiml file and then inserts 5000+ rows into a MySQL table without any problem in less than 30 seconds. Previously with MySQL, this same script would always time out with "Bad Gateway" error whenever the .aiml file contains more than 500 lines. For those who gave up or are turned off by the slow performance of MySQL 5.x, I would recommend giving MariaDb a try.
Glad you were able to get it to work. Are you using the INNODB storage engine? If you are try using the myisam stoarge engine instead. You might be surprised at how quicker access you get. At least that is what I found. Also, with myisam you can probably tweak the memory usage to be lower. The innodb engine uses a fair amount of memory.
$this->bbcode_second_pass_code('', '
default_storage_engine = myisam
')
These two scripts are great at tuning mysql (mariadb) usage:
$this->bbcode_second_pass_code('', '
wget mysqltuner.sh
wget tuning-primer.sh
')
By the way, have you looked at Monkey HTTP yet. The performance is suppose to be faster then Nginx:
http://monkey-project.com/benchmarks/ra ... nkey_nginx. I am using it on my PPv4 and it works very well.