mysql – Why is it slow: "SELECT * … ORDER BY id LIMIT 50000, 2"

car_trims is an InnoDB table, has ~ 40 fields, an average line length of 230 bytes, no columns of type TEXT or BLOB

car_trims.id is PK

Query 1: .0007 seconds

SELECT * FROM car_trims ORDER BY id LIMIT 2

Query 2: 0.023 seconds

SELECT id FROM car_trims ORDER BY id LIMIT 50000, 2

Query 3: 0.09 seconds

SELECT * FROM car_trims ORDER BY id LIMIT 50000, 2

First of all, I do not understand why query 2 is so slow, but it's reasonably acceptable. What I really do not understand is why query 3 takes almost 100 ms to read the row data with the primary key.

In my understanding, the database should retrieve the PK from memory to locate the line on the hard drive and then read it out. Query 3 should not take much longer than Query 1.

TO EXPLAIN

id  select_type     table   partitions  type    possible_keys   key     key_len     ref     rows    filtered    Extra   
 1       SIMPLE     car_trims     NULL  index   NULL            PRIMARY       4     NULL    50002   100.00      NULL

my.cnf

[mysqld]
#
# * Basic Settings
#
user        = mysql
pid-file    = /var/run/mysqld/mysqld.pid
socket      = /var/run/mysqld/mysqld.sock
port        = 3306
basedir     = /usr
datadir     = /var/lib/mysql
tmpdir      = /tmp
lc-messages-dir = /usr/share/mysql
skip-external-locking
sql_mode = "NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
#
# Instead of skip-networking the default is now to listen only on
# localhost which is more compatible and is not less secure.
bind-address        = 127.0.0.1
# This replaces the startup script and checks MyISAM tables if needed
# the first time they are touched
myisam-recover-options  = BACKUP
#
# * Query Cache Configuration
#
query_cache_type=0
#query_cache_limit  = 1M
#query_cache_size        = 16M
#
# * Logging and Replication
#
# Both location gets rotated by the cronjob.
# Be aware that this log type is a performance killer.
# As of 5.1 you can enable the log at runtime!
#general_log_file        = /var/log/mysql/mysql.log
#general_log             = 1
#
# Error log - should be very few entries.
#
log_error = /var/log/mysql/error.log
#
# Here you can see queries with especially long duration
#log_slow_queries   = /var/log/mysql/mysql-slow.log
#long_query_time = 2
#log-queries-not-using-indexes
#
# The following can be used as easy to replay backup logs or for replication.
# note: if you are setting up a replication slave, see README.Debian about
#       other settings you may need to change.
#server-id      = 1
#log_bin            = /var/log/mysql/mysql-bin.log
expire_logs_days    = 10
max_binlog_size   = 100M
#binlog_do_db       = include_database_name
#binlog_ignore_db   = include_database_name
#
# * InnoDB
#
# InnoDB is enabled by default with a 10MB datafile in /var/lib/mysql/.
# Read the manual for more InnoDB related options. There are many!
#
# * Security Features
#
# Read the manual, too, if you want chroot!
# chroot = /var/lib/mysql/
#
# For generating SSL certificates I recommend the OpenSSL GUI "tinyca".
#
# ssl-ca=/etc/mysql/cacert.pem
# ssl-cert=/etc/mysql/server-cert.pem
# ssl-key=/etc/mysql/server-key.pem


# Custom Stuff
performance-schema=0
event_scheduler=ON
slow-query-log=1
long-query-time=1
max_user_connections=1000
max_connections=1100
table_open_cache=8192
key_buffer_size=64M #myisam table index buffer
max_connect_errors=20
max_allowed_packet=256M
sort_buffer_size=2M
read_buffer_size=2M
read_rnd_buffer_size=4M
myisam_sort_buffer_size=64M
max_heap_table_size=256M
tmp_table_size=256M
thread_cache_size=100

concurrent_insert=2
innodb_buffer_pool_size=1024M
innodb_buffer_pool_instances=8
innodb_flush_method=O_DIRECT
innodb_flush_log_at_trx_commit=2
innodb_log_file_size=32M            #see http://dev.mysql.com/doc/refman/5.0/en/adding-and-removing.html
innodb_old_blocks_time=1000
innodb_stats_on_metadata=off
innodb_log_buffer_size=16M
innodb_file_per_table=1
open_files_limit=10000

