unauthenticated user | while load testing

Hi, What is unauthenticated user seen in mysql processlist ? I am doing load testing and at a single time more than 1000 users are coming to mysql server. Do any one have idea about it?

Re: Trying to Generate Dynamic Sequence IDs as Stored Function or Stored Procedure.

Peter, Thanks for the response! Unfortunately, that worked but a new error arose: check the manual that corresponds to your MySQL server version for the right syntax to use near 'ID = (select max(CONVERT(id_field, signed)) from my_table_t)' at line 1 Is there a better way to generate incremen

Re: Trying to Generate Dynamic Sequence IDs as Stored Function or Stored Procedure.

generate_dynamic_id('my_sequence_id_s', 'my_table_t', 'table_id', @dynamicId); Should be: CALL generate_dynamic_id('my_sequence_id_s', 'my_table_t', 'table_id', @dynamicId); PB On 1/4/2011 9:28 PM, James Dekker wrote: Hello there, I am using MySQL 5 on OS X - Snow Leopard... Have w

Trying to Generate Dynamic Sequence IDs as Stored Function or Stored Procedure.

Hello there, I am using MySQL 5 on OS X - Snow Leopard... Have working code in place which obtains the highest sequence number ID from a sequence table and then increments and assigns it to its corresponding table: The original code's purpose is to dynamically increments a specific table's las

Re: Moving data between two servers with SQL

Nevermind -- it's working absolutely perfectly between 5.5.8 and 4.1.x. Thanks again for the push. -Hank On Tue, Jan 4, 2011 at 5:14 PM, Hank wrote: > > Also, can I do this: > > insert into federated_table select * from local_table? > > -Hank > > > On Tue, Jan 4, 2011 at 4:15 PM, Shawn Green

Fw: problem open a innodb table

I messed up the ibdata1,ib_logfile1,0 files and encounter the problems of openning innodb tables even after I copied the back-up files of few months ago. I don't have many innodb tables and so this not causing too much trouble. I don't know what to do for restoring those tables, and not even kno

RE: This just seems to slow

I did wind up using LOAD DATA INFILE. When I started, I was afraid that I was going to process about 20 tables every day; but I redid the data exchange to avoid that. Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.83

Re: Moving data between two servers with SQL

Also, can I do this: insert into federated_table select * from local_table? -Hank On Tue, Jan 4, 2011 at 4:15 PM, Shawn Green (MySQL) < shawn.l.gr...@oracle.com> wrote: > On 1/4/2011 15:53, Hank wrote: > >> Hello, >> >>I have a background process that runs as a combination of PHP&MySQL. >>

Re: Moving data between two servers with SQL

Wow, that might just work! I've seen "Federated" tables mentioned about, but I never knew that's what they are here for.. thanks. Can I have a host (remote) table on a MySQL 4.1.x server, and the federated table on a 5.5.8 server? -Hank On Tue, Jan 4, 2011 at 4:15 PM, Shawn Green (MySQL) < s

Re: Close connetion

THX Shawn Green i going to try this soluctions 2011/1/4 Shawn Green (MySQL) > On 1/4/2011 14:47, Rafael Valenzuela wrote: > >> Hi everyone: >> >> I've a problem , this is error http://pastebin.com/eCEqLQ9b , i've >> looking >> in for google and documentation of mysql and nothing. >> >> there

Re: Moving data between two servers with SQL

On 1/4/2011 15:53, Hank wrote: Hello, I have a background process that runs as a combination of PHP&MySQL. The end results are records in a table on server #1 (but not the entire table, just a small subset of the table needs to move). What's the easiest/cleanest way of moving those records

Moving data between two servers with SQL

Hello, I have a background process that runs as a combination of PHP&MySQL. The end results are records in a table on server #1 (but not the entire table, just a small subset of the table needs to move). What's the easiest/cleanest way of moving those records to an identical table on another

Re: Close connetion

On 1/4/2011 14:47, Rafael Valenzuela wrote: Hi everyone: I've a problem , this is error http://pastebin.com/eCEqLQ9b , i've looking in for google and documentation of mysql and nothing. there any way to close connections with any command of mysql, i've modification the timeout and connexi

Re: Close connetion

Nothing is coming up at that url, so I"m afraid we can't be of much help. The normal practice on this list is to put relevant information in the email posting. - michael dykman On Tue, Jan 4, 2011 at 2:47 PM, Rafael Valenzuela wrote: > Hi everyone: > > I've a problem , this is   error http://p

Close connetion

Hi everyone: I've a problem , this is error http://pastebin.com/eCEqLQ9b , i've looking in for google and documentation of mysql and nothing. there any way to close connections with any command of mysql, i've modification the timeout and connexion number -- Mit forever My Blog

mysql log rotation

MySQL: Ver 5.0.51a-24+lenny4-log for debian-linux-gnu on x86_64 ((Debian)) Hi, I am looking for alternate methods to rotate the query and slow query logs. Currently we employ the following method, in psedu code: sh# rename mysql.log mysql.log.foo mysql> FLUSH LOGS; sh# move mysql.log.foo /back

Re: Loading date takes a long time after replication

Any pointers on this issue ? Thanks, Sairam Krishnamurthy +1 612 859 8161 On 01/03/2011 01:51 AM, Ananda Kumar wrote: What is the output of "show full processlist" On Mon, Jan 3, 2011 at 1:10 PM, Sairam Krishnamurthy mailto:kmsram...@gmail.com>> wrote: Hi all, I set up replication

RE: This just seems to slow

At 05:08 PM 1/3/2011, Jerry Schwartz wrote: Folks, this is getting creepy. It seems like each of the variations you've given me works some times and not others. I haven't found the pattern yet. The SQL I sent you works on my server just fine with your table and your data. BTW, there is no way