SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


MySQL Primer for the SQL Sever DBA


MySQL Primer for the SQL Sever DBA

Author
Message
SQLKen
SQLKen
SSC Veteran
SSC Veteran (242 reputation)SSC Veteran (242 reputation)SSC Veteran (242 reputation)SSC Veteran (242 reputation)SSC Veteran (242 reputation)SSC Veteran (242 reputation)SSC Veteran (242 reputation)SSC Veteran (242 reputation)

Group: General Forum Members
Points: 242 Visits: 73
Comments posted to this topic are about the item MySQL Primer for the SQL Sever DBA

ken kaufman
Lead DBA, Zillow.com
john-839610
john-839610
Grasshopper
Grasshopper (24 reputation)Grasshopper (24 reputation)Grasshopper (24 reputation)Grasshopper (24 reputation)Grasshopper (24 reputation)Grasshopper (24 reputation)Grasshopper (24 reputation)Grasshopper (24 reputation)

Group: General Forum Members
Points: 24 Visits: 13
A good and balanced article. I take exception to the final sentence in the MyISAM section though: "Overall for small read-only data sets Myisam out of the box (Downloaded from SourceForge) is an excellent choice, but does struggle as the datasets grow, and requires tuning".
I am not sure what you would define as small, but we have a 180gb spatial database with 450 million rows running off MyISAM and the performance does not appear to have degraded with size at all.
Spatial databases are still a bit of a specialized subset, though this was the reason I switched from SQL Server to MySQL in the first place.
SuperDBA-207096
SuperDBA-207096
Hall of Fame
Hall of Fame (3.7K reputation)Hall of Fame (3.7K reputation)Hall of Fame (3.7K reputation)Hall of Fame (3.7K reputation)Hall of Fame (3.7K reputation)Hall of Fame (3.7K reputation)Hall of Fame (3.7K reputation)Hall of Fame (3.7K reputation)

Group: General Forum Members
Points: 3721 Visits: 711
Ken,
Thanks for the article. Very informative!

Mark
Someguy
Someguy
Say Hey Kid
Say Hey Kid (711 reputation)Say Hey Kid (711 reputation)Say Hey Kid (711 reputation)Say Hey Kid (711 reputation)Say Hey Kid (711 reputation)Say Hey Kid (711 reputation)Say Hey Kid (711 reputation)Say Hey Kid (711 reputation)

Group: General Forum Members
Points: 711 Visits: 579
Ditto on the thanks. This was a good intro.

Note: Yes, you're right about the religious wars. Some people approach these discussions with a ferver that is a little disturbing...Crazy

___________________________________________________
“Politicians are like diapers. They both need changing regularly and for the same reason.”
mhaarsma
mhaarsma
Forum Newbie
Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)

Group: General Forum Members
Points: 7 Visits: 5
Great Article! I currently migrated a couple of MSSQL 2000 db's to MySQL.
Francis Apel
Francis Apel
SSC-Addicted
SSC-Addicted (400 reputation)SSC-Addicted (400 reputation)SSC-Addicted (400 reputation)SSC-Addicted (400 reputation)SSC-Addicted (400 reputation)SSC-Addicted (400 reputation)SSC-Addicted (400 reputation)SSC-Addicted (400 reputation)

Group: General Forum Members
Points: 400 Visits: 545
Wonderful Article. I hope you continue this into a "series" and delve deeper into SQL Server vs. MySQL, perhaps in writing code, Stored Object (SPs, Views, Functions, etc) and other day-to-day use comparisons.

Keep up the good work!

Francis
-----------------
SQLRanger.com
bnordberg
bnordberg
SSCommitted
SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)

Group: General Forum Members
Points: 1941 Visits: 576
Is anyone else having issues with MySQL's documentation and addition/removal of features? Things like database renaming (added then removed), local file imports having to use the option -L (was optional, now required) ... It seems like each release, no matter how minor, means I have to re-learn everything. Scripts I save in 1 version fail when run against the next minor release. I realize things like the database renaming were better off removed as they did not work at all. But how about fixing instead of just removing!
Also I would have to agree with performance issues, I have tables with 144 million rows, in MyISAM and the performance is worse than that of an MS Access DB!
Overall MySQL is not my DB of choice - SQL Server, Oracle and Sybase are better in every aspect. But MySQL is free, so I guess its worth all my time re-writing scripts!?



Mark F. Cook
Mark F. Cook
Old Hand
Old Hand (304 reputation)Old Hand (304 reputation)Old Hand (304 reputation)Old Hand (304 reputation)Old Hand (304 reputation)Old Hand (304 reputation)Old Hand (304 reputation)Old Hand (304 reputation)

Group: General Forum Members
Points: 304 Visits: 61
Great intro - as said before, please consider turning this into a series of "hands on" articles.

thanks



Charles Kincaid
Charles Kincaid
SSCarpal Tunnel
SSCarpal Tunnel (4.5K reputation)SSCarpal Tunnel (4.5K reputation)SSCarpal Tunnel (4.5K reputation)SSCarpal Tunnel (4.5K reputation)SSCarpal Tunnel (4.5K reputation)SSCarpal Tunnel (4.5K reputation)SSCarpal Tunnel (4.5K reputation)SSCarpal Tunnel (4.5K reputation)

Group: General Forum Members
Points: 4461 Visits: 2384
Great article. I'm almost surprised that this has not drawn more fire ... er ... posts. It's early in the US though.

The cost of MySQL is great. The open source thing is a bit to get over at first. I can download it and use it myself. My customer can download it and use it. I can't download it and install it for them. We give the customer a sheet of instructions and set with them while they download it and install it. Once done the sheet says, "Now your consultant can be engaged to reconfigure and tune the installation." Cool

The other thing about MyIsam is the way you can do backups. Stop the service, copy the files, start the service. Restore is the same way. To reinstall run your create table scripts and do the restore. This won't work with the other engines.

The GUI admin was not built into version 4. SqlYog to the rescue. Version 5 has a lot of new cool stuff in it. Since we have become MS partners we do a lot less with MySQL. We have to support the stuff in the field still. The stuff runs every day.

ATBCharles Kincaid
cadaverous.scribe
cadaverous.scribe
SSC Veteran
SSC Veteran (257 reputation)SSC Veteran (257 reputation)SSC Veteran (257 reputation)SSC Veteran (257 reputation)SSC Veteran (257 reputation)SSC Veteran (257 reputation)SSC Veteran (257 reputation)SSC Veteran (257 reputation)

Group: General Forum Members
Points: 257 Visits: 144
If you haven't yet, bnordberg, you may want to take a look at PostgreSQL; it's also free and I would expect the learning curve to be a bit more reasonable for someone with a MS SQL Server/Oracle/Sybase background.

Cheers.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search