| |
|
|
Job Summary:
|
| |
| Job Type: |
Project |
| Budget: |
$ 100-300 |
| Required
Skills: |
,
|
| Attached
Files: |
(None) |
| |
|
| Status: |
Closed for bidding
|
| |
|
|
|
Buyer Summary:
|
| |
| Username: |
|
| Feedback Score: |
Rating: (No Feedback Yet)
|
| Award Reliability: |
3 posted 0 paid |
| |
|
| Location: |
Hong Kong, Hong Kong
|
| Member Since: |
November 28, 2008 |
| |
|
|
|
| Invited Users: |
There are no invited users
|
Description
I have a site (build with Gregarius.net) that is making some nasty long queries to the MySQL.
If you know how to fix the following, the job is yours!
////////////////////////////////////////////////////////
Although the amount of database activity your sites are generating is pretty high, the issues you are having to not appear to be a result of a hardware limitation issues. Your server logs all databases queries that take longer than a second to run. A query is a command to read or write from the database and should run in less than a second. Your Database Container has logged several queries that have taken over a minute and half to run on average. The support for the application you are running or a MySQL developer needs to look over these queries to see if they can be optimized. Sometimes changing a command around or adding an index to a database table can make a huge difference in performance. Since these requests are taking so long to process, connections to your database are stacking up to the limit. This is what triggers the '#1040 - Too many connections' error. It's possible to raise this limit, but then you may run into hitting the general resource limits for!
your database container.
You Database container also has a MySQL report that gives other valuable information on how your database applications are running. One thing I noticed is that your database is not making very good use of Query Cache. Query Cache saves the results of queries in a dedicated portion active memory so they can be quickly retrieved. However, only 50 percent of queries to your database are cache able so about half this dedicated memory is getting wasted. Your MySQL report also shows that once queries are cached they are only used once before they need to be flushed. This is another indicator of memory dedicated to cached queries simply wasted. You may be able to adjust and optimize your application to make better use of Query Cache, but you also may want to try to reducing memory dedicated to Query Cache to free up resources for general processing.
////////////////////////////////////////////////////////////
Attached the Slow Queries Log
Thanks!
Reminder
You may not start working in this and any request before
your bid is accepted. Users who violate this policy
may have their accounts permanently suspended.
|
|
|
|
| |
| Get the Free
Step-by-Step Guide on How to Use GetACoder |
The act of
outsourcing jobs has become easy in the past few years
thanks to GetACoder. However, our team aims at making the
whole process even easier. So, it has now come the time to
provide you with a step-by-step guidance on how to use this
service and succeed in the outsourcing world totally for
FREE.
It doesn't matter if you are a more experienced user or a
novice; using GetACoder will become even simpler with the
help of this E-book. There are two major sections: a Buyers
section and a Coders section.
Buyers will learn:
- How to outsource safely
- How to pick the best freelancers
- How to manage time and money
Coders will learn:
- How to get the best jobs
- How to secure their payments
- How to build a long-lasting relationship with buyers
...and MUCH MORE
Clear examples and pictures illustrating key situations,
great tips and real testimonies of some of our best users...
all in this Outsourcing Guide. So don't loose the
outstanding opportunity to download GetACoder FREE E-book.
|
 |
|
 GetACoder is a leading Global Services Marketplace doing business in more than 200 countries. Our unique system accelerates your time to market and provides your business with key competitive advantages. When you use GetACoder you are stretching your budget and saving as much as 60% over traditional outsourcing. GetACoder is changing business, now it's no longer about what you own or build but which resources and talent you can access. With GetACoder you reduce expenses, increase efficiencies, aggressively grow your business, and create a sustainable competitive advantage. GetACoder makes outsourcing to any part of the world an easy task! With GetACoder it's simple to outsource any business request, gain access to global talent and manage jobs online. One of the main advantages of GetACoder is the low labor cost. The typically rates are about seven times lower than the ones in the US or Europe. Posting a request at GetACoder allows the right professional or company to find you and to bid for your work. We are building a reputation for exceeding our customers' expectations and for becoming an extremely cost effective way to outsource work. Use GetACoder when you want to save money, increase efficiency or accelerate the development of your request. With GetACoder you focus on growing your business and let others do the tedious work. Post your request on GetACoder for free. Find out why people outsource jobs with us day after day. Thousands of Satisfied Customers - Submit/View Quotes
| - | I am a new comer, but I already like this website. - | | - | We feel we have found the right place for getting business. - | | - | Fantastic service! I could find a partner in the opposite side of the world. An entire project without hearing their voice... Everything has been possible with GetACoder! - |
|
|
| |
© 2004-2012 GetACoder. All rights reserved. |
|
