I just uploaded the pdf of the summer issue of Open Source Database
Magazine. Included in this issue:
* A great article on the new features of Postgresql 8.4 by Robert Treat
* Part one of a two part article on Perconas new XtraBackup backup
program
Also the news, the book shelf and
There are merits to most of the common operating systems. In some ways
each of them perform better at various functions. The question becomes
which are you most comfortable and familiar with? That way you can work
most effectively with the operating system to fulfill the potential of
your
Hope the client learned the lesson about backups. it's a hard one to learn
sometimes.
If the binary logs on the slave were enabled when the table was populated
it should be possible to restore the table from the binary logs. If not,
and logging was turned on after the table was populated than you
hello everyone,
Many of you know I have been the editor of MySQL Magazine for the last two
years. Beginning with the summer issue I will be making some pretty major
changes. The magazine is being renamed Open Source Database Magazine and I
am going to be attempting to steer the subject matter to
I have seen testing of servers up to 128 GB of RAM. I wish I could say I
was the one doing the test..however I use systems on a regular basis with
up to 32 GB. Does it scale perfectly? No. Is it better than it was just a
year ago even? Definitely.
Hope that helps.
Keith Murphy
Didn't want
last month there is certainly plenty to talk about!
Draft articles will need to be in by the 10th of January so you have a
month to get things ready. I need to hear about possible articles by the
15th of this month. I can be reached at bmurphy AT paragon-cs.com with
your ideas. I want to mention
Magazine!! Just send me your idea for an article to bmurphy AT
paragon-cs.com.
For those who dont know, MySQL Magazine is a quarterly publication by
the community - for the community that is free and available for download
from http://www.mysqlzine.net.
Looking forward to hearing from everyone
Yes, you are exactly right. The schema is the structure of the database.
Keith
I've been referencing a variety of sources, including wikipedia. What I
know about a schema is that in SQLite the .schema command will show the
the SQL structure of that databases tables, which would be analogous
