Re: Growing memory usage/processes

In the last episode (Jul 03), Dave said: Hello all, I have mysql running on a 2.4.18 kernel: /usr/libexec/mysqld Ver 3.23.49 for redhat-linux-gnu on i386 and note that one started about 4 processes (threads?) began to handle the various signal/table tasks and such. After several

Re: Growing memory usage/processes

Thanks for the confirmation Dan, I will look a little closer but I could have sworn when I shutdown MySQL about 300MB of memory got freed. I had a suspicion the case was one process and ps/top could not distinguish...I just needed to hear confirmation of it I guess. -Dave In the last

Re: Growing memory usage/processes

Hi, Hi, It depends also of how many threads are running at the same time + sort buffer / record buffer values. The memory consumption can be roughly calculated as key buffer + (sort buffer + record buffer) * number of thread. As you can see, only the key buffer is shared between all the

Re: blob versus file

Am Mittwoch, 3. Juli 2002 20:43 schrieb central: More specific: Can I efficiently read the bytes x to y from any BLOB stored in a MySQL database? Why not just add another column, Char(3), that contains the file extension? That would fix this particular case, but my thought were more

Re: TCP TIME_WAIT strange problem ( LINUX mysql 3.23.49 )

Hi, TIME_WAIT said to you that are still packet in the network which are unhandled after socket it's closed. The question is: ... why happend this? IFCONFIG show you information about network interfaces which is mounted in your computer and not about entire network. Regards, Gelu

Re: Re: Transparent Encryption [was: encrypt myisam?]

Am Donnerstag, 4. Juli 2002 09:03 schrieben Sie: Your message cannot be posted because it appears to be either spam or simply off topic to our filter. To bypass the filter you must include one of the following words in your message: sql,query If you just reply to this message, and include

selected records retrieve

Hi to all. I'm new in the list and in mysql as well, so excuse me for anything that sounds novice or in wrong place.I'm facing the following situation: For some reason, i had to use a backup of the database.Because of the difference in time between my backup and the instance i had to use it,i

Performance : create table into database

Hi all, I want to add huge amount of data to the mysql database in chunks. Lets call it as data1, data2 , data3. Now there are 2 solutions to the problem: 1. Create the different table for each of data1, data2, data3 etc. 2. Create a single table and add different rows into the table, each

Re: Load Data Problem

* [EMAIL PROTECTED] Hie there, I'm having a potential problem with Load Data Infile function where i'm unable to get the right no. of records to appear in the table. I have a table created in MySQL with 2 fields region (char 1)-pkey and regionname (char 30). The table name is

Re: selected records retrieve

* Nixarlidis Aris Hi to all. I'm new in the list and in mysql as well, so excuse me for anything that sounds novice or in wrong place.I'm facing the following situation: For some reason, i had to use a backup of the database.Because of the difference in time between my backup and the

RE: selected records retrieve

Hi, you can use mysqldump command line utility with the '--where=' switch. See the man page for more details. Regards, Sebastien sql query -Message d'origine- De : Nixarlidis Aris [mailto:[EMAIL PROTECTED]] Envoye : jeudi 4 juillet 2002 09:46 A : [EMAIL PROTECTED] Objet : selected

MySQL access denied problem

Hello, I have a problem that happens periodically on my FreeBSD 4.6 box. Somehow MySQL (3.23.49) stops responding after some period. It doesn't allow to connect any user except root ( and it's not because max_connections, there aren't active connections at the time). The only thing that

Replication Question

The MySQL manual for 3.23.38, Section 11.4 states that you can have a replication chain A - B - C - A. I guess this means A Master B Slave B Master C Slave C Master A Slave Can this loop be reduced to the most trivial case A - B - A ? If so, it would help me with a roving laptop issue I have.

Re: Replication Question

On Thu, Jul 04, 2002 at 09:33:54AM +0100, David Shields wrote: The MySQL manual for 3.23.38, Section 11.4 states that you can have a replication chain A - B - C - A. I guess this means A Master B Slave B Master C Slave C Master A Slave Can this loop be reduced to the most trivial case A

