Re: DWHS inc.

On Tuesday 14 February 2006 18:37, [EMAIL PROTECTED] said something like: > Hello, > > Is there anything we can do to help the MySQL project, we are firm > believers and would like to contribute in some way. > > We have a several 100 mps connections and server space. MySQL already has a Southern C

Re: Client is starting to sue, Help me on this bug http://bugs.mysql.com/bug.php?id=15868

Hi Dan I have an application that doing huge insert over web (HTTP) handled by PHP, when i use MySQL 4. Multiple thread doing insert to table is not really a problem. But NOT in MySQL 5. You may test it self, imagine you have 1000 concurrent HTTP connection that hit your PHP script. Each PHP scri

Re: Client is starting to sue, Help me on this bug http://bugs.mysql.com/bug.php?id=15868

Thanks I have sent you the log .err > Ady, > > I replied to the bug report. > > Best regards, > > Heikki > > Oracle Corp./Innobase Oy > InnoDB - transactions, row level locking, and foreign keys for MySQL > > InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up > MyISAM > tables

Re: Downgrade from MySQL 5 to MySQL 4.1

On Wednesday, 15 February 2006 at 19:38:18 +0700, Ady Wicaksono wrote: > Dear All > > i would like to downgrade from MySQL 5.0.18 to MySQL 4.1.18, I found > MySQL 5.0.18 makes my application unstable... please help me, since > currently all table in row=compact format If you're having this kind of

mysql_ping() leads to Segmentation fault

Hello, I am having issues with the MySQL C API. I have googled, and it seems many other people are having this issue too, but unfortunately I have yet to find a solution. It seems that whenever anything calls mysql_ping(), it causes a Segmentation fault. I am currently using MySQL 4.1.10a.

Re: next, prev, records in MySql. Handler Function

Hi there, What did your MySQL error say? It looks like you didn't open the table. my example, which worked: CREATE TABLE `foo` ( `id` int(11) NOT NULL auto_increment, `bar` char(3) default NULL, PRIMARY KEY (`id`), KEY `idx_bar` (`bar`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 | insert

Re: Client is starting to sue, Help me on this bug http://bugs.mysql.com/bug.php?id=15868

Ady, I replied to the bug report. Best regards, Heikki Oracle Corp./Innobase Oy InnoDB - transactions, row level locking, and foreign keys for MySQL InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up MyISAM tables http://www.innodb.com/order.php - Original Message --

mysql-5.0.18 lex_hash.h zero-length build error on solaris-9

>Description: This is a well-known build problem that has existed at least since mysql-4.1.18, but has never been fixed. On solaris-9, the build terminates with an error containing the tokens "sql_lex.cc error sql_functions undeclared". The underlying cause

Re: Client is starting to sue, Help me on this bug http://bugs.mysql.com/bug.php?id=15868

Ady Wicaksono wrote: Dear Mr. Heikki and Team, Currently we hit by this bug http://bugs.mysql.com/bug.php?id=15868 It got worse on MySQL5 rather than MySQL4, since i failed to downgrade MySQL. Please give me idea to minimize the impact My client is very dissapointed with this issue Thank you

Re: Migration toolkit

YIKES! :) - Thanks Shawn >>> <[EMAIL PROTECTED]> 2/14/06 10:08:14 AM >>> I haven't tried the migration toolkit so I don't know what it can or cannot do. I am assuming that you have hand-transferred a few users from your old system to the new one. What I can suggest is that you generat

Re: MySQL 5.0.x and Delphi

> Hi! No I haven't tested with the v5 driver yet, I suggest you do so and keep us updated. > but I found out that the > problem is when I use date_format function > > If I dont use it the data is returned ok in my app(but with hours, minutes > etc), but if i do a date_format i get "bytes" on e

key words: problem to start the MySql Server

Hello, My name is Laurent (from Belgium) and I got some problems to start the MySql server. 1)I installed the 5.0 version a few days a go. I followed the manual how to install Mysql according to my machine : windows XP (service pack 2).I choosed the standard version and the installation went

RE: MySQL 5.0.x and Delphi

