database/sqlite
1
0
Fork 0
mirror of https://github.com/sqlite/sqlite.git synced 2026-10-26 21:59:27 +03:00
Code Activity
12,900 Commits 1,786 Branches 392 Tags
debug
Commit Graph

12900 Commits

This Branch
This Branch
All Branches
Author SHA1 Message Date
drh
a56b14be71 Try to make pcache1TruncateUnsafe() run faster for the case where iLimit is 
very close to iMaxKey.

FossilOrigin-Name: 9ab53605d562a926c5620cba9dc96a3b812a432f
 2016-08-10 03:35:50 +00:00
drh
d4a85406a1 Remove all timers and other debugging logs except for the one timer on 
pcache1TruncateUnsafe().

FossilOrigin-Name: 5980e625dbb694dc3b0535e71fd986a6d211e245
 2016-08-10 02:54:15 +00:00
drh
d59635c402 Add another timer on pcache1TruncateUnsafe(). 
FossilOrigin-Name: 42ce53f648a506d0a5d9c1231eb28c11b4e6b124
 2016-08-09 11:44:06 +00:00
dan
68759c67cb Add a debug timer to pcache1Truncate(). Change the formatting of some other messages to make them easier to read. 
FossilOrigin-Name: 7d0af4b53c440f4628f0cecdc40459335630fa4e
 2016-08-09 11:23:22 +00:00
drh
c2af03b12f Refocus the timer on the pager_end_transaction() routine. 
FossilOrigin-Name: 9d4eb6e4750939c48aff267000bd69a73e1dc364
 2016-08-09 01:21:16 +00:00
dan
a9da72afcd Add extra logging calls to this branch. 
FossilOrigin-Name: 491f1ef36e60aa65d71444b604064e3505cabd18
 2016-08-04 14:08:06 +00:00
drh
f76e89763a A new version of the slow mutex log that uses gettimeofday() instead of 
trying to access the hardware timer.

FossilOrigin-Name: 92b9fead353d50eb41f5ab7e3a887dd4e5c3aa80
 2016-07-30 03:33:30 +00:00
drh
86815d9aef Turn memory status off by default. 
FossilOrigin-Name: ea3c7162dc79cb85868d2bc86d9938fe7c2ae7ef
 2016-07-29 16:32:34 +00:00
dan
7544587412 Enhance a debugging log message to better identify a mutex. 
FossilOrigin-Name: e60cb6d8852ebf42659c7f2e86a1f6a2492b4664
 2016-07-29 14:31:30 +00:00
drh
64a2a7582e Use __sync_synchronous(), when available, instead of a mutex when a memory 
barrier is needed.

FossilOrigin-Name: 7d4562e9d577e21406e05300b9a1ad56fded2309
 2016-07-29 14:23:23 +00:00
drh
c0b9ad1266 Add calls to sqlite3_log() when sqlite3_mutex_enter() takes more than 
100,000 CPU cycles.

FossilOrigin-Name: 33c7ef7aca69f9b714bc25b2af5ae2a189d3ba78
 2016-07-29 14:10:43 +00:00
dan
5a23b409cb Temporarily add extra sqlite3_log() calls to this version to help with debugging a performance problem. 
FossilOrigin-Name: 613c1ceaf4d552dc29aff090825941eaae6baed1
 2016-07-16 11:47:45 +00:00
drh
0fb1629f11 Experimental patch restore the slight bias in btree-balancing immediately 
after the change to reduces the amount of memcpy() work done by balancing.

FossilOrigin-Name: 46bd9533c0b4656e9fb10eb41c9369ba8a113746
 2016-07-14 20:19:24 +00:00
dan
53838629ce Optimizations aimed at reducing the number of memcpy() operations required by balance_nonroot(). 
FossilOrigin-Name: face33bea1ba3a6d57780655fa827226b4d2baa9
 2014-10-27 14:26:54 +00:00
dan
f77b610e44 Add test file e_wal.test. 
FossilOrigin-Name: fc6920b5483eeeb06a474ff399a21afa51dc4859
 2014-10-27 11:25:28 +00:00
dan
61e94c9deb If a free-slot is found within a page, but using that free-slot would fragment the page further and there are already at least 60 fragmented bytes, degragment the page. This matches the behaviour of the trunk. 
FossilOrigin-Name: 1f80f8c136ac970dcc7fb2337263dc5922e348c3
 2014-10-27 08:02:16 +00:00
dan
c65f84630b Merge trunk with this branch. 
FossilOrigin-Name: a13df3013bbac4a0d4fce5cef1376c857508c1c5
 2014-10-27 07:01:04 +00:00