mysql query: left join with same column names

Hi all, I have to tables A and B. They boyh have a column with the same name. Now, I wrote this MySQL statement performing a left join. This results in a data set with rows consisting of 2 columns of the same name, in which the date is stored when the record was last altered. This column is

Re: mysql query: left join with same column names

* Wilbert Enserink I have to tables A and B. They boyh have a column with the same name. Now, I wrote this MySQL statement performing a left join. This results in a data set with rows consisting of 2 columns of the same name, in which the date is stored when the record was last altered.

exclude columns in query

Hi all, is it possible to exclude columns in a query? something like select * from table except columnname ?? regards WIlbert mysql. - Pas de Deux Van Mierisstraat 25 2526 NM Den Haag tel 070 4450855 fax 070 4450852 http://www.pdd.nl [EMAIL PROTECTED]

Demande d'inscription à mysql-france

Bonjour, Vous avez récemment demandé à vous inscrire au groupe mysql-france. Comme vous êtes déjà membre de ce groupe, votre demande ne sera pas prise en compte. Pour toute question sur l'envoi de messages à ce groupe, veuillez envoyer un e-mail à [EMAIL PROTECTED] Cordialement, L'équipe

Re: MySQL access denied problem

Pada Thu, 4 Jul 2002 10:40:36 +0200 Simas Cepaitis [EMAIL PROTECTED] menulis : Hello, I have a problem that happens periodically on my FreeBSD 4.6 box. Somehow MySQL (3.23.49) stops responding after some period. It doesn't allow to connect any user except root ( and it's not

Re: exclude columns in query

Pada Thu, 4 Jul 2002 11:34:12 +0200 W. Enserink [EMAIL PROTECTED] menulis : Hi all, is it possible to exclude columns in a query? something like select * from table except columnname ?? Nope, I don't think it's possible ... You have to give columns list, like this ... select

innodb database schema dump

how can i dump innodb tables schema with foreign key references so that the tables are created in the right order ? thanks, Pierre -- sql,query - Before posting, please check: http://www.mysql.com/manual.php (the

RE: MySQL access denied problem

