While moving around on the net for some MySQL solutions, I stopped at forge.mysql.com, wher I found a lot of tips regarding defferent issues in MySQl. So I thought it would be much helpful for those who are new at MySQL, or are looking for some very important and useful information about MySQL and posted them here with the original source link.

Specific Query Performance Tips

1. Use EXPLAIN to profile the query execution plan
2. Use Slow Query Log (always have it on!)
3. Don’t use DISTINCT when you have or could use GROUP BY
4. Insert performance
   1. Batch INSERT and REPLACE
   2. Use LOAD DATA instead of INSERT
5. LIMIT m,n may not be as fast as it sounds. Learn how to improve it (if possible): http://www.facebook.com/note.php?note_id=206034210932
6. Don’t use ORDER BY RAND() if you have > ~2K records
7. Use SQL_NO_CACHE when you are SELECTing frequently updated data or large sets of data
8. Avoid wildcards at the start of LIKE queries
9. Avoid correlated subqueries and in select and where clause (try to avoid in)
10. No calculated comparisons — isolate indexed columns
11. ORDER BY and LIMIT work best with equalities and covered indexes
12. Separate text/blobs from metadata, don’t put text/blobs in results if you don’t need them
13. Derived tables (subqueries in the FROM clause) can be useful for retrieving BLOBs without sorting them. (Self-join can speed up a query if 1st part finds the IDs and uses then to fetch the rest)
14. ALTER TABLE…ORDER BY can take data sorted chronologically and re-order it by a different field — this can make queries on that field run faster (maybe this goes in indexing?)
15. Know when to split a complex query and join smaller ones
16. Delete small amounts at a time if you can
17. Make similar queries consistent so cache is used
18. Have good SQL query standards
19. Don’t use deprecated features
20. Turning OR on multiple index fields (<5.0) into UNION may speed things up (with LIMIT), after 5.0 the index_merge should pick stuff up.
21. Don’t use COUNT * on Innodb tables for every search, do it a few times and/or summary tables, or if you need it for the total # of rows, use SQL_CALC_FOUND_ROWS and SELECT FOUND_ROWS()
22. Use INSERT … ON DUPLICATE KEY update (INSERT IGNORE) to avoid having to SELECT
23. use groupwise maximum instead of subqueries
24. Avoid using IN(…) when selecting on indexed fields, It will kill the performance of SELECT query.

Scaling Performance Tips

1. Use benchmarking
2. isolate workloads don’t let administrative work interfere with customer performance. (ie backups)
3. Debugging sucks, testing rocks!
4. As your data grows, indexing may change (cardinality and selectivity change). Structuring may want to change. Make your schema as modular as your code. Make your code able to scale. Plan and embrace change, and get developers to do the same.

Network Performance Tips

1. Minimize traffic by fetching only what you need.
   1. Paging/chunked data retrieval to limit
   2. Don’t use SELECT *
   3. Be wary of lots of small quick queries if a longer query can be more efficient
2. Use multi_query if appropriate to reduce round-trips
3. Use stored procedures to avoid bandwidth wastage

OS Performance Tips

1. Use proper data partitions
   1. For Cluster. Start thinking about Cluster *before* you need them
2. Keep the database host as clean as possible. Do you really need a windowing system on that server?
3. Utilize the strengths of the OS
4. pare down cron scripts
5. create a test environment
6. source control schema and config files
7. for LVM innodb backups, restore to a different instance of MySQL so Innodb can roll forward
8. partition appropriately
9. partition your database when you have real data — do not assume you know your dataset until you have real data

MySQL Server Overall Tips

