V následujúcej časti nášho seriálu si pozrieme základnú inštaláciu MySQL na serveri Debian a základný popis jednotlivých konfiguračných položiek.
Inštaláciu databázového servera začneme príkazom
apt-get install mysql-server-5.0
Pri inštalácii sa mi stáva že mi nevytvorí root užívateľa, prihlasovacie údaje do mysql vypíšeme
cat /etc/mysql/debian.cnf , vidíme používateľa debian-sys-maint a jeho prihlasovacie heslo.
Log slow query
Do /etc/mysql/my.cnf doplníme
long_query_time = 1
log-slow-queries = /var/log/mysql/mysql-slow.log
Tu prikladám optimalizovaný my.cnf
cat my.cnf
#
# The MySQL database server configuration file.
#
# You can copy this to one of:
# – “/etc/mysql/my.cnf” to set global options,
# – “~/.my.cnf” to set user-specific options.
#
# One can use all long options that the program supports.
# Run program with –help to get a list of available options and with
# –print-defaults to see which it would actually understand and use.
#
# For explanations see
# http://dev.mysql.com/doc/mysql/en/server-system-variables.html
# This will be passed to all mysql clients
# It has been reported that passwords should be enclosed with ticks/quotes
# escpecially if they contain “#” chars…
# Remember to edit /etc/mysql/debian.cnf when changing the socket location.
[client]
port = 3306
socket = /var/run/mysqld/mysqld.sock
# Here is entries for some specific programs
# The following values assume you have at least 32M ram
# This was formally known as [safe_mysqld]. Both versions are currently parsed.
[mysqld_safe]
socket = /var/run/mysqld/mysqld.sock
nice = 0
[mysqld]
#
# * Basic Settings
#
#
# * IMPORTANT
# If you make changes to these settings and your system uses apparmor, you may
# also need to also adjust /etc/apparmor.d/usr.sbin.mysqld.
#
user = mysql
pid-file = /var/run/mysqld/mysqld.pid
socket = /var/run/mysqld/mysqld.sock
port = 3306
basedir = /usr
datadir = /var/lib/mysql
tmpdir = /tmp
language = /usr/share/mysql/english
long_query_time = 1
log-slow-queries = /var/log/mysql/mysql-slow.log
#skip-external-locking
#
# Instead of skip-networking the default is now to listen only on
# localhost which is more compatible and is not less secure.
#bind-address = 127.0.0.1
#
# * Fine Tuning
#
key_buffer = 16M
max_allowed_packet = 16M
thread_stack = 128K
thread_cache_size = 8
#max_connections = 100
#table_cache = 64
#thread_concurrency = 10
#
# * Query Cache Configuration
#
query_cache_limit = 1M
query_cache_size = 16M
#
# * Logging and Replication
#
# Both location gets rotated by the cronjob.
# Be aware that this log type is a performance killer.
#log = /var/log/mysql/mysql.log
#
# Error logging goes to syslog. This is a Debian improvement 
#
# Here you can see queries with especially long duration
#log_slow_queries = /var/log/mysql/mysql-slow.log
#long_query_time = 2
#log-queries-not-using-indexes
#
# The following can be used as easy to replay backup logs or for replication.
# note: if you are setting up a replication slave, see README.Debian about
# other settings you may need to change.
#server-id = 1
#log_bin = /var/log/mysql/mysql-bin.log
expire_logs_days = 10
max_binlog_size = 100M
#binlog_do_db = include_database_name
#binlog_ignore_db = include_database_name
#
# * BerkeleyDB
#
# Using BerkeleyDB is now discouraged as its support will cease in 5.1.12.
skip-bdb
#
# * InnoDB
#
# InnoDB is enabled by default with a 10MB datafile in /var/lib/mysql/.
# Read the manual for more InnoDB related options. There are many!
# You might want to disable InnoDB to shrink the mysqld process by circa 100MB.
#skip-innodb
#
# * Security Features
#
# Read the manual, too, if you want chroot!
# chroot = /var/lib/mysql/
#
# For generating SSL certificates I recommend the OpenSSL GUI “tinyca”.
#
# ssl-ca=/etc/mysql/cacert.pem
# ssl-cert=/etc/mysql/server-cert.pem
# ssl-key=/etc/mysql/server-key.pem
[mysqldump]
quick
quote-names
max_allowed_packet = 16M
[mysql]
#no-auto-rehash # faster start of mysql but no tab completition
[isamchk]
key_buffer = 16M
#
# * NDB Cluster
#
# See /usr/share/doc/mysql-server-*/README.Debian for more information.
#
# The following configuration is read by the NDB Data Nodes (ndbd processes)
# not from the NDB Management Nodes (ndb_mgmd processes).
#
# [MYSQL_CLUSTER]
# ndb-connectstring=127.0.0.1
#
# * IMPORTANT: Additional settings that can override those from this file!
# The files must end with ‘.cnf’, otherwise they’ll be ignored.
#
!includedir /etc/mysql/conf.d/
phpMyAdmin
apt-get install phpmyadmin
Ďalšiu implementácius MySQL už debian vykoná za nás, phpmyadmin nájdeme na adrese IP/phpmyadmin.
Meeting Girls…
[...]here are actually some back links to sites that I link to because we know they are actually worth paying a visit to[...]…
Wow!…
A very fascinating post….
pick up artist magazine…
[...]here are a few links to web sites that we link to because we think they are actually worth checking out[...]…
Thanks For The Post…
[...]right here are actually some back links to pages that I also link to since we believe they are truly worth going to[...]…
Meeting Girls…
[...]here are simply some links to websites that we also link to because we know they are actually worth going to[...]…
I linked here…
[...]listed here are actually some links to a few other sites that we also link to since we believe they are actually worth visiting[...]…
Income Pertaining to Higher education Scholarships and grants pertaining to MinoritiesMedical site…
[…]below are generally numerous web addresses for you to websites we hook up with considering that many of us feel they’re really worthy of visiting[... ]…
Thanks…
When I originally commented I clicked the -Notify me when new comments are added- checkbox and now each time a comment is added I get four emails with the same comment. Is there any way you can remove me from that service? Thanks!…
Blog Updates…
[...]the time to read or visit the content or sites we have linked to below the[...]…
Arigatou…
Hello! I just would like to give a huge thumbs up for the great info you have here on this post. I will be coming back to your blog for more soon….
Cool sites…
[...] yet still deliberating on an actual certain fashion that you persuaded exactly who [...]…
Yahoo results…
While browsing Yahoo I found this page in the results and I didn’t think it fit…
Digg…
While checking out DIGG today I found this…
Tumblr article…
I saw a writer talking about this on Tumblr and it linked to…
Informative and precise…
Its hard to find informative and precise information but here I found…
Wikia…
Wika linked to this website…
Just Browsing…
While I was surfing yesterday I saw a excellent post about…
Yahoo results…
While searching Yahoo I found this page in the results and I didn’t think it fit…
News info…
I was reading the news and I saw this really interesting info…
Dreary Day…
It was a dreary day here yesterday, so I just took to piddeling around on the internet and found…
Wikia…
Wika linked to this place…
Dreary Day…
It was a dreary day here today, so I just took to piddeling around online and found…
Wikia…
Wika linked to this site…
Tumblr article…
I saw someone writing about this on Tumblr and it linked to…
Looking around…
I like to surf in various places on the web, regularly I will go to Digg and follow thru…
Looking around…
I like to surf in various places on the online world, often I will go to Digg and follow thru…
Informative and precise…
Its hard to find informative and precise info but here I found…
Just Browsing…
While I was surfing yesterday I noticed a great article concerning…
Yahoo results…
While searching Yahoo I found this page in the results and I didn’t think it fit…
You should check this out…
[...] Wonderful story, reckoned we could combine a few unrelated data, nevertheless really worth taking a look, whoa did one learn about Mid East has got more problerms as well [...]……
Buy Yankee Candles Cheap…
[...]below you’ll find the link to some sites that we think you should visit[...]…
Awesome website recommended your blog…
[...]the time for yоu tо read оr navigate to thе content or web-sites we’ve attached to belоw the[...]…
Superb link…
[...] Sites of interest we have a url to [...]…
This Site Linked…
[...]right here are simply some links to websites that we also link to because I think they are actually worth paying a visit to[...]…
Sites I like…
[...]right here are actually some links to a few other sites that I also link to since we believe they are truly worth checking out[...]…
Thanks…
Can I just say what a relief to find someone who actually knows what theyre talking about on the internet. You definitely know how to bring an issue to light and make it important. More people need to read this and understand this side of the story. I …
Dreary Day…
It was a dreary day here today, so I just took to piddeling around on the internet and found…
Informative and precise…
Its hard to find informative and accurate info but here I noted…
Recommended sites…
the time to read or visit the content or sites we have linked to below the…
News info…
I was reading the news and I saw this really interesting information…
Just Browsing…
While I was browsing yesterday I noticed a great post concerning…
Just Browsing…
While I was surfing yesterday I noticed a excellent post concerning…
Great site…
thanks for that, I also invite to visit my website…
Nice Focus……
[...] The material talked about within the post are a number of the most beneficial out there [...]…
Awesome website…
[...]the time to read or visit the content or sites we have linked to below the[...]……
Recent Blogrolls……
[...] If you are looking for additional information in regards to this issue, addiitional information about our present-day problem is presented on [...]…
Informative and precise…
Its hard to find informative and precise information but here I noted…
Just Browsing…
While I was browsing yesterday I saw a excellent post concerning…
Tumblr article…
I saw someone talking about this on Tumblr and it linked to…
[...] that is the end of this article. Here you’ll find some sites that we think you’ll appreciate, just click the links over[...]……
[...] Every once in a while we choose blogs that we read. Listed below are the latest sites that we choose [...]……