Gavin,
Right,
that is also an option, but you are really not sure 100% that everything
that is on memory is on the disk (buffers etc...)
also if it is definitely good for a disaster recovery.
What I meant is that the only way to have a 100% guaranteed consistent
binary backup is when the
How does the below not guarantee me 100% that everything that can be
consistent, is ?
mysql flush tables with read lock;
unixhost# sync
unixhost# lvm create snapshot
mysql unlock tables;
I agree that there may be data inconsistencies within MyISAM, as it has no
transactions, but there's also no
Johan,
Is the fact that InnoDB ignores the command FLUSH TABLES WITH READ LOCK;
enough? :)
InnoDB has buffers and activities going on even if you locked the tables and
you are not sure that its buffers are on the disk when you snapshot.
Again, you might be lucky and trust in the InnoDB recovery,
hello ML,
i'm new to MySQL, so i have a very basic question. I have to install a database
server for about 15 persons. The server is intended for testing and evaluating.
The users should be able to create their own databases and tables. And they
should be able to give grants on their own
On Wed, Apr 21, 2010 at 10:50 AM, Claudio Nanni claudio.na...@gmail.comwrote:
Johan,
Is the fact that InnoDB ignores the command FLUSH TABLES WITH READ LOCK;
enough? :)
InnoDB has buffers and activities going on even if you locked the tables
and you are not sure that its buffers are on the
Lentes, Bernd skrev:
hello ML,
i'm new to MySQL, so i have a very basic question. I have to install a database
server for about 15 persons. The server is intended for testing and evaluating.
The users should be able to create their own databases and tables.. And they
should be able to give
A Nice SQL dump with table locked are also very good, the problem is you
will lock the database for the time needed to dump it.
If you do it good like:
lock all tables
flush logs
dump
unlock tables
you will know where to start in case of recovery dump+binary logs
Cheers!
Claudio
2010/4/21
Hi Ben,
as said, you have to consider that a database data lives both on disk and on
ram,
on ram you have transactions, buffers that are asyncronously written to
disk, etc.
While the datadir of a 'shutdown' database is the FULL dataset(knowledge)
since no information is in ram,
a datadir of a
Carsten Pederseb wrote:
First, don't mess around with the grant tables. Many years
ago, that was indeed the way to control user access, but
things have progressed since then. How old is that MySQL book?
It's from 2005 and about MySQL-version 5.
Remove the manual edits you have made
On Wed, Apr 21, 2010 at 2:39 PM, Lentes, Bernd
bernd.len...@helmholtz-muenchen.de wrote:
The book says it's not possible to use metacharacters like % with GRANT.
The book is wrong. You have to use backticks to quote the lentes_% part,
though - it's an annoying quirk.
Please ritually burn the
Hi,
I have installed mysql 5.1.45 version on windows server 2003[standard edition]
and windows xp. I am using WIN SERVER as MASTER and WIN XP as slave.And the
default engine in both severs is INNODB.
I am using visual basic for my front end. The replication system is running
quite well.
I have a 1.5G database which feeds a CMS web application (Drupal).
Right now I am hosting it with a 1.5G RAM VPS and I feel it is too slow. IO
and CPU are high. So I am planning to upgrade it to a dedicated serer.
Here are two choice of my server:
1. Intel Pentium G6950 (Dual Core), 2xSATA
-Original Message-
From: Claudio Nanni [mailto:claudio.na...@gmail.com]
Sent: Wednesday, April 21, 2010 2:12 AM
Cc: mysql@lists.mysql.com
Subject: Re: better way to backup 50 Gig db?
[JS] snip
[JS] Unless I've forgotten something from earlier in my career (what day is
it, anyways?),
Switch CMSes, you'll be better off. I have the pain of running Drupal, too.
Your DB host is probably good enough, unless you're doing insane amounts of
page views. What you need is Drupal optimisations. Here's just a few:
- drupal keeps both it's sessions and cache in the DB. Change to memcache
Hi,
Have you looked at tuning Drupal first? What processes are slowing your server
down and are there any other applications sharing the machine that might be
contributing to the problem? Assuming you haven't got any wacky contrib modules
have you considered improving your application caching,
Thanks Johan,
Unfortunately I run into all 4 issues you have mentioned. And the views is
my huge part of my site.
I got about 50k-60k page view per day, about 40k nodes. It is really a pain
to make drupal run fast. I feel drupal query the db tooo much.
I understand I can get some
I am dealing with a JOIN error issue. The following query:
SELECT *
FROM (((ts_software RIGHT JOIN t_computers ON
t_softwareassoc.SoftwareAssocSoftwareID = ts_software.SoftwareID) LEFT JOIN
ts_softwaremfg ON
ts_software.SoftwareMfgID = ts_softwaremfg.SoftwareMfgID) LEFT JOIN
ts_eqtype ON
It seems all Johans are interested on this topic. :D
Thank Johan.
My web server (apache 2) is on the same server. And it looks good to me.
I have no custom module. The most often used modules are CCK, Views and
WebForm. OK my server does send out some mails every day, about 10K.
I tried to
I guess this is a DB list, but I strongly disagree with Johan's suggestion to
avoid using Views or Taxonomy. The advantages far outweigh the disadvantages in
most cases.
-Original Message-
From: vegiv...@gmail.com [mailto:vegiv...@gmail.com] On Behalf Of Johan De
Meersman
Sent: 21
Thanks Martin,
This is my current configuration.
mysql SHOW VARIABLES LIKE 'have_query_cache';
+--+---+
| Variable_name| Value |
+--+---+
| have_query_cache | YES |
+--+---+
1 row in set (0.00 sec)
mysql SHOW VARIABLES LIKE
This is my current my.cnf setttings. Could anyone take a quick peek and tell
me if I set anything awfully wrong?
[mysqld]
port = 3306
socket = /var/lib/mysql/mysql.sock
skip-locking
key_buffer = 128M
max_allowed_packet = 1M
table_cache = 4196
open_files_limit = 1
sort_buffer_size =
OK, let's get back to the original question. for a database like mine
(1.5GB), will 4GB or 8GB RAM make any difference performance wise?
On Wed, Apr 21, 2010 at 10:04 AM, Johan Gant johan.g...@groupgti.comwrote:
I guess this is a DB list, but I strongly disagree with Johan's suggestion
to
On Wed, Apr 21, 2010 at 11:14 AM, shamu...@gmail.com shamu...@gmail.com wrote:
This is my current my.cnf setttings. Could anyone take a quick peek and tell
me if I set anything awfully wrong?
If your tables are MyISAM (not InnoDB), then 128MB is much too small
for your key_buffer. You should
Thanks Perrin,
My web server is on the same box as the database server.
I tried to use a mysql tuning-primer.sh to evaluate my server. and the
result for key_buffer is
KEY BUFFER
Current MyISAM index space = 181 M
Current key_buffer_size = 128 M
Key cache miss rate is 1 : 12507
Key buffer free
It looks like that your first join clause are inconsistent in itself, that
is, you declared it for tables A B, but actually used A C instead:
ts_software RIGHT JOIN t_computers ON
t_softwareassoc.SoftwareAssocSoftwareID = ts_software.SoftwareID
-Original Message-
From: Weydson Lima
Hi Hao Ding,
I attached in my request mail it self. Please find the attachment.
Thank you
From: hao ding fire9di...@gmail.com
To: Vikram A vikkiatb...@yahoo.in
Sent: Wed, 21 April, 2010 7:25:05 PM
Subject: Re: BIN LOG Error when use Begin Trans in
Claudio,
So innodb may not be consistent between memory and disk at all times, but
that's actually not important. What is important is that the files on disk to
be consistent with a specific binlog position. That's all that is needed for a
consistent backup, and can be done with filesystem
I'd go with the 4G 4-core server. If you're running apache and a sensible
OS, the extra cores can be helpful. So, unless you know you have a need for
very large key buffers, 4G should leave the OS plenty for FS cache.
Not that I actually have a clue. I really just wanted to be the first to
answer
28 matches
Mail list logo
