[sql] Record memory usage at various periods after startup.

sql/connection.cc

 // Copyright (c) 2012 The Chromium Authors. All rights reserved.
 // Use of this source code is governed by a BSD-style license that can be
 // found in the LICENSE file.
 
 #include "sql/connection.h"
 
 #include <string.h>
 
+#include "base/bind.h"
 #include "base/files/file_path.h"
 #include "base/files/file_util.h"
 #include "base/lazy_instance.h"
 #include "base/logging.h"
+#include "base/message_loop/message_loop.h"
 #include "base/metrics/histogram.h"
 #include "base/metrics/sparse_histogram.h"
 #include "base/strings/string_split.h"
 #include "base/strings/string_util.h"
 #include "base/strings/stringprintf.h"
 #include "base/strings/utf_string_conversions.h"
 #include "base/synchronization/lock.h"
 #include "sql/statement.h"
 #include "third_party/sqlite/sqlite3.h"
 
@@ skipping 81 matching lines @@
     if (!((attachment_point[i] >= '0' && attachment_point[i] <= '9') ||
           (attachment_point[i] >= 'a' && attachment_point[i] <= 'z') ||
           (attachment_point[i] >= 'A' && attachment_point[i] <= 'Z') ||
           attachment_point[i] == '_')) {
       return false;
     }
   }
   return true;
 }
 
+void RecordSqliteMemory10Min() {
+  const int64 used = sqlite3_memory_used();
+  UMA_HISTOGRAM_COUNTS("Sqlite.MemoryKB.TenMinutes", used / 1024);
+}
+
+void RecordSqliteMemoryHour() {
+  const int64 used = sqlite3_memory_used();
+  UMA_HISTOGRAM_COUNTS("Sqlite.MemoryKB.OneHour", used / 1024);
+}
+
+void RecordSqliteMemoryDay() {
+  const int64 used = sqlite3_memory_used();
+  UMA_HISTOGRAM_COUNTS("Sqlite.MemoryKB.OneDay", used / 1024);
+}
+
 // SQLite automatically calls sqlite3_initialize() lazily, but
 // sqlite3_initialize() uses double-checked locking and thus can have
 // data races.
 //
 // TODO(shess): Another alternative would be to have
 // sqlite3_initialize() called as part of process bring-up.  If this
 // is changed, remove the dynamic_annotations dependency in sql.gyp.
 base::LazyInstance<base::Lock>::Leaky
     g_sqlite_init_lock = LAZY_INSTANCE_INITIALIZER;
 void InitializeSqlite() {
   base::AutoLock lock(g_sqlite_init_lock.Get());
-  sqlite3_initialize();
+  static bool first_call = true;
+  if (first_call) {
+    sqlite3_initialize();
+
+    // Schedule callback to record memory footprint histograms at 10m, 1h, and
+    // 1d.  There may not be a message loop in tests.
+    if (base::MessageLoop::current()) {
+      base::MessageLoop::current()->PostDelayedTask(
+          FROM_HERE, base::Bind(&RecordSqliteMemory10Min),
+          base::TimeDelta::FromMinutes(10));
+      base::MessageLoop::current()->PostDelayedTask(
+          FROM_HERE, base::Bind(&RecordSqliteMemoryHour),
+          base::TimeDelta::FromHours(1));
+      base::MessageLoop::current()->PostDelayedTask(
+          FROM_HERE, base::Bind(&RecordSqliteMemoryDay),
+          base::TimeDelta::FromDays(1));
+    }
+
+    first_call = false;
+  }
 }
 
 // Helper to get the sqlite3_file* associated with the "main" database.
 int GetSqlite3File(sqlite3* db, sqlite3_file** file) {
   *file = NULL;
   int rc = sqlite3_file_control(db, NULL, SQLITE_FCNTL_FILE_POINTER, file);
   if (rc != SQLITE_OK)
     return rc;
 
   // TODO(shess): NULL in file->pMethods has been observed on android_dbg
@@ skipping 1201 matching lines @@
   ignore_result(Execute(kNoWritableSchema));
 
   return ret;
 }
 
 base::TimeTicks TimeSource::Now() {
   return base::TimeTicks::Now();
 }
 
 }  // namespace sql