3 000 000 requests for last 14 days...

Hi, I've got very astonished to see with phpMyAdmin my MySQL database has received more than 3 Millions conexions for this last 14 days. But I don't knowwhich database is reponsable for this. Is there a mean to know connexion rate per database ? Thanks. -- MySQL General Mailing List For list a

Webobjects and mySQL

Hello -- New to mysql and the cocoa development environment. I wonder if anyone can point me in the direction of documentation for mysql support for webobjects. The webobjects page says that it will support JDBC 2 and 4, whereas mysql says it supports JDBC 3? Not sure if I'm reading this right

Notice: Intel Accelerator software corrupts files on large drives

If anyone is having problems with corrupted files on Windows machines with drives > 137GB, the culprit is likely a copy of the Intel Accelerator software if you happen to have it installed. The Intel Accelerator will corrupt files when it writes to sectors beyond 137gb. Intel has an update out

problem with mysqldump, ustf8 with mysql 4.1

I need to backup a mysql 4.1 database with UTF8 characters using InnoDB and then restore the backup on another machine I tried the following (same machine - Windows XP) mysqldump.exe -u root stp2 city > d1.sql# backup stp2.city mysql.exe -u root t1 < d1.sql

Re: Fw: Reversing the group...

David Scott wrote: Putting it simply, I want the last record from the group, not the default first. Cheers -- Dave Dave: I do not think your first query will give you the desired results either. You cannot depend on which page_id you get from group by - this depends on what decision the optimi

importing after mysqldump --xml

Is there any (easy) way to import the data created by using mysqldump -xml ? I'd like to use the xml feature to export from machine A, massage the data, import into machine B XML works well for my application's needs in terms of massaging the data. Thanks, Neal Katz

Update statement with LIKE

Can I use LIKE in an UPDATE statement when it is not in the WHERE clause? I only know what the attribute name will end with (may be prefixed). Example: UPDATE table SET LIKE '%donut' = valueColumn1 WHERE condition1 = value1; Respectfully, Ligaya Turmelle -- MySQL General Mailing List For lis

Re: Finding Most Recent Record for Sensor Problem Solved

On Tue, 09 Mar 2004 00:41:19 -0500, Michael Stassen wrote: > Did anyone refer you to the following page in the manual? > > > I admit to feeling a little foolish here. My "solution" came from combining a couple of similar query for

Re: MySql

probably more then you possibly need. dan kavitha kutty wrote: Sir, I am a student currently doing my final year MCA project.My project is in JSP and MySql.I have not studied MySql before.But I got more information about this database from MySql.com.But I have a doubt How many number of ta

MySql

Sir, I am a student currently doing my final year MCA project.My project is in JSP and MySql.I have not studied MySql before.But I got more information about this database from MySql.com.But I have a doubt How many number of tables are possible in one MySql database?

Re: Pricelist

They most probably got it from this list, i too have had virus emails sending emails with my email and name in the header !! but i dont have a virus !! > Sturgeon, Jon wrote: >> [EMAIL PROTECTED] wrote: >> >> Look it through >> >> >> Can the list administrator figure out who this moron is and

Re: InnoDB tables using 90% cpu

Sasha Pachev wrote: Cliff wrote: The query is running dramatically slower than the MyISAM query, sometimes even causing mysql to freeze for a while. I searched this list and found a few people saying that on FreeBSD mysql should be compiled using linux pthreads if you are using InnoDB or else I

Re: Pricelist

Sturgeon, Jon wrote: [EMAIL PROTECTED] wrote: Look it through Can the list administrator figure out who this moron is and remove him from the list? Jon: This so-called "moron" is Miguel Soloranzo - the guy in charge of MySQL Windows builds. So blocking his posts to the list would be a bad ide

Re: InnoDB tables using 90% cpu

Cliff wrote: The query is running dramatically slower than the MyISAM query, sometimes even causing mysql to freeze for a while. I searched this list and found a few people saying that on FreeBSD mysql should be compiled using linux pthreads if you are using InnoDB or else I would get this exact pr

Re: How to do automatic backup?

cron schedule it ? > Hi, > > Is there any function for MySQL database to do automatic backup? > Let say, i can set the time, that MySQL will automatic backup > between 7.00pm-8.00pm everyday. > > Thank you very much. > > > regards, > > florence > > > Thank you very much. >

How to do automatic backup?

