libzdb-general

libzdb-general@tildeslash.com

152 discussions

mysql executeQuery uses prepared statement
by Julien Coloos 09 Nov '12

09 Nov '12

Hi, It appears libzdb mysql implementation of Connection_executeQuery actually uses a prepared statement to query the database. This may consume a lot more resources than doing a standard query. At least each query generates 3 actions (statement preparation, execution and then closing). On one of our mysql servers handling up to 4K selects per second, the reported number of operations went up to more than 10K, and the CPU usage went from ~2% user and ~1% system to ~6% user and ~12% system. Some older servers did not have enough CPU available to handle the new load. Is there a reason for using a (lone) prepared statement for each query, or could there be a way in future versions of the library to at least allow to do standard queries (mysql_query or mysql_real_query, and mysql_fetch_*) ? Regards

2 2

[Announce] libzdb 2.10.6
by Jan-Henrik Haukeland 30 Oct '12

30 Oct '12

Hi everyone Version 2.10.6 of libzdb is available: Download: http://tildeslash.com/libzdb/dist/libzdb-2.10.6.tar.gz MD5 checksum: 60d27a7c3857a8fd62da7ba89daa5c25 This is mostly a bug fix release which has been tested on the following platforms: * Linux 2.6 (x86 and x64) * Mac OS X Mountain Lion (Darwin 10.8.x x86_64) * Mac OS X Lion (Darwin 10.7.x x86_64) * FreeBSD 6.x, 7.x and 8.x (x86 and x64) * Solaris 10 and Solaris Express (sparc and x86) * OpenBSD 4.x (x86 and x64) Changes in this release: ------------------------ * New: ConnectionPool_start() now throws an SQLException instead of calling ABORT if starting the pool failed. Thanks to Christopher O'Hara for suggestion. * Fixes: MySQL: Using a stored procedure which returned a result set would freeze the connection until it was reaped. Thanks to Jesse White for patch. * Fixes: Ensure that the library can be restarted after it was stopped without leaking resources. Only applicable for MySQL which could leak memory on runtime restart. Thanks to Axel Steiner for initial patch and suggestion. Restartable in this context means that you can call ConnectionPool_start and ConnectionPool_stop repeatedly.

2 1

Firebird Database Support
by Christian Mölders 15 Aug '12

15 Aug '12

Hi @ all! My name is Christian and I want to use dbMail with Firebird Databases. dbMails database connectivity based up on libzdb. However no Firebird-Driver exist, so I have joined this group to support the libzdb-project and develop the driver on my own. C is not my preferred codeing language, comeing from Java, Scala and PHP, therefore I will ask a lot ;-) I only coded the typical C apps with few hundred lines of code while studying. Please let me know, if there are any informations or existing approaches for an implementation of the Firebird Driver. Thanks! -- Christian Moelders Software engineer Im Schacht 1 D-35435 Wettenberg Cell: +49 1578 4492525 Mail: cm(a)christian-moelders.de http://christian-moelders.de - out of date ;-)

1 0

OS X Mountain Lion and libzdb
by Jan-Henrik Haukeland 29 Jul '12

29 Jul '12

Just a quick FYI for those attempting to build libzdb 2.10.5 on OS X (10.8) Mountain Lion. Libzdb failed to build on 10.8 because Apple had removed libfl which was required to build a scanner tool used by libzdb. Thanks to a patch from Johan Bergström, I have uploaded a new version of libzdb 2.10.5 which modify configure to also check for libl which works equally well for libzdb. There are no other changes other than configure.ac so I decided to keep the version number. (Apologies to package purists which may not like this). So if you have updated to Mountain Lion, please download libzdb _again_ from http://tildeslash.com/libzdb/dist/libzdb-2.10.5.tar.gz and it should work again.

1 0

DATE_FORMAT
by Hans Richardo 25 Jul '12

25 Jul '12

Dear all, How to use DATE_FORMAT on query with zdb? I have a query which use DATE_FORMAT( DATE_START, '%d-%m-%Y %k:%i:%s' ) AS DATE_START The return from ResultSet_getStringByName( r, "DATE_START" ) is -1208391138-Success-2012 16:0:(null) The data on table is 2012-04-19 16:04:00 so the result should be 19-04-2012 16:04:00 Please help me, Thanks

2 2

[Announce] libzdb 2.10.5
by Jan-Henrik Haukeland 13 Jul '12

13 Jul '12

Hi everyone Version 2.10.5 of libzdb is available: Download: http://tildeslash.com/libzdb/dist/libzdb-2.10.5.tar.gz MD5 checksum: 275007ec5a6fcc41216de36df4d9e776 This release adds automatically URL unescaping of the following URL components; credentials, path and parameter values. This was added as a result of the discussion today on the mailing list where it became clear that libzdb 2.10.4 and previous versions did not support the '@' char in password as well as certain other chars in parameter values. URL unsafe characters can now be used in the above mentioned components by escaping (encode) them. See for example http://www.december.com/html/spec/esccodes.html for an overview of the most common chars and their escaped versions. For example: A connection URL with the password 'b@r', must URL encode '@' using %40. So the connection URL becomes: mysql://localhost:3306/test?user=foo&password=b%40r or mysql://foo:b%40r@localhost:3306/test

1 0

MySQL Password
by Hans Richardo 13 Jul '12

13 Jul '12

Dear all, Have you tried using @ symbol on your MySQL password? I can't connect to my db cause it use @ in the password The error message on abort handler : Failed to start connection pool -- no password specified in URL How to solve this without change the db password? Thanks

3 2

Lizdb Only Mysql Package
by Hans Richardo 28 Jun '12

28 Jun '12

Hi, First, I have installed libzdb with full package (MySQL, PostgreSQL, SQLite and Oracle) on default Prefix. Then I install again with ./configure --without-postgresql --without-sqlite --without-oci --prefix=/project/libzdb-mysql Cause I only want to use the mysql package only, but after I compile my program and use the library on /project/libzdb-mysql why it still use libclntsh.so.11.1, libsqlite3.so.0, libnnz11.so (the library for oracle and sqllite), how to remove it? Please help me, I have to upload my program on my server without PostgreSQL, SQLite and Oracle package. Thanks

3 6

ResultSet_getStringByName to receive NULL
by Hans Richardo 20 Jun '12

20 Jun '12

Thanks for the Version 2.10.4 of libzdb. Please help me, I want to accomodate ResultSet_getStringByName to a String variable, but it comes error if the value returned is NULL. How can I resolve its? This is the error message : terminate called after throwing an instance of 'std::logic_error' what(): basic_string::_S_construct NULL not valid Thanks, Hans

2 1

[Announce] libzdb 2.10.4
by Jan-Henrik Haukeland 19 Jun '12

19 Jun '12

Hi all Version 2.10.4 of libzdb is available: Download: http://tildeslash.com/libzdb/dist/libzdb-2.10.4.tar.gz MD5 checksum: 71431f36728e73223050c24a3ae3912a Changes in this release: ------------------------ * MySQL: Improved error reporting for select and prepared statements

1 0

← Newer
1
...
5
6
7
8
9
10
11
...
16
Older →

Jump to page:

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

2008

2007

2006

libzdb-general