Archive for the ‘Technology’ Category
Sugarhosts now fully supports IPv6 on all products including shared web hosting, semi-dedicated hosting, VPS and dedicated servers.
IPv6 is the next generation Internet Protocol replacing the current IPv4. It offers a few advantages, not the least of which is the enormous pool of addresses available (in comparison to the legacy IPv4 network). Because of this large available address pool, Sugarhosts will initially be offering unique IPv6 IPs for free.
How to get IPv6 address
Shared Web Hosting: Submit a ticket to technical department for request.
Semi-Dedicated Hosting: Submit a ticket to technical department for request.
VPS: Each newly created VPS will have 8 IPv6 addresses assigned by default. Existing VPS clients can request via ticket.
Dedicated Servers: Note when ordering or submit a ticket to technical department after ordering.
Recently we found a client’s script causing high MySQL CPU usage. MySQL was using almost 200% CPU when his script run.
There were few concurrent queries. We noticed his table has more than 2 million records and all queries included regular expressions. By checking the structure of the table, we found no indexes were used on columns that are frequently used in where clauses. So we created an index on the most frequently used column to see if that help. MySQL’s CPU usage fell to 10% immediately.
Similar issues may exist on your sites too. If you find that your SQL query is slow or the site bites too many system resources, you may need to check the indexes of your database.
Indexes are best used on columns that are frequently used in where clauses, and in any kind of sorting, such as "order by". It can significantly improve sql query performance.
In the past time, many customers asked us " Where can I see my CPU Usage info ? ". The answer was always no. But from today, it changes to yes.
We add a new cPanel plugin to show CPU usage information. You can see that on the left sidebar of your cPanel.
The value is based on all CPUs. Multiply it by 4 or 8 ( depending on the number of the CPU cores of the server ) then you’ll get your real CPU usage.
We plan to add an email notification function so that you can know when you should upgrade your host or check scripts. Auto-suspend function is also considered to be added to prevent most clients from being affected by a few high usage clients.
*Note: The plugin is still beta.
Update ( March 21, 2011 )
The plugin is final released. The value you see is your real CPU usage now, you needn’t multiply it as above.
To avoid downtime caused by Kernel updates, Sugarhosts now use Ksplice on all servers. We strive to achieve 100% uptime in future.
- March Specials @ 2014
- February Specials @ 2014
- IPv6 Ready!
- January Specials @ 2014
- Christmas Opening Hours 2013
- October Specials @ 2013 | Sugarhosts.com Blog on Promotions
- September Specials @ 2013 | Sugarhosts.com Blog on Promotions
- August Specials @ 2013 | Sugarhosts.com Blog on Promotions
- July Specials @ 2013 | Sugarhosts.com Blog on Promotions
- June Specials @ 2013 | Sugarhosts.com Blog on Promotions
- Domain Names (10)
- Hosting (55)
- Promotions (59)
- Reseller (1)
- Server (6)
- Technology (4)
- Uncategorized (11)
- VPS (19)