Re: InnoDB CPU Spikes
Rick, all seems to be fine except for my unique users :-(
If I run every 10 mins then I can get away to generate everything except hourly unique users and daily unique users.
Another problem is I have 2 mysql servers (192.168.1.1 and 192.168.1.2) connected via a p2p connection. Now the problem is generating unique users across these two nodes. I am not using clustering or replication here as I need this info only for reports and also there are only 2 nodes so there would be a replication failure if one node goes down.
Another point to note. I need the unique user across nodes only on the daily report.
Subject
Views
Written By
Posted
8195
March 18, 2009 02:43AM
3004
March 18, 2009 03:08AM
2841
March 18, 2009 08:29PM
2792
March 19, 2009 04:48AM
2954
March 19, 2009 10:46AM
2742
March 19, 2009 03:47AM
2864
March 19, 2009 03:55AM
2736
March 19, 2009 04:49AM
2705
March 19, 2009 10:20AM
2387
March 30, 2009 01:25AM
2468
March 30, 2009 07:13PM
2537
March 31, 2009 02:31AM
2766
March 31, 2009 08:12AM
2366
April 01, 2009 03:27AM
2521
April 01, 2009 10:01AM
2570
April 01, 2009 10:22AM
2393
April 01, 2009 03:45AM
2728
April 01, 2009 11:57PM
Re: InnoDB CPU Spikes
2637
April 06, 2009 01:23AM
2595
April 06, 2009 08:01PM
2372
April 07, 2009 12:14AM
2514
April 08, 2009 04:36PM
2503
April 16, 2009 07:02AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.