]]>
]]>

You are here

Feed aggregator

Query time huge difference

Lastest Forum Posts - April 26, 2015 - 6:31am
Hi,

I'm using version 5.6.23.

The query I'm running:

SELECT stationeve0_.id AS col_0_0_, stationeve0_.notify_on AS col_1_0_, stationeve0_.event_date AS col_2_0_, stationeve0_.source_id AS col_3_0_, stationeve0_.event_type AS col_4_0_, stationeve0_.log_level_id AS col_5_0_, stationeve0_.action_result AS col_6_0_, stationeve0_.relevent_data AS col_7_0_, stationeve0_.extra_data AS col_8_0_, stationeve0_.transaction_id AS col_9_0_, stationimp1_.caption AS col_10_0_, stationimp1_.identity_key AS col_11_0_, stationimp1_.id AS col_12_0_, stationeve0_.user_id AS col_13_0_, stationeve0_.request_uuid AS col_14_0_
FROM station_event_log stationeve0_
INNER JOIN station stationimp1_ ON stationeve0_.station_Id=stationimp1_.id
WHERE (stationimp1_.deleted IS NULL OR stationimp1_.deleted=0) AND stationeve0_.service_provider_id=3 AND stationeve0_.notify_on>='2015-04-25 13:17:27' AND stationeve0_.notify_on<='2015-04-26 13:17:27.593'
ORDER BY stationeve0_.notify_on DESC, stationeve0_.id DESC
LIMIT 50

This query is taking a few milliseconds.
When I'm changing the dates in the where clause and ask for 48 hours instead of 24 it still takes a few milliseconds. When it is 72 hours I have to manually kill the query after 2-3 minutes because the query didn't finish yet. I modified the ranges until I found a limit of which 1 minute change is the difference between lightning fast results and no results at all. The range limit is dynamic, if yesterday it was 50 hours and 20 minutes (was fast, in 50 hours and 21 minutes it was very slow), today it can be 47 hours and 32 minutes for example.
I can choose a completely different time range (in the beginning of April or in March for example) and I still see the exact same behavior.
I'm really clueless at this point, can anyone point me in the right direction and help me understand it and solve it?

The create table of the relevant table:

CREATE TABLE `station_event_log` (
`id` BIGINT(20) NOT NULL AUTO_INCREMENT,
`source_id` INT(11) NOT NULL,
`event_type` BIGINT(11) NOT NULL,
`notify_on` DATETIME(3) NOT NULL,
`extra_data` VARCHAR(3000) NULL DEFAULT NULL,
`station_id` BIGINT(20) NULL DEFAULT NULL,
`log_level_id` INT(11) NULL DEFAULT NULL,
`relevent_data` VARCHAR(3000) NULL DEFAULT NULL,
`root_action_id` VARCHAR(255) NULL DEFAULT NULL,
`action_result` VARCHAR(1000) NULL DEFAULT NULL,
`transaction_id` BIGINT(20) NULL DEFAULT NULL,
`error_code_id` INT(11) NULL DEFAULT NULL,
`user_id` BIGINT(20) NULL DEFAULT NULL,
`station_socket_id` BIGINT(20) NULL DEFAULT NULL,
`service_provider_id` BIGINT(20) NULL DEFAULT NULL,
`event_date` DATETIME(3) NOT NULL,
`request_uuid` VARCHAR(250) NULL DEFAULT NULL,
PRIMARY KEY (`id`, `notify_on`),
INDEX `idx_station_event_log_1` (`notify_on`),
INDEX `idx_station_event_log_2` (`event_type`),
INDEX `fk_station_event_log_station_socket_id` (`station_socket_id`),
INDEX `idx_station_event_log_3` (`log_level_id`),
INDEX `idx_station_event_log_complex_1` (`station_id`, `notify_on`, `service_provider_id`, `event_type`)
)
COLLATE='utf8_general_ci';

In addition, I have partitions by year on `notify_on` and sub-partitions by month (on the same column).

Understanding Percona Cloud tools metrics and Query Analysis Output

Lastest Forum Posts - April 24, 2015 - 7:10pm
Hi All,

I recently started using Percona monitoring tool and I felt some difficult in understanding the metrics and Query Analysis Output like

