72,957 reputation
1172166
bio website
location Jersey City, NJ (USA)
age 49
visits member for 3 years, 11 months
seen 1 hour ago

2h
reviewed Close join 2 tables of first row of tabl1 to first row of table 2
2h
reviewed Close Get notified on (server) software updates
2h
comment Get notified on (server) software updates
I'm voting to close this question as off-topic because no real database is mentioned. This could probably be migrated to ServerFault or SuperUser.
2h
comment index not being used
@Pacerier sometimes blindly using FORCE INDEX without know the cardinality of individual key values can make things worse. Character sets can also hide why FORCE INDEX can fail See mysqldiary.com/…, stackoverflow.com/questions/4860113/… and percona.com/blog/2006/09/08/why-index-could-refuse-to-work as to why
1d
reviewed Leave Closed This Extended Events session works on Dev but not on Pro. Why?
1d
reviewed Reviewed Design Database for Wholesales
1d
reviewed Close How to get best mark for each Student
1d
reviewed Close How to add External data source into MySQL?
2d
revised Dropped connections, corrupted schema … is MySQL sick?
edited tags
2d
reviewed Leave Closed SQL Multiple JOINS Interpretation order
2d
reviewed Leave Closed off-site Dataguard replication status check
2d
reviewed Close Single Transaction across multiple Sql Database
2d
reviewed Close Unable to start SQL Safe service :Error 1053: Could Not Start or Stop the Service in a Timely Fashion
2d
reviewed Close Facing SQL Error 3403
2d
reviewed Close Import Data from SQL Server 2000 to SQL Server 2014
2d
reviewed Close Postgres Enable TCP/IP Connection
2d
reviewed Close Can user defined roles cause problems with colliding permissions?
2d
reviewed Close Query in mysql is not solving
2d
comment MySQL always writes simple temporary/memory tables to disk (both tmp_table_size and max_heap_table_size are set to 8GB)
Doing WHERE 0 or WHERE 1=0 could possibly force an O(n) (order-n) full table scan of website.gallery_likes (just personal fear of that happening), whereas doing LIKE is a O(1) (order 1) structure copy (including indexes). Regardless of website.gallery_likes having 1 row or 1 billion rows, LIKE will take the same amount of time to create.
2d
revised MySQL always writes simple temporary/memory tables to disk (both tmp_table_size and max_heap_table_size are set to 8GB)
edited tags