1. innodb_flush_commit=0 can help slave lag
2. Optimize for data types, use consistent data types. Use PROCEDURE ANALYSE() to help determine the smallest data type for your needs.
3. use optimistic locking, not pessimistic locking. try to use shared lock, not exclusive lock. share mode vs. FOR UPDATE
4. if you can, compress text/blobs
5. compress static data
6. don’t back up static data as often
7. enable and increase the query and buffer caches if appropriate
8. config params — http://docs.cellblue.nl/2007/03/17/easy-mysql-performance-tweaks/ is a good reference
9. Config variables & tips:
   1. use one of the supplied config files
   2. key_buffer, unix cache (leave some RAM free), per-connection variables, innodb memory variables
   3. be aware of global vs. per-connection variables
   4. check SHOW STATUS and SHOW VARIABLES (GLOBAL|SESSION in 5.0 and up)
   5. be aware of swapping esp. with Linux, “swappiness” (bypass OS filecache for innodb data files, innodb_flush_method=O_DIRECT if possible (this is also OS specific))
   6. defragment tables, rebuild indexes, do table maintenance
   7. If you use innodb_flush_txn_commit=1, use a battery-backed hardware cache write controller
   8. more RAM is good so faster disk speed
   9. use 64-bit architectures
10. –skip-name-resolve
11. increase myisam_sort_buffer_size to optimize large inserts (this is a per-connection variable)
12. look up memory tuning parameter for on-insert caching
13. increase temp table size in a data warehousing environment (default is 32Mb) so it doesn’t write to disk (also constrained by max_heap_table_size, default 16Mb)
14. Run in SQL_MODE=STRICT to help identify warnings
15. /tmp dir on battery-backed write cache
16. consider battery-backed RAM for innodb logfiles
17. use –safe-updates for client
18. Redundant data is redundant

Storage Engine Performance Tips

1. InnoDB ALWAYS keeps the primary key as part of each index, so do not make the primary key very large
2. Utilize different storage engines on master/slave ie, if you need fulltext indexing on a table.
3. BLACKHOLE engine and replication is much faster than FEDERATED tables for things like logs.
4. Know your storage engines and what performs best for your needs, know that different ones exist.
   1. ie, use MERGE tables ARCHIVE tables for logs
   2. Archive old data — don’t be a pack-rat! 2 common engines for this are ARCHIVE tables and MERGE tables
5. use row-level instead of table-level locking for OLTP workloads
6. try out a few schemas and storage engines in your test environment before picking one.

Database Design Performance Tips

1. Design sane query schemas. don’t be afraid of table joins, often they are faster than denormalization
2. Don’t use boolean flags
3. Use Indexes
4. Don’t Index Everything
5. Do not duplicate indexes
6. Do not use large columns in indexes if the ratio of SELECTs:INSERTs is low.
7. be careful of redundant columns in an index or across indexes
8. Use a clever key and ORDER BY instead of MAX
9. Normalize first, and denormalize where appropriate.
10. Databases are not spreadsheets, even though Access really really looks like one. Then again, Access isn’t a real database
11. use INET_ATON and INET_NTOA for IP addresses, not char or varchar
12. make it a habit to REVERSE() email addresses, so you can easily search domains (this will help avoid wildcards at the start of LIKE queries if you want to find everyone whose e-mail is in a certain domain)
13. A NULL data type can take more room to store than NOT NULL
14. Choose appropriate character sets & collations — UTF16 will store each character in 2 bytes, whether it needs it or not, latin1 is faster than UTF8.
15. Use Triggers wisely
16. use min_rows and max_rows to specify approximate data size so space can be pre-allocated and reference points can be calculated.
17. Use HASH indexing for indexing across columns with similar data prefixes
18. Use myisam_pack_keys for int data
19. be able to change your schema without ruining functionality of your code
20. segregate tables/databases that benefit from different configuration variables

Other

1. Hire a MySQL ™ Certified DBA
2. Know that there are many consulting companies out there that can help, as well as MySQL’s Professional Services.
3. Read and post to MySQL Planet at http://www.planetmysql.org
4. Attend the yearly MySQL Conference and Expo or other conferences with MySQL tracks (link to the conference here)
5. Support your local User Group (link to forge page w/user groups here)

Source: http://forge.mysql.com/wiki/Top10SQLPerformanceTips

Nowadays, there are many different cell phone services in the market. We usually like to get the newest brand of gadget like a digital camera or the latest cell phone. With this, we constantly like to change service plan and see what it offers. Ideally, with the help of cell phone unlocking, we can change service easily.

