Unexpected query execution plan on MySQL 8 when using Datetime range

I have a MySQL 8 database with about 900 millions of rows. When I run the following query the response is very slow because table B doesn’t seem to be using the right index:

SELECT  B.name

FROM A JOIN B ON A.key1 = B.key1 AND A.key2 = B.key2
WHERE
    A.active = True
    AND B.datetime  > '2020-05-28 00:00:00' AND B.datetime  < '2020-05-29 00:00:00'
    AND A.type = 1

The query has the following execution plan (EXPLAIN FORMAT=JSON):

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "10202799.44"
    },
    "nested_loop": (
      {
        "table": {
          "table_name": "A",
          "access_type": "ref",
          "possible_keys": (
            "ix_A_type_key1",
          ),
          "key": "ix_A_type_active",
          "used_key_parts": (
            "type",
            "active"
          ),
          "key_length": "5",
          "ref": (
            "const",
            "const"
          ),
          "rows_examined_per_scan": 62738,
          "rows_produced_per_join": 62738,
          "filtered": "100.00",
          "cost_info": {
            "read_cost": "62738.00",
            "eval_cost": "6273.80",
            "prefix_cost": "69011.80",
            "data_read_per_join": "1G"
          },
          "used_columns": (
            "active",
            "type",
            "key1",
            "key2"
          )
        }
      },
      {
        "table": {
          "table_name": "B",
          "access_type": "ref",
          "possible_keys": (
            "ix_B_key1_datetime",
            "ix_B_key2_datetime"
          ),
          "key": "ix_B_key2_datetime",
          "used_key_parts": (
            "key2"
          ),
          "key_length": "258",
          "ref": (
            "A.key2"
          ),
          "rows_examined_per_scan": 147,
          "rows_produced_per_join": 3136,
          "filtered": "0.03",
          "cost_info": {
            "read_cost": "9211170.19",
            "eval_cost": "313.69",
            "prefix_cost": "10202799.44",
            "data_read_per_join": "96M"
          },
          "used_columns": (
            "key1",
            "key2",
            "datetime",
            "name",
          ),
          "attached_condition": "((`B`.`key1` = `A`.`key1`) and (`B`.`datetime` > TIMESTAMP'2020-05-28 00:00:00') and (`B`.`datetime` < TIMESTAMP'2020-05-29 00:00:00'))"
        }
      }
    )
  }
}

Table B In the used_key_parts it’s only using the column key2 instead of the full composite index key2 + datetime (ix_B_key2_datetime). Why is not using the datetime part of the composite index? Is there a way to speed up this query?

Asset Progression Plan

With an income of $8K onwards, many homeowners have UPGRADED to private properties without paying extra cash from their own pocket thru our Asset Progression Plan. Do you wish to be like them?

Contact Andy Goh | Asset Progression Consultant

Does upgrading FIOS 50/50 to 200/200 Internet Plan and newer router require replacing Coax cable with Ethernet

I have the Verizon Fios 50/50 Internet plan and an ActionTec MI424-WR router with a Coax input. I want to upgrade to THE Verizon 200/200 PLAN and a faster router. Do I need to rewire from Coax to Ethernet to get the higher speed? If so, does Verizon do the rewiring for free?

Is it safe to share your password security plan with others?

The recent epidemic situation has given me enough time to seriously consider my password security. I have drawn up a detailed plan for using elements such as password manager, 2FA, U2F keys, etc. in conjunction with each other to create the optimal security architecture for my personal use (based on my rather limited knowledge of information security). .

Now the plan grew so much that I decided to write it down as a document so that I can remember how certain parts of it work, why they are designed in a certain way, what weaknesses, and so on. a friend who is also interested in strengthening his security? What about a hypothetical, extreme version – to share it online?

According to the Kerckhoff principle, the security of a system should not depend on its secrecy. I had that in mind when designing my plan. I believe that anyone who is competent enough to try to damage my system is not hampered by the lack of knowledge about the design. Its strength is based on secret keys (and an informed use of MFA), also in accordance with the principle. However, I've seen on this website that users are sometimes scolded if they reveal a lot about how to organize their security on a question.

We can easily find out in a few moments how AES or public key cryptography works. This does not prevent them from being widespread and considered safe. Would the same reasoning apply to my personal scheme?

Reward Plan – Does Halving Cause Inflation?

On May 12, 2020, Bitcoin initiated a milestone event that takes place every four years. Bitcoin block reward has been reduced from 12.5 to 6.25. Currently, only 2.62 million bitcoins have been mined. Bitcoin was halved for the first time in November 2012 and the reward reduced to 25. In July 2016, Bitcoin was halved for the second time and the reward reduced to 12.5. After the first two halves, Bitcoin opened a bull market. Bitcoin hit a record high of $ 19,000 in 2017. The price of Bitcoin during the halving was $ 8,541. However, last week Bitcoin rose to $ 10,000, an increase of 160% in the past two months. Industry insiders continue to be optimistic about Bitcoin.

There is also a big gap in yields. Assume the current price for Bitcoin is 10,000 points, and Bitcoin is likely to drop in the next hour. They open a 1 hour put option at BitOffer and spend $ 5. As expected, Bitcoin dropped 1,000 points in 1 hour and the system was automatically set up in 1 hour. You will receive a return of USD 1,000, which corresponds to a return of 20,000% of the capital.

BitOffer's options also have obvious advantages over the exchange options. For example, the JEX acquired by Binance has a minimum cycle of one week and has to pay a large amount of margin and processing fees to abandon it. It's no exaggeration to say that the most interesting option is BitOffer-Bitcoin options, and BitOffer is also the most promising exchange.

