R: Multiple instances howto

2008-03-28 Thread Nanni Claudio
Hi Jing, Logically speaking, you can run as many instances of mysql as you want, but you have to make an installation for each mysql instance. On each instance you can have as many databases as you want. From my experience here is the key: 1) One different mysql user (mysql41,mysql50) for each

R: Re: FW: Re: what is a schema? what is a database?

2008-03-28 Thread Nanni Claudio
I know I am a little late. From my experience with Oracle Database: ORACLE MYSQL(equivalent) --- DATABASEMYSQL INSTALLATION SCHEMA DATABASE So in Oracle a Database is an instance running on an

Adding Images

2008-03-28 Thread Victor Subervi
Hi; I´m trying to figure out how to upload images into a MySQL database. (Yes, that is what I want to do.) I have a form that asks for data, like this: 1ra Foto Pequeña: input type='file' name='pic1' / Then I send that form to a python script that processes like this: cursor.execute('insert

Re: Adding Images

2008-03-28 Thread Michael Dykman
Victor, you are on the wrong list. Your problem is not a MySQL problem (at least, not yet) but a question of how python deals with uploaded files (which, in ANY environment is radically different than the way normal form elements are treated). Try the python groups. - michael dykman On Fri,

Problems with unauthenticated user and DB slowing down

2008-03-28 Thread Aleksandar Skodric
Hi all, I am having problems with the following issue. Since couple of days ago, we got signs from our customers that website 'feels' very slow. One of our tests is IQ test. For this one, timing is crucial and it is unacceptable that test takes longer (because of slow site) - as it working as a

Re: Adding Images

2008-03-28 Thread Dan Nelson
In the last episode (Mar 28), Victor Subervi said: Hi; I'm trying to figure out how to upload images into a MySQL database. (Yes, that is what I want to do.) I have a form that asks for data, like this: 1ra Foto Pequeña: input type='file' name='pic1' / Then I send that form to a python

Re: Problems with unauthenticated user and DB slowing down

2008-03-28 Thread Michael Dykman
2008/3/28 Aleksandar Skodric [EMAIL PROTECTED]: Hi all, I am having problems with the following issue. Since couple of days ago, we got signs from our customers that website 'feels' very slow. One of our tests is IQ test. For this one, timing is crucial and it is unacceptable that

Re: procedure locks all statemens

2008-03-28 Thread B. Keith Murphy
When it selects values from the myisam table it is locking the entire table. Saravanan wrote: Hi Lists, i have created a procedure. It selects values from a myisam table and updates an innodb table one by one ( not as huge update it clearly use where clause). but whenever I run the

procedure locks all statemens

2008-03-28 Thread Saravanan
Hi Lists, i have created a procedure. It selects values from a myisam table and updates an innodb table one by one ( not as huge update it clearly use where clause). but whenever I run the procedure other statements waits for longtime until my procedure completes updates. any idea why it

Re: procedure locks all statemens

2008-03-28 Thread Saravanan
It doesn't lock single table it locks all other select and update statements of other tables too which I don't use in procedure. Saravanan --- On Sat, 3/29/08, B. Keith Murphy [EMAIL PROTECTED] wrote: From: B. Keith Murphy [EMAIL PROTECTED] Subject: Re: procedure locks all statemens To:

[OT] When MySQL Bites: Quirks to Watch Out For

2008-03-28 Thread obed
Hi all, i'm not trying to make trouble or bother someone with this information, I'm a mysql user and I love it, I just wanna know your point of view about it. http://use.perl.org/~Smylers/journal/34246 Have good one. -- obed.org.mx -- MySQL General Mailing List For list archives:

Re: procedure locks all statemens

2008-03-28 Thread Jaime Fuentes
Hi Last days frequently I see an error message : Can't create a new thread (errno 12) if you are not out of available memory, you can consult the manual for a possible OS-dependent bug. mysql is 5.0.41 server RAm: 2Gb and 100 Gb free spaces hard disk users around 64 Into my.ini the

Re: [OT] When MySQL Bites: Quirks to Watch Out For

2008-03-28 Thread Peter Brawley
i'm not trying to make trouble or bother someone with this information Misinformation---the first five items I found in this article make false claims: 1. CREATE TABLE creature (name VARCHAR(3) NOT NULL); INSERT INTO creature SET name = 'caterpillar'; Query OK, 1 row affected, 1 warning

Re: [OT] When MySQL Bites: Quirks to Watch Out For

2008-03-28 Thread Arthur Fuller
Dis-information not mis-information. Someone has an axe to grind, methinks. Or just perhaps is puntificating to see wha' 'appen. The objections PB has raised all apply here in my installation. Arthur

Re: [OT] When MySQL Bites: Quirks to Watch Out For

2008-03-28 Thread Ofer Inbar
It appears to be an article for perl programmers not familiar with MySQL, warning them of MySQL quirks they should be aware of. If you write a perl script with DBD::MySQL and try one of the examples he gave, and check your return status to see if the statement succeeded, does it appear to have

Error: Can't create a new thread (errno 12)

2008-03-28 Thread jfuentes
Hi Last days frequently I see an error message : Can't create a new thread (errno 12) if you are not out of available memory, you can consult the manual for a possible OS-dependent bug. mysql is 5.0.41 server RAm: 2Gb and 100 Gb free spaces hard disk users around 64 Into my.ini the