Re: Backup question.

mount vxfs snapshot. 3. From the first client, execute: UNLOCK TABLES. 4. Copy files from snapshot. 5. Unmount snapshot. " (from : http://www.mysql.com/doc/en/Backup.html) Bernard Hope this helps, Joseph Bueno On Tuesday 18 November 2003 05:12, Simon Green wrote: Has any one use LVM to

Re: Problem about the maximum isze of MYISAM table

MyISAM tables can be larger than 4Gb without using merge tables. This topic has been discussed several times on this list. You will find all details in "Google groups" archive: http://groups.google.com/groups?q=myisam+4Gb+limit+group:mailing.database.mysql&scoring=d Hope this helps

Re: inconsistent query times for same query

ur server. Thanks again, -Bob Hope this helps Joseph Bueno -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: inconsistent query times for same query

There is caching but it is at OS level: on first query, data are fetched from disk; other queries read directly from file system cache. Hope this helps Joseph Bueno [EMAIL PROTECTED] wrote: Hi everyone. I'm using MySQL 4.0.16 with W2K/SP4 on a 512KB RAM/1.2GHz Athlon machine (my dev workst

Re: MySQL with OpenMosix

ciently. In addition, openMosix doesn't currently offer support for allowing multiple cooperating threads to be separated from one another. " Since mysql is a single multithreaded process, you should not expect any performance increase :( -- Joseph Bueno -- MySQL General Mailing List

Re: sorting/grouping

Have you tried: select commentref,max(commentid) from comments group by commentref Regards, Joseph Bueno Cummings, Shawn (GNAPs) wrote: This doesn't seem to be making sure that the "newest" commentid is the result... Seems to be random. At 09:11 AM 10/6/2003 -0400, you wrote

Re: Information required

mysql bye Waseem Ahmad Zia Subqueries and prepared statements are not available in 4.0.15. They will be in 4.1 Check the manual for details : http://www.mysql.com/doc/en/ANSI_diff_Subqueries.html http://www.mysql.com/doc/en/C_API_Prepared_statements.html Regards, Joseph Bueno -- MySQL General

Re: Slow query join problem

