11.02.2014 23:11, Thomas Steinmaurer пишет:
> Does this also apply to the output via the Trace API?
AFAIR, no.
Dmitry
On Tue, Feb 11, 2014 at 5:52 AM, Mezei Zoltan wrote:
>
> >
> > 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
deadlocks. A hig
> 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 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)
Cast the result of the extract as a date or timestamp.
On 12/02/2014 6:20 AM, "Mark Rotteveel" 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 date_trunc.
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 ha
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" wrote:
>
>
> > 2.5 should behave pretty well on SMP systems, at least according to the
> > release notes. Windows task manager shows that CP
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, 2014
> 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
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" wrote:
>
>
> > I have a strange slowdown problem wit
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 re
>> 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 - old
> 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 SuperS
EXTRACT()http://www.firebirdsql.org/refdocs/langrefupd25-intfunc-extract.html
On Tuesday, February 11, 2014 4:42 PM, Maximiliano Robaina
wrote:
Hi,
Is there an equivalent function to trunc datetime fields in firebird ?
Something like date_trunc in postgre [1]
--
Maxi
[1]
http://ww
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
11.02.2014 16:49, Juan Pedro Lopez Saez wrote:
>
> 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
> For
<>
No its a bug
http://tracker.firebirdsql.org/browse/CORE-3978
Regards
Paul
Hello,
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
Transa
Hi Paul,
Thanks for the answer.
On Tue, Feb 11, 2014 at 11:05 AM, Paul Beach 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 cannot be sati
2014-02-11 17:54 GMT+09:00 Dmitry Yemanov :
>
>
> 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 wa
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 Firebir
<<- 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,
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 :
>
>
> Hi Zoltan,
>
> this problem is often topi
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 tra
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 con
25 matches
Mail list logo