1) MySQL Throughput
2) MySQL SelectTypes
3) MySQL Command

Also, I need some help in understanding the AvgMYSQL/Queries, AvgMySQL/Select_Scan, 5/95, Min/Max etc.,

Along with the above, when I am monitoring what are the expensive queries under "Queries" tab, I can see different terms like Load, Load%, 95%.

Also, when I execute any query for 1 time on my MYSQL DB server , but percona query monitoring is showing the query execution as 2 ...Can any one explain what is the reason for that.

Last but not least, I can understand the File sort, Full Join, Full Scan under the query plan, but I could not able to understand the pecentage values for each operation (filesort,full join, and full scan) for a particular query.

Can any one please help me out in understanding the above items.



Can't start node2 and node3 mySQL server

Lastest Forum Posts - April 24, 2015 - 3:59am
Hello,

I am trying to set up Percona cluster on CentOS6.5 and i followed the guide at:
http://www.percona.com/doc/percona-x...ots_howto.html

I set up the first node and bootstrapped it. Everything seems correct with that node.
The problem is with second and third node. I just can't start mySQL server.
I get this error when using this command "/etc/init.d/mysql start"

MySQL (Percona XtraDB Cluster) is not running, but lock file (/var/lock/subsys/mysql) exists [FAILED]
Starting MySQL (Percona XtraDB Cluster).The server quit without updating PID file (/usr/local/mysql/var/localhost.localdomain.pid). [FAILED]
MySQL (Percona XtraDB Cluster) server startup failed! [FAILED]

Node 2 my.cnf:

[mysqld] datadir=/var/lib/mysql user=mysql # Path to Galera library wsrep_provider=/usr/lib64/libgalera_smm.so # Cluster connection URL contains IPs of node#1, node#2 and node#3 wsrep_cluster_address=gcomm://192.168.70.123,192.168.70.120,192.168.70.144 # In order for Galera to work correctly binlog format should be ROW binlog_format=ROW # MyISAM storage engine has only experimental support default_storage_engine=InnoDB # This changes how InnoDB autoincrement locks are managed and is a requirement for Galera innodb_autoinc_lock_mode=2 # Node #2 address wsrep_node_address=192.168.70.120 # Cluster name wsrep_cluster_name=my_centos_cluster # SST method wsrep_sst_method=xtrabackup-v2 #Authentication for SST method wsrep_sst_auth="sstuser:s3cret"

Percona Live & OpenStack Live 2015 wrap-up

Latest MySQL Performance Blog posts - April 24, 2015 - 3:00am

Peter Zaitsev kicks off Percona Live 2015

With highlights that included news of Percona’s acquisition of Tokutek, a lively keynote discussion with Apple legend Steve “Woz” Wozniak, scores of technical sessions, tutorials and a festive MySQL community dinner and game night, last week’s Percona Live MySQL Conference and Expo had something for everyone.

More than 1,200 attendees from around the world converged upon Santa Clara, California for the event, which included for the first time a two-day OpenStack Live track alongside a two-day crash course for aspiring MySQL DBAs called “MySQL 101.”

With the Tokutek acquisition, announced last Tuesday by Peter Zaitsev, Percona becomes the first company to offer both MySQL and MongoDB software and solutions. Percona has also taken over development and support for TokuDB® and TokuMX™ as well as the revolutionary Fractal Tree® indexing technology that enables those products to deliver improved performance, reliability and compression for modern Big Data applications. Peter talks in depth about the technologies in last week’s post.

Apple legend Steve Wozniak at Percona Live

Also on Tuesday, “Woz” and Jim Doherty, EVP of Sales & Marketing, talked about a range of issues associated with technology and innovation.

The Apple co-founder and inventor of the Apple I and Apple II computers also shared his thoughts on what influenced him growing up, his approach to problem solving, childhood education, artificial intelligence and more. (You can view the entire 45-minute conversation by clicking on the Woz to the left.)

Tweets of #PerconaLive during the conference hit nearly 2,000 – many with photos that are worth looking at (see all of the tweets here).

The other keynotes included:

Community Appreciation Game Night

In addition to the above keynotes, all of the sessions were recorded and will be available soon for registered attendees who had access to them at the conference. Most of the slides will be available soon to everyone via the Percona Live 2015 site. Just click the session you’re interested in and scroll to the bottom of the page to view the slides.