Hi, Is there any function for MySQL database to do automatic backup? Let say, i can set the time, that MySQL will automatic backup between 7.00pm-8.00pm everyday. Thank you very much. regards, florence Thank you very much. regards, florence Y! Asia presents Lava

Re: mysqladmin processlist and pid

Hi Tom, You can't. MySQL's own thread ids are sequential. The OS pids are random. There's no connection between them. Besides, mysqld is really only running in a single "real" process, it's just that LinuxThreads shows each thread as a "process." Matt - Original Message - From: "To

Re: Security

Thank you for the kind response. May be I did not clearly ask the question. The user table in mysql database is used to set-up a user and password. Once I set-up my tables (customer, customer orders, customer order details, etc) in say abc database what will I have to do to make sure when customer

Re: mysql 1gb memory limit?

Donny Simonton wrote: Peter, There is no 1 gig limit that I am aware of. I have been using MySQL 4.1 since the day it was released. And when 4.1.1 came out I switched about half of our machines to using it, and when 4.1.2 comes out in the next week or so, I will switch our stuff that is using 4.1

Re: Security

Heya, Those are the default databases that comes with the setup. the "mysql" database holds info on mysql accounts. the "test" is an empty database. You should create a new database "CREATE DATABASE customers" then "use customers"... after that... you can setup the tables you mentioned. Goo

Security

I have used access in the past and now I have started using MySQL. I have customer table, customer order table, customer order detail table. How would I make sure that when a particular customer log-in he/she sees only the account that is set-up for them. What confused me is that MySQL has a dat

Re: Error on startup

Heya, Check the permission on that directory. Paul At 12:36 AM 3/9/2004, Lorenzo Rossi wrote: Hi. My system is Slackware 9.1. MySQL is the default version installed on Slackware cdrom while system installation, so I hope all the path are ok :) Then launched mysqld_install_db... but when I try t

Re: "Can't create thread"

Michael Bacarella wrote: We recently started getting "Can't create thread" errors since switching to Debian. On Red Hat 8.0 we were able to spawn more than 400 mysql threads and never encountered this error. mysql 3.23.56 compiled from source, stock kernel. (2GB of RAM) Now we get it all the time

RE: mysqldump JOIN?

I've tried about 20 different variations with no luck except when i modify the where statement to use only one table. Then it works fine but it's not the results i want. I was suspecting exactly what you said: you can only refer to one table, and the first one you specify at that. I was trying to a

Re[2]: Optimizing Queries

Hello Chris, Wednesday, March 10, 2004, 12:48:02 AM, you wrote: CF> Thanks for the email. I created a multi-field index using the fields that CF> are in the query and the query only took 0.91 seconds. That's better than 9 CF> minutes and definitely under 30 seconds. Glad to hear it. Farewell MSS

RE: Optimizing Queries