Hello, -Original Message- From: Dicky Wahyu Purnomo [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 04, 2002 12:44 PM To: Simas Cepaitis Cc: [EMAIL PROTECTED] Subject: Re: MySQL access denied problem What was the error message appear when you try to log in with normal user ?

AUTO_INCREMENT in master-master mode...?

Hi all! In MySQL, is replication of auto_increment (primary keys) in a master-master mode working? or is it only working with master-slave? -Jon - Before posting, please check: http://www.mysql.com/manual.php (the

FW: Regarding cast functions

-Original Message- From: Harish Varandani-Software-Bangalore Sent: Wednesday, July 03, 2002 12:26 PM To: '[EMAIL PROTECTED]' Subject: FW: Regarding cast functions I would like to know regarding the cast and convert functions in MySql4.0.1;. Can

What are the hardware requirements

To run mysql Thanks Kevin Kevin Passey KDP Software Limited Tel: 01273 712830 Fax: 08700 510103 mailto:[EMAIL PROTECTED] http://www.kdpsoftware.co.uk - Before posting, please check: http://www.mysql.com/manual.php (the

Re: unexpected results using LEFT JOIN with more than one

Harald, Wednesday, July 03, 2002, 11:06:36 PM, you wrote: HK Description: HK I use LEFT JOIN to join together two tables. And (for some 'complex' HK reason) I want to add additional conditions into the join_condition-part HK (and not in the WHERE part where it would belong to). But these

Re: exclude columns in query

W., Thursday, July 04, 2002, 12:34:12 PM, you wrote: WE is it possible to exclude columns in a query? WE something like WE select * from table except columnname ?? You should specify all needed columns, i.e. if your table contains 3 columns: column1, column2, column3, but you want to get

Re: MYSQ current value!!!

Rahadul, Wednesday, July 03, 2002, 10:32:19 PM, you wrote: RK This are the few variables for mysql. Does anyone know how can I set the RK current value to some other value. because whats happing now is when I RK try to startup mysql, it starts and right after a second it ends. and I RK think Its

Re: login root problem

Ivan, Thursday, July 04, 2002, 8:33:31 AM, you wrote: IP I can't login using root to mysql server from my pc-client... IP I have tried to use this command but still have a problem... IPmysql -u root -p -h 192.168.x.xxx IP i already created one user which have all privileges IP so, if i

Re: How to On DELETE CASCADE

multivac, Thursday, July 04, 2002, 12:22:42 AM, you wrote: m I'm quite new in MySQL and PHP, so I guess my question is stupide. Sorry m for that but I really need the solution... m I have 2 tables [skip] m The primary Keys are ClientID on table Client and CommandID on table m Command. m I'm

Row level locking

Hi, Ive just downloaded MySQL and am trying to switch on row level locking. Ive changed the tables to InnoDB but it still seems to be switched off - are there other things which need to be done? Thanks, Tom Robinson Workforce Systems

MySQL compiling errors

Hello! i have some trouble to compile MySQL (from source not from pkgsrc) on my NetBSD/i386 Notebook. After configure i type gmake and get this: gmake[2]: *** [my_gethostbyname. lo] Error 1 gmake[2]: Leaving directory '/mysql-3.23.51/libmysql' gmake[1]: *** [all-recursive] Error 1 gmake[1]:

Re: Error on rename

Hi Mark, I do have rights! I'm logged in as administrator and as root in MySQL and the problem still happens If I flush the tables, then everything is ok...and I can figure out why... The problematic areas are: rename tables alter tables types, e.g., from varchar to text. creating

temporary table query

hi all I'm using this query: CREATE temporary TABLE temptable SELECT * FROM gallery INNER JOIN designers ON (designers.designersID=gallery.designersID) WHERE (LOWER(gallery.omschrijving) LIKE '%$search%' OR LOWER(gallery.productnaam) LIKE '%$search%' OR LOWER(voornaam) LIKE '%$search%' OR

Re: temporary table query

* Wilbert Enserink I'm using this query: CREATE temporary TABLE temptable SELECT * FROM gallery INNER JOIN designers ON (designers.designersID=gallery.designersID) WHERE (LOWER(gallery.omschrijving) LIKE '%$search%' OR LOWER(gallery.productnaam) LIKE '%$search%' OR LOWER(voornaam) LIKE

Re: AUTO_INCREMENT with Replication

Hi, That kind of bothers me. But I can see how it might be better in some way than using a time function. My idea was to use the perl Time::HiRes to make a unique key adjusted by timezone. As long as the clocks of the two machines are fairly in since, it should work :) I guess I could also

Porting my gweMysql JDBC Driver(Type4) to C# Driver!!

Hi, All I ported my gweMysql JDBC Driver(Type4) to C# Driver. :-) If you are interested in C# Driver, please check it out!! http://www.t3-jpn.com/work/jdbc/jdbcmysql.html -- I love Borland. TAKAHASHI, KEN, Tomohiro -

Re: Porting my gweMysql JDBC Driver(Type4) to C# Driver!!

Sorry, URL is wrong Please check it out http://www.t3-jpn.com/jdbc/jdbcmysql.html "TAKAHASHI, Tomohiro" wrote: Hi, All I ported my gweMysql JDBC Driver(Type4) to C# Driver. :-) If you are interested in C# Driver, please check it out!! -- I love Borland. TAKAHASHI, KEN,

select tuning / simple

Hi! I got a very simple SQL query which takes 0.2sec to execute (far too long) and it seems I can't do nothing about it. I use : SELECT id FROM news WHERE state=1 and main_page=1 order by timestamp desc LIMIT 10 I got indexes too :

Problem with SQL Statement

