MySQL DLL for windows

hi ! i have a problem compiling a simple mysql client program in windows. what are the compilation options needed and also how the Linking is made . The manual says to include my_global.h in the header but i dont find that under include folder. also i searched in the net , can anyone provide

SELECT 9 BETWEEN 1 AND 0

I am trying to create a select query to find the post town of a users post code. I am using Royal Mails (UK) post town gazetteer. UK Postcode (eg. RH6 9XJ). The first column contains the first half of the post code (eg. RH6) and the next column holds the range of the second half (eg. 2AA-6PP). I

Re: type data

DWI CAHYO [EMAIL PROTECTED] wrote: can everybody help me, as i would like to save extention (*.bmp.jpg) on mysql, which i use type data ? Use CHAR/VARCHAR column types to store extention: http://www.mysql.com/doc/en/CHAR.html -- For technical support contracts, goto

Re: MySQL DLL for windows

Prem Soman [EMAIL PROTECTED] wrote: i have a problem compiling a simple mysql client program in windows. what are the compilation options needed and also how the Linking is made . The manual says to include my_global.h in the header but i dont find that under include folder. also i

Re: Starting the mySQL Server

Those are the ones. What about host.FRM ? Normally *.FRM are the ones that contain table definitions. *.MYD are the ones that contain Table Data *.MYI are the ones that contain Index information I think for every table, the above files should be there. How did you install MySQL? From

Error encountered when Connect remotely in mySQL 4.0.15

Hi, all, I had just upgrade my mySQL to version 4.0.15 yesterday. I have now encountered error in remotely connect to mysql database with the user only have a particulardb access rights. The scenerio is like this, in my mysql user db, i have one user call UserA, which this UserA only have

Re: SELECT 9 BETWEEN 1 AND 0

I am sorry to say that your question is not clear. Why don't you send us a simple Table with few data and what you want to achieve in simple terms? I mean a more clear question!!! Have tried using IN(). In your subject, you said 9 BETWEEN 1AND 0? I am confused. Thanks Emery - Original

Re: type data

If you want to save your BMP picture in the database and save the extension as well you will need separate fields. One for the picture content (BLOB) and another one for the extension (CHAR or VARCHAR as Egor said) Thanks Emery - Original Message - From: Egor Egorov [EMAIL PROTECTED] To:

Resume indexing after powerloss?

Someone knows if its possible to resume indexing a base where it left due to a power failure? The process was copying to tmp file when the power went away, having achieved 5GB of total 6GB in 6 days.. thanks -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To

Need a Tutorial on RAID with MySQL

Hi group, Does anyone know of a good tutorial on RAID? When used with MySQL. Thanks, __ NZEYIMANA Emery Fabrice NEFA Computing Services, Inc. P.O. Box 5078 Kigali Office Phone: +250-51 11 06 Office Fax: +250-50 15 19 Mobile: +250-08517768 Email: [EMAIL PROTECTED]

Re: Reliability of _rowid over multiple database accesses

Hi Smith, the fact that _rowid may change over time depending on many factors doesn't concern MySQL, but it is valable for mSQL. Regards. Thierno 6C - MySQL 4.0.15 - Original Message - From: Roger Baklund [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: Guy Smith [EMAIL PROTECTED] Sent:

export to textfile

Hello all, Have only a small problem with my mysql and hope that i can get a lil hint from ya how to go on. Currently i`m importing Log-files in the mysql-database with a cronjob (bashscript in Linux). After some processing in the db itself i try now to export the results into a textfile. But

Re: export to textfile

Hi Bernd If you are just interested in dumping the data in CSV (or whatever) format you can do it like so: SELECT * INTO OUTFILE 'arb_file.csv' FIELDS TERMINATED BY ',' LINE TERMINATED BY '\n' FROM arb_table WHERE arb_conditions There are quite a few options available, so I suggest you check

Re: export to textfile

Possibly you need the SELECT ... INTO OUTFILE command (http://www.mysql.com/doc/en/SELECT.html) which has export options (explained on http://www.mysql.com/doc/en/LOAD_DATA.html, because the command is the complement to LOAD DATA INFILE). |-+-- | |

Re: export to textfile

Bernd Tannenbaum [EMAIL PROTECTED] wrote: Have only a small problem with my mysql and hope that i can get a lil hint from ya how to go on. Currently i`m importing Log-files in the mysql-database with a cronjob (bashscript in Linux). After some processing in the db itself i try now to