And Chris, maybe now you can get rid of some of those single indexes and drop the entire size down quite a bit. Donny > -Original Message- > From: Chris Fossenier [mailto:[EMAIL PROTECTED] > Sent: Tuesday, March 09, 2004 6:48 PM > To: 'Richard Davey'; [EMAIL PROTECTED] > Subject: RE: Opti

RE: Optimizing Queries

Rich, Thanks for the email. I created a multi-field index using the fields that are in the query and the query only took 0.91 seconds. That's better than 9 minutes and definitely under 30 seconds. Thanks. Chris. -Original Message- From: Richard Davey [mailto:[EMAIL PROTECTED] Sent: Tue

Re: mysql unexpectedly dying

Ian Pushee wrote: I am running mysql version 3.23.49 on a Debian Linux box. Recently (about a month ago) I noticed that alot of my databse access scripts were failing intermitently. It was anoying, but I have only now gotten the time to look into the problem. It turns out that my mysql server p

Re[2]: Date Problem

Hello Peter, Wednesday, March 10, 2004, 12:16:51 AM, you wrote: PB> But that is adding two days, the original query was to add two PB> months, so presumably it should be "INTERVAL 2 MONTH" - but beware PB> that MySQL does some It should, sorry, I'm too used to the UK date format (even though I k

Re: Date Problem

Richard Davey wrote: Hello Eric, Tuesday, March 9, 2004, 11:46:23 PM, you wrote: ES> We have a table with a Date Time field and we need to update only the date ES> portion of that field. ES> We have table a with field Foo with value '2004-01-01 12:15:00' and a date ES> '2004-03-01' and we need t

Query INTO OUTFILE Problem

Hello MYSQL Genii, I am trying to run a query that returns results to a .csv file using mysql's 'INTO OUTFILE'. The problem is whenever I write the file I lose my the field names for each column. For example, when I run the query at command line mysql: mysql> SELECT distinct count(*), Product FRO

Re: Date Problem

Hello Eric, Tuesday, March 9, 2004, 11:46:23 PM, you wrote: ES> We have a table with a Date Time field and we need to update only the date ES> portion of that field. ES> We have table a with field Foo with value '2004-01-01 12:15:00' and a date ES> '2004-03-01' and we need to change the date por

Date Problem

We have a table with a Date Time field and we need to update only the date portion of that field. We have table a with field Foo with value '2004-01-01 12:15:00' and a date '2004-03-01' and we need to change the date portion of Foo to the date and leave the time part alone. So Foo would change

mysqldump JOIN?

I would like to do the following: mysqldump -w "users.user_id=enews.user_id" sotx users > c:/enews_users.sql Ideally this would dump all records in table users where the user_id field value is also present in the enews table. Is this possible? TIA, Dan -- MySQL General Mailing List For list a

Re: DateDiff function in SqlServer ... How do it in MySql ?

Michael Stassen said: > > Gabriel Alessandria wrote: > >> I am a user of Microsoft Sql Server and use very much the function >> Datediff (interval, fecha1, fecha2) to extract differences between two >> dates, in years, days, months, hours, etc >> >> I am a beginner with MySql and i can't see the wa

Mysql timed actions... Confused

Here is a log of query times I made when a certain page is loaded that uses php and mysql, does mysql 4 do some sort of scheduled maintenance I am not aware of? 2004/03/08 16:11:27OK, 77569 bytes0 seconds 2004/03/08 16:11:37OK, 77575 bytes0 seconds 2004/03/08 16:13:31OK, 77569

Re: mysql 5.0 production release

Matthew, - Original Message - From: ""Matthew Son"" Newsgroups: mailing.database.myodbc Sent: Tuesday, March 09, 2004 10:26 PM Subject: mysql 5.0 production release > Hello, > > Can you give an estimate of when 5.0 will be released for production? my guess is that 4.1 will be declared '

extracting .tgz archive for maxdb

Hello! I was just wondering if I am the only one that's having problem extracting maxdb .tgz file or there is someone else out there facing similar problem. tar zxvf filename.tgz or gunzip filename.tgz , tar xvr filename.tar or zcat filename.tgz | tar xvf - should work, but i tried all and i

Re: One thread takes over the whole server

Thanks for the reply What I need to know is if there is a way to prevent the server from geting stuck after a missbehave query like the example is sent? The problem is all other clients go so slow that no work can be done and no new connections can be made. The server is a DUAL XEON 3GH 1GB RAM,

Re: InnoDB tables using 90% cpu

The query is running dramatically slower than the MyISAM query, sometimes even causing mysql to freeze for a while. I searched this list and found a few people saying that on FreeBSD mysql should be compiled using linux pthreads if you are using InnoDB or else I would get this exact problem. Has th

Re: Pricelist

[EMAIL PROTECTED] wrote: >> Look it through Can the list administrator figure out who this moron is and remove him from the list? Jon -- -- FutureSoft, Inc. 12012 Wickchester Lane, Suite 600 Houston, TX 77079 If you no longer

Re: empty tables return non-empty result sets

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Randall Cayford wrote: > JDBC driver: mysql-connector-java-3.0.11-stable-bin.jar > > > Randall Cayford wrote: > I am new to mysql so this may be an obvious mistake on my part... I am using JDBC to acess some mysql data tables. I am h

Too many tables. MySQL can only use 31 tables in a join

Hi guys, I'm new to MySQL, it's been just few days since I've installed it and started playing with it. I'm migrating web application from another database which gives us too many problems. So far I've successfully moved the structure and data across and running field tests. What surprised me a

Re: DateDiff function in SqlServer ... How do it in MySql ?

Gabriel Alessandria wrote: I am a user of Microsoft Sql Server and use very much the function Datediff (interval, fecha1, fecha2) to extract differences between two dates, in years, days, months, hours, etc I am a beginner with MySql and i can't see the way to do this function .. How can I extract

Pricelist

Look it through -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

ANN: New VBMySQLDirect API

VBMySQL.com is pleased to announce the launch of a new projects page at http://projects.vbmysql.com. The first (and flagship) project is VBMySQLDirect. VBMySQLDirect is a new MySQL C API wrapper written by longtime site contributor Robert Rowe. VBMySQLDirect is a fork of the MyVbQl API and is a

mysql 5.0 production release

Hello, Can you give an estimate of when 5.0 will be released for production? Thanks, Matthew Son

RE: mysql 1gb memory limit?

If you turn on highmem support you can easily get 24gigs of memory. I think with 2.6, it's up to 64 gigs. But there are even patches for 512gigs. Not sure if those patches work, but the highmem support works just fine. Donny > -Original Message- > From: Igor Dorovskoy [mailto:[EMAIL

empty tables return non-empty result sets

I am new to mysql so this may be an obvious mistake on my part... I am using JDBC to acess some mysql data tables. I am having trouble with the following code: Statement s; ResultSet rset; longcorrectedclock; s = conn.createStatement(); rset = s.executeQuery("Sel

DateDiff function in SqlServer ... How do it in MySql ?

I am a user of Microsoft Sql Server and use very much the function Datediff (interval, fecha1, fecha2) to extract differences between two dates, in years, days, months, hours, etc I am a beginner with MySql and i can't see the way to do this function .. How can I extract for example difference of

Select problem with BigInt

I am new to mysql and am converting an existing program. I have encountered what appears to be a problem with bigints I have a large integer number (milliseconds since 1970) which is 13 digits. So I tried to store it in a table as a bigint type. Storing works fine. When I try to retrieve it

RE: mysql 1gb memory limit?

Hi Donny, What server hardware do you use to support 24G RAM over 32-bits limit? Please advise your choice of hardware and software configuration and how long and reliable it works for you on hyperthreaded Xeons? Best regards, Igor ua3qrz -Original Message- From: Donny Simonton [mailt

Re[3]: Update field conditionally

> Hello Terry, > > Tuesday, March 9, 2004, 6:25:00 PM, you wrote: > > TR> Good point, Richard. I was perhaps in a little bit too much of a > > hurry > TR> putting that together, and didn't even consider that! > > No worries. One other thought that occurred to me that might help with > the o

Re[2]: Update field conditionally

Hello Terry, Tuesday, March 9, 2004, 6:25:00 PM, you wrote: TR> Good point, Richard. I was perhaps in a little bit too much of a hurry TR> putting that together, and didn't even consider that! No worries. One other thought that occurred to me that might help with the original problem is as follo

Re[2]: Optimizing Queries

Hello Chris, Tuesday, March 9, 2004, 6:15:56 PM, you wrote: CF> Why does it only use the one index? It will evaluate the best index to use for the query and if all you have are single-field indexes, it can only select one of those. From the MySQL manual: "If a multiple-column index exists on c

Re: Update field conditionally

See below: --Original Message- > Hello Terry, > > Tuesday, March 9, 2004, 5:11:00 PM, you wrote: > > I know you have some solutions to the original problem already, but I > just wanted to make one small observation: > > TR> The fields are to be CounterCode (Varchar 10), Count

RE: Optimizing Queries

Why does it only use the one index? Chris. -Original Message- From: Richard Davey [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 09, 2004 11:00 AM To: [EMAIL PROTECTED] Subject: Re: Optimizing Queries Hello Chris, Tuesday, March 9, 2004, 4:38:00 PM, you wrote: CF> I'm trying to deter

Re: Update field conditionally

See below: --Original Message- > If it was me writing the code, I'd use two different update statements: > > a) an UPDATE to initialize the DateTime to Now() and set the counter to > 1 > when the page is first hit > b) another UPDATE to increment the counter on all of the rema

Re: JDBC timeout after 4.0.8 -> 4.0.18 upgrade?

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Eric B. wrote: > Hi, > > I've recently upgraded from 4.0.8a to 4.0.18, and am running into a strange > error in the JDBC connector. If the DB connection is unused for a period of > time (don't konw the minimum amount of time, but 8-12 hours defintiel

Re: Update field conditionally

Hello Terry, Tuesday, March 9, 2004, 5:11:00 PM, you wrote: I know you have some solutions to the original problem already, but I just wanted to make one small observation: TR> The fields are to be CounterCode (Varchar 10), CounterValue (Int 10) and TR> CounterStartDateTime (DateTime). Using a

JDBC timeout after 4.0.8 -> 4.0.18 upgrade?

Hi, I've recently upgraded from 4.0.8a to 4.0.18, and am running into a strange error in the JDBC connector. If the DB connection is unused for a period of time (don't konw the minimum amount of time, but 8-12 hours defintiely triggers the problem), I get the following error msg in my stack: **

Re: Update field conditionally

Thanks, Jeremy What I actually needed was: UPDATE Table SET CounterValue = CounterValue+1, CounterStartDateTime = IF(CounterStartDateTime IS NULL, Now(), CounterStartDateTime) This prevents it going back to NULL if the value is already not NULL. Thanks again. Terry --Original Messa

Re: Update field conditionally

If it was me writing the code, I'd use two different update statements: a) an UPDATE to initialize the DateTime to Now() and set the counter to 1 when the page is first hit b) another UPDATE to increment the counter on all of the remaining hits Something like this (assuming Java is your programmi

RE: Optimizing Queries

> Chris, > Is it faster if you remove the 'IS NOT NULL'? I know that's not the > > results > you want, but we have found that is NOT NULL will do a full scan. But we > normally use it with a join. Since you are using one table, I'm not sure > how it would affect it. > > Donny This is an intere

Update field conditionally

> UPDATE Table SET CounterValue = CounterValue+1, CounterStartDateTime = > (IF CounterStartDateTime IS NULL, Now()) > > without success. It looks like you just have the syntax wrong. Try: UPDATE Table SET CounterValue = CounterValue+1, CounterStartDateTime = IF(CounterStartDateTime IS NULL, N

Update field conditionally

Using v4.0.15 on WinNT under Apache. For my sins, the client has insisted on creating a page counter! The fields are to be CounterCode (Varchar 10), CounterValue (Int 10) and CounterStartDateTime (DateTime). Setting up the table is no problem. However, client wants to have the CounterStartDat

mysql_close needed after a failed mysql_real_connect ?

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi The docs aren't clear on this. Is mysql_close needed on a MYSQL struct previously initilized with mysql_init after a failed mysql_real_connect ? (which returned NULL) - -- Mihai RUSUEmail: [EMAIL PROTECTED] G

Re: Optimizing Queries

Hello Chris, Tuesday, March 9, 2004, 4:38:00 PM, you wrote: CF> I'm trying to determine the best way to optimize the query below. Right now CF> it is taking around 9mins and we need it to take no more than 30 seconds (we CF> can get it under 30s on MS SQL): CF> | 1 | SIMPLE | speedlink |

RE: Optimizing Queries

Chris, Is it faster if you remove the 'IS NOT NULL'? I know that's not the results you want, but we have found that is NOT NULL will do a full scan. But we normally use it with a join. Since you are using one table, I'm not sure how it would affect it. Donny > -Original Message- > From

Re: subquery and order by

"van der Scheun, Willem (GXS)" <[EMAIL PROTECTED]> wrote: > I'm new to mysql and I just installed 4.1.1 and ran into trouble combining a > subquery and 'order by'. I guess the 3 queries below show my problem > > mysql> SELECT host,facility,priority,date,time FROM logs WHERE host=(select > ip from h

Optimizing Queries

Hello, I'm trying to determine the best way to optimize the query below. Right now it is taking around 9mins and we need it to take no more than 30 seconds (we can get it under 30s on MS SQL): explain select count(distinct(phone)) as TOTAL FROM speedlink WHERE county in('247','085','145','285',

RE: subquery and order by

I'd never actually tried that before, it definitely seems like a bug to me. SELECT * FROM WordScoreTemp WHERE word = ( SELECT word FROM Word WHERE word = 'mysql' ) The above works fine. SELECT * FROM WordScoreTemp WHERE word = ( SELECT word FROM Word WHERE word = 'mysql' ) order by score;

RE: Newbie Q: How do I get a COUNT of a computed field?

> From: Victoria Reznichenko [mailto:[EMAIL PROTECTED] > What error message did you receive? Your query worked fine for me: When I say: SELECT IF(t2.status IN(2,3,4), "open", "closed") t2st, COUNT(t2st) FROM tasks t2 GROUP BY t2st; I get: #1054 - Unknown column 't2st' in 'field list

subquery and order by

Hi, I'm new to mysql and I just installed 4.1.1 and ran into trouble combining a subquery and 'order by'. I guess the 3 queries below show my problem mysql> SELECT host,facility,priority,date,time FROM logs WHERE host=(select ip from hostip where host='ams602.avctr.gxs.com'); +---+---

Re: table name is lower case if there is an index on it (4.0.18 )

"Bluemel, Marco" <[EMAIL PROTECTED]> wrote: > I have a problem with mysql 4.0.18 on WindowsXP > I set the lower_case_table_names=2 as it is mentioned for windows > t the mysql website. > > (before I'm using version 4.0.15 and had set it to 0) > so the tablenames should be stored in this case as I w

Re: Saving file into database

Check this article: http://php.dreamwerx.net/forums/viewtopic.php?t=6 Port code/design to perl or whatever client language you want.. mysql could care less once it's got the data (correctly) On Tue, 9 Mar 2004, Isa Wolt wrote: > Hi, > > I would like to save a binary file into a mysql databas

Re: Newbie Q: How do I get a COUNT of a computed field?

"Austin Hastings" <[EMAIL PROTECTED]> wrote: > I'm not sure if this is a bug or a user failure, so I'm going to ask here > before doing anything rash. > > I'm trying to classify a single field using the IN() expression into two > groups: > >IF(t2.status IN(2,3,4), "open", "closed") > > I'd l

RE: Newbie Q: How do I get a COUNT of a computed field?

Andy, Your first suggestion hit the nail right on the head. Using the column number does the trick. Your second entry was incomprehensible to me, and to mysql as well. It reports an error. (Frankly, if that worked it would be so much magic I'd have to uninstall MySQL for being smarter than me. :-

RE: mysql 1gb memory limit?

Peter, There is no 1 gig limit that I am aware of. I have been using MySQL 4.1 since the day it was released. And when 4.1.1 came out I switched about half of our machines to using it, and when 4.1.2 comes out in the next week or so, I will switch our stuff that is using 4.1.x to that as well. W

Span a database transaction across multiple CGI scripts

Hi all Is it possible to span a database transaction across multiple CGI scripts? That is, start transaction and lock some records in one CGI script and update and commit in another CGI script. Here is an example: I have a accounts database. Only one user should edit a given account at any given

RE: mysql 1gb memory limit?

Donny- While I appreciate your bluntness, I did have this issue a time back with 4.1.x. In your email, the reference to big-tables stated that it prevents table fulls. This would dictate that it does affect limits, or working around them , likely a limit set forth by temporary tables (in memo

Newbie Q: How do I get a COUNT of a computed field?

I'm not sure if this is a bug or a user failure, so I'm going to ask here before doing anything rash. I'm trying to classify a single field using the IN() expression into two groups: IF(t2.status IN(2,3,4), "open", "closed") I'd like to GROUP those together so I can COUNT them. When I try

Re: 4.0.15 replication failure ('Event too big')

Mark Swanson <[EMAIL PROTECTED]> wrote: > > I am having replication troubles with 4.0.15. Some info: > > mysql> show slave status; > | www.x.com | replicon| 3306| 60| ns1-bin.001 | > 16958428| linux-relay-bin.011 | 623915| ns1-bin.001 >

processlist: state is "Opening table"

filter: select, mysql Solaris 3.23.40 connections using perl, jdbc, odbc. Yesterday, we experienced a rare mysqld failure where all connections where in the state="Opening table". Normally our 200+ connections are in state="sleep". The Time field from command "show processlist" showed each co

RE: mysql 1gb memory limit?

Peter, I have never heard of such a limit and I have been using it for a while. And --big-tables, which BTW, you can't easily search for on mysql.com, because of the minimum 4 characters in full text indexing, says this: --big-tables Allow large result sets by saving all temporary sets on file.

Opinion about MaxDB, and Redhat

Hello, I only have one server available to be set up to handle a lot of data. I have looked through some documentation, and am a little confused. So I thought I would get the opinion of someone who has used this stuff. First will I see a performance different on a 2 GHz Intel w/ 500 MB Ram, r

RE: mysql 1gb memory limit?

Yes. There's a limit. Start mysql with --big-tables. I think there's a finer way of doing it, just don't remember what it was ;) P "Donny Simonton" <[EMAIL PROTECTED]> 03/09/2004 08:00 AM To: "'Jigal van Hemert'" <[EMAIL PROTECTED]>, <[EMAIL PROTECTED]> cc: S

Re[2]: Performance problem with 4.0.18

VP> Can you supply us with an example? Some explain plans to corroborate your VP> reported slowness. Of course. Here is the query. It is big and ugly, I'm curently working on system optimization. But why the same query is good at one machine and bad at another? SELECT ... FROM positionReports p

RE: Performance problem with 4.0.18

Can you supply us with an example? Some explain plans to corroborate your reported slowness. -Original Message- From: Andrey Chernyh To: [EMAIL PROTECTED] Sent: 3/9/04 3:35 AM Subject: Performance problem with 4.0.18 Hello All! After we converted our tables from MyISAM to InnoDB the data

RE: mysql 1gb memory limit?

I've got a server with 24 gigs in it and it works just fine. About 3 with 8 gigs and a few with 2 gigs. All running 4.1.1. And all of them run without any problems on Xeon's with Hyperthreading. Donny > -Original Message- > From: Jigal van Hemert [mailto:[EMAIL PROTECTED] > Sent: Tuesd

Re: Spanish Accents

> correctly on my web page. Querying the database with the mysql client I see > that the character ó in the word Supervisión is ok but when my web app > queries the database the web page displays Supervisi¢n. The ó character > seems to be switched for the ¢ character. Does anyone know why this i

Re: Spanish Accents

Hola, special characters contained on a web page should be replaced by special tags for a correct display, for example, the ó in the word Supervisión should be replaced by Ó ( You should send SupervisiÓn to the browser ) I don't know ASP, I use PHP, and PHP has a funcion, called htmlspecial

mysqladmin processlist and pid

hi listers how would i determine the association between the id from mysqladmin processlist to a pid? what i'm after is that i notice some of the mysql threads have a high cpu utilization. i see this using top (on a linux box). i would like to know which user/program is responsible for tuning

Re: mySQL, mySQL Max and stored procedure support (version problem?)

On Tue, 09 Mar 2004 12:36:30 +0200 Victoria Reznichenko <[EMAIL PROTECTED]> wrote: > 5 is a number of version. MySQL-Max is a name of MySQL server, where > Max means that this MySQL server supports InnoDB and BDB storage > engines. So this make MaxDB another product > > Could anyone post a corre

Spanish Accents

Hello, I am building a web page using Windows 2000 Server, IIS 5.0, ASP (with vbscript) and MySQL database with MySQL Connector/ODBC. The content of this web page is in Spanish thus the database will contain letters with Spanish accents. My problem is that the Spanish characters are not displ

Re: Saving file into database

Yes, it's possible. Just make sure you quote it (see the Perl DBI docs for the quote method) before you insert it. j- k- On Tuesday 09 March 2004 12:49 am, Isa Wolt wrote: > Hi, > > I would like to save a binary file into a mysql database, for later being > able to use the file. I am us

Re: mySQL, mySQL Max and stored procedure support (version problem?)

Ivan Sergio Borgonovo <[EMAIL PROTECTED]> wrote: > On Tue, 9 Mar 2004 10:52:38 +0100 > "Martijn Tonies" <[EMAIL PROTECTED]> wrote: > >> > I'm running: >> > mysql Ver 12.21 Distrib 4.0.15, for suse-linux (i686) >> > ps says I'm running mysql-max >> > mysql21397 0.0 1.7 71216 16064 pts/8 S

mysql 1gb memory limit?

In order to get the max performance from our servers we're reading every bit we can lay our hands on about performance tuning. In this document: http://www.phpconference.de/2003/slides/business_track/kneschke_webserver-performance-tuning.pdf (it's in German), it says on page 9 that MySQL 4.1.x on 3

Re: GRANT & REVOKE Syntax problem

* Franz Edler > I have a perhaps simple problem, but it's a problem for me: > > I have made the following GRANT statement: > mysql> GRANT ALL ON ser.* TO [EMAIL PROTECTED]; > Query OK, 0 rows affected (0.01 sec) > > But when I want to REVOKE the GRANT I get the following syntax error: > > mysql

Re: mySQL, mySQL Max and stored procedure support (version problem?)

On Tue, 9 Mar 2004 10:52:38 +0100 "Martijn Tonies" <[EMAIL PROTECTED]> wrote: > > I'm running: > > mysql Ver 12.21 Distrib 4.0.15, for suse-linux (i686) > > ps says I'm running mysql-max > > mysql21397 0.0 1.7 71216 16064 pts/8 S10:32 0:00 > > /usr/sbin/mysqld-max > > > > that

  1   2   >