First, check if you can unlock your phones easily. Most phones can easily be unlocked like T-mobile or Cingular. But it your phone does not offer a GSM service, for sure you need help to unlock it. The main reason for this is that your phone doesn’t have transferable card and your name and cell phone number is also attached to this card.

With the help of mobile phone unlocking, we can unlock any phone like HTC hero. This is for sure 100% legal that most phone companies don’t want you to know, because they want you to remain as their customer for life. But you have an option, if you like to unlock HTC phones; there are sites that offer this great service for just a small buck. They can easily unlock it by giving you the unlock code after telling or submitting them your phone IMEI.

Once you unlock HTC hero, test it out so you can be sure it really works. You can borrow your friend’s or someone else sim card and try it to your phone. If there’s an error displayed, chances are it didn’t work. But, if the procedure turns out rights, then congratulation you have unlocked your beloved phone. New or experienced cell phone owner can really benefit from this new service. It’s fast and speedy unlocking service that you’ll just sit and wait for the unlock codes, no more hard work.

The normal hair is one that is not oily or dry or delicate hair type is perfect because it’s very manageable and does not bring many maintenance problems.

However, being a hair privileged nature frees him from external damage and our occasional mistakes in your care, so here I want to show the right way to keep it healthy and beautiful:

Wash it with a neutral pH shampoo.
Apply a mild conditioner, especially on the tips and become a circular massage on the scalp.
Rinse with warm water, never hot because it is very aggressive for the hair.
Apply a mask for normal hair at least once a month.
If you’ve dyed it, using a special shampoo and conditioner for treated hair.

Women love stylish earring just like they love fashionable rings. Earrings are popular; they can be worn by teenagers, adult, women and even men. If you wore stainless steel jewelry earrings, it can make a statement on what you wear all day. It is trendy and most of all its inexpensive.

Here are the benefits if you want to buy and own a stainless steel earring:

• First is it is highly versatile. It has the shine and luster just like the silver earrings, wearing it will not make you look cheap. It carries the luminosity, and it’s a good alternative for sterling silver. Usually, gold earrings are only worn for showy purposes, but this stainless steel earring can be worn on any occasion, for comfort, style and fashion.
• If you’re worried every time you wear your usual gold or silver jewelry for a wear and tear and not comfortable with it. You can replace it with stainless steel jewelry, this kind of jewelry contains alloy, which makes it more durable. You’ll not worry every time you wear it in places you want to go and display your earring.
• It is easier to maintain. You won’t have to clean it always unlike the gold and silver ones. You’ll just need to be careful not to scratch it with stronger stainless steel.
• It is more way cheaper then gold or silver. You’re in fashion just spending a small amount of your money and you can always buy new ones. If you want it to be cheaper, you can buy it in stainless steel jewelry wholesale earring. In wholesale, you can display different earrings on your different outfits.

Stainless steel can be bought online like in lynnsfashion.com, they have lots of affordable earring for your fashion and style needs.

Zenith has been the most popular and common name for the timepieces design. The watches that Zenith produces are the most favorites among men and women around the world. The various replica Zenith watches mentioned in the catalog will amaze you by its design and its outer appearance. The replica zenith has a perfect repetition of same quality as the original Zenith watch and that might even surprise you.

Over a period of past seven years the original Swiss watch needed a transformation, so the Replica Zenith watches were created. It is also said that this watches awaken the beauty of Zenith watch which were little bit affected in between due to its high price range. Replica Zenith watches were just created keeping in view about this point. Thierry Nataf made the first step to create the Replica Zenith watches. Now the Replica Zenith watch has earned popularity in the market just because of its quality and affordable price. LVMH made the first step to create this kind of watch because of international competition. Due to above reason these kind of watch gain a large popularity in short span of time.

Replica Zenith watches are made keeping in view of the people. These watches have various language options just as the people may feel easy to enroll the functions. This kind of watch has both the quality as they are having mechanical as well as automated function. Their ranges are differentiated according to the qualities.

