similar.
BR,
Rafal.
2014-10-29 11:38 GMT+01:00 Heck, Walter :
> Hi Rafael,
> On Wed, Oct 29, 2014 at 10:15 AM, Rafał Radecki
> wrote:
>
>> I am creating an environment based on about 15 hardware nodes. 6 of them
>> will be for mysql databases. They will be divided into t
Hi All :)
I am creating an environment based on about 15 hardware nodes. 6 of them
will be for mysql databases. They will be divided into three pairs (3x2
nodes). Nodes in every pair will be configured with replication.
I done similar configuration about an year ago. I used than:
- percona 5.5 wi
Hi All.
I use:
percona-toolkit-2.2.4-1.noarch
Percona-Server-server-55-5.5.28-rel29.1.335.rhel6.x86_64
Percona-Server-shared-compat-5.5.28-rel29.1.335.rhel6.x86_64
Percona-Server-client-55-5.5.28-rel29.1.335.rhel6.x86_64
Percona-Server-shared-55-5.5.28-rel29.1.335.rhel6.x86_64
on
Centos 6.3 2.6.32
Hi All.
I use binlog_format = row for my production databases. In this format most
binlog_format changes are sent not as SQL statements but in some other
format.
I understand that when binlog_format = statement is used, queries on master
and slave can give different results, but should pt-table-ch
Have you used pt-online-schema-change.html from
http://www.percona.com/doc/percona-toolkit/2.0/pt-online-schema-change.html ?
What do you think about this tool?
Best regards,
Rafal Radecki.
2013/7/8 Rafał Radecki
> Hi All.
>
> I would like to change the layout of my production da
Hi All.
I would like to change the layout of my production database, I would like
to add a column to an existing table. As I think before the ALTER TABLE
statement all access to the database should be denied/ended, then the ALTER
TABLE should be performed, and then user/applications should be able
Hi All.
I would like to limit resources available to a given user in mysql. I know
that there is https://dev.mysql.com/doc/refman/5.5/en/user-resources.html,
I also know that cgroups can be used at operating system level.
What are your experiences in limiting resources in mysql? I've user percona
As I can see the changes in these values are use by percona cacti
monitoring templates to graph "InnoDB I/O".
Can anyone answer the question finally? ;)
2013/6/21 Hartmut Holzgraefe
> On 21.06.2013 13:59, Rafał Radecki wrote:
> > Hi All.
> >
> > I've
Hi All.
I've searched but with no luck... what do exactly these variables mean:
1343928 OS file reads, 1085452262 OS file writes, 19976022 OS fsyncs
?
I am wondering if my innodb_buffer_pool setting is not to low. Does 'file
reads' show number of times innodb files have been read into memory fro
Hi All.
I use mysql/perconna/maria on my production CentOS 6 Linux servers. I
currently try to choose the default filesystem for partitions with mysql
data. Some time ago (previous dba) reiserfs was the choice but now it is
not in the kernel and the main author is in prison.
>From what I've read
Hi All.
I am trying to set the best value for innodb_buffer_pool_size. My system
has 6GB of ram.
My system is:
2.6.32-279.19.1.el6.centos.plus.x86_64
CentOS release 6.3 (Final)
mysql-server-5.0.58
My current setting:
innodb_buffer_pool_size = 1024M
(my.cnf attached)
>From show innodb st
Hi All.
I have a production setup of four databases connected with
replication. I would like to log every command that clients execute
for auditing.
I've read
http://www.percona.com/doc/percona-server/5.5/diagnostics/mysql_syslog.html?id=percona-server:features:mysql_syslog&redirect=1#client-var
8.0.100:44077 192.168.0.1:3306
TIME_WAIT
tcp0 0 192.168.0.100:57240 192.168.0.2:9989
TIME_WAIT
tcp0 0 192.168.0.100:43897 192.168.0.1:3306
TIME_WAIT
tcp0 0 192.168.0.100:57250 192.168.0.2:9989
TIME_WAIT
tcp
Hi All.
I use:
cat /etc/redhat-release
CentOS release 6.3 (Final)
uname -a
Linux prod1.local 2.6.32-279.14.1.el6.x86_64 #1 SMP Tue Nov 6 23:43:09
UTC 2012 x86_64 x86_64 x86_64 GNU/Linux
on db host:
rpm -qa | grep mmm
mysql-mmm-2.2.1-1.el6.noarch
bmysql-mmm-agent-2.2.1-1.el6.noarch
on monitor h
Thanks, I will use this tool :)
2013/2/19 Johan De Meersman :
> - Original Message -
>> From: "Rafał Radecki"
>>
>> pt-table-checksum performs an online replication consistency check by
>> executing checksum queries on the master, which produces
&g
lem.
Any other tips?
Best regards,
Rafal Radecki.
2013/2/18 Johan De Meersman :
> - Original Message -
>> From: "Rafał Radecki"
>>
>> 3) drop mysql and app databases;
>> 4) restore them from backup;
>
> Instead of dropping the DBs, simply resto
Hi All.
I have a development database which is replicated to a slave. Backup
is taken daily from this slave. I need to test if the restore
procedure is ok.
I would like to:
1) block all application access (stop services + iptables block) to
the database and lock it read only;
2) make a backup with
Hi All.
I use:
# rpm -qa | grep -i percona-server-server
Percona-Server-server-55-5.5.28-rel29.3.388.rhel6.x86_64
My system:
# uname -a;cat /etc/redhat-release
Linux prbc01.mg.local 2.6.32-279.19.1.el6.centos.plus.x86_64 #1 SMP
Wed Dec 19 06:20:23 UTC 2012 x86_64 x86_64 x86_64 GNU/Linux
Red Hat
Hi all.
I have installed a setup in which I use semisync replication. On master I have:
mysql> show status like '%rpl%';
++-+
| Variable_name | Value |
++-
Hi all.
I would like to clear values off Rpl_semi_sync_master_no_tx and
Rpl_semi_sync_master_no_times status variables because I am plugging a
sync replication setup into nagios.
I've tried:
mysql> SET global Rpl_semi_sync_master_no_tx=0;
ERROR 1193 (HY000): Unknown system variable 'Rpl_semi_sync_
Hi all.
I write a script to delete rows from slow_log older than 2 weeks.
#!/bin/bash
if [ $# -ne 1 ]; then
echo "Usage: $0 mysql_config_file"
exit 1
fi
SELECTQUERY="select * from slow_log where start_time <
DATE_ADD(NOW(),INTERVAL - 2 WEEK)"
DELETEQUERY="delete from slow_log where start_time <
Hi all.
Is there a possibility to see the info from slowlog somewhere in database?
I would like to see slow queries using mysql and not by watching the log
file.
I've searched on google and mysql website but hasn't found the solution.
Best regards,
Rafal Radecki.
22 matches
Mail list logo
