Re: mysqlpp::Connection memory leak?

I just noticed that the MySql Client library version that the server reports is 5.1.11 Thanks again, On Mon, Jan 18, 2010 at 9:22 PM, Attila wrote: > Hi Everyone, > > I have an application that uses a custom made DBConnectionPool. > The architecture is basically as follows: &g

mysqlpp::Connection memory leak?

ad is using a connection at any given point) Thanks for your help, -- Attila Software Developer attee...@gmail.com

Re: Need to pivot rows into columns

Hey, Thanks a lot! I didn't see this response until now. I did not try it as I went with the column based solution. However this looks like it will work. I will implement and let you know. Thanks again, On 1/23/09, Peter Brawley wrote: > Attila, > >>I would like to sel

Need to pivot rows into columns

p_count tcp_count 2009-01-21 19:34:00 scenario1 tool1 100 200 300 2009-01-21 19:34:00 scenario1 tool2 400 500 600 The purpose of the query is to display the "latest statistics" for each scenario/toolname group. It is important that the original data comes in rows (statname may not be known ahead of time, so it must be stored as a string in a field value). I am using MySQL and have found some possibilities with SQL Server (Pivot, crosstab, etc) ... but the requirements call for MySQL. Is the above query possible? Thanks a lot! -- Attila Software Developer attee...@gmail.com

SQL Generalization/Specialization question

through the trigger when a sub-type is added/deleted? Better yet: Is there any good way other than the "type" method I described to determine what sub-type the BASE really is? thanks for your help (forgive my pseudo c/sql syntax above) -- Attila Software Developer [EMAIL PROT

Re: free ERD tool for MySql

Denys No I get the same problem and I'm from U.S.! :-( Attila On Wed, 1 Dec 2004, denys wrote: > Date: Wed, 01 Dec 2004 22:02:47 +0100 > From: denys <[EMAIL PROTECTED]> > Reply-To: [EMAIL PROTECTED] > To: [EMAIL PROTECTED] > Subject: Re: free ERD tool for MySql &

free ERD tool for MySql

Does anyone know where I can get the [latest] free version of MySchema? Seems both brandosoftware.com fell off the edge of the world - MySchema along with it. Failing that I'm looking for a free/reasonable ERD tool. Any/all suggestions welcome. Thx Attila -- MySQL General Mailing Lis

mysql c api

hi, i found a strange user comment in the current documentation of c api for mysql_real_connect. http://www.mysql.com/doc/en/mysql_real_query.html "If a result set (MYSQL_RES) is in use, then mysql_free_result(...) must be called before a call to this function will be successful." if this is tru

I can't make user from the MySQL Control center

Hi, I just have installed the MySQL on a Suse linux. I would like to administrate it from Win2k with MySQL Control Center 0.8.9 beta. But I can't make new user in the control center. I think, I have to enable at the linux consol that the root (SQL root) could be administrate the SQL server on my

Missing header file

install kit. Please write me how i can get it. Best regards Attila Miklosi - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this th

debian smp

hi, I have a new dual cpu server with debian 2.2.19 smp kernel and with 1G ram. my question is: need i apply the threads-patch or the fork-patch from mysql manual 2.6.1 before i compile my kernel and the mysql source? (i use max 500 connections). cheers, ati -

mysql round problem

?? cheers, Attila Soki - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsub

innodb producing strange error on a heavy-load system

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 hi, any ideas what could be causing this? this happens when apache has reached its max_client limit. using 3.23.45 011127 18:16:30 InnoDB: Started /home/attila/mysql-max-3.23.45-pc-linux-gnu-i686/bin/mysqld: ready for connecti 011127 18:35:45

innodb: request for change in manual :)))

ard to see which commands they really mean. (Or maybe it's just me, I dunno. :))) When I saw "create" listed there, I didn't read on, to figure out that it was actually part of "create index", and no other create commands do this. Right now I've inserted a coupl

innodb first start

goes wrong. any experiences? :) thanks a lot, Attila ... I'm a great believer in luck and I find the harder I work, the more I have of it. -Thomas Jefferson, third US president, architect and author (1743-1826) - --- P

Re: C API problem, CREATE TABLE SELECT & SELECT

| query_len = sprintf(query, "CREATE TEMPORARY TABLE temp SELECT "); try it out with asprintf(). but you have to define at compile time the following -D_GNU_SOURCE maybe you allocates not enough place for query. asprintf do it for you. char *query; int query_len; query_len=asprintf(&query

Re: replication howto

ed. > It would work. Thanks a lot. I think this will be very useful. (Probably for others, too. :)) Attila ... Actual newspaper headline, 1/17/77: "Cold Wave Linked to Temperatures" - --- Public key: http://c