Replica Zenith watches is water resistant, Shock resistant.
These watches are created with the highest quality and with lots of mass. Various watches are made according to the requirement of customers. For e.g.; Women are insisting on wearing slim and light weighted watches. Youth are insisting on wearing heavy and watches bearing large dials. The working classes are opting to wear fancy and formal kind of watches. So the company has to keep a view of this and have to produces such kind of watches.
Replica Zenith watches has been successful in giving all kind of ranges. So it is the first option by any human.

The Porsche 911 GT3 is one of the most gorgeous and powerful car from Porsche. It was introduced in 1999 as a high performance version of the first water-cooled version of the Porsche 911.

The 2010 GT3 sees a couple of significant upgrades over the previous GT3, but significantly does not get the direct injection technology found on nearly every other new Porsche model. The powerplant in the 911 GT3 does displace 3.8 liters, up .2 liters over the former GT3, and produces 435 bhp, a jump of 20 horses over the outgoing model.

The newly designed front air vents, ahead of the front hood, channel cooling air to the radiator and, in combination with the front lip spoiler, provide even more front end downforce. As is typical in motorsport, all of the cooling air inlets are protected by new air inlet grilles with a dark grey powder-coated finish.

Now included for the first time is the Porsche Stability Management, which can be completely disabled in the hands of a professional driver but will probably save many a driver with the chips for a 2009 911 GT3 without necessarily carrying the skills to take a rear-engined supercar to its limits.

Stability and traction control systems can also be disabled seperately, giving a discerning driver the ability to only employ the nannies he or she needs for a specific situation.

The low-slung front end, featuring a slew of minor changes to the lip spoiler and lower dams, will lift upon driver command by a full inch for use on bad roads or over bumps.

The lights on the new 911 GT3 have also been completely redesigned, with Bi-Xenon™ headlights fitted as standard. Indicators and LED daytime running lights are harmoniously integrated into the separate front light units over the outer air intakes.

At the rear, distinctive LED lights are drawn right into the fascia and taper outwards. Unmistakable – just like the new fixed bi-plane wing.

2010 Porsche 911 GT3 Specifications
======================================

Drivetrain
Layout    Rear Engine, RWD
Transmission    6 Speed Conventional Manual
Differential    Active Limited Slip

Engine
Type:    Rear-Mounted Flat “Boxer” 6
Displacement    3.8 liters
Horsepower    435 bhp
Induction    Naturally Aspirated
Exterior
Body Type    2 Door, 2 Seat Sport Coupe
Performance
Acceleration 0-60 mph s:    4.0 seconds
0-100 mph    8.2 seconds
Top Speed    194 mph
Base Price: 2010 Porsche 911 GT3: $112,200

The very first thing that you must understand before venturing off car shopping, is that you must take some time to do your homework and educate yourself. And unlike not too many years ago, before so much information was readily available on the internet, today this task is really easy to do.

In this day and age a car is no longer a luxury, but a necessity with our fast paced life and growing families. You will likely have to purchase a new car more than once in your life, for you or for your beloved one so you might as well learn to do it in a way that will make buying the cars less painful.

#1 Budget: Before you do anything either research your current budget or create a new one. This is the basis of success or failure over the next 3-5 years based on the term of your new vehicle loan agreement. Know where you are and what you will be able to pay in the worst case scenario.

#2 Need: Consider the vehicle that you most need to complete your obligations to your family and yourself. Do this for the life of the loan that you will be repaying on the vehicle. Thousands of people purchase the WRONG
VEHICLE every day, and then trade early to fit their need and LOSE a LOT of MONEY. Think it through.

#3 Research:

* Determine your need
* Select vehicles that make sense for you
* Narrow the choices to three
* Compare: Fuel mileage; Safety attributes; Real cost to own in dollars
during the warranty period and after the warranty expires; Vehicle value at
the end of the loan in real dollars; Price to value-what are you getting in
vehicle value based on the dollars spent; compare standard equipment;
compare factory warranty.

#4 Credit information: Gather up your credit information from all 3 bureaus, know where you
stand, know what rates are available to you.

