DSM-G600, DNS-3xx and NSA-220 Hack Forum

Unfortunately no one can be told what fun_plug is - you have to see it for yourself.

You are not logged in.

Announcement

#1 2009-11-17 20:24:41

esebag
Member
Registered: 2008-01-28
Posts: 60

Slow performance with Wordpress (PHP and MySQL)

More newbie questions:

I suppose it isn't recommended to install Wordpress on the NAS(DNS323). Server response is really slow. I have PHP and MySQL running fine with lighttpd (ffp 0.5).
Is there anything I can try to speed things up? I am pretty sure i followed a guide that had me copy the my-small.cnf file somewhere.

Also, i cannot access my Wordpress blog from outside my home. My 'Wordpress' folder is located inside the 'pages' folder (within 'www'). I can access my website which only shows the Wordpress folder. When I try to access the Wordpress folder, ':8080' is automatically added at the end of the url address and i get a connection time-out error. I initially forwarded port 80 to port 8080 on the DNS to eliminate having to type :8080 at the end of my url.

Thanks.

Oh, and can anyone recommend a good way to stream music and video files from the DNS over the internet?

Offline

 

#2 2009-11-17 23:10:23

wortelsoft
Member
From: Netherlands
Registered: 2009-06-08
Posts: 52

Re: Slow performance with Wordpress (PHP and MySQL)

I would have a look at this and try to get it working with sqlite, that's a lot less resource (memory) hungry then mysql.

http://wordpress.org/extend/plugins/pdo … tallation/

Offline

 

#3 2009-11-19 00:51:37

esebag
Member
Registered: 2008-01-28
Posts: 60

Re: Slow performance with Wordpress (PHP and MySQL)

Thanks, although now i have to configure some files properly. I am getting the following error when trying to access my blogsite:

'PHP installation appears not to have the right PDO drivers loaded'

Here are the steps i've taken:
- uninstalled MySQL
- installed funpkg sqlite-3.5.6-3
- edited the file php.ini to allow for extension=pdo.so and extension=sqlite.so
- restarted lighttpd
- installed PDO For Wordpress
- edited wp-config.php file to add 'define('DB_TYPE', 'sqlite');' after the line 'define('COLLATE','');'

Offline

 

#4 2009-11-19 09:43:53

wortelsoft
Member
From: Netherlands
Registered: 2009-06-08
Posts: 52

Re: Slow performance with Wordpress (PHP and MySQL)

Make a text file and paste the following:

Code:

<?php 
echo '<pre>';
print_r(PDO::getAvailableDrivers());
echo '</pre>';
?>

Save the file i.e  driver.php and put it in the folder were your configured your webserver root.
Now use your webbrowser to go to http:\\nasname(:portnumber)\driver.php

This should give an output like below:

Code:

Array
(
    [0] => mssql
    [1] => mysql
    [2] => sqlite
    [3] => sqlite2
)

Offline

 

#5 2009-11-19 16:13:26

esebag
Member
Registered: 2008-01-28
Posts: 60

Re: Slow performance with Wordpress (PHP and MySQL)

Hi, here is what i get with the driver.php file i created:

Array
(
    [0] => sqlite2
)


I am not sure what this means. Perhaps I have to install a previous version of sqlite?

Offline

 

#6 2009-11-19 21:14:46

wortelsoft
Member
From: Netherlands
Registered: 2009-06-08
Posts: 52

Re: Slow performance with Wordpress (PHP and MySQL)

I think that it means that you have sqlite version 2, if I run the above php on my nas I get:

Code:

Array
(
    [0] => sqlite
)

If you use the following in a .php file you get even more info:

Code:

   <?php 
  phpinfo();
?>

I have sqlite 3 running on my nas (don't have wordpress though)

Handy tutorial http://hasin.wordpress.com/2009/09/22/c … -platform/

Offline

 

#7 2009-11-21 16:49:33

esebag
Member
Registered: 2008-01-28
Posts: 60

Re: Slow performance with Wordpress (PHP and MySQL)

I'm pretty sure i installed SQLite3 . This is confirmed to me when I access the SQLite prompt via ssh session. I access SQLite using 'sqlite3' which then returns v3.5.6 to me. 

The strange thing is that phpinfo is telling me that i have SQLite2 PDO drivers enabled and that i am running SQLite 2:

--->
SQLite support    enabled
PECL Module version     2.0-dev $Id: sqlite.c,v 1.166.2.13.2.12 2008/12/31 11:17:44 sebastian Exp $
SQLite Library     2.8.17<----

Offline

 

#8 2009-11-24 11:51:05

wortelsoft
Member
From: Netherlands
Registered: 2009-06-08
Posts: 52

Re: Slow performance with Wordpress (PHP and MySQL)

Did some reading I think sqlite comes with php, but no complete sure.

But read in the other thread that using sqlite wouldn't make a lot of difference.
I used because it was said that it uses less memory, and memory is lacking on the dns323.

Offline

 

Board footer

Powered by PunBB
© Copyright 2002–2010 PunBB