SEO – Google can not retrieve a large sitemap with 50,000 URLs and is not rendered by browsers

My sitemap contains 50,000 URLs / 7.8 MB and the following URL syntax:




 https://www.ninjogos.com.br/resultados?pesquisa=vestido, maquiagem,   2019-10-03T17:12:01-03:00 
 1.00 


The problems are:

• The search console reports that the sitemap could not be read.

• Sitemap loading takes 1 hour and Chrome stops working.

Enter image description here

• In Firefox, the sitemap was downloaded in 1483 ms and fully loaded after 5 minutes.

Things that I have done without success:

• Disable GZip compression.

• Delete my .htaccess file;

• Create a test sitemap with 1 KB URLs and the same syntax, and send it to Search Console. However, the sitemap with 50 KB URLs still displays "" that no sitemap can be retrieved.

Enter image description here

• An attempt was made to directly check the URL, but an error occurred and you are asked to try again later while the 1KB URLs worked.

• An attempt was made to validate the sitemap on five different websites (YANDEX, ETC), and all worked without error / warning

Any light?

If you had $ 50,000, what type of hosting company would you launch in September 2019?

Is it better to offer only one thing or many?

For example only webhosting or webhosting and wordpress webdesign or such plus VPS hosting, etc ..?

If you offer only one article, such as web hosting, the customer can judge that much better than if you offer many things.

I'm just trying to return to what I've seen after decades of calm, but it's September 2019 now and I'd like some input from you.

Do you need a live chat and if so, which one is the good one these days?

Do you need telephone support or is the 15-minute help desk response sufficient? Or do I need both? I know Helpdesk is better at documenting things and not forgetting how to do it on a phone call.

Can I just use the new free SSL certificate that WHM offers, or do I really have to buy a certificate from one of the big SSL companies? Obviously, I plan to add dedicated servers down the line. In the hope of winning at least 200 customers (of the "normal user" type).

