General Community > Scripting Help

Newbie question on determining indexes in MySQL

<< < (2/2)

BigMike:
Thank you vbgamer45 for your replies. :)


--- Quote from: vbgamer45 on August 07, 2012, 06:56:20 PM ---look at the source code
--- End quote ---
I have to assume that the source code for SMF is optimized to begin with.


--- Quote from: vbgamer45 on August 07, 2012, 06:56:20 PM ---If you have a slow query log in mysql you can refer to that. Or look at the sql process list and see what stuff locks or takes a while to run.
--- End quote ---


--- Quote from: BigMike on August 07, 2012, 11:31:21 AM ---Is there a log somewhere that lists queries that are missing/need indexes? Or a log of the slowest queries?
--- End quote ---


--- Quote from: BigMike on August 07, 2012, 05:44:47 PM ---Again, is there a SQL log I can view to see what tables are being used for this?
--- End quote ---

Indeed this is what I'm trying to figure out. I'll do some more Googling and later I'll post to the cPanel forum to see if anyone over there can help me.

Mike

BigMike:
I figured out how to track these queries: http://dev.mysql.com/doc/refman/5.0/en/server-system-variables.html#sysvar_log_queries_not_using_indexes

BigMike

Navigation

[0] Message Index

[*] Previous page