mysql_server_init(), C API, And Dying Processes

What happens if I use the C API of MySQL and the process dies (maybe a pointer error or something)? a)Will the connection be killed automatically? b)What about "LOCK TABLES" and similar statements that were issued ... will the locks clear automatically? Thanks.

Re: InnoDB does not preserve AUTO_INCREMENT -- WTF!?

Daevid, That page looks a little misleading. First, it says it's stored in main memory, not on disk. Then it says that on server-startup, it finds the largest value in the table, and initialized it to that. So it is disk-based on startup, and then resides in memory thereafter. This doesn't

Compiled C-language CGI-BINs with MySQL

Has anyone ever written C-language CGI-BIN programs (to be executed from Apache) and which use the C-language interface of MySQL? Does it work OK? Thanks.

Re: InnoDB does not preserve AUTO_INCREMENT -- WTF!?

I came up with a work around when we encountered this. I don't remember exactly (and I don't have access to that code anymore), but I think we manually put a piece of code in our SQL setup scripts, before any of our insert statements. This 'mysql command' would set the next available ID to wh

Re: Using MySQL to log and report transactions

In the last episode (Nov 10), James Tu said: > I'm going use MySQL to log transactions so that I can report on them > later. > Ex: > > CREATE TABLE statistics ( >id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT > , user_id BIGINT UNSIGNED > , entity_id INT UNSIGNED > , transacti

MAX() and GROUP BY question

Hello everybody Can you explain me please how to get the entire row where ID is maximum per given status_id Mysql 4.0.xx for example: id status_idnamedate 6 3 name0 date0 5 1 name1 date1 7 4 name3 date3 10 3 name2

InnoDB does not preserve AUTO_INCREMENT -- WTF!?

http://dev.mysql.com/doc/refman/5.0/en/innodb-auto-increment-column.html We have recently switched several database tables from MYISM to INNODB, only to find out this colossal design flaw in InnoDB tables. We ship out mySQL on our appliances in enterprise level scenarios. We often like to start t

Re: www.innodb.com

I just checked it again and its working. Francesco Riosa wrote: > Heikki Tuuri ha scritto: >> Bill, >> >> we are moving the DNS of innodb.com from Capnova to Oracle Corp. >> >> I can now view http://www.innodb.com through my ISP, Elisa. Does >> anyone still have problems accessing http://www.inno

Re: www.innodb.com

My guess is that its intentional. Oracle is who they are and MySQL is eating their lunch. I look for them to kill the product to try to drive MySQL out of business or make life difficult for them; hence the reason they're working on a new storage engine of their own. They tried to buy MySQL, bu

Using MySQL to log and report transactions

Hi: I'm going use MySQL to log transactions so that I can report on them later. Ex: CREATE TABLE statistics ( id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT , user_id BIGINT UNSIGNED , entity_id INT UNSIGNED , transaction_type INTEGER(2) UNSIGNED , datetime_logged DATET

Pulling Percentages From Query

