Re: logrotate script doesn't create a new log file

2012-02-23 Thread Honza Horak
On 02/22/2012 07:58 PM, Johan De Meersman wrote: Having this line commented, we have to rely on logrotate.conf to have something similar defined and we see an error when using mysql-rotate Then something else is wrong. Does your MySQL daemon happen to run as a user who can normally not create

Re: Removing Data Duplicacy

2012-02-23 Thread Johan De Meersman
- Original Message - From: Adarsh Sharma adarsh.sha...@orkash.com Thanks Johan, but i mentioned before that adding auto increment column doesn't solve the issue it causes errors in the multi threaded application. If it causes errors, you have other problems than this. Multiple

problem after update with a second node (no cluster problem)

2012-02-23 Thread fatcharly
Hi, I´m running a mySQL-Cluster with drbd/pacemaker/heartbeat on two centOS 5.7. The old version was a mysql-server-5.0.77-4.el5_6.6 the new is mysql-server-5.0.95-1.el5_7.1. I tried to update the system with less downtime, so first update via yum was on the passive node (2 drbd-devices as

USING WHERE; USING TEMPORARY; USING filesort

2012-02-23 Thread Daevid Vincent
Anyone have any thoughts on how I might optimize this query? It takes about 2 seconds. I know that seems quick, but we get nearly 30,000 hits per second and so if we can shave this down, it helps. Also we do use memcache, but even with that, we still see this in the slow-log sometimes. I have