Fwd: Re: Server comparison running Mysql

>Have you tried monitoring server B via 'top' or something and see what >processes are taking up CPU time and/or swapping. Hello, I have monitored top for a bit. It is definitely MySQL-Max that is taking up the CPU and placing the load on the server. I have run strace on some of the p

Server comparison running Mysql

Hi, I have two servers. Server A: Dual 1GHz processors 1GB of RAM MySQL-Max 3.23.49a PHP 4.2.1 Server B: Single 1.7GHz processors 1.5GB of RAM MySQL-Max 3.23.4

Need help optimizing query

Greetings, I am struggling trying to get good performance using indexes. I'll spare the details and narrow down the situation. I have about 100,000 rows of data with the following fields: title - vachar(64) description - text state - varchar(2) priority - int modified - date People type in

Problem compiling mysql 4.0.4

Hi, I try to compile mysql-4.0.4-beta on my GNU/Linux system with gcc-3.2 There was no problem with the configure but for the make i got this : [...] Making all in isam gmake[2]: Entering directory `/tmp/mysql-4.0.4-beta/isam' /bin/sh ../libtool --mode=link gcc -O3 -DDBUG_OFF -O3 -march=i686

Compile Error on Sun 2.8[50 character or so descriptive subject here (for reference)]

>Description: Compile Error make[3]: Entering directory `/home/akbeech/sinbad_software/secure_server/mysql-3.23.52/sql' /usr/local/bin/gcc -DMYSQL_SERVER -DDEFAULT_MYSQL_HOME="\"/usr/local/mysql\"" -DDATADIR="\"/usr/local/mysql/var\""

RE: Need to match similar words

SOUNDEX might meet your needs http://www.mysql.com/doc/en/String_functions.html Peter --- Excellence in internet and open source software --- Sunmaia www.sunmaia.net tel. 0121-242-1473 ---

Need to match similar words

Hi, is there any chance in MySql to match similar strings and rate it? Ex: string: apples criterias: apples100% apple 90% appl 80% applee 50% appple 15% Any help will be much appreciated. Thanks in advance, Fabian __

Re: [PHP] recent encrpyt decrypt code... (problems)

ok - that made things work... here is the output. it looks like it is still encrypting it. what would the resolution be for this, or can I set the key to anything I want? Usage encrypted = 3D+kF/t+E9k= decrypted = Hello They match sql - Original Message - From: "Tom Rogers" <[EMAIL P

Re: DISTINCT and ORDER BY

--- [EMAIL PROTECTED] wrote: > 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 the > e

Re: mysql: multiple SELECTs with INSERT or UPDATE??

At 15:54 +0200 10/5/02, Mirza wrote: >Hi, > >i am inserting data in a mysql table like this: >INSERT INTO mytable1 >(bu_main_id) > SELECT main_id FROM mytable2 > WHERE username=\"$username\" > >that's ok. > >but now i would like to insert 2 values (bu_main_id and

Re: can't insert records with ID 0

At 18:56 +0100 10/5/02, Greg Conway wrote: >Hi all, > >I've got a MySQL Db on a Server, and I want to export and re-import the data >into another Server. > >This is fairly straight-forward using phpMyAdmin, but there is one >problem > >After creating the tables in the Db, I've gone back and ad

can't insert records with ID 0

Hi all, I've got a MySQL Db on a Server, and I want to export and re-import the data into another Server. This is fairly straight-forward using phpMyAdmin, but there is one problem After creating the tables in the Db, I've gone back and added record ID 0 in each table as a record with value

accessing field content with local application

I have the idea, to store complete xml-files in a tablefield and make it accessible for an editor (e.g. XMetaL) on a client. The retrieval in the database is done e.g. by php connections via browser. After selection of a specific row, the db-server should send the (xml) field content to the cl

Re: mysq passwords reset !

I find a blank mysql database, all is ok !:) ___ Do You Yahoo!? -- Une adresse @yahoo.fr gratuite et en français ! Yahoo! Mail : http://fr.mail.yahoo.com - Before posti