in buffer :( Regards, Joseph Bueno -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: negative decimal problem

(5,2) is -99.99 to 99.99 (although mysql MAY accept some values beyond these limits). Since your values are clearly out of this range, you should revue your field specification. Maybe DECIMAL(7,2) would be better ? Hope this helps Joseph Bueno -- MySQL General Mailing List For list archives: http://l

Re: Select distinct speed on an indexed column

Since your primary key is used, maybe you should consider adding an index on PostedZpdi field only. You may also check 'key_buffer_size' value (show variables like 'key%'). Since your primary key is more than 200 MB big, allocating a "big" key buffer (> 256M

Re: Select distinct speed on an indexed column

15540 |678 | 2180988928 |NULL |530350080 | 0 | NULL | NULL | NULL | NULL || InnoDB free: 142368768 kB | Hi, What do you get when you do an EXPLAIN of your query ? -- Joseph Bueno -- MySQL General Mailing List For list archives:

Re: Joining tables from two different databases

o a record in another and do queries that pull from both databases? Thanks, Jeff Hi, Yes you can do that. Just prefix table name with database name in your query: select * from table1,database2.table2 where table1.field1=database2.table2.field2 Hope this helps, Joseph Bueno -- MySQL General Ma

Re: Can't open...

Deependra b. Tandukar wrote: Dear all, what is the meaning of Can't open file: 'products_description.MYI'. (errno: 145) in mysql? Regards, _DT $ perror 145 145 = Table was marked as crashed and should be repaired Hope this helps -- Joseph Bueno -- MySQL General Mailing List Fo

Re: Selecting only numbers from a string or vice versa

254' 10 points to the one whos knows how to do a query like that. select * from mydata where mystring regexp '[A-Z]*1[A-Z]*2[A-Z]*5[A-Z]*4[A-Z]*'; should do it. Regards Joseph Bueno -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Dates

+ | from_unixtime(unix_timestamp('2003-08-26')) | +-+ | 2003-08-26 00:00:00 | +---------+ rt3=# select age(now(),'2003-08-26'::timestamp); age

Re: Fixing Replication

may be possible to adapt my approach to do it. PS: I use mysql 3.23, mysql 4.x has a "LOAD DATA FROM MASTER" that makes it much easier ;) Hope this helps, Joseph Bueno -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: External Access

uestion is whether that port requires TCP, UDP or both to be open. Thanks! David Christensen Brokers International, Ltd. 1200 E Main St Panora, IA 50216 (641) 755-2775 [EMAIL PROTECTED] TCP only Joseph Bueno -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscrib

Re: Database name

select database(); Regards, Joseph Bueno Vinay wrote: Is there an SQL command that i can perform which will return me the name of the Database i'm currently conected to. Thanks for your help. Vinay -- http://www.uptoten.com - The fun place to learn on-line UpToTen Kids : 600 educational

Re: New Group By, order by question

select order by abs(field) desc; Hope this helps, Joseph Bueno Martin Moss wrote: All, I have a question about grouping numbers. Lets say I have 10 records each containing a numeric value:- 1 2 3 5 10 -1 -2 -3 -4 -5 What I wish to do is to select the records from the database but group

Re: Frequent Table Corruption - Please Help

It is a Redhat 7.2 with a 2.4.7-10smp kernel.It was upgraded last september and mysqld has never been restarted since then (mysqld uptime is now 316 days). Hope this helps Joseph Bueno Richard Gabriel wrote: I am running 2.4.18-smp. You said you upgraded to a 2.4 smp kernel and it solved the

Re: Frequent Table Corruption - Please Help

newer smp kernel (2.4) that solved the problem. It may be a temporary fix until you schedule an upgrade. Hope this helps Joseph Bueno Tom Roos wrote: hi guys i am runing the rh 2.4.20-18.7smp kernel with mysql 4.0.13 and i sometimes experience problems with table corruptions when volumes become

Re: error 1130 : "Host xxx.xxx.xxx.xxx not allowed to connect this server" ?

looked at the manual ? http://www.mysql.com/doc/en/Access_denied.html Regards, Joseph Bueno -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: specific records

he 'id' column to the table, then when I will remove some records from the middle part o the table I will have holes, and the next select will give me wrong data. Regards, Maciej Bobrowski Maybe: SELECT * FROM tablename LIMIT 5,5; See: http://www.mysql.com/doc/en/SELECT.html for details R

Re: Problem when use mont and from_unixtime.

bel, http://www.vcable.net Move the parenthesis: select timestamp from lastauth where month(from_unixtime(timestamp))=6; Regards, Joseph Bueno -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: How to drop unique key

MaFai [EMAIL PROTECTED] 2003-06-30 Try: alter table p_asset drop index asset_name2; Regards, Joseph Bueno -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: MySQL/INNODB speed on large databases

are run several times, you could consider upgrading to MySQL 4.x. Its query cache may speed up your server (I have not tried it myself but there are been positive reports on this list). regards, Joseph Bueno Wendell Dingus wrote: Ahh, there's something I could have explained better. Ea

Re: INSERT weirdness

s` ( `manufacturers_name` , `manufacturers_image` ) VALUES ( 'CREATIVE_LABS' , 'manufacturer_CREATIVE_LABS.gif' ) Regards, Joseph Bueno -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: MySQL/INNODB speed on large databases

a lot of insert/updates and very few selects. Regards, Joseph Bueno Wendell Dingus wrote: Hello, I've got a situation I'm hoping someone here can help me out with. We have a web server serving up data via some PHP programs pulling from MySQL (3.23.56 currently) in INNODB tables. Th

Re: distributed database architecture for a large database

Sorry to reply to myself but after reading your post again, I think you can use replication to maintain member table in sync: it is possible to restrict replication to a some tables within a database: check 'replicate-do-table' option. Hope this helps Joseph Bueno Joseph Bueno wrote: I

Re: distributed database architecture for a large database

you mean by 'medint' but if it is a mediumint, you will be in trouble since its range is [-8388608..8388607]. You should use at least an "unsigned int" and may be an "unsigned bigint" if you suspect that you will have more than 4 billion rows. Hope this helps Joseph

Re: Simple Question: MySQL and Shell Scripts

May be: myvar=`/usr/bin/mysql -uroot -prootpass -e 'SELECT * FROM Bobstable WHERE Name=1;' BOB` But this is more a shell than a mysql question, isn't it ? Joseph Bueno -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Mysql replication with 2 masters and 1 slave

ch one replicating from one master: M1 --> S1 DB1DB1 S2 <-- M2 DB2 DB2 Hope this helps Joseph Bueno Erik Olsen wrote: Yes. The idea was to backup 2 masters, 1 that is ours and 1 that is a costumer. The slave's job is just going to have a synchronised d

Re: from_days/to_days

com/doc/en/Date_and_time_functions.html (TIP: type 'from_days' in 'Search the MySQL manual:' at the top-left of online manual page and click 'GO' ;) ) Regards, Joseph Bueno -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: AW: multiple mysqld-max running ?

this is too much, consider changing some parameters: http://www.mysql.com/doc/en/Server_parameters.html Also, if you don't use InnoDB, make sure that you have skip-innodb option set in my.cnf. (There were a few mails on that topic a few hours ago, check mailing list archive). Regards, Joseph

Re: multiple mysqld-max running ?

Hi, ps,top,.. on Linux show threads as processes. What you see is ONE process (mysqld) with 11 threads sharing 40Mb of memory. Check http://www.mysql.com/doc/en/Memory_use.html Regards, Joseph Bueno Gerald Fehringer wrote: hi list fellows, os: suse linux 8.1 myqld: mysql-max-4.0.12-pc

Re: Speed of SELECT ... LIMIT #,#?

If you want to speed it up, you have to make it use an index. You need to add a WHERE or an ORDER BY clause. Have you tried : SELECT Message_ID, Body FROM Body_etc ORDER BY Message_ID LIMIT N,M Of course, I assume that Message_ID is indexed ;) Regards, Joseph Bueno Nick Arnett wrote

Re: disabling version number

the least important of your problems. Regards, Joseph Bueno -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Replication freezing

Hi, Have tried changing the value of 'slave_net_timeout' on slave side ? By default, it is 3600s, if you make it shorter than 10 mn, I think that the slave will start a new read (and generate some TCP/IP traffic) before the firewall closes the connection. Regards, Joseph Bueno Andrew

Re: AW: replication on single server

Hi, With MySQL, you can join tables that are in different databases as long as they are on the same server. In your case, you could run: SELECT s.name FROM A.bouncebacks b, subcriber s where s.email = b.email Regards, Joseph Bueno Brandl, Thomas wrote: The thing is that this particular table in

List-ID Header

Hello, It seems that emails coming from mysql mailing list don't include 'List-ID: ' header anymore. Is this going to be fixed or should we change our email filtering rules ? Thank you Joseph Bueno -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql

Re: Mysql And Backup

mysqldump.html I am quite surprised that you could restore anything with mysqlimport :( Regards, Joseph Bueno - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the

Re: Process Limit on Linux ?

un mysql with more than ~600 connections, I have used this formula (a simplified version since I don't use InnoDB) to allocate a key_buffer as big as possible and make sure that I won't run out of memory. Hope this helps, Joseph Bueno Philipp wrote: Hi Dan, i just talked about openmosix b

Re: Process Limit on Linux ?

this helps, Joseph Bueno Philipp wrote: Dear Walt, dear List, thank you for your reply. Finally a suggestions at all. I checked both /proc/sys/kernel/threads-max /proc/sys/kernel/shmmax I dont think threads-max will be a problem, because the value is 14336, and i dont think my system will ever have

Re: error

Hi, You should run mysqladmin from DOS prompt, not within mysql client. If you want to create a database from mysql client, you should use: create database database01; Regards, Joseph Bueno Patrick Geary wrote: Hi I am a new user of Mysql and have received an error. I enter my C drive

Re: store an array of double to mysql, How?

Check BLOB data type: http://www.mysql.com/doc/en/BLOB.html Regards, Joseph Bueno Lai wrote: Hi. I am writing a program to do pattern recognition. I decide to use mysql to store the features calculated. The features are stored as an array of double in my c program. But now I do think about it, I

Re: automatically incrementing an int value

://www.mysql.com/doc/en/example-AUTO_INCREMENT.html Regards, Joseph Bueno Douglas B. Jones wrote: Hi, I understood replace to only increment n when it matches the name value. There are 122,111 statements, but when you add up the numbers in the n column, they exceed 122,111. They should sum up (when

Re: list current db

select database(); Regards, Joseph Bueno Jonathan Li wrote: A few days ago I asked about how to know which database I am currently in, I got an answer and I also replied to thank the send but the email was returned. Any way I forgot to document it. I remember the answer listed three methods to do

Re: Process pb

Hi, MySQL server is single process, multi-threaded, and creates one thread per client connection (more details in the manual: http://www.mysql.com/doc/en/MySQL_threads.html) What you see happens only if you run a single client at a time. Is it your case ? Regards, Joseph Bueno Julien Metayer

Re: Fwd: data-retrieving udf

hi, There is an example (udf_example.cc) in 'sql' sub-directory of mysql sources. You can code your functions in C++ but you must declare your UDF entry points as 'extern "C"' Regards, Joseph Bueno Maurizio Oristanio wrote: hi everybody, i'm trying to add a ud

Re: Load Balanced Mysql Cluster

00 in your case) and it doesn't increase when we add more webservers. With this setup, you only deal with load-balancing at HTTP level which is much easier than SQL load-balancing. Hope this helps Joseph Bueno Jared Saul wrote: I have a database heavy site that utilizes a master mysql server w

Re: Problem with registers import

Have you by any chance defined an unique index on a SMALLINT field ? In this case have a look at: http://www.mysql.com/doc/en/Numeric_types.html Regards Joseph Bueno Paulino Michelazzo wrote: People I have a txt file with 250.000 lines but, I'm import only 32767 lines. The database don&

Re: Replication Questions 2

the slave has all the data replicated? You can run "SHOW MASTER STATUS" on the master, "SHOW SLAVE STATUS" on the slave and compare 'Log_File' and 'Pos' fields. Thanks thorsten guddack Regards, Joseph Bueno

Re: # of connected user

SHOW PROCESSLIST Check http://www.mysql.com/doc/en/SHOW_PROCESSLIST.html for details Hope this helps, Joseph Bueno Mustafa Yelmer wrote: How i list connected users(active) to mysql server? it is important to know connected users for me? Mysql runs in server-client system, and each host of

Re: partitionong MyISAM tables??

Hi, Have you looked at MERGE tables (http://www.mysql.com/doc/en/MERGE.html) ? Hopre this helps, Joseph Bueno Prasanth Krishna wrote: Is there any way to partition MyISAM tables in mysql? i have a huge table and want to partition it. Do InnoDB tables support partitioning? thanks. Prasanth

Re: TIMESTAMP field is updated unintentionally

ERSTELL_DATUM to DATETIME type and set is explicitely to NOW() when you insert a new record. Hope this helps -- Joseph Bueno Marco Deppe wrote: Hi, I was already questioning my sanity, but the problem below is reproduceable: This is how my table looks: mysql> describe T_O

Re: [ mysqlimport ]

Hi, You should not use mysqlimport but mysql: mysql my_db < file.sql See http://www.mysql.com/doc/en/mysqldump.html for details. Regards, Joseph Bueno Elby Vaz wrote: I created a "file.sql" with mysqldump. mysqldump my_db my_table > file.sql What I do to get th

Re: file-descriptor limits for linux

Whatever value you set with ulimit, you won't get any error message until the system actually reaches file-max limit. It will then deny any new file open (not just those coming from mysqld). Hope this helps, Joseph Bueno Martin Waite wrote: Hi, Does anyone know what the story is for fi

Re: how to get the Nth record of a result ?

Hi, select * from table where LIMIT N,1 More details at: http://www.mysql.com/doc/en/SELECT.html Regards, Joseph Bueno alx wrote: HI all I'm trying to get the Nth record of a query which i don't know nothing but the table name. I mean something like select * from table where

Re: insert query

this helps, -- Joseph Bueno Murthy wrote: > how to insert only blank spaces into a field using insert query. Its getting > trimmed off. > > > Regards, > Murthy > - Before posting, please check: http://

Re: Recreating indexes on large tables

Hi, Instead of using separate "CREATE INDEX" statements, you can build all your index at once with "ALTER TABLE": ALTER TABLE my_table ADD INDEX ..., ADD INDEX ... , ADD INDEX ... ; Hope this helps, -- Joseph Bueno Salvesen, Jens-Petter wrote: > Hello, everyone &g

Re: Perl DBI secret command?

No conspiracy, read it again ! ;) http://www.perldoc.com/cpan/DBI.html#rows Joseph Bueno Jeff Snoxell wrote: > Hi, > > just stumbled across the following piece of code: > > my $rowcount = $sth->rows(); > > And I checked it out compared to a count of the fetched rows

Re: MySQL Server Crashes under heavy load

postponed those optimisations. I think you really should audit your queries first. From my experience and what other users have reported on this list, you should expect to be able to run several hundred queries/s with the kind of hardware you are using. Hope this helps -- Joseph Bueno Chavvon Smith

Re: Loading a database into RAM

22216 1189840 0 0 0 0 1359 1768 25 12 63 As you can see, no disk reads (bi) and a few disk writes (bo) Hope this helps, Joseph Bueno Steve Quezadas wrote: > I have a mySQL database that is about 240 megabytes. I am loading it on > a Linux server with 2 gigs of RAM. I woul

Re: MySQL Select SUM Function

SELECT SUM(colA+colB) FROM TABLE ? Stevens, Ryan wrote: > I understand the SQL statement in MySQL to be "SELECT sum(column name) FROM table;" >but I would like to get a SUM of multiple columns. Is this possible?? > > Thanks, > > Ryan > >

Re: The diference about raw devices and disk partitions

MySQL/InnoDB, so I can't give you more MySQL specific advice. Hope this helps, Joseph Bueno NetClub Dyego Souza do Carmo wrote: > > I'm confused , what is the difference and raw device and a disk > partition ? > > ex: on innodb I'm using /

Re: Ram Usage, and processes

| > | wait_timeout| 28800 | > +-+-+ > > -end show variables output --- > > Just a side question. I noticed in the show va

Re: QUERY question (group by) - please help

Y' returns: > mysql> SELECT COUNT(*) FROM test WHERE (kid=1) OR (kid=2) OR (kid=4); > +--+ > | COUNT(*) | > +--+ > |7 | > +--+ > 1 row in set (0.00 sec) > > So two rows are grouped because of same cid,did > > Any sugestion? > > Regards, > Dez

Re: QUERY question (group by) - please help

t; results for the current page. > > Is it posible to get number of all results without geting all results in a > temporary table and then count them? If yes, how? SELECT COUNT(*) FROM test WHERE (kid=1) OR (kid=2) OR (kid=4)

Re: Why "unsigned" doesn't work?

ll me why doesn't it work? > Sure ! Your syntax is wrong. It should be: create table aaa(id int unsigned not null, name text); Please see the manual for more details: http://www.mysql.com/doc/en/CREATE_TABLE.html > Thank you. > > Teddy, > Teddy's Center: http:

Re: need index date help

mine compares seconds. If you really need to work on day numbers, it would be more efficient to use a separate column where you explicitely insert TO_DAYS(NOW()). This way you can index it and efficiently use it on SELECTs. Hope this helps Joseph Bueno John Hinton wrote: > OK.. no takers the f

Re: Storage Requirements Not Equal to Actual Disk Space Used...

mysql needs a few more bytes per record for its internal use. Since you use a VARCHAR, you have dynamic length records; this is described in the manual: http://www.mysql.com/doc/en/Dynamic_format.html Regards, Joseph Bueno Andrew Kuebler wrote: > I have a table with 17,168,035 records. I h

Re: How can I duplicate a mysql template database?

You cannot execute several SQL statements within a single query. You are trying to reinvent 'mysql' client batch processing; if you want to do that, you have to write an SQL parser in PHP that split your input in independant SQL statements and execute them one by one :( Daevid Vincent wrote: >>Yo

Re: How can I duplicate a mysql template database? [hack]

cent wrote: > Unfortunately, command line is not an option for me. As I said before, > the php scripts are on a web server and the database is on another > server. > > >>-Original Message- >>From: Joseph Bueno [mailto:[EMAIL PROTECTED]] >>Sent: Tues

Re: How can I duplicate a mysql template database? [hack]

options but I just wanted to show the idea). Hope this helps, Joseph Bueno Daevid Vincent wrote: > Seems to me there should be a built in SQL command to duplicate a > database. Jeepers. Or to read in a .sql file from PHP and create a > database out of it (which was the origin

Re: MySQL optimization

Hi, It seems that you don't have any index on your tables. You should at least create an index on flObjectID in all tables. You should also use 'explain' on your query to make sure that indexes are properly used. Hope this helps Joseph Bueno John Glenn wrote: > &g

Re: How to backup without blocking?

Hi, You can also use mysql replication: you install a slave server and run mysqlhotcopy on it. This way, you never freeze the master server. Hope this helps Joseph Bueno Philip Mak wrote: > sql, query > > Right now, every day I run the equivalent of a mysqlhotcopy on my > databas

Re: Multiple Inserts and updates

Qty | ++-+--+ | 1 | 56-56 |5 | | 2 | 27-01 |1 | | 3 | 15-02 |2 | ++-+--+ 3 rows in set (0.00 sec) It really seems to work ;) Regards, Joseph Bueno Ed Reed wrote: > I created a new table called Table1 and did a test with that command. My &

Re: Multiple Inserts and updates

f it does not work, you should also post the error message you are getting from mysql. Regards, Joseph Bueno Ed Reed wrote: > Thanks for the response. I tried your example but it doesn't work, > Here's my SQL, can you tell what I'm doing wrong? > > Insert Into Table1

Re: automatically inserting/updating timestamp

www.mysql.com/doc/en/DATETIME.html) Or am I missing something ? Regards, Joseph Bueno [EMAIL PROTECTED] wrote: > I've created a table that contains a column called > "recordLastModified" and that column uses "timestamp" > as the data type. Is there a way in MySQL

Re: Wont use Index when data is not evenly distributed

s.) Note that if such a query uses LIMIT to only retrieve part of the rows, MySQL will use an index anyway, as it can much more quickly find the few rows to return in the result." (see http://www.mysql.com/doc/en/MySQL_indexes.html) Regards, Joseph Bueno

Re: mysql 3.23.53a-Max crashes on large memory machine

or file caching, and it will still speed up your database accesses. Hope this helps -- Joseph Bueno Johannes Ullrich wrote: > I am having 'issues' with MySQL running on Redhat Advanced Server > on a 8 Gigbyte machine (dual P4-Xeon). > > After large imports ('load dat

Re: MySQL max memory usage on linux/intel

file caching. Since the total size of all databases is around 1.5 Gb they almost fit in memory and the server is happily serving around 300 queries/s with 200 concurrent connections and almost no disk I/O (no reads, just a few write every 5 seconds). Hope this helps -- Joseph Bueno [EMAIL PROTECTED]

Re: Index using..

| | > | contributor | tinytext | YES | | NULL| | > | format | tinytext | YES | | NULL| | > | source | tinytext | YES | | NULL| | > | relation| tinytext | YES | | NULL

Re: Mysql & Encryption

Have you considered putting your databases on an encrypted filesystem ? You don't need to add anything to mysql and those filesystems already exist (although I have not yet used them). Regards, Joseph Bueno mos wrote: > At 08:15 AM 11/18/2002, you wrote: > > > * Alexandre Aguia

Re: mysql from redhat8 will only run one process and remote connectionsdie.

Try to upgrade glibc: https://rhn.redhat.com/errata/RHSA-2002-197.html [EMAIL PROTECTED] wrote: > >Description: > > I just installed redhat8 this weekend and am using the rpm's provided > by them. when mysql runs it will only run a single process. and even > worse... when I try and connec

Re: Important Restriction in Query Language?

This query uses a "subselect" that is not currently supported by MySQL. Check the manual for details: http://www.mysql.com/doc/en/ANSI_diff_Sub-selects.html Regards, Joseph Bueno jorge machado wrote: > #Hello > #I'm using hibernate a O/R model from sourceforge and

Re: restricting mysql

You can also restrict port 3306 to localhost with : bind-address = 127.0.0.1 in /etc/my.cnf Hope this helps -- Joseph Bueno David Lubowa wrote: > port 3306 is the default port for mysql , if you do "grep -i 3306 > /etc/services " you will see what service runs on t

Re: min() in where clause

That's right, I should have checked before clicking on Send ;) gerald_clark wrote: > That should not be DESC. > That will give the max value. > > Joseph Bueno wrote: > > > Erwin Ulreich wrote: > > > > > > > >> I want to code the followin

Re: min() in where clause

Erwin Ulreich wrote: > I want to code the following in one statement: > > select min(field1) from table1; > $res=result of the query > select * from table1 where field1=$res; > > does anyone know? > select * from table1 order by field1 desc limit 1 --

Re: Using AUTO_INCREMENT like SEQUENCE - Resolved

w sequence number: UPDATE sequence SET code=LAST_INSERT_ID(code+1); SELECT LAST_INSERT_ID(); We use this method in our applications and it works well. (and I didn't invent it, it is described in Paul DuBois'book ;)) Hope this helps -- Joseph Bueno Mike Hillyer wrote: &

Re: find longest string in column

g,length(string) as len FROM mytable ORDER BY len DESC LIMIT 1 regards, Joseph Bueno - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive

Re: select using regexp

Hi, REGEXP is much more powerful than LIKE; you can match full words with this syntax: SELECT * FROM TABLE WHERE field REGEXP "[[:<:]]cat[[:>:]]"; (Easy, isn't it ? ;) ) You can find more examples in the manual: http://www.mysql.com/doc/en/Regexp.html Regards,

Re: Problems with "ORDER BY" from C API (works from command-linetool mysql.exe)

ve, why? > > Please help. > > /Christer > > Hi, What do expect with "ORDER BY 2" ? If you want to arder by "sum(duration)" you should use: SELECT exe, sum(duration) AS s FROM data GROUP BY exe ORDER BY s Hope this helps -- Joseph Bueno -

Re: Identical entries

Create an unique index. See: http://www.mysql.com/doc/en/CREATE_INDEX.html Regards, Joseph Bueno FlashGuy wrote: > Hi, > > I have a database which has identical entries. Is there a way to tell > mySQL to throw out duplicate entires when un insert/update is done via

Re: How much data can MySQL push out?

! Regards, Joseph Bueno Benji Spencer wrote: > Been waiting for someone to ask. The entire database is actually > slightly over 30K (35K is a closer number...small non-the-less) > > How does 12 MBytes/s come from 35K rows? Part of the output is a large > text field. Each chunk of l

Re: How much data can MySQL push out?

Hi, Just a silly question: are you pushing those 12.5 Mbytes/s over the network ? If this is the case you have hit the limit of Fast Ethernet (12.5x8 = 100Mbits/s) and no database (not even MySQL ;) ) will be faster ! May be an upgrade to Gigabit Ethernet would help... Regards -- Joseph Bueno

Re: mysql service on linux

ic link in /etc/init.d/rc5.d Hope this helps, -- Joseph Bueno Natale Babbo wrote: > Many Thanks > > No problems with mysql.server script ... it works fine > if i start it manual like this: > shell> mysql.server start > or > shell> mysql.server stop > ... also

Re: Is it possible to replicate just a couple of tables insteadof the whole database

se)? > > Thank you in advance, > > Ralf Koellner > Hope this helps -- Joseph Bueno - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list

Re: self relation query help

; would solve this but I could not make it work using them. Confused? > Good...so am > I! Thanks in advance for any help > > Franklin Williams > [EMAIL PROTECTED] > > Hi, select A1.Name as GroupName, A2.Name as Artist from A as A1, B, A as A2 where A1.id =

Re: subselect solution

re alternatives > solutions ? > > Thanks > > Sorry for my English > > Eric > Hi, You should try: select fname, lname, date_creation from tb_person order by date_creation desc limit 1; and look at : http://www.mysql.com

  1   2   3   >