…the primary key, we can shrink the…the size. You have to write a little more complex queries, but that’s often justified by a large reduction in table size. I sort of…of these things can be overcome, but how much time do you have? And the gains are simply limited by some of…
Post: 10+ Ways to Crash or Overload MySQL
November 13, 2007 By 20 Comments
…of memory on server. The size is typically 4-8K per table though complex tables can require larger sizes, so this is mainly the…queries. Stored Procedures – How…
Post: Troubleshooting MySQL Memory Usage
March 21, 2012 By 5 Comments
…of user variables, stored procedures, prepared statements etc which can be a memory hog. My intent with this post is dual. I…whenever memory usage shrinks can be…size of MEMORY tables (the limit applies both to implicit and explicit ones) but as there is no control of how… do better as you can query …