Mysqladmin can't shutdown server

Hi, I've been running 3.23.37 on a redhat box. with zero problems for a very long time. For the past 4 days or so I've had a persistent problem. I think I had a user with an out of control query which caused the system to run out of VM. I tried shutting down with mysqladmin but it failed.

mysq passwords reset !

Hi, I updrae my windows binaries server, and save my old datadir. I copy it to the new datadir, i already did that it works ! I use to put no password to mysql database, I secure mysql by closing via a firewall the 3306 port, it so annoying to find a password for each of my db ... But now when

re: Privileges for CREATE TEMPORARY TABLE?

Victoria Reznichenko said: >Since 4.0.2 user must have CREATE TEMPORARY TABLES privilege, it's a > global level privilege: > http://www.mysql.com/doc/en/News-4.0.2.html Thank you. That page says that "To use these, you must have run the mysql_fix_privilege_tables script after upgrading."

mysql: multiple SELECTs with INSERT or UPDATE??

Hi, i am inserting data in a mysql table like this: INSERT INTO mytable1 (bu_main_id) SELECT main_id FROM mytable2 WHERE username=\"$username\" that's ok. but now i would like to insert 2 values (bu_main_id and status), and i would like to know, is it possible t

SCO & Linux question

We have a linux machine running MySQL 4.0.3Max. We need to write to it from an SCO unix machine 3.2 V5.0.5. The only MysQL binary for that version of SCO is 3.23. Can the MySQL 3.23 on SCO write to a database on linux running 4.0.3MAX? TIA Darin Horton

INSERT INTO ... SELECT not creating indexes ?

Bonjour, When I insert a lot of rows in a table from another table in MyISAM format it seems that indexes in the destination table are not updated. For example in table A I have index 1. This table contains many rows. I have table B with same structure as table A but em

Re: Additional Information: Replication issue in 4.0.4

Shane, - Original Message - From: "Shane Allen" <[EMAIL PROTECTED]> Newsgroups: mailing.database.mysql Sent: Friday, October 04, 2002 10:17 PM Subject: Additional Information: Replication issue in 4.0.4 > On Thu, Oct 03, 2002 at 06:39:26PM -0500, Shane Allen wrote: > > We have a 4.0.4-b

Re: ERROR 1: Can't create/write to file (Errcode: 13)

Thanks, it was just about the set the right for the mysql user, as - you already correctly mentioned - mysql runs as user mysql. Thanks and regards, Stephan Gloor > Stephan Gloor wrote: > >>On Fri, 4 Oct 2002, Stephan Gloor wrote: > >> > >> > >>>When trying to create an index on > >>> > >>

Re: ERROR 1: Can't create/write to file (Errcode:13)

Stephan Gloor wrote: >>On Fri, 4 Oct 2002, Stephan Gloor wrote: >> >> >>>When trying to create an index on >>> >>>Table ANSCHLUSS: >>>| ID | int(11) | | PRI | NULL| auto_increment | >>>| TELEFON | varchar(20) | | MUL | || >>>| REGION |

Query - Question

Hello, I have a problem concerning a SQL-Statement. In the table S_Objekt I have a field S_Kapitel (varchar (15) binary) that contains chapternumbers like 2.2., 2.2.1., 1.1., 1.2.3. ... The Query is to give me all chapternumbers of a certain hierarchy. My Idea was to ask for the number of Points (

Re: ERROR 1: Can't create/write to file (Errcode: 13)

> On Fri, 4 Oct 2002, Stephan Gloor wrote: > > > When trying to create an index on > > > > Table ANSCHLUSS: > > | ID | int(11) | | PRI | NULL| auto_increment | > > | TELEFON | varchar(20) | | MUL | || > > | REGION | int(11) |