Only statement triggered by cron jobs are create or replace view
statements, which run select statements. We should not have any alter
statements running.
On May 8, 4:51 pm, Tony Tseng <t...@google.com> wrote:
> Hi Jacob,
> Looks like you have an alter table in progress. Is that triggered by the
> cron job? In any case, I'd suggest not to do any alter table statements
> when your instance has traffic.
>
>
>
>
>
>
>
> On Tue, May 8, 2012 at 3:37 PM, Jacob Padgett <ja...@fdgweb.com> wrote:
> > Cannot access it via command line, either...no method seems to be working.
>
> > The longer queries are performed by python scripts running as cron jobs on
> > appengine. I'd hardly think a simple count statement counts as a long
> > query, and in any case we get the same results there as well.
>
> > On Tuesday, May 8, 2012 3:23:35 PM UTC-7, rcleveng wrote:
>
> >> Try using the command line tool vs. the web tool. The web tool isn't
> >> designed for long queries.
>
> >>https://developers.google.com/**cloud-sql/docs/commandline<https://developers.google.com/cloud-sql/docs/commandline>
>
> >> Rob
>
> >> On Tue, May 8, 2012 at 3:17 PM, Jacob Padgett <ja...@fdgweb.com> wrote:
>
> >>> Instance name is iabalpadtest:iabreportsection. Screenshot
> >>> attached...it's been down for about a half hour.
>
> >>> In addition to the periodic complete outages, we've been having sporadic
> >>> issues with this particular instance. Restarts have not helped. Various
> >>> queries on one db in the instance in particular either periodically fail,
> >>> experience unusual timeouts, or come back with inconsistent results. We've
> >>> ported the data out, get expected results on the data itself when loaded in
> >>> a different database.
>
> >>> Attempts to build 1:1 views off of a table with approximately 800,000
> >>> rows only return 8,000 rows. Additionally, the following queries give
> >>> drastically different results:
> >>> (unique_id is the primary key)
> >>> SELECT COUNT(`unique_id`) FROM `instance` returns expected number of
> >>> rows, approx. 800,000
> >>> select count(distinct unique_id) from instance returns only approx
> >>> 8,000...or around 1% of the total. Manual verification of the data via dump
> >>> and restore to a local instance of my_sql confirms there are no duplicate
> >>> primary keys.
>
> >>> We really need help with first, getting the instance running, and
> >>> secondly, understanding into why our queries are not working....
No comments:
Post a Comment