The next meeting of the North Texas MySQL Users Group is next Monday and the presentation will be on designing database tables. This is part of a series for novices with MySQL and/or databases. Too often novices commit obvious sins like BIGINTs for any numeric storage field or indexing every column. EXPLAIN is a valuable tool in optimizing SELECT statements but too many DBAs do not discover it until well after they are stuck with a small, unruly group of badly designed tables.
Using EXPLAIN is seen as a 'dark art' by too many and hopefully we can get the novices in North Texas off on the right foot. The meeting is free and starts at 7:00 PM in the Sun Offices, Suite 700, 16000 Dallas Tollway, in Dallas. All are welcome and please try to be a bit early as the …[Read more]