Congratulations go out to all of the MySQL Community Awards 2015 winners with a special thanks to Shlomi Noach and Jeremy Cole for running the awards program.

Special thanks also goes out to the Percona Live and OpenStack Live 2015 conference committees, which together organized a fantastic week of events. And of course none of the events would have been possible without our generous Percona Live sponsors and OpenStack Live sponsors.

Finally, a round of applause for Percona’s director of conferences, Kortney Runyan, for her monumental efforts organizing the event. Kortney could not have succeeded without the support of our multiple service vendors including Ireland Presentations, Carleson Production Group, Tricord, the Hyatt Santa Clara, and the Santa Clara Convention Center, to name just a few.

Also announced last week was the new venue for Percona Live Europe, which will be held September 21-22 in Amsterdam. Percona Live Amsterdam promises to be bigger and better than ever. The Call for Papers is open for this exciting new venue so be sure to submit your proposals now.

See you in Amsterdam this September! And be sure to save the date for Percona Live 2016 – April 18-21 at the the Hyatt Santa Clara, and the Santa Clara Convention Center.

P.S. For more Percona Live and OpenStack Live 2015 photos…

The post Percona Live & OpenStack Live 2015 wrap-up appeared first on MySQL Performance Blog.

Failed to build page_parser tool

Lastest Forum Posts - April 23, 2015 - 10:32pm
I was following this wiki page

http://www.percona.com/docs/wiki/inn...ding_the_tools

I run the `./configure` command inside the mysql-source directory. After that run `make` in the
root directory of the package but only the constraints_parser is successfully built.

Here is the output of the `make` command

http://pastebin.com/5n8AEcpT

Flow control state initiated by asynchronous traffic

Lastest Forum Posts - April 23, 2015 - 12:38pm
We are trying to get on a 5 node Percona cluster. We are replicating from our current environment which is 2 masters and 2 slaves. Of course we're reading the binary log from one master to a node in XtraDB cluster. We are running only a very light demo instance on the cluster currently. We are finding periods of time where the async replication causes a flow control state in XtraDB Cluster.

My theory is that there is a stored procedure being run that would be one transaction which modifies a large amount of data causing the flow control to back up. However, I'm having trouble proving that. I only know about the event after the event. I am looking for a needle in a hay farm. The stored procedure is my latest guess as to what is going on.

I am looking for advice on how to precisely capture the moment and transactions which are causing the flow control state, and fix that in my application.

I am guessing that any other writes, no matter how quickly they came in from async replication would be absorbed by galera as nothing.

Any advice on how to pinpoint the transaction/transactions causing the Flow Control state would be appreciated. We've seen up to 20 minute halt on the server due to this.

How to Restore MySQL backup to Percona XtraDB Cluster

Lastest Forum Posts - April 23, 2015 - 7:21am
All ,

I configured 3 node Percona XtraDB cluster in Amazon Ec2 , and it got successfully installed and running .

Below are the points which I want to achieve

1. Restore mysql DB backup on Percona XtraDB cluster.
2. Make one of the node as slave of existing master.

If my one of my Percona Xtradb Cluster node is slave of my current master will data get replicated across the cluster.

Plugins not compatabile with cacti 0.8.8c?

Lastest Forum Posts - April 23, 2015 - 3:56am
Hi Guy's.

I'm running cacti 0.8.8c on Centos and tried installing the latest plugins but was met with the following error:

rpm -i percona-cacti-templates-1.1.4-1.noarch.rpm
warning: percona-cacti-templates-1.1.4-1.noarch.rpm: Header V4 DSA/SHA1 Signature, key ID cd2efd2a: NOKEY
error: Failed dependencies:
cacti >= 0.8.6 is needed by percona-cacti-templates-1.1.4-1.noarch

Is there a compatible version around?

Thanks.

Percona XtraDB Cluster HandlerSocket

Lastest Forum Posts - April 22, 2015 - 9:58pm
Hi.

There was need to use HandlerSosket in Percona XtraDB Cluster 5.5. Unfortunately I not found information about plugin support in PXC 5.5. Does Percona XtraDB Cluster 5.5 support HandlerSocket?

Using OR, or IN with NULL

