09-02-2009
I think you will need to indicate which database you are referring to. Solaris ships with SQLite as a standard, so on the assumption that you are referring to SQLite, this is a file based database management system of which you can trivially look up the size.
9 More Discussions You Might Find Interesting
1. UNIX for Advanced & Expert Users
This is the info i have so far. please if you are dead positive can u let me know if i my math/process is correct.
Chunks
address chk/dbs offset size free bpages flags pathname
5003e1f8 1 1 0 250000 177177 PO- /database/link_cw_p01_rootdbs
5003e494 2 ... (5 Replies)
Discussion started by: Optimus_P
5 Replies
2. Solaris
hi ,
we are using Veritas netbackup 5 to backup all databases at our site.
i noticed lately that a specific filesystem on the netbackup servers in running critically out of space , after some investigations i found that there are images that are increasing in size everytime a backup is taken .... (6 Replies)
Discussion started by: ppass
6 Replies
3. UNIX for Dummies Questions & Answers
hello,
i'm trying to figure out the size of a mysql database shelling into my server with putty / command line.
is there / are there any commands that will return the size of a database, in MB?
thanks. (4 Replies)
Discussion started by: sbourgeois
4 Replies
4. HP-UX
Hi all ,
How to know the size of a oracle database running in hp-ux server. (1 Reply)
Discussion started by: megh
1 Replies
5. UNIX for Dummies Questions & Answers
Hi all,
I am looking to find the size of the database by counting all the used pages.
1. I have a file which reads like below
16384 4750850
32768 165
The first column is the pagesize and the second column is the number of pages... (6 Replies)
Discussion started by: family_guy
6 Replies
6. Solaris
Hey all!
I was hoping someone knew anything about this one...
I know with Solaris Volume Manager the default Database Replica size is 8192 blocks (4MB approximately)
Now I know you can increase this amount but is there any point?
The reason I am asking this is that I've setup mirroring on... (2 Replies)
Discussion started by: Keepcase
2 Replies
7. Shell Programming and Scripting
Hello,
I'm not very good at scripting as my job is an DBA for a small firm, but now I'd like to implement a few cron jobs which access and report on the databases on an automatic basis.
This is my SQL TEXT
# -- Total size of Database Size in GB
set echo off feedback off verify off pause... (2 Replies)
Discussion started by: jnrpeardba
2 Replies
8. UNIX for Dummies Questions & Answers
Hello,
I'm not very good at scripting as my job is an DBA for a small firm, but now I'd like to implement a few cron jobs which access and report on the databases on an automatic basis.
This is my SQL TEXT
# -- Total size of Database Size in GB set echo off feedback off verify off... (4 Replies)
Discussion started by: jnrpeardba
4 Replies
9. Shell Programming and Scripting
I have a reseller account with hostgator, which means i have WHM and Cpanel. I have set up a staging environment for one of my wordpress installations (client website), which is essentially sitting at staging.domain.com (live site is at domain.com). The staging website is a complete copy of the... (1 Reply)
Discussion started by: nzrobert
1 Replies
LEARN ABOUT PHP
sqlite_open
SQLITE_OPEN(3) SQLITE_OPEN(3)
sqlite_open - Opens an SQLite database and create the database if it does not exist
SYNOPSIS
resource sqlite_open (string $filename, [int $mode = 0666], [string &$error_message])
DESCRIPTION
Object oriented style (constructor): SQLiteDatabase::__construct (string $filename, [int $mode = 0666], [string &$error_message])
Opens an SQLite database or creates the database if it does not exist.
PARAMETERS
o $filename
- The filename of the SQLite database. If the file does not exist, SQLite will attempt to create it. PHP must have write permis-
sions to the file if data is inserted, the database schema is modified or to create the database if it does not exist.
o $mode
- The mode of the file. Intended to be used to open the database in read-only mode. Presently, this parameter is ignored by the
sqlite library. The default value for mode is the octal value 0666 and this is the recommended value.
o $error_message
- Passed by reference and is set to hold a descriptive error message explaining why the database could not be opened if there was
an error.
RETURN VALUES
Returns a resource (database handle) on success, FALSE on error.
EXAMPLES
Example #1
sqlite_open(3) example
<?php
if ($db = sqlite_open('mysqlitedb', 0666, $sqliteerror)) {
sqlite_query($db, 'CREATE TABLE foo (bar varchar(10))');
sqlite_query($db, "INSERT INTO foo VALUES ('fnord')");
$result = sqlite_query($db, 'select bar from foo');
var_dump(sqlite_fetch_array($result));
} else {
die($sqliteerror);
}
?>
NOTES
Tip
On Unix platforms, SQLite is sensitive to scripts that use the fork() system call. If you do have such a script, it is recommended
that you close the handle prior to forking and then re-open it in the child and/or parent. For more information on this issue, see
The C language interface to the SQLite library in the section entitled Multi-Threading And SQLite.
Tip
It is not recommended to work with SQLite databases mounted on NFS partitions. Since NFS is notoriously bad when it comes to lock-
ing you may find that you cannot even open the database at all, and if it succeeds, the locking behaviour may be undefined.
Note
Starting with SQLite library version 2.8.2, you can specify :memory: as the $filename to create a database that lives only in the
memory of the computer. This is useful mostly for temporary processing, as the in-memory database will be destroyed when the process
ends. It can also be useful when coupled with the ATTACH DATABASE SQL statement to load other databases and move and query data
between them.
Note
SQLite is safe mode and open_basedir aware.
SEE ALSO
sqlite_popen(3), sqlite_close(3), sqlite_factory(3).
PHP Documentation Group SQLITE_OPEN(3)