My projects: SUGG (M, KS), CRZST, SYNONS, URLS, SIMILAR, Misc: 3Dengine, UniteHowTo, FliCC, My blog.
Old/abandoned: TheRarestWords (TcCrnch). 		Hi, I'm Slava V. and I develop those projects in free time. rarestwords@mail.ru

Subscribe to new topics If you use mySQL:

← Back to main page | Show/hide hints new!
If you use mySQL for the first time, you really should:
  • read about one-to-many and many-to-many relationships   
  • read why and when normalization is bad (scalability)   
  • read about SQL   
  • read about ORMs   
  • read why "normalization" is a must   
If you use mySQL you should always:
  • keep backups   
  • cover your data with indexes   
If you use mySQL you should never:
  • drop tables or databases with live data in them   
  • create tables without primary key   
| See all topics
If you use mySQL you might like this about it:
  • it is very forgiving about questionable input   
  • it's free to use, in a lot of cases   
  • it's really fast   
If you use mySQL you won't be happy to know that:
  • it silently converts questionable input to what it thinks you meant   
  • string comparisons are by default case insensitive   
  • #3 is nonsense if you properly configure your server and write good scripts   
  • it doesn't really scale "by default" - you have to have your own scaling plan   
If you use mySQL then you could enjoy similar things/activities:
  • postgreSQL   
  • Oracle (not free)   
  • StrokeDB   
  • memcached   
  • nginx   
  • sphinxsearch   
  • CouchDB   
  • HyperTable   
If you want to really use mySQL you should have those things:
  • o'Reilly's MySQL Pocket Reference   
  • phpMyAdmin   
If you use mySQL and you want to push the limits, try to:
  • all the different storage engines   
When you use mySQL it is not the same as ... because ...:
  • aNSI SQL because mySQL isn't a standards whore   
When you use mySQL it is essentially the same as ... because ...:
  • postgreSQL and Oracle, because they're all relational   
When you use mySQL your "mortal enemies" are:
  • thinking mySQL isn't a real database (but... Google uses it)   
  • lack of internet access   
These sites will help you when you use mySQL:
  • MysqlPerformanceBlog   
  • www.devshed.com/   
  • www.mysql.com/   
You know it's the last time you use mySQL when:
  • your corrupted DB takes 20 hours to recover   
  • the database is created that is as fast as mySQL but scales "by design"   
When you use mySQL and fail it's probably because:
  • myISAM blew up   
  • you didn't read enough   
  • there was no usable index   
  • you've used too many joins   
What would be different in the idea (you use mySQL) if you had a million dollars:
  • the hell with mySQL. Retire to the Caymans.   
  • it can save alot of overhead (money, not tables) on large database projects.   
If you use mySQL it's probably because:


Never ceases to amaze me how you found it:

  • Mysql "too many joins"
  • When should you use join in mysql




    • ← All topics
    Start your own topic
    If you

    Subscribe to Suggestan's New Topics via RSS or via email.
    		SUGGESTAN
    1. geo. A little country where everyone is suggesting something.

    Sign in / Sign up Not required to add stuff.


    Real-time updates are disabled as the server dies under load.
    Show/hide real-time updates


    These topics are free to fill for whoever wishes to.

    1. Click "add something".
    2. Then really add something.
    3. Press "ENTER" when done.

    Don't try to fill all fields. Not every question is applicable to every topic. Skip easy.

    Top list
    UserRM
    bille+31
    comy61+28
    tokusama+2828
    stlbunny+611
    drRoflol+3052
    marcellaxing+2223
    incer3+119124


    Subscribe to Suggestan's New Topics via RSS or via email - click here.
    Suggest a feature
    Reverse Suggestan