(Sorry for English, because it isn’t my vernacular!)
I’m new to MySQL Performance, because, I cannot find a good mysql database tutorial.
I’m programming an Weblog system, like Blogger, free to register and use for everybody.
But, I haven’t enough knowledge about Database performances.
Can you write some query for me to create best tables, search and add new record, delete for have the best performance?!
I should say that I want these tables:
users: ID, Usernames, Passwords, emails and some others *** queries for add new user, delete, search for password for login or email by username.
posts: id, post id(separable for each weblog), title, post contest *** queries for add new post, delete post, select post, search in post contents and titles.
Comments: title, comment content, id(separate for each post) *** queries for add new comment, delete comment and select comments
Can you tell me what’s the best query?!
It’s urgent for me.
And… Can you tell me name of some best books for database and mysql performance?! (for begginers to professional users)
Note that I may have more than 1 million users(weblogs) and millions of posts!