MySQL Configuration On Windows Vps
Jul 20, 2007
mysql configuration..
I'm on a windows vps with 640mb of ram and I'm always at high level of usage of ram and 100% of cpu.. obviously the website slows down and it takes about 15 seconds to show up!
I've tried to put some indexes to my db but I'm not really expert in that.
I've been also told that my problem could be caused by a wrong mysql configuration, so here it is mine:
Code:
# The MySQL server
[mysqld]
; Uncomment for use on USB key
; skip-innodb
datadir=${path}/mysql/data
basedir=${path}/mysql
bind-address=127.0.0.1
port = 3306
socket = /tmp/mysql.sock
skip-locking
key_buffer = 200M
max_allowed_packet = 1M
table_cache = 200
sort_buffer_size = 1M
read_buffer_size = 1M
read_rnd_buffer_size = 3M
myisam_sort_buffer_size = 64M
thread_cache_size = 8
query_cache_size= 16M
# Try number of CPU's*2 for thread_concurrency
thread_concurrency = 2
# Replication Master Server (default)
# binary logging is required for replication
log-bin=mysql-bin
# required unique id between 1 and 2^32 - 1
# defaults to 1 if master-host is not set
# but will not function as a master if omitted
server-id = 1
[mysqldump]
quick
max_allowed_packet = 16M
[mysql]
no-auto-rehash
# Remove the next comment character if you are not familiar with SQL
#safe-updates
[isamchk]
key_buffer = 100M
sort_buffer_size = 100M
read_buffer = 2M
write_buffer = 2M
[myisamchk]
key_buffer = 100M
sort_buffer_size = 100M
read_buffer = 2M
write_buffer = 2M
[mysqlhotcopy]
interactive-timeout
View 1 Replies
ADVERTISEMENT
Dec 4, 2008
my.cnf configuration
What should be the best configuration(my.cnf) for MySQL in this server :
AMD Athlon(tm) 64 X2 Dual Core Processor 4200+
cache size: 512 KB
speed: 2200.246 MHz
4GB RAM DDR2
350 GB HDD
my current my.cnf contains this :
[mysqld]
set-variable = max_connections=500
set-variable = max_user_connections=100
set-variable = wait_timeout=100
set-variable = interactive_timeout=100
set-variable = local-infile=0
query_cache_limit=30M
query_cache_size=64M
query_cache_type=1
max_allowed_packet=30M
old-passwords = 1
skip-networking
[client]
port = 3306
socket = /var/lib/mysql/mysql.sock
[mysqld]
port = 3306
socket = /var/lib/mysql/mysql.sock
View 3 Replies
View Related
Mar 28, 2007
After increasing to 4 Giga memory ram is still a problem exists I could see there is heavy cpu and mysql usage from the Vbulletin forum of the domain " kuwaitup.com".
The mysql configuration had been tweaked in the server and also max allowed connection had been increased to 600 from 500. and i think It is need to optimize the database " q8upcom_vb" so how we can make it ? and in my server only one site
dedicated SERVER
Intel(R) Xeon(TM) CPU 3.06GHz 4CPUS
4000mb ram
100GB type/configuration: Unknown
linux CENTOS Enterprise 4.4 i686
apache/IIS version: apache 1.3.37 (Unix)
PHP version: php 4.4.4
MySQL version: mysql 4.1.22-standard
View 11 Replies
View Related
May 6, 2007
On my Fedora Core 4 Dedicated Server i run:
# MySQL: 4.1.20
# Version protocoll: 10
# Server: Localhost via UNIX socket
This is my problem, the MaxConnection parameter by default is setup to 100 max user connections i want to adjust the limit to a resonable value because if the users go over the limit the MySQL crash and i must restart the server because the entire system don't work.... (probably this is a bug of MySQL 4.1.2 ) but i don't know because i'm not an expert user....
I spoke with Godaddy Sys Admin and they said: "...you must modify the my.cnf file and add:
Code:
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
old_passwords=1
set-variable = max_connections = (the number that you want)
[mysql.server]
user=mysql
basedir=/var/lib
[mysqld_safe]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
Ok i have modified this by adding 1000, but with this new variable the MySQL don't start.....
View 5 Replies
View Related
Jul 25, 2008
I just got a new server that has 2 quad core intel processors and 4GB of RAM. I am running about 1000 queries per second and have been having some issues where users are being denied a connection to the database every few minutes. I am not sure how to tweak the my.cnf file correctly to solve this issue. The contest of my.cnf are below:
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
skip-locking
skip-innodb
query_cache_limit=1M
query_cache_size=32M
query_cache_type=1
max_user_connections=2000
max_connections=2000
interactive_timeout=100
wait_timeout=100
connect_timeout=100
thread_cache_size=128
key_buffer=16M
join_buffer=1M
max_allowed_packet=16M
table_cache=1024
record_buffer=1M
sort_buffer_size=2M
read_buffer_size=2M
max_connect_errors=10
thread_concurrency=8
myisam_sort_buffer_size=64M
server-id=1
#[mysql.server]
#user=mysql
#basedir=/var/lib
[safe_mysqld]
err-log=/var/log/mysqld.log
pid-file=/var/lib/mysql/mysql.pid
open_files_limit=8192
View 5 Replies
View Related
Sep 21, 2007
Would there be any scripts that can optimize a Mysql configuration?
I remember seeing one but I forgot the name and lost the script
View 2 Replies
View Related
May 8, 2009
I have a dedicated windows server 2003.
I installed VPN on this server and everything seems to be ok and I can connect to my VPN server but I don't have Internet when I connect to my server.
How can I share internet in my VPN server?
I want to use this VPN for my self and for secure browsing on internet.
View 8 Replies
View Related
May 4, 2014
In my computer (Windows 7 Ultimate) I host my sites with Apache 2.2.25 - mod_fcgid-2.3.6-win32-x86 and PHP 5.4.28. In "httpd-vhosts.conf" file from Apache I have my domain set as follows and work fine (http://www.example.com or http://example.com):
Code:
<VirtualHost *:80>
ServerAdmin webmaster@example.com
DocumentRoot "D:/Apache22/vhosts/Example"
ServerName example.com
ServerAlias www.example.com *.example.com
[Code] ....
And I set up a subdomain as follows:
Code:
<VirtualHost *:80>
ServerAdmin director@example.com
DocumentRoot "D:/Apache22/vhosts/DirectorExample"
ServerName director.example.com
ServerAlias www.director.example.com *.director.example.com
[Code] .....
But when I tried to access the page: http://www.director.example.com or http://director.example.com, I was redirected to the page http://www.example.com.
I have DNS configured for "example.com" and "director.example.com". This sites is live in another server.
Error.log files for "director.example.com" and Apache is empty. How can I configure the subdomain to work?
View 2 Replies
View Related
Mar 8, 2015
I have installed Parallels Plesk 12.0.18 installed on my Windows Server. I have found issues with my DNS and SOA records having issues it says I have not configured my DNS and SOA records when I do a DNS diagnosis.
setup my configure the records for me correctly so that my domains issues could be solved. You can see a link below to know the errors I have for my domain name. I have hosted multiple domain names on the same server with Plesk.
[URL]
View 1 Replies
View Related
Apr 2, 2014
In horde how we can configure that it will send email using the logged in user login to authenticate and send the email, currently it using localhost to send the emails.
View 1 Replies
View Related
Mar 8, 2015
Plesk Windows 12, MailEnable mailserver
I added users directly to mailenable (using their migration utility to import from an old mail server which plesk does not support). The domains exist in plesk but not the individual email users/mailboxes.
Now I want to add those email users to plesk but it doesn't let (not surprisingly), when I try to add a user it returns an error: "Unable to update the mail account properties:mailmng failed: MEAOPO.Mailbox.AddMailbox failed"
My question is: How can I add the users that already exist in MailEnable to the plesk configuration? (i.e. ignore the error and add the user to the plesk database, or even better yet if plesk can read the configuration and add all users)
Tthe plesk kb articles suggest running mchk.exe but that is designed to take users from plesk and add them to mailenable, I need the reverse).
View 3 Replies
View Related
Jul 22, 2015
I have Windows Server 2012 with Plesk 12.0.18
Changing PHP Settings through control panel for domain not take effect to domain through phpinfo()
I'm trying to change upload_max_filesize and post_max_size through control panel but it don't take effect on the website.
View 11 Replies
View Related
Feb 4, 2015
I've tried to install the DotNetNuke 7.0.6 appl. over plesk. if i call the website, i get a configuration error
For example : [URL] .....
"Parser Error Message: The connection name 'LocalSqlServer' was not found in the applications configuration or the connection string is empty."
View 2 Replies
View Related
Apr 29, 2013
I can not log into to plesk right now. It's display message " Unable to read Control Panel configuration file: date_default_timezone_get() [function.date-default-timezone-get]: It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_ timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier.We selected 'Asia/Krasnoyarsk' for '7.0/no DST' instead".
View 1 Replies
View Related
Jun 29, 2015
We are hosting provider. I running Plesk 11 on Window 2008 64 bit. I have a website error as flow
HTTP Error 404.3 - Not Found
The page you are requesting cannot be served because of the extension configuration. If the page is a script, add a handler. If the file should be downloaded, add a MIME map.
View 4 Replies
View Related
Jun 27, 2014
I recently upgraded from Plesk 11.5 to 12.0. I also just got an extra IPv4-address for my server (provider is Strato), unfortunately I have some problems with adding it to Plesk.
The IP should be assigned automatically through DHCP, but when I did a Reread IP in Plesk, nothing happened. I tried to manually add the IP, but then Plesk manually configured it and I lost the IPv4-connectivity (IPv6 kept working though).
Now when I want to remove the IP, I get the following error:
Is this a bug or a problem with my specific configuration?
View 3 Replies
View Related
Aug 29, 2014
I'm unable to access my plesk control panel .its giving this error "Unable to read Control Panel configuration file";tried all available solution for permissions but the problem remains.
View 3 Replies
View Related
Jul 17, 2007
thinking of running windows with mysql and php.... the question is, how do I back up mysql nightly? also what can I use to send emails from a mail php command? how about mod rewrtie.... can you please shed some light on that..... I can look into linux, but now I am not comfrtable to have it in production as I will have to manage the server for client onsite... they do not want it to be hosted anywhere.
View 10 Replies
View Related
May 31, 2009
I am about to move my site to a dedicated server. My current site is running on PHP and MYSQL on a Linux box (shared host), but I am familiar with Windows/IIS so I decide to run the site on Windows 2008 instead of Linux on a deciated server.
Before I begin to move, I would like to ask for your experience. Have anyone here ever tried PHP/MySQL on Windows server in production environment? What are the limitations (and/or performance issues) when running PHP/MySQL on Windows?
View 14 Replies
View Related
Oct 20, 2008
My website is compiled with mysql and php.
I am deciding platform it will work on. Should i go with which one? any pros and cons do you know?
View 15 Replies
View Related
Jul 15, 2008
I have win2003 server and running plesk 8.4, there is a website on it and it gives me error with mysql max_connection even I set the limit 1 million or 10000 no matters.
View 3 Replies
View Related
Oct 8, 2007
how many of you (Windows Hosting Providers) have MySQL (any version) support on your servers?
View 8 Replies
View Related
Dec 13, 2007
I have recently finished designing web pages using mysql and php on my laptop. What I am now trying to do is install the software onto the windows sbs server. I pressume in order to do this I need the various permissions to install the php and mysql software. I take it then I need to adjust the php config file accordingly.
I would be grateful if someone could let me know if this is correct and whether any has ever carried out this procedure on Widows SBS 2003 Standard Edition.
View 2 Replies
View Related
Nov 17, 2014
For one of my dedicated server I have the follwoing scenario:
Microsoft Windows Server 2012 X64
Plesk 11.5.30 Update #48
Plesk Panel - Tools and Settings -> Database Server -> Add Database Server
Type: MySql - host: localhost - Port 3307
Actual Result: error unable to connect to host
Expected result: New instance and service of MySql Server
Port 3307 is no firewalled and I have added a rule to allow connection on 3307
View 2 Replies
View Related
May 21, 2014
In order to install moodle, I need to upgrade MySQL from 5.1 to 5.5. I have gone through one of the KB articles [URL], but it's not very clear.
Can I upgrade it through Add/remove Components from Install and update products just like it can be done for PHP?? I see MySQL Server 2005, 2008 and 2012,
View 2 Replies
View Related
Mar 23, 2014
I can't start MYSQL. How can i fix this?
View 3 Replies
View Related
Jun 19, 2009
Trying to install Mysql 5 on a Windows 2003 server but getting this error attached.
For one, trying to follow this guideline
[url]
Download from:
[url]
(msi file, x86)
Filename: mysql-essential-5.1.35-win32.msi
View 14 Replies
View Related
Aug 8, 2007
i want to know that how to install php and mysql on a windows server (2003). i have a windows server version 2003 and i need php and mysql to run on that.
View 3 Replies
View Related
Sep 12, 2014
I have a dedicated server and I am about to get a few high traffic sites that will be Joomla based and MySQL served. What I am thinking a about is to create another MySQL instance, leave the current websites on the "old" instance and get the new ones onto a separate instance.
I am on PPP 11.0.9 on windows and the current mysql version is 5.1.56 on port 3306 (I can get other ports for other instances).
What I did was the following:
In the Database Servers page, I hit "Add Database Server"
In the next page I add the following:
MySQL (from the dropdown)
localhost
3307
(leave blank the default check box)
I then add the Administrator's username and passwords and hit OK.
The next page, reports an error message (in between asterisks below):
************************
Error: Test connection to the database server has failed because of network problems:
No connection could be made because the target machine actively refused it.
************************
The primary (eg. current) mysql instance is working fine, it's just I cannot add a second server...
View 3 Replies
View Related
Jul 29, 2012
Plesk has mysql installed with it to run properly and I need to upgrade that version to the latest. Now I am not talking about the mysql server that it provides for me to create databases on. I am talking about the version it uses to run.
View 3 Replies
View Related
Jul 17, 2012
I've upgraded to 11, but when I try and apply updates, I'm getting
WARNING: Unable to connect to local default MySQL server. Read carefully article [URL] ..... for details.
I've followed the directions in the KB mentioned, but haven't had any luck yet.
View 8 Replies
View Related