[firebird-support] Slow Database
Hi, I have a website with PHP and a Firebird database. It looks like the Firebird database becomes very slow and I don't know, how to find where and why. My database is 15GB, the biggest table has about 30 million records. Right now I try to create the statistics, but it takes for ever. At the same time I try to monitor the database with the Sinatica tool. OAT and Next transaction are close, no GC pending. What I see is a lot warnings like invalid char set, but I think, this has nothing to do with performance. I'm also not aware of any statement not using indexes or so. What can I do? How do I find the bottle necks? It must be in Firebird, but I don't know, what I do wrong. cu Christian
Re: [firebird-support] Slow Database
I have a website with PHP and a Firebird database. It looks like the Firebird database becomes very slow and I don't know, how to find where and why. My database is 15GB, the biggest table has about 30 million records. Right now I try to create the statistics, but it takes for ever. At the same time I try to monitor the database with the Sinatica tool. OAT and Next transaction are close, no GC pending. I would run gstat -h anyway. What I see is a lot warnings like invalid char set, but I think, this has nothing to do with performance. I'm also not aware of any statement not using indexes or so. Hmm, pretty dangerous. Although it won't help with what happened in the past, but use the Trace API, if you are using Firebird 2.5, to detect natural scan statements, long execution time etc ... What can I do? How do I find the bottle necks? It must be in Firebird, but I don't know, what I do wrong. 1) gstat -h 2) MON$ tables 3) Firebir 2.5 Trace API -- With regards, Thomas Steinmaurer * Upscene Productions - Database Tools for Developers http://www.upscene.com/ * My Blog http://blog.upscene.com/thomas/index.php * Firebird Foundation Committee Member http://www.firebirdsql.org/en/firebird-foundation/
[firebird-support] Firebird ODBC driver: connection to an embedded server by using security2.fdb
Hello, how can I get Firebird ODBC driver to connect to an embedded server by using the security2.fdb? Is there any reason, why the security2.fdb is being ignored in that case at least by default? That way the ODBC connection can only be created with SYSDBA as user and there is no way to make the connection read only. I mean yes, you can check the checkbox read when creating the connection, but the end user can uncheck it at any time and gat a write access to the DB... For the ODBC connection to a normal server he could do the same of course, but since in that case the connection cen be created with a user, who has read rights only, it doesn't matter if the checkbox gets unchecked. Why can't it work the same with embedded server? That doesn't make sense to me... Can I accomplish it in any way? Kind regards, Patrick
[firebird-support] Re: Firebird ODBC driver: connection to an embedded server by using security2.fdb
Thanks for your reply, creation of a ODBC connection to an embedded server works with SYSDBA only, is that correct? I was not able to create one with another user. If that's not correct: what can be the reason for the problem I have when trying to create a connection with a different user. If that's correct: the only way would be to grant SYSDBA read only rights, correct? Is that possible at all? --- In firebird-support@yahoogroups.com, Thomas Steinmaurer ts@... wrote: how can I get Firebird ODBC driver to connect to an embedded server by using the security2.fdb? Is there any reason, why the security2.fdb is being ignored in that case at least by default? That way the ODBC connection can only be created with SYSDBA as user and there is no way to make the connection read only. I mean yes, you can check the checkbox read when creating the connection, but the end user can uncheck it at any time and gat a write access to the DB... For the ODBC connection to a normal server he could do the same of course, but since in that case the connection cen be created with a user, who has read rights only, it doesn't matter if the checkbox gets unchecked. Why can't it work the same with embedded server? That doesn't make sense to me... Can I accomplish it in any way? Embedded works that way: The provided user/password combination isn't checked against the security database, but SQL privileges are checked for the provided user when it comes to accessing tables, views etc ... -- With regards, Thomas Steinmaurer * Upscene Productions - Database Tools for Developers http://www.upscene.com/ * My Blog http://blog.upscene.com/thomas/index.php * Firebird Foundation Committee Member http://www.firebirdsql.org/en/firebird-foundation/
Re: [firebird-support] Slow Database
Hello, I have a website with PHP and a Firebird database. It looks like the Firebird database becomes very slow and I don't know, how to find where and why. My database is 15GB, the biggest table has about 30 million records. Right now I try to create the statistics, but it takes for ever. At the same time I try to monitor the database with the Sinatica tool. OAT and Next transaction are close, no GC pending. What I see is a lot warnings like invalid char set, but I think, this has nothing to do with performance. I'm also not aware of any statement not using indexes or so. What can I do? How do I find the bottle necks? It must be in Firebird, but I don't know, what I do wrong. You can try our [commercial tool] FBScanner (http://ib-aid.com/products/firebird_interbase/monitoring/FBScanner). Regards, Alexey Kovyazin IBSurgeon (www.ib-aid.com) [Non-text portions of this message have been removed]