Re: Out of memory, but plenty of swap space left

John, are you running on a 32-bit computer? Then, normally, the process size is limited to 2 GB. Best regards, Heikki Tuuri Innobase Oy Foreign keys, transactions, and row level locking for MySQL InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up MyISAM tables http://www.innodb

word count

Is there a simple wat to get a word count out of a field in mysql, or to at least split on " " and tell me how many items in that array. -- - Scott HanedaTel: 415.898.2602

User connection history?

Hi, Is there a way to determine when was the last time a MySQL user attempted to connect to the MySQL Database? -- Thanks & Regards, Dilshad Ali -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

How to assign a variable without returning results

I have a batch of SQL code, where I need to calculate an aggregate in a SELECT and then use that value in a second SELECT. I am using MySql 4.0 so unfortunately I cannot use a subquery (which is how I'd like to do this :-)). So I run the first SELECT and assign the aggregate to a variable somet

RE: UDF request?

I think you'll find you can do what you want with a cross join. A cross join will join every row from the first table with every row from the second table. It will not randomly do this, so you'd have to be creative in "randomly" selecting rows in the WHERE clause. Here's how you could do this w

RE: UDF request?

I think you'll find you can do what you want with a cross join. A cross join will join every row from the first table with every row from the second table. It will not randomly do this, so you'd have to be creative in "randomly" selecting rows in the WHERE clause. Here's how you could do this w

MySQL Users Conference in 10 Days now!

Hi! As you may know, MySQL is holding it's third annual User's Conference on April 18-21 in Santa Clara, California. This is a annual event that I (and the other cofounder Monty) love to participate in. It nice to see so many people in one place exited about MySQL! It's a unique opportunity to m

Re: set type and normalize

As mentioned in the manual you specified, there are limits to how many items you can have in a set, among other issues. My biggest issue against using sets is that you need alter the table structure whenever you want to change the set. Usually I would want the user to be able to add, modify or

set type and normalize

Hi MySQL people. I'm trying to understand the pros and cons of the "set" column type. Here is an excerpt from the article: http://dev.mysql.com/tech-resources/articles/mysql-set-datatype.html Why You Shouldn't Use SET "Third, using a set means your data is not normalized. In our above

Re: Need help in Stored procedures and functions

Dinesh, Right, sorry for being dense, the C API doesn't yet have a published func for calling sprocs. You could put results in a temp table and query that table after your sproc returns. Or you might be able to rely on a stored procedure trick: even if the sproc issues one or more SELECT ... IN

RE: Need help in Stored procedures and functions

Shawn, Thank you for your reply. It looks like this is the only option. But i was trying to avoid the creation of temp table and parsing of data at the application layer since it can potentially slow down the overall performance. Dinesh From: [EMAIL PROTECT

RE: Need help in Stored procedures and functions

"Anchan, Dinesh" <[EMAIL PROTECTED]> wrote on 04/07/2005 03:44:07 PM: > Peter, > > Thank you for your reply. > > Actually that request was accidentally sent to mysql@lists.mysql.com > instead of [EMAIL PROTECTED] > > MySQL support also suggested the same thing. Problem is, values in the > O

RE: Need help in Stored procedures and functions

Peter, Thank you for your reply. Actually that request was accidentally sent to mysql@lists.mysql.com instead of [EMAIL PROTECTED] MySQL support also suggested the same thing. Problem is, values in the OUT variable can be retrieved only from a future SQL query. But we are trying to call

RE: mysql table structures

Is there one that will include column comments? I think they were introduced in version 4.1. -Original Message- From: Berman, Mikhail [mailto:[EMAIL PROTECTED] Sent: Thursday, April 07, 2005 10:50 AM To: mysql@lists.mysql.com Subject: RE: mysql table structures A couple of apps: EMS My

Re: stored procedure error is misleading

On Apr 7, 2005, at 2:37 PM, James Black wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 I am using mysql 5.0.3, running under Solaris 8, and I believe the error I am getting is not possible, but I don't know what I did wrong. I do: call assignItem('user', 1999, 97);// I get: ERROR 1172 (4200

Re: Cannot execute query - Can't find file: (error: 9)

It seems the "bad file number" error was caused by MySQL trying to have more than 128 files open at one time. This was "fixed" by changing MySQL startup, but the "fix" would not have been needed if MySQL were to close open files are some period of "no activity to a table" - does MySQL ever clo

re: stored procedure error is misleading

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 I am using mysql 5.0.3, running under Solaris 8, and I believe the error I am getting is not possible, but I don't know what I did wrong. I do: call assignItem('user', 1999, 97);// I get: ERROR 1172 (42000): Result consisted of more than one row But

Re: recovery of a very large table?

Not a bad suggestion... but when I try it, I get the following output: Checking MyISAM file: theTable Data records: 22906970 Deleted blocks: 0 myisamchk: warning: Table is marked as crashed and last repair failed - check file-size myisamchk: error: Size of indexfile is: 2049552384Sh

Re: Call to undefined function: mysql_connect()

Hello. You should enable MySQL support in php. For rpm-based distros you can install something like php-mysql-.rpm. "sudheshna aaa" <[EMAIL PROTECTED]> wrote: > Team, > > I am trying to make apache-php and mysql work on Linux Redhat. > I have the following versions installed th

Re: Can't create a new thread (errno 11). If you are not out of available memory, you can consult the manual for a possible OS-dependent bug'

Hello. If you are able to use a DBUG package on a production server - do it. You may limit debugging to the list of named functions with 'f' flag. See: http://dev.mysql.com/doc/mysql/en/the-dbug-package.html Send an output of 'SHOW VARIABLES', 'SHOW STATUS', ulimits for mysql user.

Re: Measuring query progress

Hello. If you're using an InnoDB tables you could monitor the progress with SHOW INNODB STATUS using the number of proceeded rows. See: http://dev.mysql.com/doc/mysql/en/innodb-monitor.html Mike Muratet <[EMAIL PROTECTED]> wrote: > Greetings > > I have a query that has been ru

RE: mysql table structures

A couple of apps: EMS MySQL Manager - http://sqlmanager.net/products/mysql/manager/ SQLyog - http://www.webyog.com/index.php Mikhail -Original Message- From: Mayuran Yogarajah [mailto:[EMAIL PROTECTED] Sent: Thursday, April 07, 2005 1:28 PM To: mysql@lists.mysql.com Subject: mysql tab

mysql table structures

I am looking for an application that can connect to a mysql db or use an sql file and create html documents describing tables in a database and their column types, foreign keys, primary keys etc... Does anyone know of such an app ? thanks -- MySQL General Mailing List For list archives: http://list

Re: Warnings level

Hi ! Thanks, for your answer. Indeed, I didn't think about the verbose option. I tried it and used "tee" to log data. Well so far I haven't got anymore Warnings (strange though...) :-) On Apr 5, 2005 9:50 PM, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > > > Mister Jack <[EMAIL PROTECTED]> w

RE: Query question

Whew, thanks Jon =) -Original Message- SELECT product_lines.* FROM product_lines LEFT JOIN manufacturer_product_line_index ON manufacturer_product_line_index.product_line_id = product_lines.id WHERE product_lines.id IS NULL -- MySQL General Mailing List For list archives: http://list

Re: Query question

"Ed Lazor" <[EMAIL PROTECTED]> wrote on 04/07/2005 12:39:01 PM: > Three tables like this: > > -- > product_lines > -- > id > title > > -- > manufacturer > -- > id > title > > -- > manufacturer_product_line_index > -- > id >

Re: 4.1.11 and 5.0.3 on Mac OS X 10.3

Hi Jan Pieter! Am Do, den 07.04.2005 schrieb Jan Pieter Kunst um 9:03: > Greetings, > > Is there a problem with MySQL 4.1.11 and 5.0.3 on Mac OS X 10.3? The > 10.3 versions on the download pages are still at 4.1.10a and 5.0.2. The problem is with the HTML generation, as the binaries for MySQL 4.

RE: Query question

SELECT product_lines.* FROM product_lines LEFT JOIN manufacturer_product_line_index ON manufacturer_product_line_index.product_line_id = product_lines.id WHERE product_lines.id IS NULL -Original Message- From: Ed Lazor [mailto:[EMAIL PROTECTED] Sent: Thursday, April 07, 2005 11:39 AM To:

Query question

Three tables like this: -- product_lines -- id title -- manufacturer -- id title -- manufacturer_product_line_index -- id product_line_id manufacturer_id The index provides a one to many relationship - one product line can

Out of memory, but plenty of swap space left

Recently I've been getting error 1041 at times, which gives the message to update the ulimit or add swap space. This is a dedicated MySQL server, so I have no ulimit set for MySQL. According to /proc/meminfo I have over 1GB of swap free. Mem: 2118533120 2067628032 509050880 19677184 165

Re: Need help in Stored procedures and functions

Dinesh, A stored func returns a scalar. To return multiple values, use an sproc declaring the INOUT variables you need, & pick up their values in the calling code after the sproc has executed. Peter Brawley http://www.artfulsoftware.com - Anchan, Dinesh wrote: Hi,   I am

Re: Strange behavior

At 16:59 06.04.2005, Gleb Paharenko wrote: Hello. Can you figure out in which state the queries from JBoss spend time the most? You may use your own program and 'SHOW PROCESSLIST' statement or something like: mysqladmin -i 1 -r processlist. I don't see a big difference between JBoss and a normal

Need help in Stored procedures and functions

Hi,   I am trying to write a function which returns multiple values.  I don't know if this is allowed or not but i am not able to create this function.  I get the following error:   ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL serv

RE: Wrong bytesec nightmare!

<[EMAIL PROTECTED]> wrote on 04/07/2005 03:42:45 AM: > > Hi, > > we are facing problem with the sql queries given below > > query number one gives the output as workstation and total logon failure > attempts from that workstation > > which is fine > > 1) select logonsvr,workstnid, count (user

Re: OS X Gui?

Jeff Justice wrote: Yes, there is a MySQL beta version of the administrator, but be warned, it has many bugs that I personally believe makes it unusable. I would have to agree. I just tried it out and within a few seconds had it crash on me. Hopefully they'll get it fixed up. -- == Eric Gorr ==

Re: OS X Gui?

Yes, there is a MySQL beta version of the administrator, but be warned, it has many bugs that I personally believe makes it unusable. Jeff J. On Apr 7, 2005, at 8:35 AM, Brent Baisley wrote: If you are looking for a GUI admin, MySQL has released a beta of MySQL Administrator for OSX. MySQL Query

Re: Question on Composite Index

"ManojW" <[EMAIL PROTECTED]> wrote on 04/06/2005 10:09:31 PM: > Dear All, > Just to get a better understanding of how indices work in MySQL - If I > have a Innodb table with a composite primary key (fld1,fld2,fld3,fld4,fld5), > then my understanding is that MySQL optimizes just the leftmost

Re: Strange behavior

At 16:59 06.04.2005, Gleb Paharenko wrote: Hello. Can you figure out in which state the queries from JBoss spend time the most? no, cause You may use your own program and 'SHOW PROCESSLIST' statement or something like: mysqladmin -i 1 -r processlist. I get this: id: 52401 user: omk-write host: xx

Call to undefined function: mysql_connect()

Team, I am trying to make apache-php and mysql work on Linux Redhat. I have the following versions installed that came with Redhat Linux: apache 2.0.46 mysql 3.23.58 php 4.3.2 I am getting the following error when I tried to connect to MySQL thru PHP. Fatal error: Call to undefined function: mysql_

Re: OS X Gui?

If you are looking for a GUI admin, MySQL has released a beta of MySQL Administrator for OSX. MySQL Query Browser is not available on OSX yet. Not sure which you may be looking for. On Apr 6, 2005, at 10:44 PM, Vic Cekvenich wrote: I am looking for a nice OS X GUI client, can be java for osx tha

Re: OS X Gui?

Navicat does not work w/ OSX-Tiger-java1.5 /MySQL 5 remote, nor does SQL Grinder(screens look nice). Jetware site is down so I can't try that. thanks for suggestions. DataBrowser does seem to work (and one that comes w/ mySQL - admin; but I do not like that one) Any more plz? tia, .V . Scott Fra

Re: mysqldump

Hello. I can't find such an error in the bug database. Is it possible that you use client part from the new server (you can see the version with mysql --version command) and an old server? What output does the following statement produce: SELECT VERSION(); "Anna Henricson" <[EMAIL P

Re: Strange behavior

Hello. Can you figure out in which state the queries from JBoss spend time the most? You may use your own program and 'SHOW PROCESSLIST' statement or something like: mysqladmin -i 1 -r processlist. I don't see a big difference between JBoss and a normal Java application except JBoss us

RE: Can't create a new thread (errno 11). If you are not out of available memory, you can consult the manual for a possible OS-dependent bug'

Hi, I have loaded and ran mysql-debug-4.1.10a and am getting the same problem. There are no errors produced in the error log and mysqld is not crashing so there is no stack trace to resolve. Any ideas? Cheers, Andrew -Original Message- From: Gleb Paharenko [mailto:[EMAIL PROTECTED] S

Re: OS X Gui?

Vic Cekvenich schrieb: > I am looking for a nice OS X GUI client, can be java for osx that works > w/ mysql 5.x. > > (these don't work MacSQL, CocaMySQL, YouSQL. MySQK admin does work, but > I want a bit more, like Maestro for OS X). AFAIK is the stuff from Navicat available for OS X. Regards,

Re: OS X Gui?

I haven't used Maestro, but I like SQL Grinder. It gives you a reasonable GUI. www.advenio.com/sqlgrinder The WebObjects EOF package has better Entity modelling, but you have to buy it! : } --s On Apr 6, 2005, at 10:44 PM, Vic Cekvenich wrote: I am looking for a nice OS X GUI client, can be jav

Re: TIME Difference Using 4.0.17

From: "shaun thornburgh" > I have a DATETIME COLUMN in my table and i need to be able to perform an > update on all colmns that are 48 hours old as specified in that column. As I > am using 4.0.17 I am unable to use the TIME() functions, is there another > way to do this? I tend to use constructio

Re: TIME Difference Using 4.0.17

shaun thornburgh wrote: Hi, I have a DATETIME COLUMN in my table and i need to be able to perform an update on all colmns that are 48 hours old as specified in that column. As I am using 4.0.17 I am unable to use the TIME() functions, is there another way to do this? Thanks for your help try d

TIME Difference Using 4.0.17

Hi, I have a DATETIME COLUMN in my table and i need to be able to perform an update on all colmns that are 48 hours old as specified in that column. As I am using 4.0.17 I am unable to use the TIME() functions, is there another way to do this? Thanks for your help -- MySQL General Mailing List

question to locks on an update statement

Hi I saw following example in the documentation on chapter 15.5 when you look at the property "innodb_locks_unsafe_for_binlog": Example from the docu START--- CREATE TABLE A(A INT NOT NULL, B INT); INSERT INTO A VALUES

Re: I need some help

Hi, Thank you very much that was what I looking for. Best regards, Cristi Harald Fuchs wrote: In article <[EMAIL PROTECTED]>, iNFERNo <[EMAIL PROTECTED]> writes: Hi, First of all thank you all for the quick replys. Now here's: select * from events limit 10; +--+---

Re: innodb, log_bin and ib_logfiles

Johanne, - Original Message - From: ""Duhaime Johanne"" <[EMAIL PROTECTED]> Newsgroups: mailing.database.myodbc Sent: Wednesday, April 06, 2005 10:12 PM Subject: innodb, log_bin and ib_logfiles --_=_NextPart_001_01C53ADC.86591B2F Content-Type: text/plain; charset="us-ascii" Content-T

Re: I need some help

In article <[EMAIL PROTECTED]>, iNFERNo <[EMAIL PROTECTED]> writes: > Hi, > First of all thank you all for the quick replys. > Now here's: > select * from events limit 10; > +--+-- > --+++--+-+---+--+---+-- > > + > | id |

RE: Wrong bytesec nightmare!

Hi, we are facing problem with the sql queries given below query number one gives the output as workstation and total logon failure attempts from that workstation which is fine 1) select logonsvr,workstnid, count (username) from winadlogon where evtid="681" group by workstnid order by workstnid;

Measuring query progress

Greetings I have a query that has been running for days on a otherwise unused mysql server. It's running on a reasonbly stout machine (dual Pentium III with 1GB of memory) and I tuned the server for big jobs. It's meeting all of the metrics in the documentation for a well-tuned system as near as I

4.1.11 and 5.0.3 on Mac OS X 10.3

Greetings, Is there a problem with MySQL 4.1.11 and 5.0.3 on Mac OS X 10.3? The 10.3 versions on the download pages are still at 4.1.10a and 5.0.2. Thanks, Jan Pieter Kunst -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[E