Reputation
Top tag
Next privilege 125 Rep.
Vote down
Badges
4
Newest
 Editor
Impact
~1k people reached

  • 0 posts edited
  • 0 helpful flags
  • 3 votes cast
Jan
25
comment Mysql Slow Log when using UNION ALL?
thanks, i heard that using counts in innodb can be costly, however do we have an alternative to get counts(*) in a highly efficient way ?
Jan
25
comment Mysql Slow Log when using UNION ALL?
added as screenshot thanks
Jan
25
revised Mysql Slow Log when using UNION ALL?
added 88 characters in body
Jan
25
asked Mysql Slow Log when using UNION ALL?
Aug
16
comment query optimization of a left join
Yeah those are set according to the mysql turner script. . Also please note that all i want to do is count the number of users who has a photo. May be there is a another way to fo the same
Aug
16
comment query optimization of a left join
Also in addition please note cant be a problem with the resources it has 32GB memory and 8 cpu hosted only this website with max only 100 users per time.
Aug
16
comment query optimization of a left join
i have added the "Explain Query output" as well to the question
Aug
16
awarded  Editor
Aug
16
revised query optimization of a left join
added 84 characters in body
Aug
15
asked query optimization of a left join
Jul
13
awarded  Popular Question
Jul
10
awarded  Supporter
Sep
26
awarded  Student
Sep
26
asked Does TRANSACTION/COMMIT/ROLLBACK only work on certain MySQL engines such as InnoDB?