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?
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.
When I hit my server's domain it redirects me to one of the hosted sites' domain with a 302 redirect. It used to return the default plesk server page. How can I cancel the redirect?
View 2 Replies View RelatedI have a VPS that gives me
Disk Space 30 GB
Bandwidth 900 GB
Guaranteed RAM 512 MB
IPs 5
My Problem is that I can't run webstats or my RAM maxes out causing all kinds of problems. Normally my privvmpages is around 200,000 out of an allocation of 500,000 but with webstats on that goes through the roof.
What can I do? Do I have to get more RAM? I can buy more ram but it is kind of pricey.
Would switching to Plesk solve my problem? I heard it uses less resources. But I have never used it before.
We deployed a subscription (through PBAS), and realised afterwards that the database resource was missing.
This has now been added and the subscription synchronised.
However, the MySQL system is still not available on the subscription. How can we enable the MySQL (or indeed any added resource) after the subscription has been deployed.
I saw for Webspace you can add additional webspace, is there a similar feature for the Databases?
I want to set plesk to allow the overuse for disk space and bandwidth for my customers, but not for e-mail accounts.
If I do not allow overuse, what exactly happens when a customer exceeds the use of resources? The plesk panel immediately stops all the customer's services? Or what?
Moreover: is there a diagnostic utility to understand if the plesk panel is working correctly and is correctly installed?
I would like to Mysql 5.6 installed on Plesk 12. Is that possible? How does it work?
View 1 Replies View RelatedHow to upgrade mySQL from version 5.1 to version 5.5 on linux. We're running CentOS version 6.3 with Plesk 11.09.
The approach outlined here [URL] .... seems like the way to go. I want to be sure that I don't adversely affect our installation.
If it is at all relevant we're running a Joomla 2.5 site.
Few weeks ago I experienced storage issues on my VPS. I made webspace copies manually cos I know ovh's standard line means:
- copy is forbidden and vm umount impossible.
Reported machine came back to me but with few broken files. That's why I made a copy... Did know the risk. Their cloud line is acceptable - let's say... But I bought that cheap classic 3 for 12 months
Redundant != copy. But while runing production services, company webspace like I do, it's needed! So it would be fantastic feature from Plesk! Definitely needed! Is it possible?
I have a problem with connection to MySQL database over PHP.
If I define host address '127.0.0.1' works well. Problem occurs if host address is 'localhost'.
How to allow both 'localhost' and '127.0.0.1'?
With one from another server. Now roundcube does not want to connect to mysql anymore, i tried to edit this :
line:$rcmail_config['db_dsnw'] = 'mysql://roundcube:randompassword@localhost/roundcubemail';
i then used a MD5 generator to input the hash in the password field of the roundcube user in mysql, with no luck...I even tried to delete roundcube user from mysql, then remove psa-roundcube, then go through the plesk update manager and install roundcube again, did not change nothing, it didn't even create the roundcube user.
Is there anyway i can reinstall roundcube from scratch?PPP 11.5 up to date on ubuntu 12.04
Code:
[05-Oct-2013 14:03:54 +0200]: DB Error: _doConnect: [Error message: Access denied for user 'roundcube'@'localhost' (using password: YES)]
[Native code: 1045]
[Native message: Access denied for user 'roundcube'@'localhost' (using password: YES)]
[code]....
I'm still using Plesk 11.5.30 and MySql 5.5.39. That was discribed here how to update. But i need to have a MySql 5.6.5 (minimum) for some software (This version is over 2 years old). I'm using CentOs 6.5. and PHP 5.4.33
how to do this, whitout breaking plesk 11.5.30??
i have installed phpMyAdmin becouse I don't like the limitation of db management of Plesk, but I can't find the root password to access in it. I read that Plesk rename "root" user in "admin", but I can't find the password. Where is it?
View 4 Replies View RelatedI need to upgrade mysql from 5.1.73 to 5.7 but I have applications like lms, cms, and websites that runs with that version with no problems, my question is: Some of you had problems upgrading mysql, because i kwon plesk runs over mysql y i don't want to mess up with plesk.
View 1 Replies View RelatedI see that Plesk 12 supports MySQL 5.6, but the server I am running is Ububtu 14.04 LTS and comes with 5.5.
I need to make 5.6 available but I can see no way of doing it without breaking Plesk (I already tried just installing it from command line with apt-get install and had to restore the whole server from backup!) - there is no option for MYSQL in Plesks updates & upgrades menu ...
Did 12.0.18 comes with default maria DB instead of mysql ??
View 2 Replies View RelatedI've have a problem with a server : we have create as usual certificate with Tools > SSL certificates.
When we want to put certificate with the domain, we don"t have the "Secure your sites" menu in the "websites and domains" sub category.
Why ? How can i activate the certificate with the domain ?
For a Magento shop I want assign a dedicated IP to a domain. When I choose this second IP in “Subscriptions” --> Change Hosting Settings” and then select this IP under “Tools and Settings --> IP Addresses” as dedicated (or shared too) for this domain, calling the domain results in the Webserver´s default Plesk Page.
The Shopsite is not shown, but was working well with the shared standard IP.
Calling the IP directly with the browser shows the start page of the shop in raw HTML ( no CSS ).
Choosing a link results in a “Not found” page.
I am trying to change the default php settings under domain (upload_max_filesize & post_max_size) but nothing happens. I am running PHP 5.5 in FastCGI. I also changed it to Centos default PHP (5.4.16) but nothing happens again. It only works when PHP runs as Apache module. The problem is on FastCGI Application.
My server: Centos 7, Plesk 12 Check the screenshot for installed components.
Plesk 12. Using the "Corporate/Business" -> "Power User view".
Where do you add a Domain Alias? The webspace has no option to add this and all documentation I've found so far seems to indicate there should be a button that says add domain or add domain alias.
How I create DNS in Plesk for a domain?
Dedicate server from server4you with centos.
There is some problem with my email and developer tell me this yesterday:
To view DNS records for a domain you need to (after loging in as admin) click on the domain name, then choose DNS Settings. Mx record is configured correctly there, but they are not taken into consideration.
You should change the nameservers from the registrar to the nameservers of your hosting. Right now the following are used: ns-canada.topdns.com. hostmaster.topdns.com .
They should be either the nameservers received from the hostings, or if you did not received any then you will have to create them, on the registrar side and on your hosting side.
So you should go to your registrar and change the nameservers for your domain. Do not just change the ip for the main A record. After you do this you will need to wait a while for the changes to propagate.
On my registrar have i set in my server ip but when him do a test here: [URL] ....
I want to setup a domain alias without www in front of it. A quite simple task in the past...but not with Plesk 12. So I have a service domain (for example: service.com) that I use for ALL clients. But each client has only a subdomain of it as alias in his account. so client1.service.com, client2.service.com....and so on. And only that subdomain...nothing more...for each account. How to achieve that in Plesk 12?
View 1 Replies View RelatedError: IP addresses for mail service of domain <domain> are not set..This is error I'm getting. It was working some time ago, but now I cannot create new domain.
View 19 Replies View RelatedIs there a way to see what domain is getting hit when I have a huge traffic spike? Not the daily report, but in real time? Like when it is happening?
View 1 Replies View RelatedIt seems to me that the panel is not DNS Template for any domain.
Plesk v. 12.0.18
How can I configure a domain in plesk panel in order to show the domain with www (www.domain.tld)
Is the propertie "Preferred domain" in plesk 11.5 but in plesk 11.0.9 does not exist. How can I configure this?
We are running Plesk 12.0.18 with MySQL (Server Version: 5.5.33-MariaDB - openSUSE package) on OpenSuSE 13.1
MySQL is running in strict mode and its fine for the most of our customers. But some are trying to run Contenido, thats a CMS, which could work with this mode and we have to disable mysql strict mode.
So my question is: Is it possible to disable mysql strict mode just for choosen customers?
I've enabled one more php using this guide: [URL] .... but mysql is not working with the new php installation, how to get it working?
View 7 Replies View RelatedAfter changing my web hosting (same system : VPS, same version of linux : CentOS 6 , but passage from Plesk 11 to 12), i am now unable to connect remotely via TCP-IP to my mysql databases (with third-party tools like Mysql Workbench, Toad...) ! I never met this problem before.
The only way to connect is to use a "Standard TCP-IP over SSH" connection method ... but i don't want (i did'nt need this method before) !
Though, remote connections are allowed from any host in the settings.
I am using Parallels panel 11.5.30 Update #44 on CentOS 6.5 (64bit version) located on VPS. What is the easiest way to update:
- PHP 5.3.3 to PHP 5.5.12 (current stable version) and
- MySQL 5.1.73 to MySQL 5.6.18 (current stable version).
Is it possible to update these from Plesk's control panel?
I try to change a mysql user password, but I get an error message:
Fehler: attribute name is invalid: status
Search for related Knowledge Base articles
I'm running12.0.18 Update Nr. 39