dan
89ca0b3878 Further modifications to new code to better handle corrupt databases. 
FossilOrigin-Name: 1a8cf0a043347772ac54d150d634c32845beee8b
 2014-10-25 20:36:28 +00:00
drh
d05ab6aacf Increase the resolution of the second parameter to the likelihood() SQL 
function (the probability value) so that it can handle probabilities
as small as 0.00000001.  Formerly, it ran out of precision at 0.001.

FossilOrigin-Name: 0f08924fe0c52a85a103f67bee9809e0f8f884b0
 2014-10-25 13:42:16 +00:00
drh
051575cbf4 Do not use virtual (and hence redundant) WHERE-clause terms to restrict the 
content of a automatic partial index.  Show when an automatic partial index
is used in the EXPLAIN QUERY PLAN output.

FossilOrigin-Name: b9ad601eab1d7298d369267eb697c7fa1bc16985
 2014-10-25 12:28:25 +00:00
dan
31f4e99d44 Ensure that the "Any prior cache entry associated with newKey is guaranteed not to be pinned" guarantee made to xRekey implementations is not violated. 
FossilOrigin-Name: ecc3544e712041736af7c7b4f34864a1f2e30ff7
 2014-10-24 20:57:03 +00:00
drh
059b2d50e1 Enhance the automatic index logic so that it creates a partial index when 
doing so gives the same answer for less work.

FossilOrigin-Name: d95d0313c447f5baeabdb17284d8606331ab7d49
 2014-10-24 19:28:09 +00:00
dan
23eba45d23 Fix some issues in the new code on this branch related to the handling of corrupt databases. 
FossilOrigin-Name: 19736dd9fbbb7e252c4f8715e2277d48ac41f5bc
 2014-10-24 18:43:57 +00:00
dan
e6593d8e8c Fix some minor formatting and code organization issues. 
FossilOrigin-Name: eab8706dc47aa0a44caf73619de858397c3e0b4e
 2014-10-24 16:40:49 +00:00
drh
4dd96a8315 Honor a high likelihood() on range constraints. 
FossilOrigin-Name: 401235edf40fcd665eaf426cf5155ac6855e8537
 2014-10-24 15:26:29 +00:00
drh
9769efcc4c Get the likelihood() functions working on operators like BETWEEN that 
create virtual terms in the WHERE-clause analysis.

FossilOrigin-Name: 03d0498d0f24bec2383d5d79edf25069effecd59
 2014-10-24 14:32:21 +00:00
drh
4f81bbb528 Implement sqlite3_create_collation() by invoking 
sqlite3_create_collation_v2() with a NULL destructor argument.  This saves
a little space.

FossilOrigin-Name: 9762ad0639cca2fc1ef0573113fb613ce9e7e83e
 2014-10-23 01:01:26 +00:00
drh
b7288e28e4 Disable the use of strchrnul() unless specifically enabled by compile-time 
options.

FossilOrigin-Name: e580470db77d6da970c755102790e603fb26b3c6
 2014-10-22 20:07:19 +00:00
drh
d7d7147022 Change the 0x800 bit of SQLITE_TESTCTRL_OPTIMIZATIONS so that it disables 
the loading of STAT3 and STAT4 content, not just the using of that content.
Change the internal name of that bit to SQLITE_Stat34.

FossilOrigin-Name: ca3b00c44ec52d209642a5ba9ef82e085fac39db
 2014-10-22 19:57:16 +00:00
dan
cc8490d2cd Merge latest trunk with this branch. 
FossilOrigin-Name: 854a54c6c21e800b0cd999023014813f7c50b23f
 2014-10-22 18:42:31 +00:00
drh
9f07cf7b2e Take steps to avoid misestimating range query costs based on STAT4 data 
due to the roundoff error of converting from integers to LogEst and back
to integers.

FossilOrigin-Name: 3c933bf95f291f7957580d823dce92c981375a5c
 2014-10-22 15:27:05 +00:00