For the first register, here is the 50USDT give-away code:
https://www.bitoffer.com/de/register?invite_code=007RTX

Cheap Windows Reseller Hosting Startup Plan $ 12 / month: Hostbazzar.com – hosting, VPN, proxies

Hostbaazar offers the affordable Windows Reseller Hosting Service from 12 / month. So start your own hosting business at an affordable price!

Inexpensive Windows reseller hosting, shared hosting, VPS hosting and dedicated hosting are the main services offered by hostbazzar. We offer the best affordable Windows reseller hosting that will satisfy customers with fast hosting and 24 hour support through plesk. hostbazzar has been offering the best managed shared hosting / reseller hosting / VPS hosting services for years. Our goal is to offer the best service at the best price. In order to achieve these goals, we are committed to providing our customers with the best and most satisfactory hosting service customers.

Hostbazzar 100% ensures that your website is faster, more secure and always up to date. Our top priority is to provide customers with affordable, reliable and affordable services for the general public. Hostbazzar's affordable Windows reseller offers unlimited bandwidth, storage space and free migration options with no hidden fees from the hosting service. So don't waste time, visit hostbazzar.com as soon as possible and use our services and give us the opportunity to serve you.

* Cheap Windows Reseller Hosting Startup Plan @ Only $ 12 / month.

> WR-HB1: $ 12 / month

-Unlimited websites
-Disk storage space: 10 GB
-Monthly bandwidth: 200 GB
-24X7 live chat support

> WR-HB2: $ 22 / month

-Unlimited website
-Disk storage space: 25 GB
-Monthly bandwidth: 500 GB
-24X7 live chat support

> WR-HB3: $ 39 / month

-Unlimited website
-Disk storage space: 50 GB
-Monthly bandwidth: 1000 GB
-24X7 live chat support

*Properties :-

-Unlimited subdomains
-Plesk control panel
-Unlimited mailboxes
-SSL support
-E-commerce support
-Dream Weaver compatible
-Unlimited parked domains
-Unlimited auto responders
-Unlimited MySQL databases
-Unlimited carriers
-Unlimited mailing lists
-Zend Optimizer
-DDoS attack response
-Subdomain statistics
Firewall
-Flash support
-Curl, DomXML, Mod_rewrite

We are sure that our plans are better than the others and full of resources. For more information: https://hostbazzar.com/windows_reseller_hosting.php

Thanks a lot.

Cheap Windows Reseller Hosting Startup Plan $ 12 / month: Hostbazzar.com

Hostbaazar offers the affordable Windows Reseller Hosting Service from 12 / month. So start your own hosting business at an affordable price!

Inexpensive Windows reseller hosting, shared hosting, VPS hosting and dedicated hosting are the main services offered by hostbazzar. We offer the best affordable Windows reseller hosting that will satisfy customers with fast hosting and 24 hour support through plesk. hostbazzar has been offering the best managed shared hosting / reseller hosting / VPS hosting services for years. Our goal is to offer the best service at the best price. In order to achieve these goals, we are committed to providing our customers with the best and most satisfactory hosting service customers.

Hostbazzar 100% ensures that your website is faster, more secure and always up to date. Our top priority is to provide customers with affordable, reliable and affordable services for the general public. Hostbazzar's affordable Windows reseller offers unlimited bandwidth, storage space and free migration options with no hidden fees from the hosting service. So don't waste time, visit hostbazzar.com as soon as possible and use our services and give us the opportunity to serve you.

* Cheap Windows Reseller Hosting Startup Plan @ Only $ 12 / month.

> WR-HB1: $ 12 / month

-Unlimited websites
-Disk storage space: 10 GB
-Monthly bandwidth: 200 GB
-24X7 live chat support

> WR-HB2: $ 22 / month

-Unlimited website
-Disk storage space: 25 GB
-Monthly bandwidth: 500 GB
-24X7 live chat support

> WR-HB3: $ 39 / month

-Unlimited website
-Disk storage space: 50 GB
-Monthly bandwidth: 1000 GB
-24X7 live chat support

*Properties :-

-Unlimited subdomains
-Plesk control panel
-Unlimited mailboxes
-SSL support
-E-commerce support
-Dream Weaver compatible
-Unlimited parked domains
-Unlimited auto responders
-Unlimited MySQL databases
-Unlimited carriers
-Unlimited mailing lists
-Zend Optimizer
-DDoS attack response
-Subdomain statistics
Firewall
-Flash support
-Curl, DomXML, Mod_rewrite

We are sure that our plans are better than the others and full of resources. For more information: https://hostbazzar.com/windows_reseller_hosting.php

Thanks a lot.

dnd 5e – Plan to hit a second target with an arrow if it misses the first target

I've read a lot about how to "shoot the other enemy" and how enemies don't occupy the entire 5-foot field. However, what I can't find is the following scenario:

two orcs an arrow

I deliberately position my character so that it has a straight line with two enemies. I aim at the first one, but if it misses, I want my arrow to continue and possibly hit the next enemy. My understanding is that I can miss for two reasons.

  1. I'm shooting something in the wrong direction
  2. I'm shooting right, but the enemy is evading.

It is the situation (2) that I want to take advantage of and basically want to roll again for the second enemy, perhaps even with advantage, since he did not expect to be shot. Would you let that happen? What would you ask to roll?

Hosting – is it possible to use goormIDE 24/7 in the free plan?

I was looking for a solution to use a container for free and came across Goormide, the only problem with which is that it is not active around the clock unless there is "activity" or something like that stated on the page. I tried pinging Uptimerobot every 5 minutes but it doesn't work. I have a container that is active around the clock, but I don't use it because it doesn't have enough resources. Is there a way to keep the goormide container active around the clock? Thanks in advance.