How To Give All Resources To MySQL
Aug 16, 2008
I got a dedicated server running, which is administered by DirectAdmin, which I mainly use as a mysql server. Now my question would be, what would I do to give all resources possible to mySQL? I mean I don´t wanna take down directadmin and setup mySQL only, so I want to keep directadmin but give almost all server resources to mySQL?
What I did so far is adjust all tables, do indexes and stuff.
The background is that at certain times I face server loads of 40 caused by many external servers of mine querying the mySQL database on the server I am talking about.
So while the load is mainly below 0.1 it sometimes goes up to 40. So this peak I wanna slow down a little bit by giving all resources to mySQL. To say that beforehand splitting the queries from external servers is not an option - they all need to be done at the same time.
So I would really be interested and thankful in what you would advice to do to optimize the mySQL service?
BTW system is running on debian.
View 14 Replies
ADVERTISEMENT
Jul 3, 2015
I am migrating some clients between Plesk panels ...
After migrate 10 domains the Health monitoring growup from MSQL from 1gb to 4.5gb
All 10 websites are small, how can i see to identify which domain/subscription is consuming a lot of resources?
View 6 Replies
View Related
Apr 11, 2008
I am trying to make a free shell service, and i was wondering if it was possible using a FreeBSD VPS, with CPanel, and additional IPs. Or would a dedicated server be required to do that?
View 11 Replies
View Related
Mar 10, 2008
I can see that almost all the web hosting companies have been overselling. Can anyone give some suggestion.Tell me a couple of non overseller.
View 14 Replies
View Related
Jun 2, 2008
I've sent in for my refund over 7 days ago and still nothing. I've also got a ticket here which hasn't been replied to within 72hours. Pc-Core just give me my refund all I want is my money. I'm sorry you might be busy or something but just give me my money.
I've been waiting forever you should just give me my money!
View 7 Replies
View Related
Jun 29, 2007
Speaking from personal experience only, who are the good, helpful hosts, who can give a reseller account, with servers physically located in the UK, giving 20Gb Bandwidth and 1Gb Disk space, has excellent email support (in English!!!!!) within 20 minutes of sending the email, full access to Cpanel including access to HTAccess, all for less than 20 pounds a month.
View 9 Replies
View Related
Apr 30, 2009
My quetsion is just the title,i have not build a website by myself,and i have not enough money to do it.
Now i want to creat a site,so could you tell me which site have free host,and it support php and sql.
View 3 Replies
View Related
Jun 1, 2009
The'v changed their homepage design and this time I personally think that the old design was a bit better than the new one,This one might work In terms of performance but I personally think that the new design might not work out pretty well.
View 14 Replies
View Related
Apr 6, 2009
My dedi host, was having all sorts of problems with simply just setting up a box, taking them roughly a week, and I'm still waiting for a resolution.
Anyhow,
Windows validation failed, I contacted them to open up a ticket, They wanted the password to root because I've changed the default password they gave me, so I gave them the password
(1)Should I not be doing this, or do you have to give them the password when they ask.
(2)Can this have been resolved without giving them password to root.
They said it'd be resolved in an hour, I emailed them back and they said they'll email me when it's done. But they've closed off the ticket.
(3)Issue hasn't been resolved, how's anyone going to be working on it if the ticket is closed? Shouldn't that ticket be left open till the issue is resolved?
Wow I'm so green behind the ears with all this stuff.
View 4 Replies
View Related
Jul 21, 2008
I've been with JaguarPc since 1999 and I just realized that through all my years here I never gave them a shout out. These guys are very helpful and it's amazing the type of service they offer for the money. I have 2 virtual private servers with them and absolutely no issues. They manage the entire server for me for $33.95 a month. So if anybody needs good hosting:
[url]
View 10 Replies
View Related
Nov 26, 2007
I know nothing of server management, nothing about how to manage my VPS Can't even install a simple software and do not know how to secure my VPS on the other hand I am so busy I can't learn at least for a few months have trouble
Should I go back to share hosting?
View 14 Replies
View Related
Apr 19, 2007
I've got an older "Super Server P4" series server @ ThePlanet - it's been a great box for years. We recently upgraded php4 to php5 and did a mysql upgrade as well. Ever since, randomly, without warning, Apache stops terminating connections, so the max connections fills up, and httpd won't respond. Apache doesn't stop running, it just max's out and stops accepting new connections, so customers assume the server is "down", although email/FTP work fine.
The server never crashes, the loads stay down, but httpd just fills up and won't accept more connections. We can't increase max connections (we actually DECRESED IT), because they'll just keep piling up, never terminating, and then ultimately, it will crash the box.
My admin has worked for nearly 2 weeks trying to figure it out, and Scott (AtomicRocketTurtle) and his team have been evaluating it for about a week - it's happened 3x in 2 days ... last night, httpd quit responding for about 7+ hours and since we didn't have httpd monitoring, we never knew until the office opened this AM and I had two very angry customers. Scott suspects it may be some rogue application that triggers it that didn't affect it prior to the php5/mysql upgrades.
Both Scott and Parm, my admin, have about thrown in the towel and are recommending we retire the server and migrate to a new box.
It's older - much older .. I'm pasting specs below, RHEL3, Plesk 7.5 .. but just wonder, before retiring an old server that was RUNNING GREAT prior to the upgrade, maybe someone has seen this happen before?
If so - PLEASE LET US KNOW before I spend the $$$ on a new box.
Current box's specs:
CPU GenuineIntel, Intel(R) Pentium(R) 4 CPU 2.80GHz
Version psa v7.5.4_build75060118.18 os_RedHat el3
OS Linux 2.4.21-47.0.1.ELsmp
RAM: 1GB, with 2GB swap
apache 1.3.31
bind 9.2.4-20.EL3
coldfusion Component was not installed
coldfusion-support 7.3-2.96.128
courier-imap 3.0.8-rhel3.build75050824.12
drweb 4.32.2-rh7_psa
drweb-qmail 4.32-rhel3.build75050824.12
frontpage 5.0.2.2634
httpd 2.0.46-61.ent
jdk 1.4.2
logrotate 3.7
mailman 2.1.5.1-25.rhel3.7
mod_perl 1.99_09-10.ent
mod_python 3.0.3-5.ent
mysql 4.1.21-2.rhel3.art
perl-Apache-ASP 2.57-rhel3.build75050824.12
php 5.0.4-13.rhel3.art
phpmyadmin 2.5.3
phppgadmin 2.4.2
postgresql 7.3.6-7
postgresql-server 7.3.18-1
proftpd 1.2.9
psa 7.5.4-rhel3.build75050824.12
psa-agent 1.3.2-2_psa7.1
psa-api-rpc 7.5.4-rhel3.build75050930.11
psa-bu 7.5.4-rhel3.build75050926.17
psa-horde 3.0.5-rhel3.build75050824.12
psa-imp 4.0.3-rhel3.build75050824.12
psa-logrotate 3.7-rhel3.build75050824.12
psa-manual-custom-skin-guide 7.5.4-rhel3.build75050824.12
psa-migration-manager 7.5.4-rhel3.build75050930.11
psa-proftpd 1.2.10-rhel3.build75050824.12
psa-qmail 1.03-rhel3.build75050824.12
psa-qmail-rblsmtpd 0.70-rhel3.build75050824.12
psa-spamassassin Component was not installed
psa-tomcat-configurator 7.5.4-rhel3.build75050824.12
psa-turba 2.0.3-rhel3.build75050926.17
qmail 1.03
rblsmtpd 0.70
samba 3.0.9-1.3E.12
spamassassin 3.1.3-1
SSHTerm 0.2.2-rhel3.build75050824.12
stunnel 4.04-4
tomcat 4.1.24-full.2jpp
webalizer 2.01_10-15.ent
View 4 Replies
View Related
Oct 24, 2007
do any vps providers give over 100gig of space and 20mbs
View 6 Replies
View Related
May 22, 2009
if i can lock a file from being downloaded or viewed in ftp editor even if i give some one ftp access?
View 3 Replies
View Related
Feb 24, 2008
I have taken over management of a bunch of a dedicated servers and have a question.
What are the commands on Linux (RedHat, RHL) for giving a User access rights to a directory(ies) only.
So that this user can FTP and Telnet to the server but will be able to:
1- only upload files to these directory(ies)
2- only delete files/dirs from these directory(ies)
3- only execute programs residing in these directory(ies)
View 3 Replies
View Related
Nov 27, 2008
What you guys think about liquidweb hosting?
how fast the speed is? i have doubt because when i visit their main page are slow but i read some feedback its good
View 12 Replies
View Related
Feb 15, 2008
I'd like to give my username on my server permission to access g++ to compile custom C++ programs. I know I can just su - and compile as root, but I really don't like that.
What do I need to do to allow ONLY my username permission to do that?
View 4 Replies
View Related
Nov 13, 2013
I have WHM and Cpanel on my dedicated server. Is there a way to give them access to change this? I dont want then to have access to everything either.
Edit your httpd.conf file.
Timeout 50
KeepAlive On
MaxKeepAliveRequests 120
KeepAliveTimeout 10
MinSpareServers 10
MaxSpareServers 20
StartServers 16
MaxClients 125
MaxRequestsPerChild 5000Â
View 4 Replies
View Related
Apr 17, 2009
I have the same error mentioned in this old tread:
[url]
Once in a while the user have "Internal server error"
when accessing any php page.
The php is php v4 compile as fastcgi on Centos 5.
The warning/error sequins is always like this:
[Fri Apr 17 09:09:49 2009] [warn] FastCGI: (dynamic) server "/home/fastcgi-scripts/abc.fcgi" (pid 22726) termination signaled
[Fri Apr 17 09:09:49 2009] [warn] FastCGI: (dynamic) server "/home/fastcgi-scripts/abc.fcgi" (pid 22726) terminated by calling exit with status '0'
[Fri Apr 17 09:09:49 2009] [error] [client 127.0.0.1] FastCGI: incomplete headers (0 bytes) received from server "/home/fastcgi-scripts/abc.fcgi", referer:
[url]
View 2 Replies
View Related
May 30, 2008
I am just curious, I know that it is a great customer retention hook, but really, and how about unlimited bandwidth? This is my first post on the forum, and I will be asking many more questions as I want to get the inside scoop before I take the reseller plunge.
At first glance it seems as though the advertising is throughout the site and not just in the advertisement section. I know it's only $7.95, but for life? I guess if they're paying for 2 years at a time, but month to month there is no way. They would end up with a ton of registered domains, and allot of parked domains. Oh well just thought I would ask.
View 15 Replies
View Related
Apr 14, 2008
I have an account on godaddy, with more than 20 domains registered and well, so far i have been in charge of the updates of these domains and the websites they represent. But now I have this customer who is asking me to have access to his specific domain so he can upload files by him self, the thing is that i dont have a clue of how to do it. I tried to create a new account in godaddy for this customer and tried to transfer this domain into his account and I was not allowed to. I cannot give him my username and psw cause he wont only have access to his website but all those i have registered under my account. I will really appreciate some advises to help me work this out.
View 4 Replies
View Related
Oct 13, 2008
I want to transfer hosts right now but I still have 9 months with my old host. Do you know of any hosts that will transfer this time when I move to them? I have seen this on a few sites but forgot where
View 14 Replies
View Related
Aug 4, 2008
I have a software program on my home PC that writes to files on my remote VPS every few minutes.
The only way I can accomplish this is to CHMOD the files to 777 and give the whole world write priveledges.
Is there a way I can give my external (home) IP address write priveledges to certain files on my VPS without CHMODing them as 777?
I run the latest version of cPanel and WHM on my VPS.
View 6 Replies
View Related
Apr 14, 2015
1 have to create a new user, for example "webmaster" with ftp access, plesk access and database access.
My problem is: after i make all, this user can see all database for this domain. Can i show him only 1 database (him database)? If yes, how i can do?
View 2 Replies
View Related
Feb 16, 2015
My reseller have got one plan, where option "Gestion de l'accès au serveur via SSH" (Manage SSH access to server) is on "Peut autoriser l'accès uniquement à un environnement chrooté" (Can autorize access only in chrooted environment).
This plan contains only one subscription in which I would like to permit users to use sftp. If I go in the subscription, and then I click on "Customize subscription", I can see option "Gestion de l'accès au serveur via SSH" (Manage SSH access to server) is on "Peut autoriser l'accès uniquement à un environnement chrooté" (Can autorize access only in chrooted environment)...
=> So same than in the plan.
After that, when I click on subscription => WebSites and Domain => One domain => FTP Access and I choose a ftp user, I don't have any option to allow ssh access to the user.
View 4 Replies
View Related
Jan 18, 2015
I'm using Plesk Panel 12 on Debian GNU/Linux 7.6 server. I created a ftp user in a subdomain (sub.domain.tld) of my domain (domain.tld).
In Tools and settings = Policy security, I allowed sftp and ftp connections. When I try to connect I get this message :
Code:
sftp my_user@domain.tld
Connection closed
In the password file I got :
Code:
my_user:x:10000:1003::/var/www/vhosts/domain.tld/sub.mydomain.tld/httpdocs:/bin/false
View 15 Replies
View Related
Feb 22, 2007
I am running a cPanel/WHM VPS and would like to know what sort of resources CSF takes?
View 1 Replies
View Related
Mar 30, 2009
I just want to complain about HostICan.
I am a affiliate partner of HostICan.
From Jan.2009, they give me the wrong report about the sales on my file, the sales and commissions were alway be zero.....
I am a web designer, so I am very sure that my clients they signed up to HostICan from my site.
When they signed up to HostICan, I was by their side.
But there was still no sales and commissions showing on my file.
I have sent the tickets to them 5 times from Feb.2009, but they didn't reply me any.
I ask them at the live chat, the person at live chat always told me that I have to create a ticket to their affiliate department.
HostICan....well...I think maybe he/she is cheater, or they have some problems with their financial affairs?
I live in Asia, I have no idea about this! I think I have nothing can do!
Or how should I do?
My english is not good enough, thanks for your attention.
If there are personnel of HostICan this forum,
View 14 Replies
View Related
Jun 26, 2008
Being using the free version of siteuptime.com but this month alone i have had so far 3 false alerts reported, i am always in the putty and does not get interrupted, and i am sure i am around on the site too while supposedly siteuptime reports down (i am guessing firewall blocks their server ip for w/e reason). So am wondering is there any really good public tracking site out there which can do public reports more accurately and not kak out on me?
Whats your experience with siteuptime for monitoring if any ? Sometimes it works "ok" other times its just off the charts.
View 9 Replies
View Related
Apr 21, 2008
I have been with HostNine for almost a year now and have had reasonably decent service, until now.
They recently suspended one of my client's accounts. Understandable, the account had some very old PHP files on them. Let me preface this by stating that I am very sympathetic to hosts who have to deal with problem clients who have sites that slow down shared servers for everyone else on them.
I have tried my hardest to work with HostNine to get these files back and ensure that this account is not a problem on their server. I have never once asked for them to restore the account "as is", all have I have asked is that they backup the files and the database for me (I would do it myself, but they locked me out of the account), so that I can investigate the problem and do testing to ensure that it doesn't cause them problems again.
All in all, getting anyone to co-operate has been unsuccessful. Getting a hold of them has been a hassle (from the time I e-mailed them about the issue to the time I received my first response was a span of over 6 hours). Getting them to co-operate has been impossible. Their "Support Manager", Alex, in broken English has told me next to nothing, aside to accuse me of trying to "get around this" and that I would need to move the account to one of their dedicated plans. I have asked that the account simply be backed up, but have not received any response so far, as time ticks away and the client whose account this was becomes more and more frustrated as their files are effectively being "held hostage".
My last complaint is that they never notified myself, nor the client that they had suspended the account.
Has anyone else had problems with trying to get their files back after a host has locked you out of your account? What are my options? Does the hosting company technically "own" the files, simply because they are being hosted on their server?
View 14 Replies
View Related
Jun 23, 2008
Do the hsting comapny provide a system for you website for users to login or register
or do i have to do it myself
View 13 Replies
View Related