FW: SELECT 9 BETWEEN 1 AND 0

This went direct and not to the list. Andy -Original Message- From: Andy Eastham [mailto:[EMAIL PROTECTED] Sent: 21 October 2003 08:19 To: Steven Ducat Subject: RE: SELECT 9 BETWEEN 1 AND 0 Steve, I'd add an extra column with modified code in it, where I subtracted 1 from the number

RE: SELECT 9 BETWEEN 1 AND 0

The question is how can I use some sort of statement using mysql and php to select all rows between 1 and 0 NOT 0 and 9 like the above statement performs. Sure, an option was nicer, but isn't the following possible? SELECT ... WHERE ... AND ( x BETWEEN 1 AND 9 OR x BETWEEN 0 AND 1 )

Re: export to textfile

Helloand ty for the fast answers, but Am Dienstag, 21. Oktober 2003 13:10 schrieben Sie: Hi Bernd If you are just interested in dumping the data in CSV (or whatever) format you can do it like so: SELECT * INTO OUTFILE 'arb_file.csv' FIELDS TERMINATED BY ',' LINE TERMINATED BY '\n'

Re: WANTED: Betatesters for a MySQL Developer Tool

Hi Minky, From: [EMAIL PROTECTED] Hi Regards Minky You're email address fails - can you re-contact me with a valid email address? With regards, Martijn Tonies Database Workbench - developer tool for InterBase, Firebird MS SQL Server. Upscene Productions http://www.upscene.com --

Re: InnoDB or OS restriction?

Hi Heikki, here is a snip from the original posting which you probably have overlooked: The first strange thing is that MAXDSIZ and DFLDSIZ in kernel config are setted to 1536M Regards Alexander Varshavchick, Metrocom Joint Stock Company Phone: (812)118-3322, 118-3115(fax) On Mon,

Re: export to textfile

Hi Bernd Will the query be static? E.g. could you put the SELECT ..INTO OUTFILE query into a batch file and just call that batch file from the command line? mysql -u user -p arb_file.bat Obviously this will be a little more of a problem if you generate the query dynamically each time. Rory

Re: export to textfile -solved :)

Hi and thx to all who answered :) Okay, finally found my mistake with ur help. One can add the needed options within the select statement, not within the mysql -e statement as i tried. Working solution is now: ./mysql --skip-column-names -e select ek_satzart,[...] into outfile 'File' FIELDS

RE: C API

There is a C++ package called OTL (http://otl.sourceforge.net/home.htm). It supports both MySQL through MyODBC, and Oracle. It works great with Oracle applications, but we have not used it with MySQL. Thanks, Brad Teale Universal Weather and Aviation, Inc. mailto:[EMAIL PROTECTED] 713-944-1440

Re: What is SQL Standard: ISNUL()L, IFNULL() ?

Holly Chamberlain [EMAIL PROTECTED] wrote: Does anyone have a good site that contains the current SQL standard? Or does anyone know is ISNULL() and IFNULL(), and similar null testing functions, standard SQL or extensions to SQL? No, there are no such functions in the SQL-99. In the standard

Moving to Linux and NetApps

Previously, we have installed MySQL 4.0.x server on a Solaris box where the MySQL binaries, MySQL databases and MySQL logs are stored on local discs. We now want to move to a Linux box (Redhat 9) where the MySQL binaries, MySQL databases and MySQL logs are provided by a NetApps server using NFS.

Re: Multiple Image inserts into a MySQL BLOB column

Make sure that the mysql server has read permission for the file. Zafar wrote: Hello Having trouble inserting images into a BLOB column. No problems doing this 'one at a time' via a third party MySQL GUI Manager, but I need to create an indexed table containing some 1K + images. Using the

Re: InnoDB or OS restriction?

Alex, because 512 MB is not an InnoDB or MySQL restriction, it must be an OS restriction :). I assume you have not allocated 1.5 GB of MySQL key_buffer. Best regards, Heikki Innobase Oy http://www.innodb.com InnoDB - transactions, row level locking, and foreign keys for MySQL InnoDB Hot Backup

