Very Common question i want ask to all of you..
i knew the configuration, installation of mysql database with apache, mailserver and monitoring tools.
But still i have a some confusions....
==> Why we use mysql database?
==> Which type of information is stored in database with apache, mailserver and monitoring tools?

DuckDuckGo is your friend. Have you looked here?
https://www.mysql.com/why-mysql/
jdk

Thank you for reply But i don't want theory dear i want simple logical idea...

Formerly, MySQL had the right price, performance and capabilities desired. Now that Oracle has taken it over, some other capabilities have been lost - test suites, updates, and bad behavior from Oracle.

Many distributions are moving to either MariaDB (a fully GPL version of MySQL), or Postgres (a completely different database).

Your second question is a bit of a "What?" as you can store whatever data you want. Mixing in specifically applications like Apache, Mailservers, and monitoring tools don't make sense. You can store any data you get from them. Now identifying what data you WANT from them might take a lot of time. Some of them already have data base interfaces (some monitoring tools for instance), but it depends on which ones (Nagios has a database interface, log files from either Apache or the various mail servers can be parsed for some data) and what data you want.

1 members found this post helpful.

and yet your signature quotes Stallman..."To understand the concept,"

Don't mean to discourage you, but you won't get a helpful answer to this 'very generic information seeking' type question. Rather if you grok in a working MySQL environment and post your doubts and questions with problem detail, I'm pretty sure a number of people will join to help you.

Regards.

Maybe if you stated your requirements more clearly, dear, you would get the kind of answers you are looking for.
jdk

Your questions make no sense at all.

You want to know WHY you would use a database?? You tell me...I know why *I* would use a database, and why others use them. You can use it for whatever you want to. And it's not limited to MySQL...it goes for Postgresql, NoSQL, Oracle, Sybase, or any other database you can name. You use it if you need it, for what you need it for, same as with any tool.
What type of information? That's like asking "What kind of information can be sent over email??". You can put whatever you want in it....have one table or 200,000; two fields or 10,000....that's up to you.

1 members found this post helpful.

As with all of the above, you can put any kind of info you want in a DB.
Try their website http://dev.mysql.com/doc/refman/5.1/en/

Or be more specific...

Thanks to all of you specially jpollard thanks dude
actually i got the idea its uses raw and tables for storing data in systematic in organize manner.
Data like errors, user info, system generated queries etc..
Am i right?

No, you're not, and I have no idea where you got that idea. AGAIN...you can store ANYTHING in a database.

A small bit of research on how databases work via a Google search can tell you what you need to know.

mysql database is used mainly for the following reasons: Robust Transactional Support,Web and Data Warehouse Strengths,Scalability and Flexibility,Strong Data Protection,Comprehensive Application Development,Lowest Total Cost of Ownership.

1 members found this post helpful.

1. MySQL came with my web hosting. If my web hosting had come with PostgreSQL, I'd be using it instead. I suspect most partnering works the same way. If "apache, mailserver and monitoring tools" are using MySQL, that partnership was likely the result of a business decision that may not have been based in technical considerations.

2. As to what those applications are storing in MySQL, you'll probably have to poke through the tables and hope the field names make sense.

1 members found this post helpful.