Lastest Forum Posts - April 22, 2015 - 9:35am
Is there any benefit to using one of these over the other?

1) AND (r.resolve_status = 0 OR ISNULL(r.resolve_status))

2) AND r.resolve_status IN(0,NULL)

I ran a query through an online "tuner" and the only recommendation was to use IN instead of OR. I can not find any documentation on this, but then again searching for variations of 'using or or in' may not have been the best approach.

Hello

Lastest Forum Posts - April 22, 2015 - 2:11am
Hello,

I've had a 3-node cluster online for a few days, and I tried to take the second node down to change the tmpdir in my.cnf (disk was getting full). When I start MySQL now, the node will not recieve an SST and fails with some frustrating error messages. /www.e-six-sigma.net

Percona - Metrics and perfs drop after migration.

Lastest Forum Posts - April 22, 2015 - 12:39am
Hi i'm pretty new to MySQL, and recently our company moved from the "regular" version of MySQL (5.1) to Percona.(5.6)

We have this machine for migration :

2 x 2690v3 Intel Processors (24 Cores 48 Threads)
256 GB 2133Mhz ECC memory
2xIntel SSD for System
4xMicron P420m RAID 10 for DATA (Making it 1,3TB EXT4)
10 Gbps Intel Cards (Base-T)
Ubuntu 14.04.02 LTS
5.6.23-72.1-log Percona Server (GPL), Release 72.1, Revision 0503478


We got something like :

Read 4K : 4,9GB/s
Read 16K : 6,6 GB/s

Network Troughput : 9,42Gbps


Sysbench shows something like :

OLTP test statistics: 48 threads
queries performed:
read: 22059002
write: 0
other: 3151286
total: 25210288
transactions: 1575643 (26260.09 per sec.)
deadlocks: 0 (0.00 per sec.)
read/write requests: 22059002 (367641.29 per sec.)
other operations: 3151286 (52520.18 per sec.)

Test execution summary:
total time: 60.0014s
total number of events: 1575643
total time taken by event execution: 2872.7015
per-request statistics:
min: 1.13ms
avg: 1.82ms
max: 18.27ms
approx. 95 percentile: 2.57ms

Threads fairness:
events (avg/stddev): 32825.8958/149.43
execution time (avg/stddev): 59.8479/0.00

I don't know what your metric looks like, but, foor a noob like me, it looks solid.

Well, i guess we have some pretty good hardware down here, but so far, the App Team complains about really poor database performance compared to legacy hardware, which is strange. Old Xeons, 32GB of slower memory, only 2x10K 600Gigs Drives (Hardware raid with BBU and 256MB of cache).

We tuned the server accordingly to the parameters given by percona's tuner.

But it might be related to something else.

In fact i'm beggining to think that there is a link between the change of version has more to do than the server itself.

Any clues ?

Have a nice day.






















Considering Sharding with MySQL? Join my April 22 webinar. Questions welcome!

Latest MySQL Performance Blog posts - April 21, 2015 - 9:08am

MySQL sharding is one of the most used and surely the most abused MySQL scaling technology. My April 2 Dzone article, “To Shard, or Not to Shard,” proved there is indeed quite an interest in this topic.

As such, I’m hosting a live webinar tomorrow (April 22) that shed light on questions about sharding with MySQL. It’s titled: To Shard or Not to Shard That is the Question!

I’ll be answering question such as:

  • Is sharding right for your application or should you use other scaling technologies?
  • If you’re sharding, what things do you need to consider and which questions do you need to have answered?
  • What kind of specific technologies can assist you with sharding?

I hope you can make it for this April 22. Please register now and bring your questions, as sharing them with me and the other attendees is half of the fun of live webinars.

Or if you prefer, share your questions about sharding with MySQL in the comments section below, and I’ll do my best to answer them. I’ll be writing a followup post that will include all questions and my answers soon. A recording of this webinar along with my slides will also be available here afterwards.

The post Considering Sharding with MySQL? Join my April 22 webinar. Questions welcome! appeared first on MySQL Performance Blog.

Unable to install percona tool kit

Lastest Forum Posts - April 21, 2015 - 7:22am
Hi ,

I am trying to install "percona-toolkit-2.2.14-1.noarch.rpm" on the production box running MySQL 5.5.39 on Linux CentOS 6.6.

