[fixed] Very slow phpMyAdmin?
-
- Starting out
- Posts: 45
- Joined: Fri Aug 31, 2007 11:19 am
[fixed] Very slow phpMyAdmin?
I turn on the WebServer and MySQL. Accessing http://<mynas>/phpMyAmin was possible but the page takes a long time to load - more than 30 secs.
I am connected to my NAS via a wireless network. Accessing NAS admin page is good and no lag.
Anyone had a similar feeling that accessing phpMyAdmin page is very slow?
I am connected to my NAS via a wireless network. Accessing NAS admin page is good and no lag.
Anyone had a similar feeling that accessing phpMyAdmin page is very slow?
TS 209
Firmware Version v3.3.0 Build 0924T
2 x 2TB Hitachi Deskstar 7K2000 HDS722020ALA330 Mirroring Disk Volume
Gallery2, PHPGedView on WebServer (Apache, PHP, MySQL), QMultimedia, QDownload, QRecording
DLink DCS 5220
MacOSX 10.6 on MacBook
Win7 on Dell
Firmware Version v3.3.0 Build 0924T
2 x 2TB Hitachi Deskstar 7K2000 HDS722020ALA330 Mirroring Disk Volume
Gallery2, PHPGedView on WebServer (Apache, PHP, MySQL), QMultimedia, QDownload, QRecording
DLink DCS 5220
MacOSX 10.6 on MacBook
Win7 on Dell
-
- New here
- Posts: 9
- Joined: Wed Sep 12, 2007 12:41 pm
I am having the exact same problem with phpMyAdmin being super-slow while the everything else seems to be working fine. I'm connected to my nas by the wire.
I am also receiving some error at the bottom of the phpMyAdmin page about "unable to load mcrypt extentions", and I am having problems setting user access for some programming buddies of mine (I'm not sure if they have to have user accounts on the NAS as well for this to work).
Any similar experiences or advice would be appreciated .
I am also receiving some error at the bottom of the phpMyAdmin page about "unable to load mcrypt extentions", and I am having problems setting user access for some programming buddies of mine (I'm not sure if they have to have user accounts on the NAS as well for this to work).
Any similar experiences or advice would be appreciated .
-
- New here
- Posts: 4
- Joined: Fri Sep 14, 2007 12:08 am
same over here
Qnap 209Pro PHPMyAdmin very very slow ????
- AndyChuo
- Experience counts
- Posts: 2388
- Joined: Thu Sep 13, 2007 11:56 am
- Location: Taipei, Taiwan
Hi Guys,
Just an alternative that you might wanna try if you only need the basics but do use it frequently.
PHPMiniAdmin
Andy
Just an alternative that you might wanna try if you only need the basics but do use it frequently.
PHPMiniAdmin
Andy
=============================================================>>>
TS-659-Pro [RAID6] rtorrent+SABnzbdplus+SickBeard+Couchpotato [Best PVR] Plex+PMS [Ultimate Streamer]
Apple iPad [Best Tablet] HTC One M8 [Mobile Phone] Samsung UA46ES6100 [My Screen] KRK Rokit 6 [Audio Speakers]
Chrome Cast [Screen Casting] Philips Hue [Personal Lighing]
Buffalo WZR-1750DHP [My Wifi Hub] D-Link DGS-1005D [Gbit Network]
=============================================================>>>
TS-659-Pro [RAID6] rtorrent+SABnzbdplus+SickBeard+Couchpotato [Best PVR] Plex+PMS [Ultimate Streamer]
Apple iPad [Best Tablet] HTC One M8 [Mobile Phone] Samsung UA46ES6100 [My Screen] KRK Rokit 6 [Audio Speakers]
Chrome Cast [Screen Casting] Philips Hue [Personal Lighing]
Buffalo WZR-1750DHP [My Wifi Hub] D-Link DGS-1005D [Gbit Network]
=============================================================>>>
-
- New here
- Posts: 6
- Joined: Sat Sep 29, 2007 10:34 am
I use the windows MySQL GUI Tools via an SSH tunnel - nice and fast and looks nice as well!!
I have only tried MySQL Administrator and MySQL Query Browser on my QNAP TS-209.
I got them from http://dev.mysql.com/downloads/gui-tools/5.0.html
I have only tried MySQL Administrator and MySQL Query Browser on my QNAP TS-209.
I got them from http://dev.mysql.com/downloads/gui-tools/5.0.html
- AndyChuo
- Experience counts
- Posts: 2388
- Joined: Thu Sep 13, 2007 11:56 am
- Location: Taipei, Taiwan
Hi lunchbox99,
nice one I tried it myself and it's strongly recommended for users who prefer GUI based MySQL administration.
Andy
nice one I tried it myself and it's strongly recommended for users who prefer GUI based MySQL administration.
Andy
=============================================================>>>
TS-659-Pro [RAID6] rtorrent+SABnzbdplus+SickBeard+Couchpotato [Best PVR] Plex+PMS [Ultimate Streamer]
Apple iPad [Best Tablet] HTC One M8 [Mobile Phone] Samsung UA46ES6100 [My Screen] KRK Rokit 6 [Audio Speakers]
Chrome Cast [Screen Casting] Philips Hue [Personal Lighing]
Buffalo WZR-1750DHP [My Wifi Hub] D-Link DGS-1005D [Gbit Network]
=============================================================>>>
TS-659-Pro [RAID6] rtorrent+SABnzbdplus+SickBeard+Couchpotato [Best PVR] Plex+PMS [Ultimate Streamer]
Apple iPad [Best Tablet] HTC One M8 [Mobile Phone] Samsung UA46ES6100 [My Screen] KRK Rokit 6 [Audio Speakers]
Chrome Cast [Screen Casting] Philips Hue [Personal Lighing]
Buffalo WZR-1750DHP [My Wifi Hub] D-Link DGS-1005D [Gbit Network]
=============================================================>>>
-
- New here
- Posts: 6
- Joined: Tue Sep 04, 2007 8:39 am
Re: Very slow phpMyAdmin?
Can you try to add / at the end? Is it better?James wrote:I turn on the WebServer and MySQL. Accessing http://<mynas>/phpMyAmin was possible but the page takes a long time to load - more than 30 secs.
I am connected to my NAS via a wireless network. Accessing NAS admin page is good and no lag.
Anyone had a similar feeling that accessing phpMyAdmin page is very slow?
http://<mynas>/phpMyAmin/
-
- Starting out
- Posts: 39
- Joined: Mon Sep 03, 2007 11:47 pm
I installed MySQL administrator but failed to connect to my TS-109. I have enabled TCP/IP Networking for MySQL server under QNAP administration page. Is there any other setting required?QNAPAndy wrote:Hi lunchbox99,
nice one I tried it myself and it's strongly recommended for users who prefer GUI based MySQL administration.
Andy
-
- New here
- Posts: 6
- Joined: Sat Sep 29, 2007 10:34 am
-
- Starting out
- Posts: 39
- Joined: Mon Sep 03, 2007 11:47 pm
-
- New here
- Posts: 6
- Joined: Sat Sep 29, 2007 10:34 am
-
- New here
- Posts: 8
- Joined: Sat Nov 03, 2007 6:03 pm
Could someone please explain how to connect via SSH tunnel and etc. Im new to this and have been using phpMyAdmin, but its very slow.
I have installed the MySQL GUI. I can connect to my NAS via PuttY.
But when i try to connect via MySQL gui i get:
"Lost connection to MySQL server during query"
when I use mysql gui, do I use the root/admin login?
I have installed the MySQL GUI. I can connect to my NAS via PuttY.
But when i try to connect via MySQL gui i get:
"Lost connection to MySQL server during query"
when I use mysql gui, do I use the root/admin login?
-
- Starting out
- Posts: 17
- Joined: Sat Oct 27, 2007 1:42 pm
Hi denya,
I think you are experiencing this problem because the default configuration of MySQL allow admin to connect from the 'localhost' only. I am little rusty on MySQL, but if I am remembering correctly you can allow remote access and setup different permission when you connect from locahost or remotely.
Please refer the MySQL documentation for more accurate information.
5.7.2. How the Privilege System Works
5.8. MySQL User Account Management
I hope that this info will help and get you up and running.
I think you are experiencing this problem because the default configuration of MySQL allow admin to connect from the 'localhost' only. I am little rusty on MySQL, but if I am remembering correctly you can allow remote access and setup different permission when you connect from locahost or remotely.
Please refer the MySQL documentation for more accurate information.
5.7.2. How the Privilege System Works
5.8. MySQL User Account Management
I hope that this info will help and get you up and running.
Last edited by sal-e on Sun Nov 04, 2007 10:50 am, edited 1 time in total.
Qnap TS-109pro (3.1.0 build 0708T) / 500GB (WD5000AAKS)