intellix Posted November 25, 2010 Share Posted November 25, 2010 Hey guys... I've got a medium sized table which I'm querying and having quite annoying performance issues... In general, what websites, blogs, books, articles are you reading that you would recommend when it comes to learning MySQL performance? Quote Link to comment https://forums.phpfreaks.com/topic/219825-mysql-and-not-in-or-is-null-performance/ Share on other sites More sharing options...
fenway Posted November 25, 2010 Share Posted November 25, 2010 Too broad a question -- but if NOT IN is the only predicate in the WHERE clause, you're looking at a full table scan. Post the query, the EXPLAIN output, and we'll take it from there. Quote Link to comment https://forums.phpfreaks.com/topic/219825-mysql-and-not-in-or-is-null-performance/#findComment-1139570 Share on other sites More sharing options...
s0c0 Posted November 27, 2010 Share Posted November 27, 2010 Hi is just asking for recommendations for reading material... not specific help. Read High Performance MySQL, its my fav and written my the guys over at mysqlperformanceblog.com. Make sure you get the most recent edition possible. I've got some pretty sweet information on my blog as well. Quote Link to comment https://forums.phpfreaks.com/topic/219825-mysql-and-not-in-or-is-null-performance/#findComment-1140409 Share on other sites More sharing options...
fenway Posted November 28, 2010 Share Posted November 28, 2010 Hi is just asking for recommendations for reading material... not specific help. Read High Performance MySQL, its my fav and written my the guys over at mysqlperformanceblog.com. Make sure you get the most recent edition possible. I've got some pretty sweet information on my blog as well. That's overkill for an intro -- SQL Antipatterns is a good introductions on what not to do. Quote Link to comment https://forums.phpfreaks.com/topic/219825-mysql-and-not-in-or-is-null-performance/#findComment-1140457 Share on other sites More sharing options...
intellix Posted November 28, 2010 Author Share Posted November 28, 2010 Thanks for the advice on reading material Sorry that my post is extremely confusing. It started off as a specific question then as I posted, it sort of strayed into a general reading topic so my fault for not changing the whole post I figured the problem I have is a little too specific and i'd be better off reading into it instead Quote Link to comment https://forums.phpfreaks.com/topic/219825-mysql-and-not-in-or-is-null-performance/#findComment-1140620 Share on other sites More sharing options...
s0c0 Posted November 29, 2010 Share Posted November 29, 2010 True that might be overkill. I learned how to program and about mysql from this book http://www.amazon.com/PHP-MySQL-Web-Development-4th/dp/0672329166/ref=sr_1_1?ie=UTF8&qid=1291051671&sr=8-1 albeit that was 5 years ago. Still gave me a solid start and was easy enough to read for a tech savy network admin with limited programming/database experience. Quote Link to comment https://forums.phpfreaks.com/topic/219825-mysql-and-not-in-or-is-null-performance/#findComment-1140953 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.