Just another WordPress site
Summary: in this tutorial, you will learn how about SQL MINUS operator and how to simulate MySQL MINUS operator using join. Introduction to SQL MINUS operator MINUS is one of three set operations in the SQL standard that includes UNION, INTERSECT, and MINUS. MINUS compares results of two queries and returns distinct rows from the […]
The post MySQL MINUS appeared first on MySQL Tutorial.
While the Epixor name has long been associated with Okuma spinning reels, the all-new Epixor XT adds a body built from C-40X long-strand graphite fiber for enhanced durability. Additional features include Okuma’s slow oscillation system for optimal lime lay, 7+1 bearing construction and a multi-disc drag that can exert more than 22 pounds of drag pressure. Available in three sizes (20, 30 and 40 series) the Epixor XT comes with a one-year warranty. MSRP is $69.99
The fourth generation Revo low profile baitcasting reel, Abu Garcia’s new Revo premier takes smoothness and durability to a new level with 10 stainless steel HPCR bearings plus 1 roller bearing, an alloy frame with carbon side plates, Abu’s Carbon Matrix drag system and Infini II spool, and a lube port for easy maintenance. An oversized cranking handle and knobs provide greater leverage and comfort. MSRP is $299.95.
2017 may well go down as the year of the frog at ICAST, with frog baits more prominent than ever. Leading the charge is Doomsday tackle’s new D-Hop 90. Made from DuraFoam, the D-Hop 90 can never be filled with water no matter how many pike chew on it. Soft and pliable, yet buoyant enough to float any hook the angler chooses to use, it offers an easy walking action supported by floppy legs for enhanced appeal. MSRP is $7.49.
Show off your angler’s pride all the time with the Wader Maker wallet by Simms. Made from the same Gore-Tex material used in the company’s premium waders, this wallet features six card slots, two currency pockets and an embossed Simms trout logo in a slim fold, easy wearing design. It’s also just plain cool. MSRP is $89.95.
The Raffal from Biwaa Fishing Performance is an all-new jerk bait design built using a resin body for extreme durability, yet matching wooden baits in terms of performance. The Raffal delivers an erratic or gliding action depending on the retrieve, and shimmies enticingly as it falls on a slack line. Photorealistic finishes using Clone Tech – Capture Life technology give these baits an irresistible appearance. MSRP for the 4-inch model is $14.99, while the 6-inch Raffal is $17.99.
Walleye, salmon and steelhead anglers will appreciate the new Haira Tiny from Lucky John USA. This shallow diving, thumbnail-sized wobbler floats at rest, providing an enticing action when retrieves in a slow stop-and-go. With a steady retrieve, the Haira Tiny vibrates quickly, delivering intense vibrations fish can sense at long distances. Lucky John’s OSS system provides increased casting range as well. MSRP is $8.99.
Star brite’s Magic Sponge scuff and streak eraser uses a non-abrasive texture to safely remove stains and scuff marks from fiberglass boat decks, vinyl, plastic and other surfaces. Individually, packed, the Magic Sponge is perfect for spot clean-ups in a boat, RV, garage or house. MSRP is $2.99.
The PackFish 7 from Sea eagle weighs just 21 pounds and packs down to a 20x20x5 inch package that can be worn as a backpack, allowing anglers to effectively fish even the most remote waters. The PVC ladder is protected by a thick 840 denier nylon fabric to protect against punctures. Standard features include oak locks, rod holders, a measuring tape and two large gear pockets with cup holders. Inflated, it supports up to 300 pounds of angler and gear. MSRP is $399 – $439.
The post Best New Products of iCAST: Day 3 appeared first on AllOutdoor.com.
This isn’t just a video extolling the film’s special effects or praising the story (though there’s plenty of that). You also get to see new characters, new creatures, new settings, and what looks to be a couple of between-shot dance parties. This Last Jedi behind-the-scenes reel is jam-packed with so much awesome.
We’ll have a closer look at everything revealed in this clip very soon.
Star Wars: The Last Jedi has also begun sharing some gorgeous character posters. So far, Leia and Finn have made their way online.
And Rey and Luke too.
Star Wars: The Last Jedi is out December 15, 2017.
via Gizmodo
Go Behind the Scenes of Star Wars: The Last Jedi in This Awesome New Video
dork-cli is a Python-based command-line Google Dork Tool to perform searches againsts Google’s custom search engine. A command-line option is always good as it allows you to script it in as part of your automated pen-testing suite.
It will return a list of all the unique page results it finds, optionally filtered by a set of dynamic page extensions.
Any number of additional query terms/dorks can be specified. dork-cli was designed to be piped into an external tool such as a vulnerability scanner for automated testing purposes.
In order to use this program you need to configure at a minimum two settings: a Google API key and a custom search engine id.
Custom Search Engine:
API key:
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 |
$ ./dork–cli.py –h usage: dork–cli.py [–h] [–e ENGINE] [–f [FILETYPES]] [–k KEY] [–m MAX_QUERIES] [–s SLEEP] [T [T ...]]
Find dynamic pages via Google dorks.
positional arguments: T additional search term
optional arguments: –h, —help show this help message and exit –e ENGINE, —engine ENGINE Google custom search engine id (cx value) –f [FILETYPES], —filetypes [FILETYPES] File extensions to return (if present but no extensions specified, builtin dynamic list is used) –k KEY, —key KEY Google API key –m MAX_QUERIES, —max–queries MAX_QUERIES Maximum number of queries to issue –s SLEEP, —sleep SLEEP Seconds to sleep before retry if daily API limit is reached (0=disable) |
The free Google API limits you to 100 searches per day, with a maximum of 10 results per search. This means if you configure dork-cli.py to return 100 results, it will issue 10 queries (1/10th of your daily limit) each time it is run. You have the option to pay for additional searches via the Google API console. At the time of writing, signing up for billing on the Google API site gets you $300 free to spend on API calls for 60 days.
You can download dork-cli here:
Or read more here.
via Darknet – The Darkside
dork-cli – Command-line Google Dork Tool
“My hilarious father, (the one with the magazine), and my grandfather, grandmother, and uncle at his bar mitzvah.”
(via source)
The post Becoming A Man appeared first on AwkwardFamilyPhotos.com.
In this blog post, I’ll look at a trick we use at Percona when upgrading to MySQL 5.7.
I’ll be covering this subject (and others) in my webinar Learning MySQL 5.7 on Wednesday, July 19, 2017.
We’ve been doing upgrades for quite a while here are Percona, and we try to optimize, standardize and improve this process to save time. When upgrading to MySQL 5.7, more often than not you need to run REPAIR or ALTER via mysql_upgrade to a number of MySQL tables. Sometimes a few hundred, sometimes hundreds of thousands.
One way to cut some time from testing or executing mysql_upgrade is to combine it with mysqlcheck. This identifies tables that need to be rebuilt or repaired. The first step is to capture the output of this process:
|
revin@acme:~$ mysqlcheck —check–upgrade —all–databases > mysql–check.log |
This provides a lengthy output of what needs to be done to successfully upgrade our tables. On my test data, I get error reports like the ones below. I’ll need to take the specified action against them:
|
ads.agency error : Table upgrade required. Please do “REPAIR TABLE `agency`” or dump/reload to fix it!
store.categories error : Table rebuild required. Please do “ALTER TABLE `categories` FORCE” or dump/reload to fix it! |
Before we run through this upgrade, let’s get an idea of how long it would take for a regular mysql_upgrade to complete on this dataset:
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 |
revin@acme:~$ time mysql_upgrade Enter password: Checking if update is needed. Checking server version. Running queries to upgrade MySQL server. Checking system database. mysql.columns_priv OK mysql.db OK ... mysql.user OK Upgrading the sys schema. Checking databases. ads.account_preference_assoc OK ... Repairing tables ... ads.agency Note : TIME/TIMESTAMP/DATETIME columns of old format have been upgraded to the new format. status : OK ... `store`.`categories` Running : ALTER TABLE `store`.`categories` FORCE status : OK ... Upgrade process completed successfully. Checking if update is needed.
real 25m57.482s user 0m0.024s sys 0m0.072s |
On a cold server, my baseline above took about 25 minutes.
The second step on our time-saving process is to identify the tables that need some action (in this case, REPAIR and ALTER … FORCE). Generate the SQL statements to run them and put them into a single SQL file:
|
revin@acme:~$ for t in $(cat mysql–check.log |grep –B1 REPAIR | egrep –v ‘REPAIR|–‘); do echo “mysql -e ‘REPAIR TABLE $t;'” >> upgrade.sql; done revin@acme:~$ for t in $(cat mysql–check.log |grep –B1 ALTER | egrep –v ‘ALTER|–‘); do echo “mysql -e ‘ALTER TABLE $t FORCE;'” >> upgrade.sql; done |
My upgrade.sql file will have something like this:
|
mysql –e ‘ALTER TABLE store.categories FORCE;’ mysql –e ‘REPAIR TABLE ads.agency;’ |
Now we should be ready to run these commands in parallel as the third step in the process:
|
revin@acme:~$ time parallel –j 4 — < upgrade.sql ... real 17m31.448s user 0m1.388s sys 0m0.616s |
Getting some parallelization is not bad, and the process improved by about 38%. If we are talking about multi-terabyte data sets, then it is already a big gain.
On the other hand, my dataset has a few tables that are bigger than the rest. Since mysqlcheck processes them in a specific order, one of the threads was processing most of them instead of spreading them out evenly to each thread by size. To fix this, we need to have an idea of the sizes of each table we will be processing. We can use a query from the INFORMATION_SCHEMA.TABLES for this purpose:
|
revin@acme:~$ for t in $(cat mysql–check.log |grep –B1 ALTER | egrep –v ‘ALTER|–‘); do d=$(echo $t|cut –d‘.’ –f1); tbl=$(echo $t|cut –d‘.’ –f2); s=$(mysql –BNe “select sum(index_length+data_length) from information_schema.tables where table_schema=’$d’ and table_name=’$tbl’;”); echo “$s |mysql -e ‘ALTER TABLE $t FORCE;'” >> table–sizes.sql; done
revin@acme:~$ for t in $(cat mysql–check.log |grep –B1 REPAIR | egrep –v ‘REPAIR|–‘); do d=$(echo $t|cut –d‘.’ –f1); tbl=$(echo $t|cut –d‘.’ –f2); s=$(mysql –BNe “select sum(index_length+data_length) from information_schema.tables where table_schema=’$d’ and table_name=’$tbl’;”); echo “$s |mysql -e ‘REPAIR TABLE $t;'” >> table–sizes.sql; done |
Now my table-sizes.sql file will have contents like below, which I can sort and pass to the parallel command again and cut even more time!
|
32768 |mysql –e ‘REPAIR TABLE ads.agency;’ 81920 |mysql –e ‘ALTER TABLE store.categories FORCE;’ |
|
revin@acme:~$ cat table–sizes.sql |sort –rn|cut –d‘|’ –f2 > upgrade.sql revin@acme:~$ time parallel –j 4 — < upgrade.sql ... real 8m1.116s user 0m1.260s sys 0m0.624s |
This go-around, my total execution time is 8 minutes – a good 65% improvement. To wrap it up, we will need to run mysql_upgrade one last time so that the system tables are also upgraded, the tables are checked again and then restart the MySQL server as instructed by the manual:
|
revin@acme:~$ time mysql_upgrade —force |
The whole process should be easy to automate and script, depending on your preference. Lastly: YMMV. If you have one table that is more than half the size of your total data set, there might not be big gains.
If you want to learn more about upgrading to MySQL 5.7, come to my webinar on Wednesday, July 19: Learning MySQL 5.7. This process is only one of the phases in a multi-step upgrade process when moving to 5.7. I will discuss them in more detail next week. Register now from the link below, and I’ll talk to you soon!
via MySQL Performance Blog
A Little Trick Upgrading to MySQL 5.7
When your manager comes back from a basic SQL querying class and asks from sysadmin access to production.
via DBA Reactions
When your manager comes back from a basic SQL querying class and…
The Happiest Place on Earth isn’t so happy when you’ve been stuck in line for Space Mountain the past two-and-a-half hours on a sweltering Saturday in July, stress-eating a Mickey-shaped pretzel. Next time, avoid the theme park masses by analyzing line data.
The Los Angeles Times has put together a wildly comprehensive guide to choosing the best time to visit Disneyland and California Adventure based on average wait times for rides. Search for your favorite, can’t-miss rides, check the chart to see when the wait is the shortest, and strategize your trip your trip accordingly.
For instance, Splash Mountain has a peak wait time of 62 minutes at 3 p.m., so do something else around that time. Unsurprisingly, the wait time for this ride is the least miserable when the park opens to the general public at 8 a.m. The Los Angeles Times recommends arriving to the parks at least a half-hour before they open. Do this if you want to maximize that $174 (on peak dates) Park Hopper ticket.
Other takeaways from the Times analysis, which used data from touringplans.com:
Advertisement
Advertisement
Don’t waste your time at Disneyland. Here’s how to avoid the lines. | Los Angeles Times
via Lifehacker
Go to Disneyland on a Wednesday Morning in September
This weekend is Disney’s D23 expo, where the company often unveils the first glimpses into what it has in store for the years ahead.
Our own Editor-and-Disney-aficionado-in-Chief Matthew Panzarino is down in LA for the event’s early access press day. Disney just pulled back the curtain on a bunch of stuff that’ll appear in the Star Wars Land parks that are set to open at Disneyland and Disneyworld in 2019, and he’s got pics of everything.
I expect we’ll see quite a bit more about Star Wars Land (and, hopefully, the tech that’ll power it) throughout the weekend, but here’s a little sneak peek of what we’ve seen so so far. Tap that right arrow to proceed through the slideshow — or if you’re on mobile, just scroll.
via TechCrunch
Here’s a sneak peek of what Disney’s Star Wars Land will look like
Summary: in this tutorial, you will learn how to use the MySQL EXTRACT() function to extract part of a DATE or DATETIMEvalue. Introduction to the MySQL EXTRACT function The EXTRACT() function extracts part of a date. The following illustrates the syntax of the EXTRACT() function. [crayon-596848704a2f5006580142/] The EXTRACT() function requires two arguments unit and date. […]
The post MySQL EXTRACT Function appeared first on MySQL Tutorial.