There is a too many mysql process (because of directadmin) but i don't want to. As i read it is related with compile options.
Is there a way turn off that setting to one mysql process ? OR how can i told to directadmin that i want to one mysql process ?
mysqq has a nice value of 6, is this fine? I read somewhere that it's better at a value of -5.
View 4 Replies View Relatedon my top process am having this one as shown in the attachement image
its consuming time+ of 746:21:95
on the Process Manager that mysqld process is using the command
/usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/host.theplanet.host.pid --skip-external-locking
is that process normal? and what is cousing it? should i kill it?
I have a constant mysql process using 10-20% CPU, its very strange because the process is always present, if I restart apache and mysql and I just open the phpmyadmin or any website connecting to the DB I get this error.
With strace I have seen that the process details are:
futex(0x87326c4, 0x5 /* FUTEX_??? */, 1) = 1
futex(0x8732174, FUTEX_WAKE, 1) = 1
select(15, [13 14], NULL, NULL, NULL) = 1 (in [14])
fcntl64(14, F_SETFL, O_RDWR|O_NONBLOCK) = 0
accept(14, {sa_family=AF_FILE, path="ӿ"}, [2]) = 25
fcntl64(14, F_SETFL, O_RDWR) = 0
getsockname(25, {sa_family=AF_FILE, path="/var/run/mysql"}, [30]) = 0
fcntl64(25, F_SETFL, O_RDONLY) = 0
fcntl64(25, F_GETFL) = 0x2 (flags O_RDWR)
fcntl64(25, F_SETFL, O_RDWR|O_NONBLOCK) = 0
setsockopt(25, SOL_IP, IP_TOS, [8], 4) = -1 EOPNOTSUPP (Operation not supported)
The strace show that this piece of code is being repeated everytime that any website or app is using the database.
I have seen that the process call to the path /var/run/mysql in:
getsockname(15, {sa_family=AF_FILE, path="/var/run/mysql "}, [30]) = 0
...but in my system the path doesnt exists, its /var/run/mysqld/ and I cant find a call to "/var/run/mysql" in any file of the server (i have tryed with sudo grep -nr '/var/run/mysql' /)
Server specs:
CENTOS Enterprise 4.6 i686
Linux 2.6.9-67.0.7.ELsmp
Core2Duo E6750
PHP Version 5.2.5
MySQL 5.0.45
How can see wich user have more mysql process?
View 2 Replies View Relatedhow do I stop mysql process for good?
service mysqld stop & killall mysqld don't do anything, mysqld stop and few minutes latter it restart again.
I run httpd with lxadmin.
When i login to the root for the server and go to mysql process list i see a lot of processes that are connected to photo handling and the sate is Locked with over 500 seconds of each one.
I see there is one process that the state says: Copying to tmp table
I read online that if this is taking long it might lock up other queries causing your server to perform slow and only solution is to restart mysql servers.
Right now i have over 100 queries that say Locked and one that says Copying to tmp table....each time i have to restart the mysql services but this happens every 10 minutes as i have enough traffic to cause this problem.
in one of our dedicated servers, when we go to WHM/Service Status / CPU Memory MySQL usage.. http server and MySQL process appears all 3 times...
is that normal?
i attach an email to be more clear.
I have a single mysql process that never stops and running with 10-200% CPU load: URL....
I restart mysql => process coming back
I restart server => process coming back
I kill process => process coming back
I have run:
# mysqladmin -uadmin -p`cat /etc/psa/.psa.shadow` -i 1 processlist
but there was noting that runs >10min.
Code:
> SHOW FULL PROCESSLIST;
+------+-------+-----------+------+---------+------+-------+-----------------------+
| Id | User | Host | db | Command | Time | State | Info |
+------+-------+-----------+------+---------+------+-------+-----------------------+
| 328 | admin | localhost | psa | Sleep | 56 | | NULL |
| 8110 | admin | localhost | NULL | Query | 0 | init | SHOW FULL PROCESSLIST |
+------+-------+-----------+------+---------+------+-------+-----------------------+
2 rows in set (0.00 sec)
I have strace the PID
Code:
# timeout 1m strace -f -c -p 5873
Process 5873 attached with 30 threads - interrupt to quit
Process 10499 attached (waiting for parent)
Process 10499 resumed (parent 5873 ready)
Process 10502 attached (waiting for parent)
Process 10502 resumed (parent 5873 ready)
Process 10503 attached (waiting for parent)
[code]....
I found with google a hint for high cpu URL....I have deinstalled "health monitor" module, but that was not the reason.I use plesk 12.0.18 Update #38 with CentOS 6.6 (Final).
I am receiving errors while executing domainname.com/cgi-bin/folder/filename.cgi files in directadmin. The error is Internal server error.
I have tried the below things,
./script.cgi : no errors found
checked domain log : got premature end of script headers
checked suexec log : No errors
Checked the permission : all the files and folders under cgi-bin is 755
Where is the location of my.cnf?
I've got directadmin on this server, however I can't seem to find the mysql config file.
I've checked /etc for it, but it doesn't seem to be there?
i just sign up a directadmin vps package, this is the direct admin that i saw once i login, is quite different from the direct admin that i normally saw, is this normal?
when i check with the support, they just tell me nothing is wrong and ask me if i wan they will just rebuild the vps, any one that using direct admin vps using this kind of interface?
Quite simple - does anybody know of any Directadmin resellers?
Me (and my customers) are used to directadmin so that is the control panel I would like to use on my servers. However not all hosts offer directadmin, and that means I would have to get it from directadmin.com myself.
The main 'issue' with this is pricing. Single licenses cost $29 per month. While a reseller can get the same license for a one-time fee of $49. That means turning a profit in 1.5 months when going that way instead of single licenses.
Does anybody know of a way to buy these one-time licenses? I am aware of the fact that they do not include support, that is fine.
We've had a request to assist a transfer from LxAdmin to DirectAdmin.
We don't mind moving all the files and MySQL manually, however our main concern is copying the old emails.
All the settings (ie. mail forwarders, cron jobs) can be re-created.
how to move the MailDir from LxAdmin to DirectAdmin?
who are some of the largest, most well known or oldest running DirectAdmin hosts?
View 14 Replies View RelatedMy server is using Directadmin as the control panel..
I am not able to login the DA since last week though the password must be correct..
I have 4 ip addresses.
74.63.67.146 - my main server. I have also configured my main domain to "own" this IP address and have installed an SSL cert. The domain and the cert work correctly but when you type in the IP address in, it shows "Apache is functioning normally".
74.63.67.147 - this is owned by a client. Same thing happens as above except that the domain name and the IP address point to the Apache message.
74.63.67.148 - this is the shared IP. Everything works correctly.
74.63.67.149 - this is another owned IP and it works correctly.
The only thing that is different from 146, 147
I know I should be asking DirectAdmin this question, but I do not want to wait until Monday. I want to know if DirectAdmin allows VMware VPSes on their VPS license. I know cPanel does.
View 5 Replies View RelatedAnybody having problems installing directadmin on Fedora 9?
Right after I run the install, it does start downloading the packages but experiencing this issue after numerous tries:
100%[=====================================================================>] 2,769 --.-K/s in 0.07s
2008-09-03 13:47:29 (40.2 KB/s) - `/var/named/named.ca' saved [2769/2769]
Installation didn't pass, halting install.
may I know which version of apache and mysql are you running on your production server? Will the latest apache or mysql conflict with DA?
View 9 Replies View RelatedI'm trying to decide what panel to get, I've used cPanel and DirectAdmin before so trying to figure out which is best suited for me.
Obviously cPanel has more features but uses more ram. Do I really need all the features of cPanel or can I get by using DirectAdmin?
The server I'm going to get will have 8GB RAM so does it matter that cPanel uses more memory because there is so much ram anyway?
Anyone know a reseller for DA licenses that can be used with a vps bought elsewhere?
View 6 Replies View Relatedwhich is better, LXAdmin or DirectAdmin? I have decided to sign up with world-of-computing.com. They have a promo code for free DirectAdmin. Should I go for it or use the 25%off promo code? The virtualization technology used is OpenVZ.
Does anyone have any experience with them? I had chatted with a Sales Rep for 45 minutes and he has been really helpful. But I know that support for sales and service is entirely different.
Also which OS should I go for (CentOS4/CentOS5/Fedora7/Debian4/Gentoo4/OpenSuse 10/Ubuntu 8.04)?
If you were looking for a web host, which control panel do you want?
cPanel or DirectAdmin?
I know most will choose cPanel, but I want to find out how many choose DA and how many choose cPanel.
Is there a way to see which user is using how much cpu resources in DirectAdmin?
View 5 Replies View Relatedi am swtiching the hosting package from company A to company B. Company A is using directadmin and company B using cpanel.
How can i transfer all my mail to cpanel?
On average, how much memory does cpanel use when compared to a standard directadmin setup?
I've never had a chance to use directadmin before, but I've been reading quite a bit about it around the web and that it uses much less memory than cpanel.
Anyone used both? Which is better for VPS hosting?
Can Lighttpd be installed with DirectAdmin in this fashion:
Lighttpd - port 80
DirectAdmin on Apache - port 999
OR
Is there any performance decrease in
Apache - Port 80
Lighhttpd - port 81 (proxy between Apache)
DirectAdmin on Apache - port 999
I am using DirectAdmin and need help setting up IP addresses for specific domain names. How can I do this?
Is it in DNS management?
I have been using cPanel for long and some custom panels like DreamHost and Site5 provide.
I have seen DirectAdmin a couple of times but never used it. Now my question is that:
Why we should we use cPanel instead of DirectAdmin, when:
* DA is cheaper than cPanel.
* People says DA support is better.
* DA have nearly all features cPanel have.
* DA looks prettier than cPanel.
I could be able to state more if I have been using DA.
Now, please list your REAL world reason to not use DA but cPanel. Lets keep it on topic.
My reason, as of now, is:
* Transferring site from cPanel to cPanel is easier than cPanel to DA.
I really need at least 10 reasons for not choosing DA.
So, i need an managed linux server located in Europe. DirectAdmin account, so i can make my own resellers. Budget is 30-70 $/€ month.
Any good recommendations or experiences?