Digest Problem?

I cannot seem to get this list as a digest :( I have unsubscribed and re-subscribed multiple times choosing the digest option to no avail. I keep receiving single e-mails. Thanks for any help! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:

Recovering data from ISD/ISM/frm files

I need to restore a table from backup copies of the ISD/ISM/frm files. I can't seem to get it to work. I have copied over the files, I have tried restoring using isamchk. I'm sure it has something to do with the temporary tables, but I can't find anything in the docs about this. All I keep getting

Re: Resume indexing after powerloss?

In the last episode (Oct 21), Peer Reiser said: Someone knows if its possible to resume indexing a base where it left due to a power failure? The process was copying to tmp file when the power went away, having achieved 5GB of total 6GB in 6 days.. Nope; you'll have to start over. That's an

Re: GEMINI

Hi! Thanks to the god of multiversioned databases, creator of InnoDB and all-round good human being Heikki, I can tell you the following things with confidence: 1. InnoDB is the fastest disk-based transactional database engine on the planet, period. No ifs, no buts, no conditions at all. 2.

RE: Recovering data from ISD/ISM/frm files

Ok, well I have managed to recover the data from my backup, but now when I try to update the table, or insert rows I get the error: table 'tablename' is read only. trying to unlock the table doesn't seem to help. I have stopped and restarted mysql. Thanks, Roger -Original Message-

How to get a nice schema diagram

Looking for an open source or commercial tool to help with database visualization for a presentation we are to give. Can't seem to find a simple way to generate a nice poster of our database design. Any suggestions? Thanks. -- MySQL General Mailing List For list archives:

RE: How to get a nice schema diagram

Have you tried datanamic.com? -Original Message- From: Jeff Weeks [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 21, 2003 1:50 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: How to get a nice schema diagram Looking for an open source or commercial tool to help with database

RE: Recovering data from ISD/ISM/frm files

Ok, got it worked out. I had to dump, drop and recreate the table, but it's working. Roger -Original Message- From: Harrell, Roger [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 21, 2003 8:49 AM To: [EMAIL PROTECTED] Subject: RE: Recovering data from ISD/ISM/frm files Ok, well I have

Re: Recovering data from ISD/ISM/frm files

Check the ownership and permissions on the files. Since you copied them over, perhaps they are owned by root, and not mysql. You did shut down the server before copyng the files? Harrell, Roger wrote: Ok, well I have managed to recover the data from my backup, but now when I try to update the

Mysql Performance Question

I'm running a community site (Xoops) on Mysql 4.0.14. I found that the speed of my site is slow during peak hours, when there are 450 concurrent uers hanging on the site. Mytop showed that the queries per second maxed at 500. I believe this could be higher, provided that I have it running on a

Re: Mysql Performance Question

On Tuesday, October 21, 2003, at 12:48 PM, Rainer Sip wrote: I'm running a community site (Xoops) on Mysql 4.0.14. I found that the speed of my site is slow during peak hours, when there are 450 concurrent uers hanging on the site. Mytop showed that the queries per second maxed at 500. I

Re: Mysql Performance Question

On Wed, 22 Oct 2003 00:48:29 +0800, Rainer Sip [EMAIL PROTECTED] wrote: In the mid run I'm planning to mirgrate to innodb for higher concurrency (I'm currently using myisam). However, I'm seeking suggestions in fine tuning the parameters. I know you want to tune the parameters, but if you

Multithreaded?

All installations of mysql I have run ps -fax will show about 5 mysql proccess running, even at idle. I compiled on a Redhat 9 box, it did find pthreads however ps -fax show 1 mysqld process running. Is there a spot to configure spare proccess? -- Or verify that it is indeed compiled

Find non-unique values

I have a table wherein one column is SUPPOSED to be unique but I strongly suspect isn't. Because I had this suspicion, I did not apply a unique index to the column. Assuming there are no null values in that column how would I find the instances of non-unique values? If I try to alter table add

RE: Multithreaded?

On red hat systems threads show up in a normal processlist. Thoese are threads that your seeing, some for connections others to do some innodb tasks and/or replication. - Dathan Vance Pattishall   - Sr. Programmer and mySQL DBA for FriendFinder Inc.   - http://friendfinder.com/go/p40688

Re: Mysql Performance Question

Thanks a lot guys. Haydies: Just out of wondering, are you using PHP and if so do you use mysql_pconnect rather then mysql_connect because that would really speed things up. I tired pconnect before but it didn't help but using up all the available memory. It speeds up things until the disks

Re: Find non-unique values

Assuming 'id' is an identifying column and 'dupe_col' is the column with duplicate values... SELECT id, COUNT( dupe_col ) AS cnt FROM tbl GROUP BY dupe_col HAVING cnt 1 HTH PB - - Original Message - From: Randy Chrismon To: [EMAIL PROTECTED] Sent: Tuesday,

RE: Find non-unique values

You can use the group by and having clause: use test; drop table if exists duptest; create table duptest( x int , z varchar(25) ) type=innodb; insert into duptest(x, z) values(1, 'Val1'); insert into duptest(x, z) values(2, 'Val2'); insert into duptest(x, z) values(3, 'Val3');

RE: Find non-unique values

Randy, For general SQL questions, you might find something in a newsgroup, such as comp.databases.*, but there are so many peculiarities, even among the most compliant datbases, that it's hard to really ask a general question. As for your unique values... -Original Message- From:

Re: Multithreaded?

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Tue, 21 Oct 2003, Greg(Bear) Casad wrote: All installations of mysql I have run ps -fax will show about 5 mysql proccess running, even at idle. Yep. I compiled on a Redhat 9 box, it did find pthreads however ps -fax show 1 mysqld process

Strange results

Hey folks - can anyone explain this behaviour: mysql select token, spam_hits, innocent_hits from dspam_token_data where uid=500 and token=14243385100413148122; Returns this result, which is a completely different record. +---+-++ | token

Re: Mysql Performance Question

Rainer Sip wrote: I'm running a community site (Xoops) on Mysql 4.0.14. I found that the speed of my site is slow during peak hours, when there are 450 concurrent uers hanging on the site. Mytop showed that the queries per second maxed at 500. I believe this could be higher, provided

Re: C API

Priyanka Gupta wrote: Is there a way to have a common C API for MySQL and Oracle. I am writing some software that I would like to work with both MYSQL or Oracle as the backend server? priyanka _ Enjoy MSN 8 patented spam

Datanamic works great for attractive schema diagrams

It reads a MySQL database and will even form relationships based on matching column names. Totally cool. Thanks, Victor. On Tuesday, October 21, 2003, at 09:13 AM, Victor Pendleton wrote: Have you tried datanamic.com? -Original Message- From: Jeff Weeks [mailto:[EMAIL PROTECTED]

RE: mysql Digest 21 Oct 2003 17:33:01 -0000 Issue 2672

Hi, I have a table SalaryInfo as below Salary | Department | Level 50 | RD| Director 3 | Maintenance| Groundsman .. I want to know what level in each department makes the highest salary and how much that salary is? Something like: SELECT Salary, Level, Department FROM

Uninstalling MySQL

Hi, I´ve just installed MySQL and I wanna know how to uninstall it. I tried to look for uninstall in the manual and at MySQL WebSite but I did not found. Thanks. Tag Line Francis Fernandes Ferreira

Re: Strange results

Is that a character field? If it is, you forgot the quotes, and the string was converted to a number. 16 significant digits match. Joakim Ryden wrote: Hey folks - can anyone explain this behaviour: mysql select token, spam_hits, innocent_hits from dspam_token_data where uid=500 and

Re: C API

Hi Priyanka, BTW, which programming language you are using? In PHP there is a PEAR DB utitlity which acts as the database abstraction layer. Regards, Hardik Doshi walt [EMAIL PROTECTED] wrote: Priyanka Gupta wrote: Is there a way to have a common C API for MySQL and Oracle. I am writing

Re: Strange results

It's a BIGINT(25). On Tuesday 21 October 2003 11:58 am, gerald_clark wrote: Is that a character field? If it is, you forgot the quotes, and the string was converted to a number. 16 significant digits match. Joakim Ryden wrote: Hey folks - can anyone explain this behaviour: mysql

Re: Mysql Performance Question

You need to figure out what's slowing down your application. It could be expensive queries which in turn could be caused by missing indexes. It could be that the machine is too slow or the configuration of MySQL is sub-optimal. In this case, the machine looks fine. I can't comment on queries or

libmysqlclient.so

Any ideas what packages install this library? I used the RPM to try and install MySQL-client on my redhat machine, but the libmysqlclient did not show up in /usr/lib - so I am wondering which RPM I need to get this file? Thanks, Matt -- MySQL General Mailing List For list archives:

Re: InnoDB or OS restriction?

Hi Alex, What user is the mysql daemon running as? Are there any limits on that user or user class (/etc/login.conf). Just because you have raised the kernel limits does not mean they are raised for the user. Can you login as that user and type limit and get something like - %limit cputime

Use of uninitialized value in join or string at ./dump_members.pl line 35.

Hi, I'm reading MySQL by Paul DuBois When I run dump_members.pl I get: Use of uninitialized value in join or string at ./dump_members.pl line 35. Line 35 is the print line before. while (my @ary = $sth-fetchrow_array ()) { print join (\t, @ary), \n; } I just can't see which value is

Re: libmysqlclient.so

At a certain time, now past [Oct.21.2003-12:24:30PM -0400], [EMAIL PROTECTED] spake thusly: Any ideas what packages install this library? I used the RPM to try and install MySQL-client on my redhat machine, but the libmysqlclient did not show up in /usr/lib - so I am wondering which RPM I need

Re: libmysqlclient.so

the mysql-devel rpm installs it. Kelley Matt Babineau wrote: Any ideas what packages install this library? I used the RPM to try and install MySQL-client on my redhat machine, but the libmysqlclient did not show up in /usr/lib - so I am wondering which RPM I need to get this file?

Re: libmysqlclient.so

Thanks everyone! I installed MySQL-shared-X and it worked! On Tue, 2003-10-21 at 15:48, Kelley Lingerfelt wrote: the mysql-devel rpm installs it. Kelley Matt Babineau wrote: Any ideas what packages install this library? I used the RPM to try and install MySQL-client on my redhat

Re: Use of uninitialized value in join or string at ./dump_members.pl line 35.

My Guess: Jerry Rocteur wrote: Hi, I'm reading MySQL by Paul DuBois When I run dump_members.pl I get: Use of uninitialized value in join or string at ./dump_members.pl line 35. Line 35 is the print line before. Your select probably failed, while (my @ary = $sth-fetchrow_array ()) and

Re: Strange results

On Tue, 21 Oct 2003 11:58:57 -0700, Joakim Ryden [EMAIL PROTECTED] wrote: It's a BIGINT(25). Well there you go. Your number is too big for the field. BIGINT(25) can (theoretically) DISPLAY up to 25 digits, but it is still bounded by MySQL's internal limits, as documented here:

Updating help.

Hi, Can somebody tell me if there is a way to accomplish this update without locking both tables. UPDATE t1, t2 SET t2.a = t1.a WHERE t2.id = t1.id t1 is not being updated yet it becomes locked and does not allow any read queries until it is done. Can somebody help? Thanks, Mike.

Re: Uninstalling MySQL

It all depends on how you installed it. If it is an rpm, use rpm -e to un-install it. If from a tarfile, find out where the files were written, and remove them. [EMAIL PROTECTED] wrote: Hi, I´ve just installed MySQL and I wanna know how to uninstall it. I tried to look for uninstall in the

unable to connect after log in

I have a connection problem that I have been unable to solve after searching the web and the mysql mailing-lists. I'm connecting to a local database using PHP. It's a pretty simple and straightfoward setup, a user logs in and the links they have access to are displayed (change user info,

how to change border color and type of mysql_row command!!!!?

Hi, im using this script to show in a table the results of a query how can i change the border color and type is this posible?? if (mysql_num_rows($qry) 0) { for ($i = 0; $imysql_num_fields($qry); $i++) { echo td align=centerstrong . mysql_field_name($qry, $i) . /td; } }

gemini

Someone recently asked about Gemini tables on this list and it got me curious about what ever happened to that technology... NuSphere still seems to exist, and they still sell their PHPEd product along with the NuSphere Technology Platform which appears to contain a build of MySQL. Did they

Need help constructing query ...

Hi, I have a table full of logged urls and ip addresses. The following query returns all the urls and the number of requests. How would I modify it to return unique requests based on distinct ip addresses? select url, count(*) as pageviews from table group by url order by pageviews desc --

Re: Need help constructing query ...

Hi, I have a table full of logged urls and ip addresses. The following query returns all the urls and the number of requests. How would I modify it to return unique requests based on distinct ip addresses? select url, count(*) as pageviews from table group by url order by pageviews desc

Replication RO/RW DBs on same server.

Hello, I have spent the last few hours searching through the archives for help with this question, and have also been reading the MySQL documentation, so please excuse me if I am being monumentally blind and missing something obvious. I am trying to set up a MySQL installation like so:

mysql to mssql query

Does anybody know the equivalent of this query in mssql: SELECT * FROM myTable WHERE date_field = DATE_SUB('2003-10-19', INTERVAL 7 DAY); For this project we are pulling records off a MS SQL db, and I need to figure a way to return all records for the week. Any help is appreciated. --

Re: mysql to mssql query

Well, even if you don't find an alternative for that syntax, you could always do the date subtraction in application space and make the query like this: SELECT * FROM myTable WHERE date_field = '2003-10-12' - Gabriel On Tuesday, October 21, 2003, at 05:49 PM, DevList wrote: Does anybody

RE: mysql to mssql query

If I understand your question correctly, you're wanting to grab the records where the date is greater than or equal to a date plus 7 days. If so, then: SELECT * FROM myTable WHERE date_field = CAST('2003-10-19' AS DATETIME) + 7 Or you can use the DATEADD function: SELECT * FROM myTable WHERE

RE: mysql to mssql query

Oops, you are subtracting the date, so use - 7 instead of + 7... Dan -Original Message- From: Dan Lampkin [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 21, 2003 5:05 PM To: 'DevList'; 'mySQL Mailing List' Subject: RE: mysql to mssql query If I understand your question correctly,

Config problems - logging

Hey all- I've been trying to track down some slow queries but I cant get the logging turned on properly, for some reason my server just wont create a slow query log and then when I tried mysqldumpslow, it gave me an error that I have no basedir setup. Has anyone had any similar problem that can

Re: Need help constructing query ...

- Original Message - From: Daniel Clark [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Tuesday, October 21, 2003 2:33 PM Subject: Re: Need help constructing query ... : Hi, I have a table full of logged urls and ip addresses. The following : query returns all the

Very large table with broken index

Hello All-- We have a particularly large MyISAM table on an older MySQL (3.23.56) on an older Linux (RedHat 6.2). The table is always growing (data is never removed, except when we move it and start a new one). Yesterday one of the indexes started acting weird, so I took a look, and the .MYI

RE: Need help constructing query ...

Then I think you want SELECT url, COUNT(DISTINCT ip_address) FROM tablename GROUP BY url; -Original Message- From: John Kelly [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 21, 2003 3:45 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: Need help constructing query ...

How do I have 3.23.54 and 4.0.15 running at the same time?

Hi, That's basically my question. I want to be able to run the 2 releases on the same OSX 10.2.8 machine. Is there a way? Thanks Juan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

What is best hardware for server performance

So I think these are the only options, but if someone has another idea I'd be glad to hear it. Our current server just isn't handling the load anymore so, it has single processor Option 1: Single server with dual processor and change from IDE to SCSI Option 2: One server with mysql on

Re: What is best hardware for server performance

Travis Reeder wrote: So I think these are the only options, but if someone has another idea I'd be glad to hear it. Our current server just isn't handling the load anymore so, it has single processor Option 1: Single server with dual processor and change from IDE to SCSI Option 2: One

Re: Need help constructing query ...

: -Original Message- : From: John Kelly [mailto:[EMAIL PROTECTED] : Sent: Tuesday, October 21, 2003 3:45 PM : To: [EMAIL PROTECTED] : Cc: [EMAIL PROTECTED] : Subject: Re: Need help constructing query ... : : : - Original Message - : From: Daniel Clark [EMAIL PROTECTED] :

Re: Mysql Performance Question

Hi Rainer, You might get more improvement by optimizing your application and queries than by tuning hardware or MySQL. :-) About switching to InnoDB, are you doing lots of writes that are causing locked tables? e.g. What's the ratio of Table_locks_immediate to Table_locks_waited in SHOW STATUS?

Update Syntax

Please tell me it ain't so... I am writing a Lotus Nots agent to feed data directly into a MySQL table. The agent needs to either insert a new record or update an existing record depending on whether a document in Nots is new or updated. Because this app may be ported over to a DB2 server, I am

Re: Update Syntax

Can you use REPLACE? Kelley Randy Chrismon wrote: Please tell me it ain't so... I am writing a Lotus Nots agent to feed data directly into a MySQL table. The agent needs to either insert a new record or update an existing record depending on whether a document in Nots is new or updated.

Re: What is best hardware for server performance

It seems mostly to be mysql pinned, not the app. like 99% mysql until all data is processed and keeps going up when data coming in is more than can be processed. What could I change in my.cnf to get better performance? I just have a default mysql install (4.0). Travis Daniel Kasak wrote:

SOLVED Re: Strange results

This was indeed the problem. See below. It turns out MySQL's BIGINT doesn't handle all that big of an INT. :-/ Many thanks to bluejack. --Jo On Tuesday 21 October 2003 12:51 pm, bluejack wrote: On Tue, 21 Oct 2003 11:58:57 -0700, Joakim Ryden [EMAIL PROTECTED] wrote: It's a BIGINT(25).

cnf file reference

Hello All, I've looked online and searched through many threads in the lists and can't find a good reference for the cnf file. I've found the page with the command line options, but there are options I see in the list threads that aren't in the page. Is there a reference that lists all of

Re: What is best hardware for server performance

Travis Reeder wrote: It seems mostly to be mysql pinned, not the app. like 99% mysql until all data is processed and keeps going up when data coming in is more than can be processed. What could I change in my.cnf to get better performance? I just have a default mysql install (4.0). Travis

storage of values in mysql

Hello, I need to store the charater value as well as some float value in the varchar defined field..is there any other way of decalaration of the field that i can store the character as well as float value ? Regards, Uma -- MySQL General Mailing List For list archives:

Re: Mysql Performance Question

Thanks for your input. I'll try give my.cnf a try. I'm not technical at all and am unable to describe the queries myself. Attached some output from the server (Sorry for the long post): SHOW STATUS - +--++ | Variable_name|

[SubQuery] BUG ??

hello I have a very strange case where the my result depend on the fields I want return from query :-( A simplified query (Extracted the Sub queries out for read easyness): select POL1.*,PRO.ID from oPositionLine POL1 , (SUB2) T4 join pproduct PRO on POL1.ProductID=PRO.ID where

Access my mysql db remotely...

i want to create a user who access from internet remotely to my db (outside firewall)? what is the solution then? how can i define the user accoutn? [EMAIL PROTECTED] Cheers, yenonn -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: