(Sheeri Cabral) According to the manual, FLUSH LOGS is supposed to: Closes and reopens all log files. If binary logging is enabled, the sequence number of the binary log file is incremented by one relative to the previous file. On Unix, this is the same thing as sending a SIGHUP signal to the mys

(Peter Zaitsev) Backing up MySQL Database most people compress them – which can make a good sense in terms of backup and recovery speed as well as space needed or be a serious bottleneck depending on circumstances and approach used.

(Sunny Walia) As a consultant, I do a lot of content migrations for clients. One issue I run into quite often is the encoding of databases, tables, columns differs between source and destination. Most clients do not want me to go and change the way their encoding is to fix issues since they are too

(Patrick Galbraith) I’ve been using MySQL fulltext indexes on a table where I keep a few varchar and one text column that is used for searches. I’ve had it defined as:

(John K. Waters) There was a lot of head scratching at this year’s MySQL Conference and Expo when Microsoft was singled out for its contributions to open source development.

(Peter Zaitsev) I was working with the customer today investigating MySQL over DRBD performance issues. His basic question was why there is so much overhead with DRBD in my case, while it is said there should be no more than 30% overhead when DRBD is used.

(Lewis Cunningham) The datastore in Postgres (which is what Advanced Server is based on) is quite a bit different than the way Oracle stores data. Gone are the usual logical storage components. Data blocks, extents and segments just don’t exist in a Postgres database. Actually, segments do exist whe

(Baron Schwartz) Do you have skip_name_resolve set in your /etc/my.cnf? If not, consider it. DNS works fine, until it doesn’t. Don’t let it catch you off guard.

(Jayant Kumar) Why? In brief, it is said that mysql is not as stable as postgresql. Postgresql or pgsql focuses on a single database engine as compared to mysql which has a pluggable engine architecture and has multiple engines. Also postgresql is well designed as compared to mysql. psql console is

(Greg Sabino Mullane) I just wrapped up a new action named replicate_row that I’ve been kicking around for a while. This is part of the check_postgres.pl script, which monitors many Postgres things for Nagios or other systems. This new action (part of the just-released version 1.7.0 of check_postgre