No Image

MySQL 8.0.1: Using SKIP LOCKED and NOWAIT to handle hot rows

2017-04-13 KENNETH 0

MySQL 8.0.1: Using SKIP LOCKED and NOWAIT to handle hot rows MySQL 8.0.1 introduces two new features which allow you to better manage situations where you have tables with hot row contention.  This issue frequently presents itself in scenarios such as worker threads all accessing the same tables trying to find new work, and ecommerce websites trying to keep accurate inventory counts.… Source: MySQL 8.0.1: Using SKIP LOCKED and NOWAIT to handle hot rows

No Image

Disabling VBScript execution in Internet Explorer 11

2017-04-13 KENNETH 0

Disabling VBScript execution in Internet Explorer 11 VBScript is deprecated in Internet Explorer 11, and is not executed for webpages displayed in IE11 mode. However, for backwards compatibility, VBScript execution is currently still permitted for websites rendered in legacy document modes. This was introduced as a temporary solution. Document modes are deprecated in Windows 10 and not supported at all in Microsoft Edge. To provide a more secure experience, both the Windows 10 Creators Update and Cumulative Security Update for Internet Explorer-April 11, 2017 introduce an option to block VBScript execution in Internet Explorer for all document modes. Users can configure this behavior per site security zone via registry or via Microsoft Easy fix solution. Enterprise customers can also configure this behavior via Group Policy. Recommended Actions As a security best practice, we recommend that Microsoft Internet Explorer users disable [ more… ]

Spring Sale is on now in the Windows Store

2017-04-13 KENNETH 0

Spring Sale is on now in the Windows Store We’re ushering in the new season with fresh deals in the Windows Store, with more than 100 special offers on top games, movies & TV, apps and music. Hop into the Windows Store now through April 17* for big savings! Below are 10 of our favorite Spring Sale deals for Windows 10 devices: Up to 50% off great games Forza Horizon 3: Ultimate Edition – 40% off Take to the open roads of Australia, then connect them into the wildest, most far-ranging Forza game yet. Halo Wars 2: Ultimate Edition – 35% off Real-time strategy makes an explosive return to the Halo universe in Halo Wars 2: Ultimate Edition, where you lead Spartans, Warthogs and other classic Halo fighting forces in a brutal war against a terrifying new enemy. Fallout Shelter [ more… ]

No Image

MySQL 8.0: Improved performance with CTE

2017-04-12 KENNETH 0

MySQL 8.0: Improved performance with CTE MySQL 8.0 introduces Common Table Expressions (CTE). My colleague Guilhem has written several blog posts on how to use CTEs , and you can also read about it in the MySQL 8.0 Reference Manual. In this blog post, I will focus on how using a CTE instead of a view or a derived table can improve performance.… Source: MySQL 8.0: Improved performance with CTE

No Image

NGINX Plus as a Virtual Load Balancer

2017-04-12 KENNETH 0

NGINX Plus as a Virtual Load Balancer Although virtual machines have been overshadowed in recent years by the buzz around containers, their use continues to increase. NGINX and NGINX Plus are widely used as a virtual load balancer in such deployments. In this article we spell out the many advantages of virtual load balancers for many use cases and describe how to quickly and easily implement NGINX Plus as a virtual load balancer. Prebuilt and Build‑It‑Yourself Virtual Machines Virtualized load balancing offers much more flexibility than hardware‑based load balancers or application delivery controllers (ADCs), and so the major hardware vendors have created virtualized offerings, commonly referred to as virtual appliances. These appliances are prebuilt, meaning that the vendor creates a virtual machine image with its proprietary software preinstalled on a particular operating system. As such, a prebuilt virtual appliance is tied to [ more… ]