Displaying 20 results from an estimated 10000 matches similar to: "SQLite and ext3 journalling mode"
2009 Jan 30
1
barrier and commit options?
Hello,
On my home server (Debian etch, custom 2.6.28.2 kernel), I am using ext3
for both root and /home filesystems, with barriers enabled to prevent
corruption caused by my PATA disk write cache.
Looking for a better performance, I have also set the commit=nr option
as described in linux-2.6.28.2/Documentation/filesystems/ext3.txt, so
that I now have:
niko at petole:~$ mount -t ext3
2006 Dec 09
2
fsync, ext3, raid (md) 1, write barriers and PATA caching
I have been trying to figure out whether I can enable write caching on my
PATA hard drives (WD3200JB) and have fsync not return until data is
safely on the platters. I am also running software raid.
This is currently on FC5 (though soon to be FC6) with a 2.6.18 kernel.
>From snippets I have found on the net, it looks like write barriers are
pushed down through software raid when using raid 1.
2011 Jun 29
33
Re: Mis-Design of Btrfs?
On 06/27/2011 07:46 AM, NeilBrown wrote:
> On Thu, 23 Jun 2011 12:53:37 +0200 Nico Schottelius
> <nico-lkml-20110623@schottelius.org> wrote:
>
>> Good morning devs,
>>
>> I''m wondering whether the raid- and volume-management-builtin of btrfs is
>> actually a sane idea or not.
>> Currently we do have md/device-mapper support for raid
>>
2007 Mar 21
1
Ext3 behavior on power failure
Hi all,
We are building a new system which is going to use ext3 FS. We would like to know more about the behavior of ext3 in the case of failure. But before I procede, I would like to share more information about our future system.
* Our application always does an fsync on files
* When symbolic links (more specifically fast symlink) are created, the host directory is also fsync'ed.
* Our
2005 Jun 29
3
trouble with active record and sqlite
I am getting an error that I can''t figure out. I have a class called
Test with 3 fields, id, x, and y. When I do Test.new(''x''=>1,
''y''=>2).save, I get an error saying that id (my ''not null primary
key'') can''t be null. But isn''t active record supposed to deal with
setting that for me? Here''s the code
2010 Sep 28
18
[PATCH] Btrfs: add a disk info ioctl to get the disks attached to a filesystem
This was a request from the systemd guys. They need a quick and easy way to get
all devices attached to a Btrfs filesystem in order to check if any of the disks
are SSD for...something, I didn''t ask :). I''ve tested this with the
btrfs-progs patch that accompanies this patch. Thanks,
Signed-off-by: Josef Bacik <josef@redhat.com>
---
fs/btrfs/ioctl.c | 64
2014 Jan 18
3
File System corruption tool
Hi -
I'm searching for file system corruption tool, say it inject disk-errors
like
multiply owned blocks etc. Later an integrity scan process (like e2fsck)
will
verify on-disk layout and fix these errors.
I'd like to read/understand such tools before writing one for an proprietary
on-disk file system.
Do we have such tools for ext{2,3,4}fs ? Thanks for any help or pointers!
--
----
2008 Sep 16
2
When is a block free?
Where in the ext2/3 code does it know that a block on the disk is now free
to reuse?
Thanks,
Chris
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://listman.redhat.com/archives/ext3-users/attachments/20080916/7b737a93/attachment.htm>
2017 Oct 11
1
gluster volume + lvm : recommendation or neccessity ?
After some extra reading about LVM snapshots & Gluster, I think I can
conclude it may be a bad idea to use it on big storage bricks.
I understood that the LVM maximum metadata, used to store the snapshots
data, is about 16GB.
So if I have a brick with a volume arount 10TB (for example), daily
snapshots, files changing ~100GB : the LVM snapshot is useless.
LVM's snapshots doesn't
2017 Oct 11
0
gluster volume + lvm : recommendation or neccessity ?
On 10/11/2017 09:50 AM, ML wrote:
> Hi everyone,
>
> I've read on the gluster & redhat documentation, that it seems recommended to
> use XFS over LVM before creating & using gluster volumes.
>
> Sources :
> https://access.redhat.com/documentation/en-US/Red_Hat_Storage/3/html/Administration_Guide/Formatting_and_Mounting_Bricks.html
>
>
2005 Dec 22
13
in-memory SQLite for testing
I am following the rails book, and arrived to the section about
testing. The test database is configured as:
test:
adapter: sqlite3
database: ":memory:"
and I get this error with the simple product test:
% ruby test/unit/product_test.rb
Loaded suite test/unit/product_test
Started
E/usr/local/lib/ruby/gems/1.8/gems/sqlite3-ruby-1.1.0/lib/sqlite3/
errors.rb:94:in
2008 Mar 16
2
Filesystem fragmentation and scatter-gather DMA
When designing a filesystem, is fragmentation really an issue if
access to the disk can be done using scatter-gather DMA techics ?
2009 Oct 01
3
sqlite limit
Hi All,
I am working on a POC that I''d like to show a group of 10 to 15 folks.
I was wondering if sqlite would do for db with about 20 people hitting
on the application. Does sqlite locking the entire db while writing
manifest itself in such scenario?
Regards,
Kashyap
2006 Oct 10
1
Python/sqlite date time problems.
Bear with me, this is CentOS related. :)
I have a python CGI that's behaving weirldy on Whitebox systems
that've been switched over to CentOS 4 (ages ago, no other problems to
speak of aside from this one).
I've broken the problem down to a minimal test case...
1. Create a small database
# sqlite3 /tmp/testcase.db 'CREATE TABLE testtable ( date date primary
key unique, name
2014 Jan 18
0
Re: File System corruption tool
We have a script that adds corruption to ext2/3/4 filesystems and runs
e2fsck on it. It definitely could be improved, but it still catches some
occasional errors:
http://git.whamcloud.com/?p=tools/e2fsprogs.git;a=commit;h=aee44c669bebe29bfdb8a1c86da443234f8bc257
It tries to format the filesystem with different features and options, then
adds corruption from both random data and copying parts of
2005 Apr 15
1
How can I change SQLite cache size for R session?
How can I change SQLite cache size for R session?
SQLite cache size can be set by a pragma, for the
duration of the session - or by default.
.pragma cache_size
.pragma default_cache_size
my questions are about RSQLite, version 0.4, running
on Windows:
- what is the cache size set to when SQLite is
invoked from R?
- if the page_size is set to 4096 what will be the
cache size in bytes
2006 Feb 28
7
windows sqlite client?
Hi all,
Does anyone know a good windows client for sqlite 3? typical use is create
and modify tables and export creation queries.
Thanks,
Nicolas
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://wrath.rubyonrails.org/pipermail/rails/attachments/20060228/363834cf/attachment.html
2005 May 08
3
sqlite, views, incorrect data types?
This has been driving me crazy for a few days now. I am using sqlite3
however I have also found this to be the case with 2.8.15:
I have data types text or integer on every column of every table in
the database. Now i know sqlite doesnt care much about data types,
but I believe rails does (correct me if im wrong). On pages that
query a table, everything is perfect.
BUT when I use a view
2020 Aug 26
2
[supermin PATCH] rpm: check for SQLite-based RPM DB
Fedora 33 switched the DB of RPM to SQLite, so no more Packages/Name/etc
files. Because any missing file exception is ignored when checking for
--if-newer, the lack of the Package files was not properly noticed, so
the appliance was always considered out out date.
Check for the SQLite-based DB first, falling back to the old format.
Signed-off-by: Pino Toscano <ptoscano@redhat.com>
---
2009 Apr 03
10
btrfs for enterprise raid arrays
Dear all,
While going through the archived mailing list and crawling along the wiki I didn''t find any clues if there would be any optimizations in Btrfs to make efficient use of functions and features that today exist on enterprise class storage arrays.
One exception to that was the ssd option which I think can make a improvement on read and write IO''s however when attached to