Posts Topics Forums Images
Search videos from message boards Videos Search messages from microblogs Microblogs Search messages from imdb.com Imdb Search messages from yuku.com Yuku Search messages from lefora.com (free forums) Lefora
My account: Login | Sign Up
Loading... 

Thread: MySQL Configuration on Windows
Started 1 month, 2 weeks ago by Tiago
Hello There! I have windows 2008 server running Plesk with high mysql CPU load and very low memory. Server is a xeon quad core with 8 GB of memory. My mysql configuration is: default-character-set=latin1 default-storage-engine=INNODB read_buffer_size=1M read_rnd_buffer_size=256K sort_buffer_size=256K innodb_additional_mem_pool_size=2M innodb_flush_log_at_trx_...
Site: WebHostingTalk Forums - Web Hosting Discussion  WebHostingTalk Forums - Web Hosting Discussion - site profile
Forum: Technical & Security Issues  Technical & Security Issues - forum profile
Total authors: 4 authors
Total thread posts: 5 posts
Thread activity: no new posts during last week
Domain info for: webhostingtalk.com

Other posts in this thread:

chaosuk replied 1 month, 2 weeks ago
Is the load high due to heavy queries? How big is the database? Do you regularly perform database maintenance to keep the table indexes clean?
Size: 142 bytes
Customize:  Customize "<b>Reply 1</b>: MySQL Configuration on Windows :: Technical & Security Issues :: WebHostingTalk Forums - Web Hosting Discussion"

ZanyHost replied 1 month, 2 weeks ago
How much traffic is the server getting? I assume its low...?
Size: 60 bytes
Customize:  Customize "<b>Reply 2</b>: MySQL Configuration on Windows :: Technical & Security Issues :: WebHostingTalk Forums - Web Hosting Discussion"

Tiago replied 1 month, 2 weeks ago
This is a webhosting server with 250 databases. The traffic is low. And querys don't seem to big, I don't the table indexes clean, can I do it for all databases at once?
Size: 184 bytes
Customize:  Customize "<b>Reply 3</b>: MySQL Configuration on Windows :: Technical & Security Issues :: WebHostingTalk Forums - Web Hosting Discussion"

Drew_Parallels replied 1 month, 1 week ago
So I talked to the tech support guys, and they told me that it looks like a common MySQL optimization problem. Try these optimization recommendations , and let me know if they help.
Size: 279 bytes
Customize:  Customize "<b>Reply 4</b>: MySQL Configuration on Windows :: Technical & Security Issues :: WebHostingTalk Forums - Web Hosting Discussion"

 

Top contributing authors

Name
Posts
Tiago
2
user's latest post:
MySQL Configuration on Windows
Published (2009-11-11 20:17:00)
This is a webhosting server with 250 databases. The traffic is low. And querys don't seem to big, I don't the table indexes clean, can I do it for all databases at once?
chaosuk
1
user's latest post:
MySQL Configuration on Windows
Published (2009-11-11 16:18:00)
Is the load high due to heavy queries? How big is the database? Do you regularly perform database maintenance to keep the table indexes clean?
ZanyHost
1
user's latest post:
MySQL Configuration on Windows
Published (2009-11-11 17:19:00)
How much traffic is the server getting? I assume its low...?
Drew_Parallels
1
user's latest post:
MySQL Configuration on Windows
Published (2009-11-13 15:40:00)
So I talked to the tech support guys, and they told me that it looks like a common MySQL optimization problem. Try these optimization recommendations , and let me know if they help.

Related threads on "WebHostingTalk Forums - Web Hosting Discussion":

VPN Configuration on Windows Server  WebHostingTalk Forums - Web Hosting Discussion - site profile Technical & Security Issues - forum profile VPN Configuration on Windows Server
VPN Configuration on Windows Server
Mysql 5 on windows 2003 server (error)  WebHostingTalk Forums - Web Hosting Discussion - site profile Technical & Security Issues - forum profile Mysql 5 on windows 2003 server (error)
Mysql 5 on windows 2003 server (error)
Windows: Reloading apache configuration.  WebHostingTalk Forums - Web Hosting Discussion - site profile Technical & Security Issues - forum profile Windows: Reloading apache configuration.
Windows: Reloading apache configuration.
MySQL and PHP!?!? On Windows  WebHostingTalk Forums - Web Hosting Discussion - site profile Programming Discussion - forum profile MySQL and PHP!?!? On Windows
MySQL and PHP!?!? On Windows
MySQL on Windows Server  WebHostingTalk Forums - Web Hosting Discussion - site profile Windows Hosting Forum - forum profile MySQL on Windows Server
MySQL on Windows Server
Free Windows s/w to backup mysql & files on server to...  WebHostingTalk Forums - Web Hosting Discussion - site profile Web Hosting Forum - forum profile Free Windows s/w to backup mysql & files on server to local machine
Free Windows s/w to backup mysql & files on server to local machine
20% Off Windows Hosting! PHP5 | MySQL 5 | MSSQL | ASP |...  WebHostingTalk Forums - Web Hosting Discussion - site profile Shared Hosting Offers - forum profile 20% Off Windows Hosting! PHP5 | MySQL 5 | MSSQL | ASP | Perl | Python
20% Off Windows Hosting! PHP5 | MySQL 5 | MSSQL | ASP | Perl | Python
Which windows share hosting support apache php mysql?  WebHostingTalk Forums - Web Hosting Discussion - site profile Windows Hosting Forum - forum profile Which windows share hosting support apache php mysql?
Which windows share hosting support apache php mysql?
MySQL 5.0 Guru for Windows 2003 Standard needed  WebHostingTalk Forums - Web Hosting Discussion - site profile Employment Offers (by employers) - forum profile MySQL 5.0 Guru for Windows 2003 Standard needed
MySQL 5.0 Guru for Windows 2003 Standard needed
Would you recommend MySQL for asp.net (windows)?  WebHostingTalk Forums - Web Hosting Discussion - site profile Programming Discussion - forum profile Would you recommend MySQL for asp.net (windows)?
Would you recommend MySQL for asp.net (windows)?

