Dear all,
Today i backup my all databases (25) by using the below command :-
mysqldump --all-databases -q --single-transaction | gzip >
/media/disk-1/Server11_MysqlBackup_15September2011/mysql_15sep2011backup.sql.gz
Now I have some doubts or problems that I need to handle in future :
1. Is
" I am still benchmarking, but I see a 15-20% performance gain after
enabling compression using bacula gui (bat)."
This is a very good performance improvement and how much disk space did you
saved here ?
Can you do bench marking with 4kb and 8kb key_block_size as well to check
what suits your app
Hi Prabhat,
FYI
On Thu, Sep 15, 2011 at 10:33 AM, Suresh Kuna wrote:
> If the hardware on master and slave, version of mysql server, configuration
> and memory allocations are same then you can do a clean shutdown of mysql on
> slave and copy the files to master. Check if any memories needs to b
If the hardware on master and slave, version of mysql server, configuration
and memory allocations are same then you can do a clean shutdown of mysql on
slave and copy the files to master. Check if any memories needs to be
adjusted and start mysql adding the innodb_file_per_table option on master
s
Am 14.09.2011 22:06, schrieb Prabhat Kumar:
> Hi,
>
> I have 2 machine. Master and a slave replication.
>
> few days back I have switched slave machine (innodb_file_per_table) from
> single
> innodb file to one per file table.
>
> Now I want to do for Master.
>
> Now question,
>
> Is it rec
Hi,
I have 2 machine. Master and a slave replication.
few days back I have switched slave machine (innodb_file_per_table) from single
innodb file to one per file table.
Now I want to do for Master.
Now question,
Is it recommendable this method, stop MYSQL services on both and copy mysql
file's
On Wed, Sep 14, 2011 at 09:49:34PM +0530, Ananda Kumar wrote:
> So,
> You want to have 100,000 buttons for 100,000 entries or just have one filter
> column, which allows you to specify any type of "WHERE CONDITION"
>
> regards
> anandkl
>
> On Wed, Sep 14, 2011 at 7:17 PM, Arthur Fuller wrote:
>
Call me stupid, but IMO this is just plain Bad Design. Maybe your masters
are making you want to deliver this, but it's frankly insane. Go instead
with the Sally Rand Principle: show them just enough to pique their
interest. Given that you've narrowed it down to the WHERE clause, try again.
WHERE
So,
You want to have 100,000 buttons for 100,000 entries or just have one filter
column, which allows you to specify any type of "WHERE CONDITION"
regards
anandkl
On Wed, Sep 14, 2011 at 7:17 PM, Arthur Fuller wrote:
> Forgive my bluntness, but IMO it is silly to attempt to retrieve a 100,000
>
Forgive my bluntness, but IMO it is silly to attempt to retrieve a 100,000
rows, except for reporting purposes, and in that case, said reports ought to
run against a replica, not the OLTP instance.
Far better, IMO, is to present (in the UI) an alphabet as buttons, plus a
textbox for refinements.
Dr. Doctor,
What kind of 10 entries? Is it insert,update delete etc.
regards
anandkl
On Wed, Sep 14, 2011 at 6:30 PM, The Doctor wrote:
> Question:
>
> How can you optimise MySQL for 10 entires?
>
> Just running OSCemmerce and it is slow to pull up a who catalogue.
>
> --
> Member - Libe
Question:
How can you optimise MySQL for 10 entires?
Just running OSCemmerce and it is slow to pull up a who catalogue.
--
Member - Liberal International This is doc...@nl2k.ab.ca Ici doc...@nl2k.ab.ca
God, Queen and country! Never Satan President Republic! Beware AntiChrist
rising!
ht
Am 14.09.2011 14:50, schrieb Maria Arrea:
> I have finally enabled compression:
> I am still benchmarking, but I see a 15-20% performance gain after enabling
> compression using bacula gui
as expected if disk-io is the only bottenleck
the same with NTFS-Compression inside a VMware Machine on mod
I have finally enabled compression:
+++-++---++-+-+--+---++-+-+-+---+--+---
Hi, all:
There is a problem about master-slave sync delay,
I find some infomations from 'show processlist', some like that:
1051system user nsConnect 10 update xxx
what does Connect mean, mysql manual explained:
Connect
A replication slave is connected to its master.
Am 14.09.2011 09:50, schrieb Maria Arrea:
> I have read all your mails, and still not sure if I should enable innodb
> compression
if you have enough free cpu-ressources and IO is your problem simply yes
because the transfer from/to disk will be not so high as uncompressed
signature.asc
The server hosting bacula and the database only has one kind of disk: SATA,
maybe I should buy a couple of SSD for mysql.
I have read all your mails, and still not sure if I should enable innodb
compression. My ibfile is 50 GB, though.
Regards
Maria
Questions:
1) Why are you putting you
17 matches
Mail list logo
