Thank you for attending the webinar ! Here are the ppt slides.
If you missed it, you can still join the archived event by clicking the URL below.
http://ift.tt/1f4fkEB
There were a lot of attendees and a lot of questions. I could not answer everything during the limited time. But here are finally the answers !
Question
Answer
Can MEM be used on community version?
Yes, of course. any known problems for MySQL running on an overprovisioned VMWare environment….for instance, the VMWare admins over allocate CPU for all the Vms?
Yes, a busy MySQL server needs cores, memory and fast storage and network. If these ressources are shared by busy servers then performance drops dramatically.
what makes XFS better over EXT4 ?
XFS works better with O_DIRECT. XFS had historically better support for SSD (TRIM). See http://ift.tt/TwMsvd
Does sync_binlog=1 effect on write performance or read performance
Write performance only (fsyncs)
What are the disadvantage of setting wait_timeout and interactive_timeout value to 1 ?
Any query executing longer than 1s will be interrupted.
You focus on innoDB, is there no case where MyISAM would be preferable?
Not really. MyISAM uses the OS to cache the data and requires a lot of system calls.
MySQL 5.6 introduced read only transactions and full text indexes for InnoDB. It can only think of spatial indexes.
what monitor instruments you recommend in mac os x system.
On Mac OS X, you can install MEM to monitor the database. The performance_schema and ps_helper will also work on any platform. DTrace can be helpful too.
How do i check Qcache_free_blocks?
show global status like ‘Qcache_free_blocks’;
How Table Partitioning effect the performance on read and write ? Partitioning can improve read and write performance. But it requires more tuning than a normal table. The table and query designs are critical. I would recommend to use as little partitions as possible, use pruning for all queries. Partitioning is the best way to delete useless rows (drop or truncate partitions). If a query does not use pruning, then it is more expensive in terms of locking and table access, especially range index scans. Partitioning is good for big data when the insertion rate is limited by the table size.
Are there any recommendations for running MySQL on ESX?
see http://ift.tt/1f4fkEC
what is the scope of mysql dba in market as per current trends?
I can not answer this question. I know that there is a high demand for MySQL DBAs worldwide
Sir I have E-5 family server getting slow while fetching 1 row from table
any tips to make it more faster, Using MYISAM
It is hard to tell. Again I recommend InnoDB. If you can, please open a support request or submit your question to http://ift.tt/hmaHsk
via Planet MySQL
50 tips to boost MySQL Performance Webinar follow up
Total Recall #4: The Ultimate Collection of the 100 Best Free WordPress Themes of 2013
|
|
Thanks for voting our Total Recall series a success. A whole lot of people have been reading our first three parts, so we decided to give you all more of the good stuff and extend our series into other topics. Today we bring you the ultimate collection of the 100 best free WordPress themes of 2013, and hope you enjoy it as much as you did with icons, UI sets and HTML/PSD templates. You might think, choosing a premium theme guarantees for the best possible experience, when it comes to building a WordPress site. This is certainly true in a lot of cases, ye there are quite a few free templates that have much to offer when it comes to functionality. Along with basic features that are inherent to almost every modern theme, they are also rich in specific components that depending on the type of theme can of course vary. You can easily create a website that is populated with various widgets, sliders, carousels, galleries, lightboxes, even contact forms that are traditionally found only in paid versions. As for customization, it is also not a problem since each theme provides its owner with a small yet effective option panel that helps you change the background, set coloring, quickly upload logos and much more.
via noupe
Total Recall #4: The Ultimate Collection of the 100 Best Free WordPress Themes of 2013
Transformers 4 trailer UNLEASHES THE DINOBOTS
In this thundering Transformers: Extinction trailer, Stanley Tucci and all the humans tell the Transformers "we don’t need you any more." And then guess what happens next? BLAMMO: Dinobots! Watch the first real Dinobot-on-Autobot fight.
When to Buy Your Plane Ticket, Based on Data from Four Million Trips
When you’re booking a flight, you don’t want to buy too far in advance—and be the guy who lost out on a price drop; nor do you want to book too late—and pay hundreds more for the convenience. When’s the best time to buy? CheapAir crunched the numbers from over four million tickets bought last year to offer some advice.
Those four million tickets add up to a database of 1.3 billion air fares. What they found, at least for domestic airfares, is there’s a "prime booking window" of between 29 and 104 days in advance when the average fare is at its lowest (so, roughly a month to three months before the flight). Taken altogether, 54 days in advance is the best time to buy, based on this data.
As you can see from the chart above, the cost of waiting up to 13 days in advance is enormous.
These real-world findings back up one economist’s calculation of the cheapest time to book a flight
, eight weeks.
CheapAir notes, however, that the exact 54 days in advance number isn’t very important. Prices for each trip will rise and fall volatilely depending on the market and when you’re flying. As a rule of thumb, you should still keep checking fares frequently and grab a good deal when you see one.
When should you buy your airline ticket? Here’s what our data has to say | CheapAir
via Lifehacker
When to Buy Your Plane Ticket, Based on Data from Four Million Trips
The way of the sword
Dilbert 2014-03-02
Dilbert 2014-02-28
Dilbert 2014-02-27
Why you should always order the largest pizza in one graphic
This is why I love data and data visualization: The larger the pizza, the cheapest the price per square inch is. Get the largest size, eat the rest at room temperature the next day.
via Gizmodo
Why you should always order the largest pizza in one graphic
Rinse Bacon in Water Before Cooking to Reduce Shrinkage by 50 Percent
This sounds like a bizarre thing to do, but we’re talking about less bacon shrinkage! Rinse your bacon before you cook it and you’ll have longer strips to enjoy.
This tip has been circling around the interwebs for a while. Fran at the Franalan blog put it to the test and confirmed her bacon did not shrink. Several people at Thrify Fun, BabyCenter, and Art of Manliness report the same. I, sadly, do not have any bacon on hand to rinse, but if it’s on a Snapple real facts cap, it’s definitely worth a try.
Also, cooking bacon in the oven definitely is a superior method, but if you want to cook it in a skillet, Cooking Light suggests you could also prevent some shrinkage by starting with a cold pan and flipping often.
Cooking Perfect Bacon | Franalan.com
Photo by Lifehackable.
via Lifehacker
Rinse Bacon in Water Before Cooking to Reduce Shrinkage by 50 Percent