Sorry for dont start my own topic... I apologize Hi! No I haven't tested with the v5 driver yet, but I found out that the problem is when I use date_format function If I dont use it the data is returned ok in my app(but with hours, minutes etc), but if i do a date_format i get "bytes" on each rec

Client is starting to sue, Help me on this bug http://bugs.mysql.com/bug.php?id=15868

Dear Mr. Heikki and Team, Currently we hit by this bug http://bugs.mysql.com/bug.php?id=15868 It got worse on MySQL5 rather than MySQL4, since i failed to downgrade MySQL. Please give me idea to minimize the impact My client is very dissapointed with this issue Thank you very much -- MySQL

Any comment to this article from the LIST?

Dear List, Does anyone can offer any comments on: "Oracle Gives MySQL a Raspberry for Valentine's Day" http://www.eweek.com/article2/0,1895,1926600,00.asp Specifically on referential integrity issues raised in the article. Rega

RE: Problems getting MySqlDump to use sub-queries

Henry, Maybe the shell is doing something funky with the parens? maybe try escaping them with the \ ?? Just a wild guess :) > -Original Message- > From: Henry Dall [mailto:[EMAIL PROTECTED] > Sent: Wednesday, February 15, 2006 12:06 PM > To: mysql@lists.mysql.com > Subject: Problem

Problems getting MySqlDump to use sub-queries

I am having a problem using MySqlDump. Context: I am having to export some "very specific" records from our database We have a table called BIN which has, amongst others, an ID column and an ACCOUNT_ID column. When I use this mysqldump -u root -p --complete-insert "--where=account_id='194

Re: Downgrade from MySQL 5 to MySQL 4.1

Moreover, I found this bug report http://bugs.mysql.com/bug.php?id=15868 I believe my problem posted in this few days is due to the problem like this Bug huge insert/update... and finally MySQL hangand or crash (sometimes i need to kill -9 mysql-max to kill the "hang") Ss this

Downgrade from MySQL 5 to MySQL 4.1

Dear All i would like to downgrade from MySQL 5.0.18 to MySQL 4.1.18, I found MySQL 5.0.18 makes my application unstable... please help me, since currently all table in row=compact format Thank you -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:

Unknown error - processes/queries hangs

Hi. We are seeing problems when trying to upgrade from version 4.0.23 to version 5.0.18 (using standard RPM's) The upgrade includes new hardware and we are exporting our databases with mysqldump and reading them in on the new database server. All seams to be just fine and enabling some traffi

launch store procedures from windows client

Hi, List Please, Someone know wy MyOdbc don't run store procedures from windows client ? I launch it from Asp and Fox 8 and answer with error sintax. The Same store procedure run from Java and on MySql properly. Thanks, Elkin Ortiz Medellin,Colombia - Original Message - From: "ElkinF

Re: MySql InnoDB

Hi! - Original Message - From: <[EMAIL PROTECTED]> Newsgroups: mailing.database.myodbc Sent: Tuesday, February 14, 2006 5:50 PM Subject: MySql InnoDB Hi, I'v installed MySql on my machine and created a new tables. when i open some table to alter it,i see in the COMMENT textbox: Inno

Re: Unable to duplicate a database at home, possible encoding problem

Hi Dave, To try and explain it better: if you used Synaptic, you use what is called a package manager, basically a program that will get everything you need and install it for you. (the .rpm) But in that case as you said you can't use 'configure'. The other option you have is to install from

Re: mysql oddity

You will not have access to the extra functionality in MySQL 5.0 if you are connecting to it via a php4 client API, as the php4 API does not know about the extra functionality in MSQL 5.0. You could try downloading and compiling Apache 2.0.55, or 2.2.0, MySQL standard linux statically linked

MyISAM Key Buffer and Key Writes

Hello List :-):-) I have a question regarding the LRU-mechanism in Key Buffer. Following the documentation I would expect key writes to occur under following conditions: 1. At server shutdown, REPAIR TABLE etc. 2. Whenever a new key is fetched from disk and there is no room left in the buffer.