- Original Message -
> From: "Adarsh Sharma"
>
> Dear all,
>
> I have doubt regarding the storage structure for Innodb files :
>
> Our database server has the following paths :
>
> /dev/sda5 69G 35G 32G52% /hdd1-1
> /dev/sdb1 274G 225G 36G 87% /hdd2
Dear all,
I have doubt regarding the storage structure for Innodb files :
Our database server has the following paths :
/dev/sda5 69G 35G 32G52% /hdd1-1
/dev/sdb1 274G 225G 36G 87% /hdd2-1
/dev/sdc5 274G 225G 36G 87% /hdd3-1
/dev/sdd5
On Mar 15, 2011, at 6:18 PM, Rhino wrote:
All you should need is this:
select distinct org_id
from orders
where item_id in (34, 36, 58, 63)
I'm assuming that the DISTINCT operator is available in the version
of MySQL that you are using. I don't currently have any version of
MySQL instal
Hi,
I need a help to build a query.
Let's say there is a table orders (simplified, of course)
CREATE TABLE orders (
`item_id` int,
`org_id` int,
) ENGINE=MyISAM
item_idorg_id
342607
342607
341520
362607
361520
368934
3828
3815
You might want to look into replication
(http://dev.mysql.com/doc/refman/5.5/en/replication.html). You can set up a
replication slave to follow the master DB in real time, or offset by minutes,
hours, days, or weeks, or whatever. That way you have a copy already served up
waiting in the wings,
On Tue, March 15, 2011 12:36, Joerg Bruehe wrote:
> Hi!
>
>
> Adarsh Sharma wrote:
>> Dear all,
>>
>> Taking Backup is must needed task in Database Servers. [[...]]
>
> Correct.
>
>>
>> We have options RAID, mylvmbackup , mysqldump. But it depends on the
>> company requirement too.
>
> RAID is no b
Hi!
Adarsh Sharma wrote:
> Dear all,
>
> Taking Backup is must needed task in Database Servers. [[...]]
Correct.
>
> We have options RAID, mylvmbackup , mysqldump. But it depends on the
> company requirement too.
RAID is no backup!
A RAID system may give you protection against a single disk
>-Original Message-
>From: Sándor Halász [mailto:h...@tbbs.net]
>Sent: Monday, March 14, 2011 8:52 PM
>To: Johan De Meersman
>Cc: mysql@lists.mysql.com
>Subject: Re: "IF"
>
> 2011/03/14 16:08 +0100, Johan De Meersman
>I'm afraid I'm not authoritative on this, but it seems to me t
- Original Message -
> From: "Sándor Halász"
>
> Yes, but Access s "IIF", of the same use, evaluates all three, and
> the documentation explicitly says so. MySQL s, that I have seen,
> says neither. Assuming the worst is safer, and then one uses CASE
> ..., but if not,
Well, they n
The OR conditions require a full table scan everytime this is called.
You didn't say how many rows you had, nor if there were indexes on
your various phone_xxx fields. If you do, you should get some value
by approaching it as a UNION
select count(id)from (
select id from leads where phone_work
- Original Message -
> From: "Krishna Chandra Prajapati"
>
> incremental backup using zamanda.
I'm running Zmanda on about two dozen hosts, and it comes well-recommended. It
doesn't do anything that you can't do yourself, but it's easy to set up,
reports well and backs up in what are b
Dear all,
I have a query that takes a rather long time and was wondering if there is
anyway to optimize it.
Normally we removing duplicate records by phone number. This query takes about
a
second and
it really slows down the process when we are importing several 1000 records a
day.
Here is
Is there a field to save symbols like degree in mysql
--Original Message--
From: Peter Brawley
To: mysql@lists.mysql.com
ReplyTo: peter.braw...@earthlink.net
Subject: Re: "IF"
Sent: Mar 15, 2011 9:22 PM
> Yes, but Access s "IIF", of the same use, evaluates all three, and the
> documentat
Yes, but Access s "IIF", of the same use, evaluates all three, and the
documentation explicitly says so.
Let's be glad we don't depend on Access, then.
PB
-
On 3/14/2011 7:52 PM, Sándor Halász wrote:
2011/03/14 16:08 +0100, Johan De Meersman
I'm afraid I'm not authoritative on t
Hi,
there is a lot of info on different backup methods here:
http://dev.mysql.com/doc/refman/5.1/en/backup-methods.html
For example, for incremental backups see "Making Incremental Backups
by Enabling the Binary Log",
cheers Andy.
--
MySQL General Mailing List
For list archives: http:
xtrabackup, mysqlhotcopy for myisam, incremental backup using zamanda.
Krishna
On Tue, Mar 15, 2011 at 9:09 PM, petya wrote:
> Hi,
>
> What storage engine are you using?
>
> Peter Boros
>
> On 03/15/2011 02:12 PM, Adarsh Sharma wrote:
>
>> Dear all,
>>
>> Taking Backup is must needed task in Da
Hi,
What storage engine are you using?
Peter Boros
On 03/15/2011 02:12 PM, Adarsh Sharma wrote:
Dear all,
Taking Backup is must needed task in Database Servers. I research a lot
and find techniques to perform it in Mysql.
We have options RAID, mylvmbackup , mysqldump. But it depends on the
c
2011/03/14 16:08 +0100, Johan De Meersman
I'm afraid I'm not authoritative on this, but it seems to me that it would be
very very bad if the third, unused expression were to be evaluated - not only
from a performance point of view, but who is to say that that expression is not
a user-d
Dear all,
Taking Backup is must needed task in Database Servers. I research a lot
and find techniques to perform it in Mysql.
We have options RAID, mylvmbackup , mysqldump. But it depends on the
company requirement too.
We have a database of more than 250GB in mysql database & which is
inc
- Original Message -
> From: "Adarsh Sharma"
>
> Please check the attachment for the script & output.
Thanks for your password :-)
> Now I just want to mail the output of my script to some persons
> e-mail-ID
Assuming you run this from crontab, just set MAILTO=per...@domain.ext right
Dear all,
I have prepared a simple script that shows the database, tables size in
the Database server as :-
Please check the attachment for the script & output.
Now I just want to mail the output of my script to some persons e-mail-ID
Also, I want to do some calculations and provide the info
- Original Message -
> From: "Adarsh Sharma"
> I am able to fetch the output individually, but I try that I access
> all information through one command :
> mysql> SELECT table_schema 'database',table_name 'Table', concat(
> round( sum( data_length + index_length ) / ( 1024*1024*1024) ,
22 matches
Mail list logo