I think most of the money is spent on a new cpanel / WHM dedicated server (to get started), (I can build the website myself), to acquire web hosting companies (it's better to buy the entire company and all the assets or easy to search) cpanel customers?) and Google AdWords. Any thoughts on that too?

Or maybe the hosting industry is so saturated these days that I should just get a hot dog truck, lol

Thanks WebHostingTalk, I've been here since 2003 and have always appreciated the opinion of everyone here. Thanks again.

[DICHVUSOCKS.US] 23h15 PM UPDATE 24 / 24- Good socks

Payment Immediately perfect money, Bitcoin, wmtransfer, dash, ETH (Please click on buy socks)
Update Tools Client Dichvusocks.us http://dichvusocks.us/tools.php Link Check Socks http://check.dichvusocks.us/
LIVE | 64.90.51.72:32828 | 0.27 | California | 92821 | gervais.dreamhost.com | United States | Blacklist: Yes | Tested at http://dichvusocks.us
LIVE | 192.169.189.215:54306 | 0.24 | Arizona | 85260 | GoDaddy.com, LLC | United States | Blacklist: Yes | Tested at http://dichvusocks.us
LIVE | 74.123.23.40:44800 | 0.11 | Tennessee | 37388 | Tullahoma Utilities Authority | United States | Blacklist: Yes | Tested at http://dichvusocks.us
LIVE | 64.90.53.193:48400 | 0.27 | California | 92821 | bandon.dreamhost.com | United States | Blacklist: Yes | Tested at http://dichvusocks.us
LIVE | 50.63.167.72:38634 | 0.26 | Arizona | 85260 | ip-192-169-140-100.ip.secureserver.net | United States | Blacklist: Yes | Tested at http://dichvusocks.us
LIVE | 82.146.57.96:9076 | 0,63 | Unknown | Unknown | h-158-174-122-199.NA.cust.bahnhof.se | Unknown | Blacklist: Yes | Tested at http://dichvusocks.us
LIVE | 64.90.54.161:9790 | 0.29 | California | 92821 | pelican.dreamhost.com | United States | Blacklist: Yes | Tested at http://dichvusocks.us
LIVE | 128.199.72.46:48081 | 0.94 | Chiang Mai Province | 50000 | 184-82-26-0.24.public.cmbp-mser.myaisfibre.com | Thailand | Blacklist: No | Tested at http://dichvusocks.us
LIVE | 132.148.142.205:13358 | 1.62 | Arizona | 85260 | GoDaddy.com, LLC | United States | Blacklist: Yes | Tested at http://dichvusocks.us
LIVE | 192.169.189.215:53185 | 1.36 | Arizona | 85260 | ip-192-169-188-105.ip.secureserver.net | United States | Blacklist: Yes | Tested at http://dichvusocks.us
LIVE | 51.75.18.214:9050 | 0.85 | Unknown | Unknown | Onion friends e.V. | Unknown | Blacklist: No | Tested at http://dichvusocks.us
LIVE | 132.148.142.205:6115 | 2.66 | Arizona | 85260 | ip-132-148-142-205.ip.secureserver.net | United States | Blacklist: Yes | Tested at http://dichvusocks.us
LIVE | 192.169.216.124:1100 | 0.26 | Arizona | 85260 | ip-192-169-216-124.ip.secureserver.net | United States | Blacklist: Yes | Tested at http://dichvusocks.us
LIVE | 192.169.218.103:58264 | 1.64 | Arizona | 85260 | ip-192-169-218-103.ip.secureserver.net | United States | Blacklist: Yes | Tested at http://dichvusocks.us
LIVE | 192.169.194.150:21031 | 0.45 | Arizona | 85260 | ip-198.12-157-28.ip.secureserver.net | United States | Blacklist: Yes | Tested at http://dichvusocks.us
LIVE | 185.180.196.108:7774 | 1.29 | Tul "skaya Oblast & # 39; | 301245 | 78-106-163-76.broadband.corbina.ru | Russia | Blacklist: No | Tested at http://dichvusocks.us
LIVE | 173.177.2.238:3339 | 0.18 | Quebec | J7A | modemcable238.2-177-173.mc.videotron.ca | Canada | Blacklist: No | Tested at http://dichvusocks.us
LIVE | 147.135.191.103:48339 | 0.68 | Texas | 78221 | 108-205-5-239.lightspeed.snantx.sbcglobal.net | United States | Blacklist: No | Tested at http://dichvusocks.us

dichvusocks
Reviewed by dichvusocks on
,
[DICHVUSOCKS.US] 23h15 PM UPDATE 24 / 24- Good socks
Payment Immediately perfect money, Bitcoin, wmtransfer, dash, ETH (Please click on buy socks)
Update Tools Client Dichvusocks.us http://dichvusocks.us/tools.php Link Check Socks http://check.dichvusocks.us/
LIVE | 64.90.51.72:32828 | 0.27 | California | 92821 | gervais.dreamhost.com | United States | Blacklist: Yes | Tested at http://dichvusocks.us
LIVE | 192.169.189.215:54306 | 0.24 | Arizona | 85260 | GoDaddy.com, LLC | United States | Blacklist: Yes | Tested at http://dichvusocks.us
LIVE |

Rating: 5

,

[DICHVUSOCKS.US] 23h15 PM UPDATE 24 / 24- Good socks

Payment Immediately perfect money, Bitcoin, wmtransfer, dash, ETH (Please click on buy socks)
Update Tools Client Dichvusocks.us http://dichvusocks.us/tools.php Link Check Socks http://check.dichvusocks.us/
LIVE | 66.33.212.228:50710 | 0.03 | California | 92821 | birdseye.dreamhost.com | United States | Blacklist: No | Tested at http://dichvusocks.us
LIVE | 66.33.211.231:29948 | 0.03 | California | 92821 | brimstone.dreamhost.com | United States | Blacklist: Yes | Tested at http://dichvusocks.us
LIVE | 50.62.35.107:4115 | 0.26 | Arizona | 85260 | ip-50-62-35-107.ip.secureserver.net | United States | Blacklist: Yes | Tested at http://dichvusocks.us
LIVE | 91.134.157.11:26358 | 0.3 | Unknown | Unknown | gwc.cluster020.hosting.ovh.net | France | Blacklist: No | Tested at http://dichvusocks.us
LIVE | 5.135.58.121:35778 | 0.3 | Unknown | Unknown | 76.ip-137-74-175.eu | France | Blacklist: No | Tested at http://dichvusocks.us
LIVE | 24.6.215.155:47177 | 0.31 | California | 94587 | c-24-6-215-155.hsd1.ca.comcast.net | United States | Blacklist: Yes | Tested at http://dichvusocks.us
LIVE | 142.0.102.231:10200 | 0.08 | Maine | 04849 | dynamic-142-0-102-231.tidewater.net | United States | Blacklist: No | Tested at http://dichvusocks.us
LIVE | 166.62.80.198:28604 | 0.26 | Arizona | 85260 | ip-166-62-80-198.ip.secureserver.net | United States | Blacklist: Yes | Tested at http://dichvusocks.us
LIVE | 50.63.26.13:53887 | 0.77 | Arizona | 85260 | ip-50-63-26-13.ip.secureserver.net | United States | Blacklist: No | Tested at http://dichvusocks.us
LIVE | 128.199.72.46:48081 | 0,73 | Chiang Mai Province | 50000 | 184-82-26-0.24.public.cmbp-mser.myaisfibre.com | Thailand | Blacklist: No | Tested at http://dichvusocks.us
LIVE | 212.22.92.122:56342 | 0.47 | Unknown | Unknown | SRVCORE | Unknown | Blacklist: No | Tested at http://dichvusocks.us
LIVE | 50.62.35.107:60129 | 0.26 | Arizona | 85260 | ip-50-62-35-107.ip.secureserver.net | United States | Blacklist: Yes | Tested at http://dichvusocks.us
LIVE | 192.169.249.49:58480 | 1.64 | Arizona | 85260 | ip-192-169-249-49.ip.secureserver.net | United States | Blacklist: Yes | Tested at http://dichvusocks.us
LIVE | 66.110.216.105:39431 | 0.29 | Georgia | 30260 | Georgia Public Web | United States | Blacklist: No | Tested at http://dichvusocks.us
LIVE | 103.209.64.19:6667 | 1.57 | Gujarat | 383430 | Gtpl Abhilash Communication Private Limited | India | Blacklist: No | Tested at http://dichvusocks.us
LIVE | 103.240.161.108:6667 | 1.82 | Gujarat | 384265 | GTPL Broadband Pvt. | India | Blacklist: No | Tested at http://dichvusocks.us
LIVE | 37.59.8.29:10692 | 3.37 | Unknown | Unknown | OVH SAS | France | Blacklist: Yes | Tested at http://dichvusocks.us
LIVE | 98.143.145.29:62354 | 1.32 | California | 90014 | 98.143.145.29.static.quadranet.com | United States | Blacklist: No | Tested at http://dichvusocks.us

dichvusocks
Reviewed by dichvusocks on
,
[DICHVUSOCKS.US] 23h15 PM UPDATE 24 / 24- Good socks
Payment Immediately perfect money, Bitcoin, wmtransfer, dash, ETH (Please click on buy socks)
Update Tools Client Dichvusocks.us http://dichvusocks.us/tools.php Link Check Socks http://check.dichvusocks.us/
LIVE | 66.33.212.228:50710 | 0.03 | California | 92821 | birdseye.dreamhost.com | United States | Blacklist: No | Tested at http://dichvusocks.us
LIVE | 66.33.211.231:29948 | 0.03 | California | 92821 | brimstone.dreamhost.com | United States | Blacklist: Yes | Tested at http://dichvusocks.us

Rating: 5

,

amazon kms – The simple AWS Appsync app has already received more than 50,000 AWS Key Management Service requests

Last month we developed an Ionic App with AmplifyJS.
It basically runs on an AWS Appsync API.

So far it has been an unpleasant journey, especially the @ connections between DynamoDB tables.

For example, you might want to join Tables Team> Members> Tasks.
Maybe this is not the way to go because we basically build SQL structures on a noSQL database.

Anyway, we managed to get it running with several @connections:
https://aws-amplify.github.io/docs/cli-toolchain/graphql#connection

The problem is that we already have 50,000+ AWS Key Management Service requests during a trial of only two developers.

Does it require a key for each database query?

[DICHVUSOCKS.US] 20h05 PM UPDATE 24 / 24- Good socks

Payment Immediately perfect money, Bitcoin, wmtransfer, dash, ETH (Please click on buy socks)
Update Tools Client Dichvusocks.us http://dichvusocks.us/tools.php Link Check Socks http://check.dichvusocks.us/
LIVE | 208.113.182.208:35632 | 0.03 | California | 92821 | ps28713.dreamhostps.com | United States | Blacklist: No | Tested at http://dichvusocks.us
LIVE | 192.169.197.122:17708 | 0.26 | Arizona | 85260 | ip-192-169-197-122.ip.secureserver.net | United States | Blacklist: Yes | Tested at http://dichvusocks.us
LIVE | 64.118.87.30:63534 | 0.01 | New Jersey | 07310 | drive100.123servers.com | United States | Blacklist: No | Tested at http://dichvusocks.us
LIVE | 166.62.59.87:5525 | 0.26 | Arizona | 85260 | ip-192-169-197-122.ip.secureserver.net | United States | Blacklist: Yes | Tested at http://dichvusocks.us
LIVE | 192.169.215.114:8106 | 0.26 | Arizona | 85260 | ip-192-169-215-114.ip.secureserver.net | United States | Blacklist: No | Tested at http://dichvusocks.us
LIVE | 166.62.59.87:54696 | 0.24 | Arizona | 85260 | ip-192-169-197-122.ip.secureserver.net | United States | Blacklist: Yes | Tested at http://dichvusocks.us
LIVE | 23.29.85.213:39880 | 0.21 | Nebraska | 69348 | 23.29.85.213.bbc.net | United States | Blacklist: No | Tested at http://dichvusocks.us
LIVE | 192.169.197.122:42755 | 0.26 | Arizona | 85260 | ip-192-169-197-122.ip.secureserver.net | United States | Blacklist: Yes | Tested at http://dichvusocks.us
LIVE | 46.105.87.103:63115 | 0.83 | Tennessee | 37130 | 158-174-195-148.myvzw.com | United States | Blacklist: No | Tested at http://dichvusocks.us
LIVE | 69.60.71.80:39880 | 0.46 | Nova Scotia | B0K | 80.71.60.69.cpe.seasidehighspeed.com | Canada | Blacklist: Yes | Tested at http://dichvusocks.us
LIVE | 75.119.207.158:32212 | 0.26 | California | 92821 | flattail.dreamhost.com | United States | Blacklist: Yes | Tested at http://dichvusocks.us
LIVE | 46.105.87.103:63680 | 3.9 | Hawaii | 96814 | udp277910uds.hawaiiantel.net | United States | Blacklist: No | Tested at http://dichvusocks.us
LIVE | 51.254.57.83:64700 | 0.76 | Illinois | 61087 | 228-82-181-166.mobile.uscc.net | United States | Blacklist: No | Tested at http://dichvusocks.us
LIVE | 46.105.87.103:63300 | 0.96 | District of Columbia | 20011 | ue.tmodns.net | United States | Blacklist: Yes | Tested at http://dichvusocks.us
LIVE | 51.68.97.209:62703 | 0.55 | New York | 11209 | pool-173-52-53-205.nycmny.fios.verizon.net | United States | Blacklist: Yes | Tested at http://dichvusocks.us
LIVE | 173.244.200.159:23443 | 0.27 | California | 94806 | c-73-241-60-142.hsd1.ca.comcast.net | United States | Blacklist: Yes | Tested at http://dichvusocks.us
LIVE | 128.199.72.46:48081 | 1.03 | Chiang Mai Province | 50000 | 184-82-27-0.24.public.cmbp-mser.myaisfibre.com | Thailand | Blacklist: No | Tested at http://dichvusocks.us
LIVE | 50.63.13.254:20067 | 0.26 | Arizona | 85260 | GoDaddy.com, LLC | United States | Blacklist: Yes | Tested at http://dichvusocks.us

,

[DICHVUSOCKS.US] 16:30 UPDATE 24 / 24- Good socks

Payment Immediately perfectmoney, bitcoin, wmtransfer, dash, ETH (Please click on buy socks)
Update Tools Client Dichvusocks.us http://dichvusocks.us/tools.php Link Test Socks http://check.dichvusocks.us/
LIVE | 208.113.182.131:27141 | 0.08 | Unknown | Unknown | | Unknown | Blacklist: Yes | Checked at http://dichvusocks.us
LIVE | 208.113.183.100:46744 | 0.09 | Unknown | Unknown | | Unknown | Blacklist: Yes | Checked at http://dichvusocks.us
LIVE | 45.55.230.207:44613 | 0.03 | New Jersey | 07014 | Digital Ocean | United States | Blacklist: Yes | Checked at http://dichvusocks.us
LIVE | 192.169.250.203:17983 | 0.3 | Arizona | 85260 | ip-192-169-250-203.ip.secureserver.net | United States | Blacklist: No | Checked at http://dichvusocks.us
LIVE | 24.156.8.185:11008 | 0.36 | Arizona | 85344 | 24-156-8-185.prkrcmtc01.res.dyn.suddenlink.net | United States | Blacklist: No | Checked at http://dichvusocks.us
LIVE | 46.119.112.71:3176 | 0.62 | Quebec | H2C | 201-32-11-66.static.cogecodata.net | Canada | Blacklist: No | Checked at http://dichvusocks.us
LIVE | 192.169.140.74:55824 | 1.71 | Arizona | 85260 | ip-192-169-140-74.ip.secureserver.net | United States | Blacklist: No | Checked at http://dichvusocks.us
LIVE | 128.199.72.46:58081 | 0,78 | Chiang Mai | 50000 | 184-82-26-0.24.public.cmbp-mser.myaisfibre.com | Thailand | Blacklist: No | Checked at http://dichvusocks.us
LIVE | 174.76.20.209:38583 | 0.37 | California | 92675 | wsip-174-76-20-209.oc.oc.cox.net | United States | Blacklist: No | Checked at http://dichvusocks.us
LIVE | 192.169.233.35:19927 | 0,99 | Unknown | Unknown | | Unknown | Blacklist: Yes | Checked at http://dichvusocks.us
LIVE | 192.169.218.61:6644 | 2.44 | Arizona | 85260 | ip-192-169-218-61.ip.secureserver.net | United States | Blacklist: No | Checked at http://dichvusocks.us
LIVE | 132.148.142.205:4907 | 3.19 | Arizona | 85260 | ip-132-148-142-205.ip.secureserver.net | United States | Blacklist: No | Checked at http://dichvusocks.us
LIVE | 192.169.194.120:22526 | 1.86 | Arizona | 85260 | ip-198.12-157-77.ip.secureserver.net | United States | Blacklist: No | Checked at http://dichvusocks.us
LIVE | 192.169.193.183:22526 | 5,52 | Arizona | 85260 | ip-198.12-157-77.ip.secureserver.net | United States | Blacklist: No | Checked at http://dichvusocks.us
LIVE | 192.169.243.124:12703 | 0.3 | Arizona | 85260 | ip-192-169-243-124.ip.secureserver.net | United States | Blacklist: No | Checked at http://dichvusocks.us
LIVE | 122.116.238.22:20032 | 4.04 | Unknown | Unknown | | Unknown | Blacklist: Yes | Checked at http://dichvusocks.us
LIVE | 192.169.157.42:31463 | 0.32 | Arizona | 85260 | ip-192-169-188-105.ip.secureserver.net | United States | Blacklist: No | Checked at http://dichvusocks.us
LIVE | 46.119.112.71:3663 | 0.68 | Quebec | H1Y | ks4002049.ip-198-100-146.net | Canada | Blacklist: No | Checked at http://dichvusocks.us

dichvusocks
Reviewed by dichvusocks on
,
[DICHVUSOCKS.US] 16:30 UPDATE 24 / 24- Good socks
Payment Immediately perfectmoney, bitcoin, wmtransfer, dash, ETH (Please click on buy socks)
Update Tools Client Dichvusocks.us http://dichvusocks.us/tools.php Link Test Socks http://check.dichvusocks.us/
LIVE | 208.113.182.131:27141 | 0.08 | Unknown | Unknown | | Unknown | Blacklist: Yes | Checked at http://dichvusocks.us
LIVE | 208.113.183.100:46744 | 0.09 | Unknown | Unknown | | Unknown | Blacklist: Yes | Checked at http://dichvusocks.us
LIVE | 45.55.230.207:44613 | 0.03 | New Jersey | 07014 |

Rating: 5

,