Re: mysql creating lots of processes (not threads, linux processes)

Nope, I'm using 5.0.38 on Gentoo, built via emerge in the exact same manner. Thanks for your answers guys. On 5/30/07, Scott Tanner [EMAIL PROTECTED] wrote: Sounds like your not using threaded libraries. Was mysql built differently, or are you using a different RPM on this server? Scott

RE: mysql creating lots of processes (not threads, linux processes)

Try to start it with mysql_safe instead or try to start mysqld manually within a command prompt, without fork, to see what happen. ./mysqld --console --verbose --your_options Can you at least connect to mysql with a remote client on this server or not? Have a look on this page about starting

FLUSH TABLE LOCK READ

Hi All, This question just for information sake. If i do flush table lock read; Any changes happening on tables during this period, will it be viewable by another user or will the user have to wait till the lock is released to see the new changes And once the lock is released, does mysql apply

Re: FLUSH TABLE LOCK READ

Hi, Ananda Kumar wrote: Hi All, This question just for information sake. If i do flush table lock read; I think you mean FLUSH TABLES WITH READ LOCK? Any changes happening on tables during this period, will it be viewable by another user or will the user have to wait till the lock is

selecting second last row

I have a table of publications. -- Table structure for news -- CREATE TABLE `news` ( `id` int(100) NOT NULL auto_increment, `content` longblob, `title` varchar(100) default NULL, `date` date default NULL, `display` varchar(10) default 'no', PRIMARY KEY

Re: selecting second last row

I have a table of publications. -- Table structure for news -- CREATE TABLE `news` ( `id` int(100) NOT NULL auto_increment, `content` longblob, `title` varchar(100) default NULL, `date` date default NULL, `display` varchar(10) default 'no', PRIMARY KEY

RE: selecting second last row

SELECT * FROM news WHERE display='yes' ORDER BY id desc limit 1 Think this would get the lastest article that is to be displayed but how do I get the second one. Just add an offset to the LIMIT clause: SELECT * FROM news WHERE display='yes' ORDER BY id desc limit 1,1 Edward -- MySQL

Does mysql support groups?

Does Mysql support groups of users? I am working on porting an application from Sybase to Mysql and it relies heavily on using groups to control access to the data. I am not seeing this mentioned in Mysql, but I might be overlooking something. So does it support groups? Thanks, Chris

mysql software appliance

I am pleased to announce the creation of a MySQL software appliance built using rPath's rBuilder tools. The appliance includes mysql server, the latest community edition. Give it a try, and leave feedback! Currently, there are install images for x86/x86_64, xen domU images for x86/x86_64, and

Re: Does mysql support groups?

Hi Chris, Chris Hoover wrote: Does Mysql support groups of users? I am working on porting an application from Sybase to Mysql and it relies heavily on using groups to control access to the data. I am not seeing this mentioned in Mysql, but I might be overlooking something. So does it

Re: Does mysql support groups?

Chris, Does Mysql support groups of users? It does not implement groups, but they are relatively easy to implement by linking a usergroups table to mysql.users. PB -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL

Re: FLUSH TABLE LOCK READ

Hi Baron, Its only a read lock, so changes on these table should be allowed, that is what the documentaion say. And the changes will be in bin-log till the READ lock is held. regards anandkl On 5/30/07, Baron Schwartz [EMAIL PROTECTED] wrote: Hi, Ananda Kumar wrote: Hi All, This question

mysqldump --where condition.

Hi All, In mysqldump , we have a --where parameter. Is this parameter used only for a specific table or can we have list of tables or can this be for a specific database or all databases. regards anandkl

identifying rows that have changed

Hi, I'm working on a rewrite of a batch process that operates on a large InnoDB database. In the past, it would process the entire database every night, but now the size of the data is making that impossible, and there is a desire for the process to operate in near real-time, so I'm rewriting

Re: FLUSH TABLE LOCK READ

Hi Ananda, I think you are confused about locks and the binlog both. Locks lock tables. This disallows changes. READ locks prevent changes, but do not block anyone from READING from the tables, and if I recall correctly, also allow other people to get READ locks at the same time. WRITE

Re: mysql creating lots of processes (not threads, linux processes)

Merci Geoffroy, starting from the command prompt shows: # /usr/sbin/mysqld --console --verbose --basedir=/usr --datadir=/var/lib/mysql --pid-file=/var/run/mysqld/mysqld.pid --socket=/var/run/mysqld/mysqld.sock 070530 18:01:28 [Note] /usr/sbin/mysqld: ready for connections. Version: '5.0.38-log'

Re: identifying rows that have changed

Perrin, I like #3 the best. #1 - it's not a good approach to hope your database keeps up. There are fairly common situations that can come up where you never know how long something will take - unusually high traffic, table check and repair, a bulk load into the same or another database on that

Re: identifying rows that have changed

On 5/30/07, Dan Buettner [EMAIL PROTECTED] wrote: #1 - it's not a good approach to hope your database keeps up. There are fairly common situations that can come up where you never know how long something will take - unusually high traffic, table check and repair, a bulk load into the same or

Re: mysql creating lots of processes (not threads, linux processes)

Oh and by the way mysql works just fine on that machine. You can run queries without any problems. Only it keeps spawning new processes over again. It takes about 3h before the machine starts having problems due to memory getting full of useless mysql processes. I just got a new machine for my

Re: mysql creating lots of processes (not threads, linux processes)

Hi Quentin, You say this machine is the same as all other machines. In my experience with Gentoo, this is hard to achieve. About the only way to do it, in my opinion, is to rsync the Portage snapshot from a machine you're happy with, rsync all the downloaded source tarballs, rsync the

selecting second last row

If there are only two rows that satisfy SELECT * FROM news WHERE display='yes' ORDER BY id desc then SELECT * FROM news WHERE display='yes' ORDER BY id asc limit 1 gives the second row. Am I missing something? Waldo Tumanut Database Analyst

True multi user?

I have a mailmerge document set up with a datasource table of 'data' I want each user to create this table from a result of other tables. How can users create their own version without overwriting each others work ? Thanks -- View this message in context:

Trigger question

Hey all, I asked this before (a while back) and have gotten some answers that solve my problem partially only. --- old message -- I have a table with 205 columns. When an update statement updates a row in this table I want a trigger that creates a record of the old row in a separate

Redirecting all queries to mysql dababase to another instance

Hi, I need to write a small middleware program that can capture, inspect and redirect all queries to an old instance of mysql to a new instance. Any help or pointers to get started would be greatly appreciated. thanks, Chike. -- MySQL General Mailing List For list archives:

Re: Redirecting all queries to mysql dababase to another instance

Hi, Chibuike Muoh wrote: Hi, I need to write a small middleware program that can capture, inspect and redirect all queries to an old instance of mysql to a new instance. Any help or pointers to get started would be greatly appreciated. Perhaps this will help:

Re: Trigger question

Hi, Olaf Stein wrote: Hey all, I asked this before (a while back) and have gotten some answers that solve my problem partially only. --- old message -- I have a table with 205 columns. When an update statement updates a row in this table I want a trigger that creates a record of

RE: True multi user?

You didn't specify how this table is to be created or used (what application). If it is all done within one connection, then you could use a temporary table. I have a feeling that's not what you need, though. Please give a little more detail about the application's interaction with MySQL.

RE: Trigger question

Will a SELECT * FROM work there? I'm not using 5.x, so I haven't really investigated triggers; this is just a guess. Regards, Jerry Schwartz The Infoshop by Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 www.the-infoshop.com

Re: Trigger question

Baron, Thanks a lot Adding the columns to the end works... Olaf On 5/30/07 2:13 PM, Baron Schwartz [EMAIL PROTECTED] wrote: Hi, Olaf Stein wrote: Hey all, I asked this before (a while back) and have gotten some answers that solve my problem partially only. --- old message

RE: True multi user?

There is a master document on a server which references a table called 'data' within database. I need users to query many tables and produce a data source called 'data' which the document can then reference. The problem is, that this 'data' table could easily get overwritten by another user.

Efficiently modeling sets and subsets in lattice-like structure

Apologies for the mass cross-posting: I haven't been able to find a single answer or reference for the problem below (googling didn't help), and was hoping someone could point me to something helpful. I'm convinced there's a well-known answer here that I just can't find :( We're modeling a

Re: True multi user?

As Jerry mentioned, you can use temporary tables. Temp tables are unique to the login session, so each usr logged in could create a table called data with conflict. But temp tables are just that, once the session is done, the temp table is dropped. If you need persistant tables, which I think

Replication Complication

Howdy, Having trouble getting Slave_IO_Running to start. The master-slave system was working before, but I think the master and slave binlogs have been reset (truncated). I'm unsure how to proceed. Am I SOL? David

stored procedure not working in legacy ASP

Hi How do you get multiple record sets from a stored procedure in legacy ASP? It doesn't seem to work for us. The question is how to return multiple record sets from a single stored procedure which myodbc doesn't seem to support? set rs = connection.execute(strSQLsp) If not rs.EOF then

Re: True multi user?

mmm I think i need some sort of compromise here... Yes setting up a table called data with a userid is easily done but can I 'filter' these within the master document? - perhaps 'feed' the document the userid (somehow) and then with a bit of manipulation via document code filter the result set

Re: Replication Complication

Howdy, Having trouble getting Slave_IO_Running to start. The master-slave system was working before, but I think the master and slave binlogs have been reset (truncated). I'm unsure how to proceed. Am I SOL? mysql Load Data From Master; seems to have done it. David

RE: True multi user?

It appears that the master document is going to be processed on individual PCs. In that case, I think that downloading the merge data source is the best solution. It might require some training, but doing a mail merge in MS Word is not a huge challenge. You were thinking of using an ODBC

RE: True multi user?

I agree i will have to request that the user downloads a datasource and saves it as 'c:\data.csv' and point a document to c:\data.csv otherwise i will need to incorporate a lot of vba/c# into the document Thanks for your help just thought there mat be an 'easy' way Cheers Juglugs -- View

help converting trigger

I have the following trigger in Postgresql, how can we do this in Mysql? CREATE TRIGGER tr_encounter_lab_order_upd AFTER UPDATE ON encounter_lab_order FOR EACH ROW EXECUTE PROCEDURE tr_encounter_lab_order_upd_trig_func(); CREATE OR REPLACE FUNCTION

Re: stored procedure not working in legacy ASP

Surely, you don't have legacy stored procedure in ASP under MySQL? are you sure this is the right list to be asking? - michael On 5/30/07, Critters [EMAIL PROTECTED] wrote: Hi How do you get multiple record sets from a stored procedure in legacy ASP? It doesn't seem to work for us. The

Re: Efficiently modeling sets and subsets in lattice-like structure

Hi Kelly, I'm pretty sure there's no universal efficient solution to this problem, this must be the well known answer you are looking for. The pure mathematics of 'very hard' could be very hard to express, though. So before you choose a solution you need to find out more about the actual

Connection time out/slow response from server

Hi, Running 4.1.22 created from FreeBSD ports on FreeBSD 5.5 . I run under TCP Wrappers. Even if 1 foreign machine attempts to contact us on the tcp port, the database becomes incredibly sluggish or unresponsive at all. Is there something I can do to prevent this from

Re: mysql creating lots of processes (not threads, linux processes)

I know I've run into this before, and it was a build issue. We build from source on redhat linux, so it may not be related to your issue. Anyways, I just did a test and built mysql from source with the flag --with-mysqld-ldflags=-all-static. I end up with the process spawning mysqld: ps -eaf

Re: stored procedure not working in legacy ASP

The stored procedure is in MySQL, but when called using ASP it fails to return more than the first record. Anyone? -- Dave Michael Dykman wrote: Surely, you don't have legacy stored procedure in ASP under MySQL? are you sure this is the right list to be asking? - michael On 5/30/07,

Re: stored procedure not working in legacy ASP

Would you care to send the source of that procedure plus tell us why you believe it works when called by something other than C#? On 5/30/07, Critters [EMAIL PROTECTED] wrote: The stored procedure is in MySQL, but when called using ASP it fails to return more than the first record. Anyone? --

RE: stored procedure not working in legacy ASP

[snip] The stored procedure is in MySQL, but when called using ASP it fails to return more than the first record. Anyone? [/snip] You need a while loop. Does the SP work from the command line properly? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:

Data types and reading in data

First of all I am very much a newbie with MySQL. I am trying to create some tables and then read in some data from a .csv file using load data infile 'filename.csv' The data in the .csv file has actually come from another database system. I have two problems which I haven't been able to

Re: MySQL in multi-threaded environment

Thanks! but I am already using table locks...any other thoughts? Cheers, Rajan On 5/29/07, sangprabv [EMAIL PROTECTED] wrote: Maybe need to lock the table Regards Willy - Original Message - From: Ace [EMAIL PROTECTED] To: mysql@lists.mysql.com Sent: Wednesday, May 30, 2007 12:22 PM

Re: MySQL in multi-threaded environment

Hi, What is your table engine? AFAIK it is recommended to use InnoDB than MyISAM. Regards Willy - Original Message - From: Ace To: sangprabv Cc: mysql@lists.mysql.com Sent: Thursday, May 31, 2007 11:48 AM Subject: Re: MySQL in multi-threaded environment Thanks! but I

Re: MySQL in multi-threaded environment

Yes, I am using InnoDB. On 5/30/07, sangprabv [EMAIL PROTECTED] wrote: Hi, What is your table engine? AFAIK it is recommended to use InnoDB than MyISAM. Regards Willy - Original Message - *From:* Ace [EMAIL PROTECTED] *To:* sangprabv [EMAIL PROTECTED] *Cc:* mysql@lists.mysql.com