replication howto

well? Thanks a lot, Attila ... I was court-martialled in my absence, and sentenced to death in my absence, so I said they could shoot me in my absence. -Brendan Francis Behan, playwright (1923-1964) - --- Public key: http://c

Re: Gemini compile error

with myisam table locks now.) I need to modiy a lot of code to use row-level locks. I'll let you know about the result. :) BDB as far as I know does not support row-level locking, it has page-level locks. Attila ... A

Re: How to send multiple SQL statements using C API mysql_query?

that this is the reason for not allowing several statements in the same query. A workaround could be to pass the 20-statement query to a subprocess, which would go through them one by one. If you do this, be very careful with escape strings though! Attila ..

php + innodb deadlocks

and check that variable before commit. This -- other than gives me a bit of work ;) -- will slow down the php script, since there is now a new if statement after every query. Maybe I will end up having better speed with table locks. So I would really like to avoid this, if there's an easier way.

Re: innodb locks

is way, I was just trying to speed it up. If this particular case cannot be solved otherwise, I'm still happy, because I could get rid of 90% of the lock tables. That's still better than nothing. :) Except... see next mail, on a different topic. :) Thanks, Attila

innodb locks

them? I would like to be able to use other rows though from other threads. At this point, it seems to me that I can only do this by locking the entire table. Any suggestions? Thanks, Attila ... Even if you're on

segfault in mysql client

hi, just for information: i know the following line is bugous but, if i execute it in shell then i get a segfault. mysqldump -uCHANGED -pCHANGED --add-drop-table CHANGED Acc9200101Users,Acc9200101BonusCollectors,Acc9200101BonusFlow,Acc9200101Bonu sFlowLogs,Acc9200101CumulativeBonusCollectors,Ac

Re: About huge numbers

| > One more question is how to transfer these values through | > the MySQL C api ? try this site... http://www.mathtools.net/C++/Extra_precision_computation/ ati - Before posting, please check: http://www.mysql.com/manual.

Re: Comparing Dates

| not experienced enough to figure it out. I simply want to grab every entry | in a given table that has been entered within the last three days. select * from yourtable where datefield < date_sub(now(),interval 3 day); see mysql doc: http://www.mysql.com/doc/D/a/Date_and_time_functions.html at

where is my binary log file

hi, i have a lamer question: where is my binary log file? i can't find it. i am sure it exists because grows crazy, when i restore a database from dumpfile. i found nothing about binary log in my.cnf. version: mysql 3.23.32-log install path: /usr/local (default) thanx, ati ---

Re: conversion.........

| he saves it as (.frm,.MYD,.MYI)anybody knows how in windows can i use the | database from my LINUX? simple, see mysql manual: mysqldump in linux shell type: mysqldump -uUSER -pPASSWORD --add-drop-table MYDATABASE > dumpOfMyDatabase.sql copy the file dumpOfMyDatabase.sql to your win computer,

how to get a list of locks

hi, 1. can i get a list of locks created with get_lock()? 2. if i create locks with get_lock() and my program stops with script error before releasing these locks, how can i release these _dead_ locks? (i use persistent mysql connections) thanx, ati

Re: How to do simple stuff

hi | Add a column add an integer column: alter table sometable add somecolumn int; add an varchar column: alter table sometable add somecolumn varchar(255); see: mysql doc 7.8 Alter table syntax | Alter a table to fit a different character lengths |(say...unlimited in a 1 column) simply spec

Re: What does this error mean??!!

hi, try to execute this query too: FLUSH PRIVILEGES; bye, ati - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e

double column type why...

;<<<<<<<<<<< HERE | 898.0 |<<<<<<<<<<<<<<< HERE | 88.0 |<<<<<<<<<<<<<<< HERE | 1.00010 |

unix_timestamp why 0

hi, is this normal? how can i get a timestamp of dates before 1970? thanks. ati mysql> select from_unixtime(-86400); +---+ | from_unixtime(-86400) | +---+ | 1969-12-31 01:00:00 | +---+ 1 row in set (0.00 sec) mysql> select unix_t

recursive query

hi, how can i make recursive querys in mysql? i want to show a tree. my table: tree (id int, parent int, name char(10)); id parent name -- 1 0 joe 2 1 mike 3 1 jim 4 2 george 5 3

Re: recovery help

Steve Ruby wrote: > Elekes Attila wrote: > > > > Hi! > > > > The mysql server (version 3.22.32-4) has hanged up, and the restarting > > causes a part of the > > *.ISM and *.ISD files are gone. Unfortuanetly, I have not got a backup > > from these fi

recovery help

ANY help!!! Attila - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscr