MySQL Bin Log Position C API

Hello everyone, Is there a way to get the last bin pos of a write using the C API? I'm wanting to use this for MASTER / SLAVE load balancing check. For example: M = Master S = Slave W = Write Q = Query W-M (get write bin pos). Now right after insert go query that rec and try using S

MySQL Thread Memory Usage

Hello all, I am looking for a way to view the max values that have been used by all threads or a signal thread for read_buffer, read_rnd_buffer, sort_buffer, and net_buffer. I want to know these values so that I can turn them appropriately. Regards, --Dave David W. Juntgen Medical

Indiana Time Zone Issues

Hello All, Indiana will move to EDT on April 2nd. I am concerned with MySQL DATETIME stamps that I have stored in my systems and whether or not I need to restart each MySQL daemon to ensure that it reads the correct system time and zone info. Your help is greatly appreciated. Regards,

MySQL 64bit static build?

Hello All! I have noticed that MySQL does not distribute a static linked binary of MySQL x86_64. I ran into the pthread_rwlock_wrlock hang with nptl bug on an earlier install of Fedora Core 2. The MySQL binary version I am using now is mysql-pro-4.0.26-unknown-linux-gnu-x86_64-glibc23.tar.gz

Excluding tables from MySQL bin-log.

Hello, I have a several databases that have one table in them that have thousands of inserts per day. These tables are not mission critical I would like to exclude them from the MySQL bin-logs. As far as I know, MySQL is not capable of excluding tables, just databases. Would this be a valid

To use Quotes or not to, that's the question.

Hi! Could someone please explain to me why the second query below is faster then the first query? The only difference between the two is that ext_doc_id's value is quoted. Index and column information follow and the table being queried contains approximately 3.5 million rows. Thanks!

RE: ERROR 1044 (42000): Access denied for user 'root'

Ed, It sounds like root doesn't have the GRANT permission for the localhost. You can check by querying the User table in mysql. --Dave David W. Juntgen Medical Informatics Engineering Inc. Phone: 260.459.6270 Fax : 260.459.6271 -Original Message- From: Guru Vai Kernel-Hacker!!!

RE: To use Quotes or not to, that's the question.

PROTECTED] Sent: Wednesday, December 15, 2004 11:10 AM To: Dave Juntgen Cc: [EMAIL PROTECTED] Subject: Re: To use Quotes or not to, that's the question. In the last episode (Dec 15), Dave Juntgen said: Could someone please explain to me why the second query below is faster then the first query

InnoDB tablespace Question.

Hello! I have what seems to be a trivial question, but have not been able to find a definite answer and your help would be greatly appreciated. Question: When creating InnoDB table spaces, are there any advantages to using multi table spaces for each table or is it better to create a few

RE: MySQL C API questions

Prepared Statements, only offered in 4.1 API's. http://dev.mysql.com/doc/mysql/en/C_API_Prepared_statements.html David W. Juntgen Medical Informatics Engineering Inc. Phone: 260.459.6270 Fax : 260.459.6271 -Original Message- From: Mads Kristensen [mailto:[EMAIL PROTECTED] Sent:

RE: Error documentation

If you are running Linux, try. ]$ perror errno errno being the number of the error. David W. Juntgen Medical Informatics Engineering Inc. Phone: 260.459.6270 Fax : 260.459.6271 -Original Message- From: Rhino [mailto:[EMAIL PROTECTED] Sent: Monday, December 06, 2004 5:17 PM To:

Limitations on select statements?

Hello everyone, I have a few questions that I hope some of you might be able to answer. Is there a MAX_SIZE on a select statements and when does MySQL lose performance when the statement becomes very large? When using the 'IN' clause, how does MySQL parse the data? Does it do an inline

Order by using alias?

Hello everyone, It seems as though I am unable to perform an order by with a DATETIME field when the column is named as an alias. For example... SELECT DATE_FORMAT(service_date,'%m-%d-%Y') AS 'Serv. Date' FROM documents ORDER by 'Serv. Date' DESC LIMIT 0,10; Can anyone give me an explanation?

HASH tables...

Hello, I would like to ask those of you who have used temporary hash tables in MySQL version 2.23.x if you have encountered any problems, concurs or known issues. I have been testing it myself and everything sees to working just fine. Please list your thoughts and comments on temporary hash

Re: Order by using alias?

PROTECTED] To: "Dave Juntgen" [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Monday, March 19, 2001 1:41 PM Subject: Re: Order by using alias? Periods are not allowed in field names. Dave Juntgen wrote: Hello everyone, It seems as though I am unable to perform an order by with a

Linking problems.

I am unable to link libmysqlclient staticlly. I have tryed everything I could have thought, please look at the linking below, I tried to look for the file my_compress.o and my file system and I was unable to find it. gcc -g -Wall -O6 -static -o webchart.cgi -L../../mieutils/linux/lib