Our local authority is looking into using MySQL database for some internal applications and possibly our website.
Do we need a commercial or enterprise license for this particular use or can we use a free version?
I have the files .myd .myi and .frm files in a archive .tar.gz
My host do not provide shell access.
Is the any way that i can convert the files into .sql queries
Or is there any method other that using shell access.
Or is there any software to convert the database files into .sql query in my desktop computer so that i can restore it using phpmyadmin
My site has been down from several days
What is the good value to set query_cache_size. I have set it to 60 M and here
is the status. Is it good? I am not sure how to check this? Can anyone explain?
query_cache_size=60M
mysql> SHOW STATUS LIKE 'Qcache%';
+-------------------------+----------+
| Variable_name | Value |
+-------------------------+----------+
| Qcache_free_blocks | 5 |
| Qcache_free_memory | 62666440 |
| Qcache_hits | 922 |
| Qcache_inserts | 381 |
| Qcache_lowmem_prunes | 0 |
| Qcache_not_cached | 565 |
| Qcache_queries_in_cache | 182 |
| Qcache_total_blocks | 400 |
+-------------------------+----------+
8 rows in set (0.00 sec)
some vBulletin customers facing to that error message, with session table with attachment only. Other just work fine. It's not because of server load. The load is just around 0 - 0.1
I have increased wait_timeout to 200 and max_allowed_packet to 64MB. Each attachment file in those vBulletin is just around 1-3MB.
Is there any idea why and how to fix?
We have a dedicated server and we host 4 news portals based on e107 and joomla.
My partner on Sunday has upgraded mysql from version 4 to 5. Now the server experiences very high CPU usage and query time on portals has been increased very much.
We used to have query times lower than 1 sec for the main page of [url](which is a site that receives about 2000 visits/day) and now query times are 5-15sec !
Does anybody know if this is makes sense ?
Below is the server Status from WHM :
-------------------------------------
cpdavd up
cpsrvd up
exim (exim-4.69-15.1_cpanel_maildir) up
ftpd up
httpd (2.2.11 (Unix)) up
imap up
interval up
mysql (5.0.67-community-log) up
named (9.3.4) up
pop up
rsyslogd up
spamd up
syslogd up
Server Load 6.97 (1 cpu)
Memory Used 49.4 %
Swap Used 0.23 %
Disk /dev/hda3 (/tmp) DMA+ 70 %
Disk /dev/hda5 (/) DMA+ 22 %
Disk /dev/hda1 (/boot) DMA+ 14 %
Below is the Server Information from WHM :
------------------------------------------
Processor #1 Vendor: GenuineIntel
Processor #1 Name: Intel(R) Core(TM)2 Duo CPU E4600 @ 2.40GHz
Processor #1 speed: 2394.068 MHz
Processor #1 cache size: 2048 KB
Memory Information
Memory: 2064420k/2087424k available (2091k kernel code, 21752k reserved, 846k data, 236k init, 1169920k highmem)
System Information
Linux server.aktoweb.biz 2.6.20-1.2319.fc5 #1 Mon May 21 19:52:13 EDT 2007 i686 i686 i386 GNU/Linux
Physical Disks
hda: WDC WD3200AAJB-00TYA0, ATA DISK drive
hda: hw_config=600d
hda: hw_config=600d
hda: max request size: 512KiB
hda: 625142448 sectors (320072 MB) w/8192KiB Cache, CHS=38913/255/63<6>hda: hw_config=600d
hda: cache flushes supported
Current Memory Usage
total used free shared buffers cached
Mem: 2066428 1756324 310104 0 339576 486636
-/+ buffers/cache: 930112 1136316
Swap: 1052248 2428 1049820
Total: 3118676 1758752 1359924
Current Disk Usage
Filesystem Size Used Avail Use% Mounted on
/dev/hda5 288G 60G 213G 22% /
/dev/hda1 99M 13M 82M 14% /boot
tmpfs 1009M 0 1009M 0% /dev/shm
/dev/hda3 494M 215M 254M 46% /tmp
Below is the CPU/Memmory/Mysql Usage from WHM :
-------------------------------------------------
mysql42.707.300.0
Top Process%CPU 42.7/usr/sbin/mysqld --basedir/ --datadir/var/lib/mysql --usermysql --pid-file/var/lib/mysql/server.aktoweb.biz.pid --skip-external-locking
Top Process%CPU 42.6/usr/sbin/mysqld --basedir/ --datadir/var/lib/mysql --usermysql --pid-file/var/lib/mysql/server.aktoweb.biz.pid --skip-external-locking
giaprakigiapraki.com2.7012.111.7
Top Process%CPU 1.3httpd [urll] [/e107_plugins/pm/pm.php?inbox]
Top Process%CPU 1.1httpd [url] [/e107_plugins/forum/forum_viewforum.php?87]
Top Process%CPU 1.0httpd [url] [/e107_plugins/chatbox_menu/chatbox_iframe.php]
adsnetadsnet.gr1.177.900.7
Top Process%CPU 0.5httpd [adsnet.gr] [/www/delivery/lg.php?bannerid16&campaignid4&zoneid5&chan]
Top Process%CPU 0.4httpd [adsnet.gr] [/www/delivery/lg.php?bannerid50&campaignid6&zoneid15&cha]
Top Process%CPU 0.3httpd [adsnet.gr] [/www/delivery/lg.php?bannerid183&campaignid77&zoneid1&ch]
r40r40.gr1.073.340.0
Top Process%CPU 1.1httpd [r40.gr] [/index.php?optioncom_fireboard&Itemid188&funcshowcat&cat]
Top Process%CPU 0.5httpd [r40.gr] [/images/fbfiles/avatars/s_64.png]
Top Process%CPU 0.3httpd [r40.gr] [/index2.php?optioncom_jim&taskxml&no_html1]
root0.278.532.0
Top Process%CPU 0.2[kjournald]
alex123alexandroupoli.net0.030.270.0
Top Process%CPU 0.1httpd [alexandroupoli.net] [/e107_images/banners/banner468x60-alexandroupolinet.gif]
galfasgalfas.gr0.030.270.0
Top Process%CPU 0.1httpd [galfas.gr] [/racing/images/galfas_R40_banner.jpg]
eximstats0.000.000.3
nobody0.001.100.0
mailnull0.000.000.0
unauthenticated0.000.000.0
named0.000.10
how to enable slow-query logging in MySQL ? Im using mysql version 4.1.20
well i just added following line in my.cnf can you please tell me is it correct way or not?
Code:
log-slow-queries=/tmp/slow_queries.log
log-update = /var/lib/mysql/updates.log
I want to run flush query cache, saying once a week. Is there anyway to schedule it, so system can do it automatically? Currently, I have to login server, and run it manually
View 1 Replies View Relatedhow to add a mysql access host by command line? or or how to add a mysql access host through an sql query?
View 3 Replies View RelatedI've got a problem with an SQL query that is behaving badly. Its probably really obvious, but I can't see the problem!
I have a table with 3 fields:
Code:
money bigint(20)
income int(12)
userID mediumint(7)
I have a row that has a negative money and a value of 0 for income. When I update the money value to add "0" to it, nothing happens (as expected). When I update the money field to add the income field (which is equal to 0) to it, MySQL flips the sign to make the money field positive.
The following queries show the problem:
Code:
mysql> SELECT money, income from users where userID=327961;
+----------------------+--------+
| money | income |
+----------------------+--------+
| -9223372036854775807 | 0 |
+----------------------+--------+
1 row in set (0.00 sec)
mysql> UPDATE `users` SET money = money + 0 WHERE userID =327961;
Query OK, 0 rows affected (0.00 sec)
Rows matched: 1 Changed: 0 Warnings: 0
mysql> SELECT money, income from users where userID=327961;
+----------------------+--------+
| money | income |
+----------------------+--------+
| -9223372036854775807 | 0 |
+----------------------+--------+
1 row in set (0.00 sec)
mysql> UPDATE `users` SET money = money + income WHERE userID =327961;
Query OK, 1 row affected, 1 warning (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 1
mysql> SELECT money, income from users where userID=327961;
+---------------------+--------+
| money | income |
+---------------------+--------+
| 9223372036854775807 | 0 |
+---------------------+--------+
1 row in set (0.00 sec)
mysql>
Notice that there is no negative sign after the third select!!
So, we are saying that executing an update where 0 is specified in the query results in the correct action but if you take the 0 from another field it takes the negative sign away...
This for various reasons is a rather urgent problem. This problem has only appeared after upgrading from MySQL 4.0 to MySQl 5.1. This problem does not occur in MySQL 4.1.
Which VmWare product allows me officially to use it for VPS hosting business (ESXi does not allow that)? Do you have a link to document where they specifically authorize use of their software to make and sell VPS? Are there any legal limitations? What about vSphere standard?
What about Xen, what are limitations of free version? Which payed version is best for VPS hosting, are there any legal limitations?
i was thinking about partitioning my servers into a number of VPSs to sell.
in regard to offering cPanel, i see that licensing is $425 a pop. is there any way of registering for multiple servers at a low cost.
how does Windows handle licensing on Virtual Dedicated Servers? Does SPLA licensing cost the same as a full dedicated server?
This would be a VMware server, with multiple Windows virtual servers.
I'm sure this has been covered before, but during my search I didn't find much, maybe someone can point me in the right direction.
Okay, so here's how it goes...
I, and a partner, plan on purchasing a 2U server and we're going to co-locate this server in Chicago. This server will be serving a new gaming company we plan on opening. Now, my main issue is obtaining Windows for this server. I have found plenty of retail CD's with like a 5 CALs included, but that was in the $750-$1000 range, which I understand this is what Windows server really cost, but I believe I could find it cheaper.
Does anyone know the BEST, and preferably the cheapest place to buy Windows Server 2003 (Specifically Standard 64bit - R2) or even an "external" monthly license, if such exist. I am new to the entire Windows Server licensing and pricing stuff, so any information would be very much helpful.
if anyone has an idea of which dedicated provider has the most reasonable prices when it comes to Virtuozzo licensing. I have looked at several and it seems prices vary.
View 9 Replies View RelatedIs there any difference between lincense cost of windows 2003 server SE for virtual server and standalone physical server?
View 0 Replies View RelatedI'm helping one of my clients setup some windows VPS's but we're having some serious confusion as to how the licensing works.
I've read on microsoft.com that they now are far more accepting of virtulization and allow, with a single license, anywhere from 4 to unlimited VPS installs with it.
Now, my question is: Does this count with leased licenses? Say I leased a license from my datacenter (say i did 2k3 STD) for $25/m. Would I then be allowed to install it on however many VPS's allow under MS without issue or how does that exactly work?
Whats the most cost effective method of purchaseing cpanel licenses for colocated servers?
View 12 Replies View RelatedFrom the posts in this forum it would appear that a number of forumites are colocation service providers and web hosters that use Cisco gear.
I was reviewing the Cisco End User License Agreement that was included in the router box. Under the General Limitations section, "Customer shall have no right, and Customer specifically agrees not to:", item (iv) states, "use or permit the Software to be used to perform services for third parties, whether on a service bureau basis or time sharing basis or otherwise, without the express written authorization of Cisco".
Does this mean that a service provider is required to acquire
a separate license similar to the Microsoft Service provider license?
My understanding is that the IOS software running in most of their products is non-transferable. So clearly this prevents a user from receiving updates if they purchase used hardware (i.e. ebay). However, isn't it possible to purchase an IOS software license from Cisco for any of their supported product?
Their web site is a mess! I've spent, literally, hours on their site trying to figure out how to purchase such a license, or how to purchase a service plan that might entitle me to IOS updates.
And how does "SMARTnet" fit into this puzzle? Do I need a SMARTnet contract to download maintenance updates, even for *new* hardware that I've purchased?
I have problem locating the Licensing module which allow us to add/delete CALs/Processor licenses, where is it now in Windows 2008?
View 0 Replies View RelatedCan anyone give me some insight on how VPS licensing works with SPLA? According to my reseller, each VPS needs its own standalone license which seem to differ with what I read somewhere about Microsoft Server 2008 allowing up to 8 virtual stances with 1 license or something like that.
View 1 Replies View RelatedHeads Up.
Forget everything you've learned about Windows Server "authenticated" and "unauthenticated" licensing for your monthly SPLA reports. The game has completely changed, and NOT for the better.
Microsoft has changed to "outsourcer" and "non-outsourcer" licensing instead.
Quoting Microsoft:
Quote:
"Outsourcing is an application or service that a service provider manages for their customer. For purposes of this definition, the managed application or service is:
(a) Used by its customer's employees, contractors, agents, or vendors
(b) Not the service provider's intellectual property
I contacted MS directly for clarification on how this applies to webhosting. The response was, if the service provider is (and I quote), "simply managing the infrastructure layer and not managing anything else... in other words just keeping the lights on", that is non-outsourced.
If you are providing any software or management of the environment, even something as simple as Windows Updates or other basic management tasks on the server-- which is the case, for example, if you are running a shared webserver, then it is "outsourced".
Your email server is providing a service that is considered an outsourced service, and you must report (and pay for) an "outsourced" license for that server.
And here is the bad news.
Under the old terms, the Datacenter edition of Windows Server (which allows unlimited VMs at no additional charge on the machine where the license is assigned) cost just under $50/month.
The new "outsourcer" Datacenter license is nearly $250/mo. Yes, you read that right, a whopping 400% monthly license fee increase for Datacenter edition.
A single copy of Windows Server Standard edition is over $75/mo. when used in the outsourcing role.
Other pricing and terms have changed as well, so grab a copy of the new SPUR and READ it. All it takes is a moment of uncertainty to put you wildly out of compliance under this new layer of insanity.
Microsoft said this about Microsoft Licensing for Virtualization
Windows Server 2008 Datacenter
Run any number of software instances in physical and virtual operating system environments on a server.
Now,I have some questions:
1)Is this method of licensing just for hyper-v or we can use it on vmware ESXi or Xen?
2)How we can use Microsoft Volume Licensing on Vmware ESXi and Xen?
3)What is the best solution for windows virtualization?(vmware esxi or hyper-v or xen)
4)what is difference between xen and xenserver?
5)which control panels we can use for hyper-v,vmware ESXi and xenserver?
where can I find cheapest virtuozzo licensing or even dedicated server with virtuozzo licensing. Budget is $300/mo. Bandwidth needed at least 10tb/mo.
View 10 Replies View Relatedso let's get this all hashed out... it'll be interesting to see how people handle various situations.
Before responding, let's keep this thread signature free.
I recently came across an issue where a customer wanted to bring their own Microsoft products/licenses to the table. Got a few questions for the other providers out there... this really needs to be hashed out.
Microsoft is very strict when it comes to enforcing their license policies, we all know this much.
So... when a customer wants to install their own software, what do people do to help ensure that whatever agreement you have with your upstream provider or Microsoft isn't in voliation by allowing someone to bring their own licenses?
What steps do you take to ensure validity of said licenses?
How do you define, much less enforce, these guidelines?
What role, if any, should a provider play in doing their part to help stem illicit license abuse?
where can I find cheapest virtuozzo licensing for 100 vps?
View 2 Replies View RelatedI bought Windows Vista Ultimate OEM and installed it on the physical machine, can I install Virtual Server 2005 and install the ultimate OEM version again on the VIRTUAL server 2005??
I run MySql but I hate to run it on the physical machine, want to run on a virtual machine.
if I have a dedicated server with WS2003, would I be allowed to install my own software (with license)? such as MS SQL Server - I have an MSDN subscription and multiple licenses.... would this be ok to do so?
What about Exchange Server? I have a License for that also...again, MSDN subscription
I will be running Plesk.
I only need 1 user, Administrator with full Remote Desktop Connection access.
But I need to be able to serve websites using Plesk.