when i executed rpm -ivh percona-toolkit-2.2.14-1.noarch.rpm, i received the following dependencies but is failing on DBD::MySQL

[root@SVPROD mysql]# rpm -ivh percona-toolkit-2.2.14-1.noarch.rpm
warning: percona-toolkit-2.2.14-1.noarch.rpm: Header V4 DSA/SHA1 Signature, key ID cd2efd2a: NOKEY
error: Failed dependencies:
perl(DBD::mysql) >= 1.0 is needed by percona-toolkit-2.2.14-1.noarch
perl(IO::Socket::SSL) is needed by percona-toolkit-2.2.14-1.noarch
perl(Term::ReadKey) is needed by percona-toolkit-2.2.14-1.noarch
[root@SVPROD mysql]# rpm -ivh perl-TermReadKey-2.30-3.el6.rfx.x86_64.rpm
warning: perl-TermReadKey-2.30-3.el6.rfx.x86_64.rpm: Header V3 DSA/SHA1 Signature, key ID 6b8d79e6: NOKEY
Preparing... ########################################### [100%]
1erl-TermReadKey ########################################### [100%]
[root@SVPROD mysql]# rpm -ivh perl-IO-Socket-SSL-1.44-1.el6.rfx.noarch.rpm
warning: perl-IO-Socket-SSL-1.44-1.el6.rfx.noarch.rpm: Header V3 DSA/SHA1 Signature, key ID 6b8d79e6: NOKEY
error: Failed dependencies:
perl(Net::SSLeay) >= 1.21 is needed by perl-IO-Socket-SSL-1.44-1.el6.rfx.noarch
[root@SVPROD mysql]# rpm -ivh perl-Net-SSLeay-1.36-1.el6.rfx.x86_64.rpm
warning: perl-Net-SSLeay-1.36-1.el6.rfx.x86_64.rpm: Header V3 DSA/SHA1 Signature, key ID 6b8d79e6: NOKEY
Preparing... ########################################### [100%]
1erl-Net-SSLeay ########################################### [100%]
[root@SVPROD mysql]# rpm -ivh perl-IO-Socket-SSL-1.44-1.el6.rfx.noarch.rpm
warning: perl-IO-Socket-SSL-1.44-1.el6.rfx.noarch.rpm: Header V3 DSA/SHA1 Signature, key ID 6b8d79e6: NOKEY
Preparing... ########################################### [100%]
1erl-IO-Socket-SSL ########################################### [100%]
[root@SVPROD mysql]# rpm -ivh perl-DBD-MySQL-4.022-1.el6.rfx.x86_64.rpm
warning: perl-DBD-MySQL-4.022-1.el6.rfx.x86_64.rpm: Header V3 DSA/SHA1 Signature, key ID 6b8d79e6: NOKEY
error: Failed dependencies:
mysql is needed by perl-DBD-MySQL-4.022-1.el6.rfx.x86_64

[root@SVPROD mysql]#

Kindly let me know how to fix this error

Thanks,
Rajesh

Order by using an Inner Join not working in Linux environment of Mysql

Lastest Forum Posts - April 21, 2015 - 4:08am
As i have to do an order by, on a column for a table having millions of records, I found an approcah which can do faster sort in the following way.

It is like doing an Inner Join with a result set which is ordered by the interested order by column, where in such column has to be indexed, so that it will use the created Index. So in this case, the time is not utilized at all for Order by and it is only Join time, so the result was faster.

SELECT distinct pd.message_id, pd.receipt_time_stamp
FROM fm_package_db.dla_package_details pd
INNER JOIN
(SELECT message_id FROM fm_package_db.dla_package_details
where receipt_time_stamp between '2015-03-30 00:00:00' AND '2015-03-30 23:59:59'
ORDER BY receipt_time_stamp desc) as temp ON temp.message_id = pd.message_id
WHERE pd.Site_Code = 'SITE_6' LIMIT 0 , 25

Now the problem is, this approach will do an Order by on any column in both Asc and Desc perfectly in Windows environment of Mysql. But it is always doing an 'asc' sort only in Linux environment of Mysql, but not doing Desc sorting.

Is there any such implementation differences with different Mysql instances in Linux and Windows, for the above query to not to work.