Related threads on other sites:

Updated “Intelligent MySQL Configuration”:...  theory - Identi.ca - site profile theory - forum profile Updated “Intelligent MySQL Configuration”: http://www.justatheory.com/computers/databases/mysql/configuration.html
Updated “Intelligent MySQL Configuration”: http://www.justatheory.com/computers/databases/mysql/configuration.html
One MySQL Configuration Tip That Can Dramatically Improve...  Twitter / maxtheitpro - site profile maxtheitpro - forum profile One MySQL Configuration Tip That Can Dramatically Improve MySQL Performance http://tinyurl.com/56hqyf 10:20 PM Nov 6th from web
One MySQL Configuration Tip That Can Dramatically Improve MySQL Performance http://tinyurl.com/56hqyf 10:20 PM Nov 6th from web
GR&gt; Optimizing MySQL: Configuration: This is the...  Twitter / meveno - site profile meveno - forum profile GR&gt; Optimizing MySQL: Configuration: This is the first part of MySQL optimization mini series. In this tut.. http://bit.ly/11Cmb4 10:41 AM Jun 16th from twitterfeed
GR&gt; Optimizing MySQL: Configuration: This is the first part of MySQL optimization mini series. In this tut.. http://bit.ly/11Cmb4 10:41 AM Jun 16th from twitterfeed
Simple Thoughts: One MySQL Configuration Tip That Can...  Twitter / angsuman - site profile Angsuman Chakraborty - forum profile Simple Thoughts: One MySQL Configuration Tip That Can Dramatically Improve MySQL Performance ( http://tinyurl.com/56hqyf ) 07:04 AM August 13, 2008 from web
Simple Thoughts: One MySQL Configuration Tip That Can Dramatically Improve MySQL Performance ( http://tinyurl.com/56hqyf ) 07:04 AM August 13, 2008 from web
Navicat MySQL Client for Windows 8.1.9: GUI Tool for...  Twitter / BetaNews - site profile Beta News - forum profile Navicat MySQL Client for Windows 8.1.9: GUI Tool for MySQL admin and access to MySQL conversion http://tinyurl.com/bcoxtg 8:24 AM Feb 24th from twitterfeed
Navicat MySQL Client for Windows 8.1.9: GUI Tool for MySQL admin and access to MySQL conversion http://tinyurl.com/bcoxtg 8:24 AM Feb 24th from twitterfeed
Configuration changes made. Incident pending resolution.:...  Twitter / mt_incidents - site profile mt_incidents - forum profile Configuration changes made. Incident pending resolution.: Our engineers made changes to the MySQL configuration .. http://snipurl.com/d912b 8:09 AM Mar 6th from twitterfeed
Configuration changes made. Incident pending resolution.: Our engineers made changes to the MySQL configuration .. http://snipurl.com/d912b 8:09 AM Mar 6th from twitterfeed
Can PHP, apachy and MySQL run on Windows ME correctly?  ExpertsHeaven.com an online portal for wide variety of technical discussion - site profile Server-Side Development - forum profile Can PHP, apachy and MySQL run on Windows ME correctly?
Can PHP, apachy and MySQL run on Windows ME correctly?
Configurando PHP/MySQL localmente no Windows e OS X...  Twitter / joildo - site profile joildo - forum profile Configurando PHP/MySQL localmente no Windows e OS X http://migre.me/1lHg #apache #php #mysql #tutorial 11:09 PM May 20th from Ping.fm
Configurando PHP/MySQL localmente no Windows e OS X http://migre.me/1lHg #apache #php #mysql #tutorial 11:09 PM May 20th from Ping.fm
# MySQL configuration files are nutty. When do I edit...  basilgohar - Identi.ca - site profile basilgohar - forum profile # MySQL configuration files are nutty. When do I edit the [mysqld] section and when [mysqld-safe]? Published about a month ago From xmpp
# MySQL configuration files are nutty. When do I edit the [mysqld] section and when [mysqld-safe]? Published about a month ago From xmpp
Tweaked mysql configuration to support the needed number...  Twitter / dragulesq - site profile dragulesq - forum profile Tweaked mysql configuration to support the needed number of concurrent read/write transactions. phew, no more locked threads! 9:41 PM Aug 3rd from TwitterFox
Tweaked mysql configuration to support the needed number of concurrent read/write transactions. phew, no more locked threads! 9:41 PM Aug 3rd from TwitterFox
Thread profile page for "MySQL Configuration on Windows" on http://www.webhostingtalk.com. This report page is a snippet summary view from a single thread "MySQL Configuration on Windows", located on the Message Board at http://www.webhostingtalk.com. This thread profile page shows the thread statistics for: Total Authors, Total Thread Posts, and Thread Activity