Hello, i have tryed a lot but don´t find a way for the following problem with my SQL Statement. I have 3 tabels and will make a fulltext search on this 3 tables. My fulltext indexes are propper set. On a hit i will see the datas from table1 with the main informations (the other 2 tables have

RE: Row level locking

What tests have you done to satisfy to yourself that it is turned off? =C= * * Cal Evans * The Virtual CIO * http://www.calevans.com * -Original Message- From: Tom Robinson [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 04, 2002 6:10 AM To: [EMAIL PROTECTED] Subject: Row level

RE: What are the hardware requirements

I wouldn't try it on anything less than a Pentium class machine with at least 64 MB of RAM. It could probably be compiled on a 486 but, well, I'm not into that kind of pain. :) If you want decent performance I would suggest no less than a PIII500 with 1GB of RAM. (THe more RAM the merrier) It

BigINT inserts

You can always store an exact integer value in a BIGINT column by storing it as a string. In this case, MySQL will perform a string-to-number conversion that involves no intermediate double representation. I don't understand this, does this mean that the fastest way to insert bigint values

Re: AUTO_INCREMENT with Replication

Eric Frazier wrote: Hi, That kind of bothers me. But I can see how it might be better in some way than using a time function. My idea was to use the perl Time::HiRes to make a unique key adjusted by timezone. As long as the clocks of the two machines are fairly in since, it should work

Problem with SQL Statement

Hello, i have tryed a lot but don´t find a way for the following problem with my SQL Statement. I have 3 tabels and will make a fulltext search on this 3 tables. My fulltext indexes are propper set. On a hit i will see the datas from table1 with the main informations (the other 2 tables have

RE: AUTO_INCREMENT with Replication

We use a strategy of giving each node a unique ID and using the combination of the NodeId and the AUTO_INCREMENT value as the key for the objects. The AUTO_INCREMENT field ensures uniqueness between records in a single node. The NodeID ensures uniqueness between nodes. This way nodes that are

resizing images in blobs

Hi there, I am wondering if it is anyhow possible to resize an image stored in a blob field. Lets say the image is 400 x 300 px and I would like tor resize the image to 40 x 30. Is there a way without php or similar? Maybe someone has done this already and can give me a hint on that. Thanx in

How best to store queries

Hello All: I believe that MySQL does not have the ability to directly store procedures, but I need to develop a process for clients to have an option to store queries that they have just made. The most obvious solution (to me) would be to store the entire query as a string

Re: resizing images in blobs

:Lets say the image is 400 x 300 px and I would like tor resize the image to :40 x 30. :Is there a way without php or similar? Go with ImageMagick. It has a imaging resizing and cropping functions : :Maybe someone has done this already and can give me a hint on that. : :Thanx in

Re: How best to store queries

Tim: From the DB side, it is pretty easy to do ... a table with 3 columns will suffice: CREATE TABLE queries ( q_id int(11) NOT NULL auto_increment, q_name varchar(30) default NULL, q_text text, PRIMARY KEY (q_id) ); Your app needs to be able to

help me please with mysqlgui

When I start mysqlgui on my mandrake 8.2 machine the program starts, but I get an error message: Can't connect to local MySQL server through socket'/tmp/mysql.sock'(2) I don't know what to do and I cannot acces the help file or find documentation on MySQLserver. Please tell me how I can solve

Re: help me please with mysqlgui

You might have your socket files in /var/lib/mysql/. Search for the socket file and create a symlink in the /tmp directory as such: ln -s /var/lib/mysql/mysql.sock /tmp/mysql.sock Regards, Bhavin. - Original Message - From: Bas Mooyman [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent:

innodb database schema dump

I had the same problem, and while I don't think there's a way around it, you can load the schema with the force option so that it will eventually make it to the table the must be created first, (even if a previous table creation gives an error). Running the script many times over and over will

Audit - Log

Hi, After reading about the audit log (http://lists.mysql.com/cgi-ez/ezmlm-cgi?1:mss:95588), which I need; I looked for the my.cnf and mysql.log file but didn't find any nor any other related file. Are these created by default or should I create them ? Please advise. TIA. Jorge Ceballos

Re: Audit - Log

You will need to create my.cnf and turn ON the loggin option. Bhavin. - Original Message - From: Jorge Ceballos [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, July 04, 2002 12:30 PM Subject: Audit - Log Hi, After reading about the audit log