Pls help out.

Percona Server removes its pid and socket

Lastest Forum Posts - April 20, 2015 - 1:02pm
Faced with the fact that Percona Server on Centos 6 when re-start init script removes its pid and starts the second process. Checked at 51 and 55. A similar case is not found.

: [root@localhost ~]# ps auxw | grep mysql root 9826 0.0 0.0 103244 856 pts/1 S+ 15:35 0:00 grep mysql [root@localhost ~]# ls -l /var/lib/mysql/ total 28692 -rw-rw----. 1 mysql mysql 18874368 Apr 20 14:32 ibdata1 -rw-rw----. 1 mysql mysql 5242880 Apr 20 15:15 ib_logfile0 -rw-rw----. 1 mysql mysql 5242880 Apr 20 14:12 ib_logfile1 drwx------. 2 mysql mysql 4096 Apr 20 14:08 mysql drwx------. 2 mysql mysql 4096 Apr 20 14:08 performance_schema -rw-r--r--. 1 mysql mysql 117 Apr 20 14:08 RPM_UPGRADE_HISTORY -rw-r--r--. 1 mysql mysql 117 Apr 20 14:08 RPM_UPGRADE_MARKER-LAST drwx------. 2 mysql mysql 4096 Apr 20 14:08 test [root@localhost ~]# /etc/init.d/mysql start Starting MySQL (Percona Server). SUCCESS! [root@localhost ~]# ls -l /var/lib/mysql/ total 28696 -rw-rw----. 1 mysql mysql 18874368 Apr 20 15:35 ibdata1 -rw-rw----. 1 mysql mysql 5242880 Apr 20 15:35 ib_logfile0 -rw-rw----. 1 mysql mysql 5242880 Apr 20 14:12 ib_logfile1 -rw-rw----. 1 mysql mysql 5 Apr 20 15:35 localhost.localdomain.pid drwx------. 2 mysql mysql 4096 Apr 20 14:08 mysql srwxrwxrwx. 1 mysql mysql 0 Apr 20 15:35 mysql.sock drwx------. 2 mysql mysql 4096 Apr 20 14:08 performance_schema -rw-r--r--. 1 mysql mysql 117 Apr 20 14:08 RPM_UPGRADE_HISTORY -rw-r--r--. 1 mysql mysql 117 Apr 20 14:08 RPM_UPGRADE_MARKER-LAST drwx------. 2 mysql mysql 4096 Apr 20 14:08 test [root@localhost ~]# /etc/init.d/mysql start Starting MySQL (Percona Server) SUCCESS! //When recalling the init-script erased pid and socket [root@localhost ~]# ls -l /var/lib/mysql/ total 28692 -rw-rw----. 1 mysql mysql 18874368 Apr 20 15:35 ibdata1 -rw-rw----. 1 mysql mysql 5242880 Apr 20 15:35 ib_logfile0 -rw-rw----. 1 mysql mysql 5242880 Apr 20 14:12 ib_logfile1 drwx------. 2 mysql mysql 4096 Apr 20 14:08 mysql drwx------. 2 mysql mysql 4096 Apr 20 14:08 performance_schema -rw-r--r--. 1 mysql mysql 117 Apr 20 14:08 RPM_UPGRADE_HISTORY -rw-r--r--. 1 mysql mysql 117 Apr 20 14:08 RPM_UPGRADE_MARKER-LAST drwx------. 2 mysql mysql 4096 Apr 20 14:08 test //two process at one time [root@localhost ~]# ps auxw | grep mysql root 9843 0.0 0.1 106064 1484 pts/1 S 15:35 0:00 /bin/sh /usr/bin/mysqld_safe --datadir=/var/lib/mysql --pid-file=/var/lib/mysql/localhost.localdomain.pid mysql 9932 0.0 4.0 597860 41592 pts/1 Sl 15:35 0:00 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --log-error=/var/log/mysqld.log --pid-file=/var/lib/mysql/localhost.localdomain.pid --socket=/var/lib/mysql/mysql.sock root 9969 0.0 0.1 106064 1484 pts/1 S 15:35 0:00 /bin/sh /usr/bin/mysqld_safe --datadir=/var/lib/mysql --pid-file=/var/lib/mysql/localhost.localdomain.pid mysql 10060 0.1 2.9 389884 30456 pts/1 Sl 15:35 0:00 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --log-error=/var/log/mysqld.log --pid-file=/var/lib/mysql/localhost.localdomain.pid --socket=/var/lib/mysql/mysql.sock root 10074 0.0 0.0 103244 856 pts/1 S+ 15:35 0:00 grep mysql [root@localhost ~]#