drh
442c5cd3cf Call fsync() right after ftruncate() when in journal_mode=TRUNCATE and 
when synchronous=FULL in order to ensure that transactions are durable
across a power loss that happens moments after the commit.  Proposed
fix for [https://bugzilla.mozilla.org/show_bug.cgi?id=1072773].

FossilOrigin-Name: 3e922208b68563489c7766abb9afb4885113e7b8
 2014-10-21 21:56:06 +00:00
drh
f7f2e84a9c Further tuning of the cost estimates for skip-scan loops, especially for cases 
when skip-scan loops are in competition with regular loops.

FossilOrigin-Name: a27861c28c4791e51d797aa37e9cca806cb58775
 2014-10-21 18:16:21 +00:00
drh
1b131b7a7a Improvements to the WHERETRACE debugging logic. 
FossilOrigin-Name: ec1e942f08548695ff02645b3f3cd6bb2516bc9a
 2014-10-21 16:01:40 +00:00
drh
c8bbce1e6a If a skip-scan is a proper subset of some other scan, then adjust the 
cost of the skip-scan upward so that it is more costly than the other scan.
Such a cost imbalance can arise under STAT4 because of difficulties in getting
an accurate estimate for skip-scans.

FossilOrigin-Name: f4b22a2620a5dc48949048c2ecbd226755d4b2c3
 2014-10-21 01:05:09 +00:00
drh
40253262e0 Fix a (probably harmless) but in the CSV output mode of the command-line 
shell.

FossilOrigin-Name: 19fe4a0a475bd94f491031aea7a183f7c0515cf3
 2014-10-17 21:35:05 +00:00
drh
81b567a4c7 Version 3.8.7 
FossilOrigin-Name: e4ab094f8afce0817f4074e823fabe59fc29ebb4
version-3.8.7 		2014-10-17 11:24:17 +00:00
mistachkin
7bdc9749d5 Work around MSVC not being able to deduce that a local variable was initialized in a called function. 
FossilOrigin-Name: 06c576c152c4013080c255cbbeb45bf2e298be9f
 2014-10-16 21:39:17 +00:00
mistachkin
92c2e0da8f Changes to work around Win32 and MSVCRT APIs that are not present on Windows CE 200x. 
FossilOrigin-Name: 1418c006e377d7915a50577d4ccb21125b750bae
 2014-10-16 18:34:50 +00:00
dan
facd5fd622 Update the vdbe-compress.tcl script to account for expressions of the form (123>var), where "var" should be replaced with a reference to a union member. 
FossilOrigin-Name: 640345d880c6178f8434e3ce40329b7527588843
 2014-10-16 11:45:14 +00:00
dan
5d510d4c41 Update releasetest.tcl so that x86-64 runs a superset of the x86 tests. 
FossilOrigin-Name: 3c1e70f4d55bc009ed9ed4cf6d756d7061985851
 2014-10-15 15:28:27 +00:00
dan
f41652419e Fix a problem causing lock5.test to fail in mmap-mode. 
FossilOrigin-Name: b3e7b446bdb47cf9d7fe43dc37e3b4f8010ee09e
 2014-10-15 14:45:34 +00:00
drh
92787cf042 Add a four-byte prefix to the BtShared.pTmpSpace buffer to avoid reading 
before the beginning of an allocation.

FossilOrigin-Name: 9386bfca128023583a24303e5f1d832987a49d43
 2014-10-15 11:55:51 +00:00
dan
74439167cb Rearrange an expression in vdbemem.c to avoid a (harmless) reference to a possibly unitialized variable. 
FossilOrigin-Name: 4a7b3fa049a9aa0668e318287edd4a78c0588bf8
 2014-10-15 11:31:35 +00:00
drh
5604cc0d3b Make sure new sqlite3_vtab objects created by the xCreate() virtual table 
method are initialized by the system, in accordance with the documentation.

FossilOrigin-Name: eab82330631187dcc3e5d2dddd23dbda5752904b
 2014-10-14 20:25:43 +00:00
dan
8e9ba0c335 Fix some code duplication issues on this branch. Add minor optimizations to the new code. 
FossilOrigin-Name: 58d7793bd5d608ba9fc3a2cd44b9d9512e0332ba
 2014-10-14 17:27:04 +00:00
drh
8dd8362d64 Optimize a database corruption test inside of the OP_Column opcode. 
FossilOrigin-Name: 005e5b388a8a97bca6d1f0e06c40d68d92aa1212
 2014-10-13 23:39:02 +00:00
drh
facf47a891 Use the padding word in the Mem object as temporary storage for 
serial_type value in OP_Record, and thus avoid a redundant computation of
the serial_type for each column.

FossilOrigin-Name: 4b3b65ee5ea61e9b9671ca027940bf02689cb890
 2014-10-13 20:12:47 +00:00
dan
d0b8f93b5f Merge trunk changes into this branch. 
FossilOrigin-Name: d5b7c5a88dd58de85b3060a1f28b6d96e6e21207
 2014-10-13 18:09:13 +00:00
dan
d7b545bbcb Further work on balance_nonroot(). 
FossilOrigin-Name: 6594f9b420e2fa642737722ff8521f756ecef227
 2014-10-13 18:03:27 +00:00