Dear All, I'm trying to pull percentages from a query and really don't understand how to initiate this. Here is the low down: I have a list of venues with the number of acts who performed catoragized by genre. For example: venue_id: 23 blues: 117 rock: 34 world_music:57 ( and so on, there a

Re: replacing mysql 4 with versiono 5

Afan, the password hashing is different, starting with 4.1. Also the JOINs were changed / made to comply with standard in 5.0. http://dev.mysql.com/doc/refman/4.1/en/password-hashing.html and http://dev.mysql.com/doc/refman/5.0/en/join.html Dan On 11/10/06, [EMAIL PROTECTED] <[EMAIL PROTECTED

Re: MySQL on a ram disk?

Pretty much the only way you're going to find out is by giving it a shot. :) I imagine it shouldn't take too much time to setup. Server and query tuning is what will take most time, but I suspect it will be worth it in the end. Once you have your setup, it'd be worth explaining your data and how y

RE: MySQL Licensing

Hello, I would recommend posting your question in the Licensing Fourm: http://forums.mysql.com/list.php?4 Also, please refer to our FAQ: http://www.mysql.com/company/legal/licensing/ Thanks, Jimmy Guerrero Sr Product Manager MySQL, Inc > -Original Message- > From: I have a question [m

MySQL Licensing

It is my understanding that MySQL provides two kind of licensing (a) GPL license for free download (b) OEM - commercial license for fee. Question is- Can OEM develop software using MySQL, create database desiged for MySQL. However, during distribution cirmvent commercial license by telling custom

Views accessed as table in MS Access

Hello, I am using MySQL 5.0.17 and MyODBC 3.51.12 with MS Access 2003/Xp with Jet 4.0. Currently it is not giving the normal problem of Access while inserting new records (#deleted), but when a View created in database is linked with MS Access it is not giviing correct results. e.g. There are two

replacing mysql 4 with versiono 5

hi, we are in the process of moving from our old hosting company to new one. and I was thinking that it's the best time to move from mysql 4 to version 5. currently, we use php 4.3.4 / mysql 4.0.18 / apache 2.0 where I can expect problems because of difference in versions? all queries I use are re

Re: www.innodb.com

--On Friday, November 10, 2006 08:46:50 AM -0500 Curtis Maurand <[EMAIL PROTECTED]> wrote: http://www.oracle.com/innodb/index.html Please quit telling us that Oracle purchased Innodb. That is ancient news. The innodb.com web site had innodb content on it in the past, Heikki signature m

RE: ORDER BY RAND() gives me duplicate rows sometimes

The SELECT that Daevid originally tried is straight out of the documentation, which says that ORDER BY RAND() LIMIT x is a good way to get a random sample of your data. The documentation also says you can't use a RAND() column in an ORDER BY clause because the ORDER BY would evaluate the column mu

Re: Foreign Key MATCH constraint

Alle 14:04, giovedì 9 novembre 2006, Heikki Tuuri ha scritto: > Giorgio, > > InnoDB only implements MATCH SIMPLE. MySQL/InnoDB ignores the MATCH > clause that you specify in the foreign key constraint definition. Thanks a lot :-) Giorgio -- MySQL General Mailing List For list archives: http://

Re: How to determine index size ?

According to Chapter 6 of the MySQL Reference Manual, ISBN 0-596-00265-3, Page 453 Year values 00-69 are the years 2000-2069 Year values 70-99 are the years 1970-1999 A date value would have to be based on the size of a UNIX date long integer, the number of seconds since 12:00AM, January 1, 1970

Re: www.innodb.com

http://www.oracle.com/innodb/index.html Riemer Palstra wrote: > On Thu, Nov 09, 2006 at 09:26:52AM -0800, Bill MacAllister wrote: >> What happened to the Innodb web pages? What comes up for be is a >> search page with a bunch of related links on it. I wanted to pull >> down a copy of ibbackup d

Re: " Copy to tmp table " optimize

Try orgainzing the date and time indexes as follows: alter table logs_2006_11 drop index date; alter table logs_2006_11 drop index time; alter table logs_2006_11 add index date_time (date,time); You at least want a index range scan across dates in log_2006_11 When you use a LEFT JOIN you must wa

RE: www.innodb.com

Depending on when Heikki and the InnoDB team moved the DNS records, it could take between 24 and 48 hours to propogate throughout the entire internet. I also see the cyber-squatter page, but I am sure that this will resolve itself shortly. J.R. ---

Re: www.innodb.com

Heikki Tuuri ha scritto: > Bill, > > we are moving the DNS of innodb.com from Capnova to Oracle Corp. > > I can now view http://www.innodb.com through my ISP, Elisa. Does > anyone still have problems accessing http://www.innodb.com? > > If you cannot see some web page, you can resort to Google's ca

RE: www.innodb.com

I'm seeing:   innodb.comHere are some related websites for: innodb.com Sponsored Links MySQL database designData

Re: www.innodb.com

Bill, we are moving the DNS of innodb.com from Capnova to Oracle Corp. I can now view http://www.innodb.com through my ISP, Elisa. Does anyone still have problems accessing http://www.innodb.com? If you cannot see some web page, you can resort to Google's cache to view it. I hope that we wil

Re: SELECT shows DOUBLE numbers incorrectly.

В сообщении от 10 ноября 2006 13:44 Олег Петрачёв написал(a): > I am using mysql 4.1.21 under FreeBSD rel 6.1-p10 > Ver 14.7 Distrib 4.1.21, for portbld-freebsd6.1 (i386) using 5.0 > I noticed Mysql sometimes shows data from columns with DOUBLE type > incorrectly, cutting away the last (ri

SELECT shows DOUBLE numbers incorrectly.

Good day everyone. I am using mysql 4.1.21 under FreeBSD rel 6.1-p10 Ver 14.7 Distrib 4.1.21, for portbld-freebsd6.1 (i386) using 5.0 I noticed Mysql sometimes shows data from columns with DOUBLE type incorrectly, cutting away the last (right) symbol. For example, I am creating a table:

RE: MySQL Front

Cf. http://www.phpcenter.de/phorum/read.php?f=1&i=50453&t=50453 + http://www.heidisql.com/. cheers, Thomas t.j. loeffler eth zurich institute of geology CAB E 10.4, universitaetsstrasse 6 8092 zurich, switzerland www.erdw.ethz.ch

Re: ORDER BY RAND() gives me duplicate rows sometimes

Add DISTINCT(primary_key) in your query? Regards Willy -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]