Percona SSH based configuratin failing

Lastest Forum Posts - April 20, 2015 - 8:46am


HI

su - www-data -c 'env -i php /usr/share/cacti/site/scripts/ss_get_by_ssh.php --type memory --host 10.78.203.141 --items gu,gv'

gu:-1 gv:-1 (not returing proper values)


i am able to do
root@CACTI:/usr/share/cacti/site/scripts# ssh -i /etc/cacti/id_rsa cacti@10.78.203.141 echo "it works"
it works


i am not sure why i ama not getting the output




















handshake with remote endpoint failed, but endpoint is not part of config (any more)

Lastest Forum Posts - April 20, 2015 - 3:57am
I set up a cluster of 3 database nodes using a percona 5.6 cluster. Everything works, all nodes are replicated. I configured SSL for state transfer. The cluster recently changed its topography, because we had to migrate 2 nodes to new machines. The cluster was completely restarted recently with configuration files that only contain the 3 current cluster nodes node3, node8, nodeA (don't mind the naming). Earlier we also had node1 but this machine left the cluster and does not run any mysql any more.

Now the problem: In the log files of node3 and node8 I find every couple of seconds an error log that looks like this:

: 2015-04-20 11:06:24 22546 [ERROR] WSREP: handshake with remote endpoint ssl://<PUBLIC.node1.IP>:57953 failed: 1: 'End of file.' ( ) where ```<PUBLIC.node1.IP>``` is the address of the old node1, which is by no means any more part of the cluster. I looked through the my.cnf config files of all cluster nodes, but all traces of node1 are gone from it. How does it come the node3 and node8 try to contact the outdated node? Note, that this is after a complete bootstrapping of the cluster starting from nodeA, which does not show the strange error messages in the log.

I found an error description of a very similar error here: https://mariadb.com/kb/en/mariadb/st...-in-error-log/

There it was suggested, that this may be due to a broken network configuration where nodes could only ping from one node to the other, but not the reverse direction. But the given reason/solution does not fit in my case, since all nodes can ping each other fine. Also, it does not explain at all the fact, that my cluster nodes try to contact a node that is not part of the cluster any more.

Here is the relevant part of the congiguration file (from node8)


: ### PERCONA CLUSTER STUFF wsrep_provider=/usr/lib/libgalera_smm.so wsrep_cluster_address=gcomm://<PUBLIC.nodeA.IP>,<PUBLIC.node3.IP>,<PUBLIC.node 8. IP> #wsrep_cluster_address=gcomm:// wsrep_node_address=<PUBLIC.node8.IP> wsrep_slave_threads=8 wsrep_sst_method=xtrabackup-v2 binlog_format=ROW default_storage_engine=InnoDB innodb_autoinc_lock_mode=2 wsrep_cluster_name=betdata_cluster wsrep_provider_options=gcache.size=3G;socket.ssl_cert=/etc/mysql/cert.pem;socket.ssl_key=/etc/mysql/key.pem wsrep_sst_donor=node3,nodeA wsrep_node_name=node8 wsrep_sst_auth=sstuser:blahblubb wsrep_sst_receive_address=<PUBLIC.node8.IP>:14444 query_cache_size=0 query_cache_type=0
Any Ideas?

Note. This is a cross posting from http://dba.stackexchange.com/questio...ndpoint-is-not

MySql Order by on a huge joined datasets is taking too long time.

Lastest Forum Posts - April 17, 2015 - 3:25am
I have to join many tables where in each table has huge volume of data and on such joined huge dataset, i have to apply Order by which is taking a very very longer time

MySql Order by on a huge joined datasets is taking too long time.

Lastest Forum Posts - April 17, 2015 - 3:25am
I have to join many tables where in each table has huge volume of data and on such joined huge dataset, i have to apply Order by which is taking a very very longer time

Pages

Subscribe to Percona aggregator
]]>