#5 Interest rates: Research current interest rates for the type of vehicle you are buying and
the term you will finance for.

#6 Financing: Arrange financing with a credit union, your bank, or even online with a
reputable lender, compare term and rates.

#7 Dealer reputation: Research the dealer reputation for sales and service. Use the BBB, friends,
and online information. Even if not a great reputation you may still do business there, just let them know up front what you expect, NO NONSENSE IN THE DEAL, GOOD SERVICE.

#8 USED or NEW: Consider USED vs. NEW. You may be able to accomplish your objective by
buying used and save thousands of dollars. However, consider all aspects of the deal and compare both the new and used to determine the total dollars upfront, and the end cost.

#9 Leasing: Consider a lease. Leasing is good business, but not for everyone. Do lease research and then compare a lease deal with a purchase, you might save hundreds, possibly thousands of dollars.

#10 ADD-ON Stuffs: After the deal, beware of the  “ADD-ON” stuff. Car care kits! Extended warranties. Options and option upgrades. Accessories; tires/wheels/moonroofs; music systems, and on and on and on. In thirty minutes with  a greedy F&I person (some are) you could spend several thousand dollars on stuff, pay too much interest, and increase your amount to repay by thousands of dollars. Know what you want and walk away if being “sold” beyond that.

In addition:
#11 If you are trading a vehicle do all the research on the VALUE so you know where you stand in true dollars based on the dealer’s dollar value. Trade dollars vary, but having a baseline allows you to be in the ballpark and gives you a reasonable snapshot of where you should be.

#12 Shop more than one dealer and compare the deals. Be sure and compare equipment, model, trade value, and price. Buy local if possible, there are mutual benefits for you, the dealer, and the community.

#13 Research the factory incentives across the board with the manufacturers, there may be a healthy amount from one to far better your deal.

The use of CSS nowadays is important to all web designers out there. If you are a certified web designer then you should know the importance of having CSS. Your work is being displayed to see by millions of people every day and you must attract the attention of these users. One of the main instruments to make your task a lot easier is with the use of a CSS. If you want to get your website on top you have to increase the volume of visitors in your website.

There are certain things that you have to remember when using a CSS. You have to abide some rules to post your works properly. First, check if your portfolio is free from any kind of errors before posting. You have to ensure that all internal links are functioning. The graphic files must be included and should be properly linked; pages must be structured correctly to have a successful CSS gallery listing.

The site should be free from any errors because it will reflect your credibility as a web designer. It can affect your career and your clients trust to your work. Make sure that the site work properly before you submit or it will hit your reputation. Another important thing to remember when submitting in design gallery is the coding. Be careful with the code because a lot of users will use your code and your syntax should be well organized. All web designers make use of this CSS for the advancement of their career and it is important to maintain their quality of work.

First thing you need to understand is how a web directory works for your benefits and how it can be helpful to those who want to be visible and attain a successful career over the web? For your information, a web directory doesn’t use automated method of reviewing and checking. They use manual method and rank each of those submitted stuff under a category. This is the primary reason why there are times when your submission can be rejected. They do manual checking to make sure only those that are highly qualified will be approved. If you are not aware of this method, you can check the web or better yet check the submission directory you opt for so that you will be able to refer to their guidelines. Directories vary in rules and you need to check on these from time to time.

Web directory also commonly known as link directory increases web traffic on your site. It allows you to do marketing freely without exerting so much effort. There are 2 types of web directory and it’s up to you where you want to engage your works. There are paid and free directory submission sites you can engage these days. Although they both provide the same services, most of this free website contains lots of listing each day. Your listing might not be noticed by most people who will visit the site unless you have a featured listing. It is also important for you to think of ways that will make your listing noticed by more audiences.

My site is on the top of many search engines for the search query “Russian brides”, and as the result I receive lots of requests for interviews from journalists all over the world, and the question they invariably ask is: “Why western men look for Russian women?”

So let me once and forever explain you the reason why thousands western men flock to Russia in search for their love partner.

The answer is benevolently straightforward: they can meet in Russia a partner of better quality than is available for them at home!

