Best places to look for MySQL help

This is not a resource list post. It is actually a question for you: where do you go, when you’re looking for MySQL help?

For the last few months I been feeling an itch – having some MySQL experience, I would really like to spend some time helping people solve their MySQL issues for free. But I’ve been blocked on the fact that I don’t really know what is the best place to do this.

Naturally, first place to look for MySQL help is Google. But what do you do when Mr. Google can’t help? Stackexchange? Quora? Percona forums? Maybe some mailing lists ? Do you just leave comments on blog posts that are somewhat on-topic?

Please leave a comment and/or upvote an existing one.

I really appreciate it.

The post Best places to look for MySQL help appeared first on Speedemy.

via Planet MySQL
Best places to look for MySQL help

Ruger Introduces An Integrally Suppressed Barrel for the 10/22 Takedown

Ruger Introduces An Integrally Suppressed Barrel for the 10/22 Takedown
Ruger Introduces An Integrally Suppressed Barrel for the 10/22 Takedown

Ruger FirearmsU.S.A.-( Sturm, Ruger & Co., Inc. (NYSE: RGR) proudly introduces the Silent-SR ISB for the 10/22 Takedown platform. The ISB, or Integrally Suppressed Barrel, is an exciting addition to the Ruger Silent-SR family that delivers quiet and accurate performance in a compact and truly user-serviceable package.

Known for its unrelenting reliability, durability and accuracy, the 10/22 Takedown rifle is the ideal platform for an integral suppressor. The Silent-SR ISB quickly and easily assembles to any Ruger 10/22 Takedown or 22 Charger Takedown, and features an induction-hardened breech with cold hammer-forged barrel that provide easy takedown and accurate return-to-zero – the same elements that have made the 10/22 Takedown an instant classic worthy of its heritage.

Reducing sound pressure levels of .22 LR to an average of 113.2 dB with standard velocity ammunition, a 10/22 Takedown rifle equipped with the Silent-SR ISB is as quiet as a bolt-action rifle with a thread-on silencer. Its compact, 16.12″ barrel length makes the Silent-SR ISB easy to handle, and the relatively long barrel of the Silent-SR ISB (compared to other integral suppressors) means the bullet generates energy near that of a 16″ gun for consistent, accurate and effective performance on target. The pushed-cone baffle geometry has been stretched to utilize the volume under the barrel maximizing suppression of the gunshot without disturbing the travel of the bullet.

Ruger Introduces An Integrally Suppressed Barrel for the 10/22 Takedown
Ruger Introduces An Integrally Suppressed Barrel for the 10/22 Takedown

Disassembly for cleaning is as simple as separating the barrel from your firearm and loosening the Silent-SR ISB’s single assembly screw using the included 5/32″ hex key tool. Once loose, pull the screw to remove all six 17-4 stainless steel baffles, spacer and front cap free of the sleeve for cleaning. The sealed baffles keep the fouling away from the serialized sleeve, yet easily come apart even after thousands of rounds. Finished with Cerakote, the Silent-SR ISB is engineered and built for a lifetime of hard use without clogged ports, seized components or loss of suppression that often plague other integrally suppressed rimfire barrels.

Suppressed firearms help to preserve our hearing, make verbal communication on the range easier and make shooting more fun. Paired with the Ruger 10/22 Takedown, the Silent-SR ISB makes the perfect training, plinking and small-game hunting platform.

All information, including the press release for these products, can be accessed through the links below:

Ruger Silent-SR ISB Information by AmmoLand Shooting Sports News on Scribd

For more information on the Silent-SR ISB or to learn more about the extensive line of award-winning Ruger firearms, visit or To find accessories for Ruger firearms, visit or your local independent retailer of Ruger firearms.

This post Ruger Introduces An Integrally Suppressed Barrel for the 10/22 Takedown appeared first on Shooting Sports News .

via Shooting Sports News
Ruger Introduces An Integrally Suppressed Barrel for the 10/22 Takedown

Percona Live 2017: Lessons Learned While Automating MySQL Deployments in the AWS Cloud

Automating MySQL

Automating MySQLThe last day of Percona Live 2017 is still going strong, with talks all the way until 4:00 pm (and closing remarks and a prize giveaway on the main stage then). I’m going to a few more sessions today, including one from Stephane Combaudon from Slice Technologies: Lessons learned while automating MySQL deployments in the AWS Cloud.

In this talk, Stephane discussed how automating deployments is a key success factor in the cloud. It is actually a great way to leverage the flexibility of the cloud. But often while automation is not too difficult for application code, it is much harder for databases. When Slice started automating their MySQL servers at Slice, they chose simple and production-proven components: Chef to deploy files, MHA for high availability and Percona XtraBackup for backups. But they faced several problems very quickly:

  • How do you maintain an updated list of MySQL servers in the MHA configuration when servers can be automatically stopped or started?
  • How can you coordinate your servers for them to know that they need to be configured as a master or as a replica?
  • How do you write complex logic with Chef without being trapped with Chef’s two pass model?
  • How can you handle clusters with different MySQL versions, or a single cluster where all members do not use the same MySQL version?
  • How can you get reasonable backup and restore time when the dataset is over 1TB and the backups are stored on S3?

This session discussed the errors Slice made, and the solutions they found while tackling MySQL automation.

Stephane was kind enough to let me speak with him after the talk: check it out below:

There are more talks today. Check out Thursday’s schedule here. Don’t forget to attend the Closing Remarks and prize give away at 4:00 pm.

via MySQL Performance Blog
Percona Live 2017: Lessons Learned While Automating MySQL Deployments in the AWS Cloud

Steyr Arms to Unveil the Rimfire Scout RFR at the NRA Annual Meetings

Steyr Arms Rimfire Scout RFR
Steyr Arms Rimfire Scout RFR

Steyr Arms

BESSEMER, Ala. -( The Steyr Scout RFR, a blazingly fast straight-pull rifle that emulates the look and feel of the original Steyr Scout Rifle on a rimfire platform, will make its official debut to the American public in the Steyr Arms booth (#3258) at the NRA Annual Meetings of Members and Exhibits in Atlanta tomorrow.

Based on the proven, biathlon-inspired SPA action built by fellow Austrian firearms manufacturer ISSC, the Steyr Scout RFR was designed from the ground up as an economical, minimal-recoil Scout Rifle trainer. Available in .22 LR, .22 WMR, and .17 HMR, the Scout RFR has an exceptionally smooth straight-pull action fed from its 10-round magazine, allowing for extremely fast cycling that makes training easy and range time enjoyable.

Code-named “Cub Scout” during its development, the Scout RFR features the same stock lines as the original Steyr Scout, as designed by Steyr engineers with the continual input of scout-rifle-concept visionary, Col. Jeff Cooper.

The Scout RFR provides a 30-slot Picatinny rail along its barrel for forward-mounted optics. An integrated 3/8-inch dovetail base also runs the full length of the receiver’s topside, and a set of Weaver bases are also included for conventional scope mounting.

The Scout RFR also features a 20-inch heavy-barrel configuration for maximum accuracy. Both the .17 HMR and .22 LR barrels are 1/2-20 UNF threaded for the users’ choice of attachments, while the .22 WMR barrel is not.

Steyr Arms Rifle Specs Chart
Steyr Arms Rifle Specs Chart

The overall length of the Scout RFR is 35.6 inches, and its base weight is 7.3 pounds. An optional knife tucks away neatly into the stock, and the standard Steyr SBS/Scout buttplate spacers can be swapped in or out to adjust length-of-pull.

The Scout RFR may not be exactly what Col. Cooper envisioned with his center-fire scout-rifle concept, but this rimfire rifle makes the idea as accessible to everyone as easy as it makes taking squirrels in your back yard or gaining a merit badge.

The Steyr Scout RFR includes two Weaver bases; one 10-round, steel-box magazine; and an owner’s manual. The suggested retail of the Scout RFR is $599.


About Steyr Arms:

Steyr Mannlicher, GmbH, is one of the world’s oldest and most prestigious firearms manufacturers. Steyr’s comprehensive lines of premium hunting rifles and precision sporting and tactical firearms are technically mature, and their subtle elegance also communicates the harmony between appearance and substance. Steyr’s legendary SBS actions and cold-hammer-forged barrels are distinctive and unparalleled. Steyr Arms is the subsidiary headquarters of Steyr Mannlicher in the U.S.

For more information, contact Steyr Arms at 2530 Morgan Rd., Bessemer, AL 35022; call (205) 417-8644; or visit their website.

This post Steyr Arms to Unveil the Rimfire Scout RFR at the NRA Annual Meetings appeared first on Shooting Sports News .

via Shooting Sports News
Steyr Arms to Unveil the Rimfire Scout RFR at the NRA Annual Meetings

An Accurate and Automatic Device for the Detection of Chemicals on Food Produce

Today, scanning for food contaminants, such as pesticides, can only be done using equipment that is: expensive to buy, expensive to operate, immobile, requires skilled personnel, and does not supply immediate results. The food industry, from farmers, producers, handlers, regulators and retailers to consumers, is in need of a better solution.INSPECTO is an innovative startup company aiming to revolutionize the process by producing an accurate, portable, affordable, quick and automatic device for the detection of chemicals on food produce, both liquid and solid.

View the full content here
via Core77
An Accurate and Automatic Device for the Detection of Chemicals on Food Produce

Percona Live 2017: Designing your SaaS Database for Scale with Postgres


PostgresThe Percona Live Open Source Data Conference 2017 day one is rolling right along, and we’re already in the afternoon sessions. In this blog, we’ll look at Citus Data’s presentation on how to design your SaaS database to scale with Postgres.

If you’re building a SaaS application, you probably already have the notion of tenancy built in your data model. Typically, most information relates to tenants/customers/accounts and your database tables capture this natural relation. With smaller amounts of data, it’s easy to throw more hardware at the problem and scale up your database. As these tables grow, however, you need to think about ways to scale your multi-tenant database across dozens or hundreds of machines. In this talk, Citus Data’s Lukas Fittl and Ozgun Erdogan (CTO) talked about the motivations behind scaling your SaaS (multi-tenant) database and several heuristics they found helpful in deciding when to scale.

They then described three design patterns that are common in scaling SaaS databases:

  1. Create one database per tenant
  2. Create one schema per tenant
  3. Have all tenants share the same table(s).

Next, they highlighted the tradeoffs involved with each design pattern and focused on one pattern that scales to hundreds of thousands of tenants. They also shared an example architecture from the industry that describes this pattern in more detail. Lastly, they talked about key PostgreSQL properties, such as semi-structured data types, that make building multi-tenant applications easy.

After the talk, Lukas and Ozgun were kind enough to speak with me about their session. Check it out below:

Don’t miss any of tomorrow’s session. See Wednesday’s (4/26) full schedule here.

via MySQL Performance Blog
Percona Live 2017: Designing your SaaS Database for Scale with Postgres

PHOTOS: Ikea has furniture on the floor, product on the shelves

The allen wrenches are cranking away at Ikea.
The Swedish mega retailer’s Columbus store at 1900 Ikea Way off Polaris Parkway remains on track for its June 7 opening. I was invited to the site Tuesday to get a peek at the progress.
Interior walls that set the consumer path through the showroom are up and work is underway on all of the departments and rooms shoppers will amble through in a few short weeks.
Check out the slideshow to see how the store is coming along.
It isn’t just display…

via Columbus Business News – Local Columbus News | Business First of Columbus
PHOTOS: Ikea has furniture on the floor, product on the shelves

President Trump’s First 100 Days

Everyone observing politics seems to agree on two things about a president’s first 100 days in office:

1. 100 days is a meaningless, arbitrary marker for a president’s performance that is likely to be more misleading than useful.


2. Let’s treat it like it is important! Reeeeeeee!

The thing that fascinates me the most about this situation is that the so-called “pro-science” people are giving Trump low grades for his first 100 days.

Allow me to connect some dots.

In science, you don’t have much of an experiment unless you have a control case for comparison. For example, you can’t know if a drug helped with a particular disease unless you study the people who didn’t take the drug at the same time as those who did.

But the pro-science people forget this concept when thinking about politics. Where is the control case for Trump’s first 100 days?

Is it George Washington’s first 100 days?

Is it Jimmy Carter’s first 100 days?

And which prior president came to office in 2017 with identical problems and the most polarized political environment in history?

And just how long is it supposed to take to revise Obamacare? Do we compare it to the time Abe Lincoln repealed and replaced Obamacare? Or how about the time those other presidents repealed and replaced Obamacare in the year 2017? 

I saw an article in Politico that is too dumb to link to, saying it is objectively true that Trump has had a bad first 100 days. This is a perfect example of what I call the “two movies on one screen effect.” I’m almost certain that many Trump supporters would say these facts are objectively true too:

Economic confidence is up.

Trump signed a bunch of executive orders. You might not like them, but that’s more about you, not about his job performance.

China is putting the screws on North Korea (finally)

Trump erased the “puppet of Putin” charge by prudent application of Tomahawk missiles. That’s an accomplishment, even if you don’t like it.

Trump erased the “Trump is Hitler” hallucination that the Clinton side spray-painted onto him during the election. (That’s a big deal.)

Trump got a qualified Supreme Court judge, albeit the hard way.

Healthcare is moving along briskly from the first plan that was terrible to something that is approaching feasible. That’s progress, not failure.

Tax reform will probably be slower than we want, but most observers expect something good to come of it.

International relations look fine. The only awkward relationship is with Putin, and that’s the awkward relationship Trump’s detractors want.

Illegal immigration is way down because of Trump’s persuasion.

Now let’s look at the things President Trump did wrong in his first 100 days:

You can criticize Trump’s actions against women’s reproductive rights, both on the topic of Planned Parenthood funding and his Supreme Court pick. But calling those things failures or successes depends on your political views, not on Trump’s job performance.

I think you could make an objective case against Trump for putting economics above the environment. But you’d have to ignore the fact that a stronger economy almost always puts you in a better position to keep the environment clean. (Trump says that.) You don’t see clean air and water in poor countries. 

President Trump reversed a bunch of campaign statements from impractical positions to more practical ones. Is that failure?

President Trump said a bunch of things that did not pass the fact-checking, surprising literally no one. And as usual, none of it mattered in any way except that it made us focus on whatever topic he wanted us to focus on.

President Trump’s staff and advisors are reportedly doing a lot of in-fighting for influence. But that sounds more like a healthy situation than a Trump-is-dictator situation. It would be worse if there were no differences of opinion in the group.

President Trump has been slow to fill lots of government positions. But has any of that mattered to your life? I haven’t noticed, personally. Was the Secretary of Whatever supposed to come over and mow my lawn?

President Trump did not release his tax returns, so we imagine there are problems there.

President Trump incorrectly claimed that his staff had been “wiretapped.” It turns out that they were only legally surveilled in an indirect way. Which only sounds different to his critics.

Generally speaking, the criticisms of President Trump’s first 100 days (and in general) are based on imaginary stuff:

Imagined problems on his tax returns.

Imagined blackmail by Russia.

Imagined poor performance based on imagining a control case of another imaginary president doing the same job at the same time, but doing it faster.

Imaginary belief that doing things you prefer he not do is similar to not being competent.

Imagined staff problems that are bigger than they are.

Imagined nuclear holocaust that happens because of Trump’s imaginary insanity.

Imagined problems caused by his ignoring of facts that don’t matter.

Imagined future climate calamity. (They could be right, but for now it is imaginary because complex models have a bad track record.)

You might enjoy reading my book because it performed better than all the imaginary books I am comparing it to.

I’m also on…

Twitter (includes Periscope): @scottadamssays​

YouTube: At this link.

Instagram: ScottAdams925

Facebook Official Page:

via Scott Adams’ Blog
President Trump’s First 100 Days