11.02.2014 03:42, Ian Lawrence Barwick wrote:
Is the integer value of the column rdb$character_set_id from the table
rdb$character_sets constant between Firebird versions?
E.g. will character set UTF8 always be 4 (and was it 4 in pre-2.5
versions)?
Yes, these values remain constant. Purely
Hi Zoltan,
this problem is often topic here.
Solving this problem is a long boring process, where community will try
to explain you basics about transactions and transaction markers
meaning, ask you to send gstat statistics, then explain about record
versioning and garbage and long-running
Hi Alexey,
I've sent a mail directly to You about this particular case asking for
personal assistance.
Any suggestions or hints are welcome if someone else is willing to
participate.
Best Regards
Zsolt
2014-02-11 9:58 GMT+01:00 Alexey Kovyazin a...@ib-aid.com:
Hi Zoltan,
this problem is
- fb_lock_print displays the following about the database:
LOCK_HEADER BLOCK
Version: 145, Active owner: 0, Length: 2097152, Used: 1335440
Flags: 0x0001
Enqs: 9993237, Converts: 93191, Rejects: 1417230, Blocks: 2
Deadlock scans: 0, Deadlocks:
Hi Alexey,
Thanks for the answer. I'll look at our options regarding the professional
services.
Regards,
Zoltan
PS: I am familiar with database concepts like MVCC, transactions, locking
and query execution planning but unfortunately I don't know how to
investigate these mechanisms within
2014-02-11 17:54 GMT+09:00 Dmitry Yemanov dim...@users.sourceforge.net:
11.02.2014 03:42, Ian Lawrence Barwick wrote:
Is the integer value of the column rdb$character_set_id from the table
rdb$character_sets constant between Firebird versions?
E.g. will character set UTF8 always be 4
Hi Paul,
Thanks for the answer.
On Tue, Feb 11, 2014 at 11:05 AM, Paul Beach pabe...@waitrose.com wrote:
- How should the output of fb_lock_print interpreted in this case? Are
these numbers wrong in some sense? Can they be improved by some
parameter tuning?
Rejects = Lock requests that
I found a strange issue when sweep is executed.
I'm using Firebird 2.5.2 Super Server for Linux AMD 64 bits.
I first execute SHOW DATABASE in isql:
PAGE_SIZE 16384
Number of DB pages allocated = 524480
Sweep interval = 2
Forced Writes are OFF
Transaction - oldest = 26483174
Transaction -
Hi,
Is there an equivalent function to trunc datetime fields in firebird ?
Something like date_trunc in postgre [1]
--
Maxi
[1]
http://www.postgresql.org/docs/current/static/functions-datetime.html#FUNCTIONS-DATETIME-TRUNC
EXTRACT()http://www.firebirdsql.org/refdocs/langrefupd25-intfunc-extract.html
On Tuesday, February 11, 2014 4:42 PM, Maximiliano Robaina
maxi_roba...@yahoo.com.ar wrote:
Hi,
Is there an equivalent function to trunc datetime fields in firebird ?
Something like date_trunc in postgre [1]
I have a strange slowdown problem with a Firebird database. During the
daily use of the database the clients experience significant slowdowns
while the system still have lots of resources available. Some
information about the environment:
- 64 bit Firebird 2.5.2 server running in SuperServer
I found a strange issue when sweep is executed.
I'm using Firebird 2.5.2 Super Server for Linux AMD 64 bits.
I first execute SHOW DATABASE in isql:
PAGE_SIZE 16384
Number of DB pages allocated = 524480
Sweep interval = 2
Forced Writes are OFF
Transaction - oldest = 26483174
On 11-2-2014 16:06, Virna Constantin wrote:
EXTRACT()
http://www.firebirdsql.org/refdocs/langrefupd25-intfunc-extract.html
Extract is not the same as PostgreSQL date_trunc. Extract returns the
requested value as an integer, while date_trunc returns a DATE or
TIMESTAMP truncated to the
2.5 should behave pretty well on SMP systems, at least according to the
release notes. Windows task manager shows that CPU load is distributed
among the available cores. Am I missing something here?
On Feb 11, 2014 8:15 PM, Thomas Steinmaurer t...@iblogmanager.com wrote:
I have a strange
2.5 should behave pretty well on SMP systems, at least according to the
release notes. Windows task manager shows that CPU load is distributed
among the available cores. Am I missing something here?
Then you are not using SuperServer, or SuperServer not serving a single
database but several
SELECT CAST(CURRENT_TIMESTAMP as DATE) || ' ' || EXTRACT(HOUR FROM
CURRENT_TIMESTAMP) || ':00:00' as date1
FROM RDB$DATABASE
Best Regard
| ISMAEL |
- Original Message -
From: Mark Rotteveel
To: firebird-support@yahoogroups.com
Sent: Tuesday, February 11,
I have one fbserver.exe. I have multiple databases though, one with high
load, the others with very low load .
On Feb 11, 2014 8:34 PM, Thomas Steinmaurer t...@iblogmanager.com wrote:
2.5 should behave pretty well on SMP systems, at least according to the
release notes. Windows task manager
From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of Mezei Zoltan
Sent: Tuesday, February 11, 2014 3:14 PM
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] Firebird slowdowns while resources are available
I have one fbserver.exe. I
Cast the result of the extract as a date or timestamp.
On 12/02/2014 6:20 AM, Mark Rotteveel m...@lawinegevaar.nl wrote:
On 11-2-2014 16:06, Virna Constantin wrote:
EXTRACT()
http://www.firebirdsql.org/refdocs/langrefupd25-intfunc-extract.html
Extract is not the same as PostgreSQL
On 11-2-2014 21:54, Alan McDonald wrote:
Cast the result of the extract as a date or timestamp.
That doesn't work and that is ok: I'd be surprised when casting the
result (= 20) of EXTRACT(hour from TIMESTAMP '2001-02-16 20:38:40')
would result in 2001-02-16 20:00:00, while the result (= 2001)
I have one fbserver.exe. I have multiple databases though, one with high
load, the others with very low load .
fbserver.exe = SuperServer (SS).
With several databases, the CPU utilization makes sense then, even under
SuperServer. But still, SuperClassic or Classic might even utilize the
CPU
On Tue, Feb 11, 2014 at 5:52 AM, Mezei Zoltan mezei.zol...@gmail.comwrote:
Rejects = Lock requests that cannot be satisfied no big deal
\
Slightly more specifically, (IIRC) they're requests to convert a lock from
read to write without releasing the read lock. That happens to prevent
11.02.2014 23:11, Thomas Steinmaurer пишет:
Does this also apply to the output via the Trace API?
AFAIR, no.
Dmitry
23 matches
Mail list logo