They are NOT looking for a Russian woman - they are looking for a better quality woman!

But why it is possible?

I know what you think: you think it is because Russian women are desperate to escape from Russia.

Well, such thinking is pure ignorance.

Check the websites of American expatriates living in Russia (yes, there is a huge community of Americans permanently living in Russia, with their own newspapers and websites!) and you will confirm what I am saying: women who seek partners abroad do it because they want to meet a suitable partner that they have failed to meet at home. They are not looking to immigrate. They are looking to find their love!

Hard to believe?
Read on, I will explain.

The fundamental reason for that lies in Russian demographics.

You know that men to women ratios differ dramatically between the countries.

For example, the latest figures from The Economist show that in United Arab Emirates there are 186 males for 100 females. It’s clear the competition for eligible females should be stiff there. If you are a single male, The Emirates will be the last place in the world to look for an available woman (unless you live there, of course :-).

Now, what is the best place for a single male to score?
Let’s look at the world statistics again.

The lowest men to women ratios are in Eastern Europe!

Countries like Russia and Ukraine are on the top of the list, with only 88 males to 100 females.
The latest Russian census provided astounding figures of 10 million more women than men.
There the situation is exactly the opposite way around: eligible bachelors are more precious than gold.

So if you were a single male, exploring your dating options in Russia would make the perfect sense!

One wise man said: “Craziness is to do the same thing expecting a different result.”

If you ever grow tired of your local dating market, or would like to expand your opportunities, check Russia: you will be stunned what kind of women can be available for you there!

If recruiting is considered the lifeblood of an organization, then training must certainly be its pulse. Experienced salespeople are often reluctant to take time away from their busy schedule for training and as a result, over time, become less productive. It is only natural to expect commission-based salespeople to resist any activity that takes them away from their customers. Award winning sales managers place a high premium on training and purposefully design their training programs to be timely, relevant, realistic, and reoccurring.There is absolutely no substitute for a well-trained and highly motivated sales force! In his best selling book, The 7 Habits of Highly Effective People, Dr. Stephen Covey makes a strong case for the fundamental importance of training, or as he calls it, “sharpening the saw.” In addition to skill development, Dr. Covey points out that time allocated for training also provides an opportunity for much needed personal reflection and renewal. Progress and growth are virtually impossible in an environment void of assessment and training.

Timing is everything. It is important to operate from a written training program and schedule training well in advance. Due to the damaging ripple affect on appointment calendars, training must be scheduled at least 30-days in advance and short notice changes should be avoided. Planning ahead not only helps minimize scheduling conflicts, but it also provides opportunity for training preparation and promotion. Attendees are typically more receptive and inclined to participate when they have been given sufficient time to plan and prepare for the training.

For training to be perceived as relevant and beneficial by the sales force, they must be given the opportunity to contribute to topic selection. An excellent way to elicit input and establish training priorities is through the use of a self-administered, skills assessment survey. A well-designed survey will evaluate skill expertise over a wide array of categories such as administrative tasks, product knowledge, and sales proficiency. For example, it is quite common for a low producer to rate themselves high in product knowledge and low in sales related categories. The skills assessment survey not only provides a good benchmark of an organization’s current overall training level, but it also serves to identify potential peer trainers as well. With the appropriate person, peer training can be extremely effective and therefore should be encouraged.

As they say in the military, train like you plan to fight! Obviously, the more realistic and thought provoking the training, the greater its impact. Build value into your training sessions by finding ways to inject realism. For example, if you are role-playing phone scripts, it’s preferable to separate the participants and conduct the training over the phone vs. across the table. Due to the lack of visual cues, this approach closely mimics the real experience. If a picture is worth a thousand words, then videotaping a role-play session speaks volumes. Videotaped training sessions don’t lie and therefore, provide an excellent opportunity for self-critique. A videotape provides meticulous feedback on body language and sales techniques that otherwise may go unnoticed.

Designing a successful training program is limited only by your creativity. With a little effort and imagination, you can develop a world-class training program that will excite your sales team and keep them coming back for more!

Source: John Boe