Re: LEFT JOIN changes order of results

Johan Höök [EMAIL PROTECTED] writes: Hi Scott, I think you've been lucky so far... As you're only ordering on listdate, which is the same for both homes in your example you might definitely get different results once you put in the limit. A basic thing about rdb's is that you must never

mysqldump : Character set '#33' is not a compiled character set

Hi It's my first time using mysqldump. [EMAIL PROTECTED] mysql]$ mysqldump -uroot --all-databases backup_test.sql mysqldump: File '/usr/share/mysql/charsets/?.conf' not found (Errcode: 2) mysqldump: Character set '#33' is not a compiled character set and is not specified in the

Illegal mix of collations for operation IN

Hello, I have problem which I don't understand. if I send command (from Query Browser or from C++ Builder application) SELECT FileName FROM Files WHERE FileName = 'FILE1.TXT' OR FileName = 'FILE2.TXT' query executes without any problem but command SELECT FileName FROM Files WHERE FileName IN

Re: How to get the name of the last failed FK constraint

Hi, Status; gives your own session id. To be combined to show innodb status (ksh or perl). Mathias Selon Frank Schröder [EMAIL PROTECTED]: [EMAIL PROTECTED] wrote: Frank Schröder [EMAIL PROTECTED] wrote on 05/31/2005 03:18:11 AM: Hello, I have an InnoDB table running on MySQL 4.1.11

Re: Select MAX(column1,column2)

Hi Scott, you may be int his case : http://bugs.php.net/bug.php?id=32882 can't reproduce it because of env lack Mathias Selon Scott Klarenbach [EMAIL PROTECTED]: You guys have been so helpful with this, I'm hoping that I can ask for one more favor... The reason I needed the greatest(max())

Re: Design of a Client-side MySQL Java Load Balancer

Hi, i think that client load-balacer are more Dispatchers than real load balancer. load balancing in the database side takes care to number of connections, but also node load. So thisis more real. But this issue is difficult. even for oracle with 9iRAC and 10gRAC, load balancing is not

RE: Mysqldump

If you just dump the structure with mysqldump and then build SELECT INTO OUTFILE and LOAD DATA INFILE statements for each table, the process will run faster than even the extended insert option of mysqldump. -Original Message- From: ManojW [mailto:[EMAIL PROTECTED]

mysql: varchar and case sensitive

Column type is username varchar(100). When I do select from database: select * from user where username='John'; //returns one row select * from user where username='john'; //returns one row The records in the database has username 'John'. Why it isn't case sensitive? 'John and

Re: Find the biggest blobs

Hi, since reading blobs is not a simple action (heavy), you must store the size of every file in the table's structure. if you write with php, somthing like that filesize($binFile) gives you the column value for every insert When done, a simple order by filesize gives you what you want before

Re: mysql: varchar and case sensitive

Jerry Swanson wrote: Column type is username varchar(100). When I do select from database: select * from user where username='John'; //returns one row select * from user where username='john'; //returns one row The records in the database has username 'John'. Why it isn't

Re: mysql: varchar and case sensitive

it depends of the collation of table, for example: if your table has collation: utf8_english_ci, ci means case insensitive. El jue, 02-06-2005 a las 09:43 -0400, Jerry Swanson escribió: Column type is username varchar(100). When I do select from database: select * from user where

MySQL - Tiger - install on separate partition

Is there a recommended way for installing MySQL on Mac OS X(Tiger)? Is it a good idea to have MySQL installed on a separate partition considering future upgrades and scalability? Currently i have one 250 GB hard drive and I am expecting MySQL databases not to exceed 100 GB. Just to try, i created

RE: Find the biggest blobs

Did you try: select blob_field from blob_table order by length(blob_field) DESC limit 1 Regards, Artem -Original Message- From: Roland Carlsson [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 01, 2005 10:02 AM To: mysql@lists.mysql.com Subject: Find the biggest blobs Hi!

Re: mysqldump : Character set '#33' is not a compiled character set

hi, look at : usr/bin/mysqldump --defaults-extra-file=/.../backup-credentials.cnf in http://dev.mysql.com/doc/mysql/en/mysqldump.html add the port, protocol,password mathias Selon Gu Lei [EMAIL PROTECTED]: Hi It's my first time using mysqldump. [EMAIL PROTECTED] mysql]$ mysqldump -uroot

Re: unable to start mysqld_multi

Hello. Check the --no-log option for mysqld_multi to see it's messages on your console. What is in servers' error logs? PRASHANT N [EMAIL PROTECTED] wrote: hi as per the online manual, i have configured mysql and able to run the server as mysqld_safe. but if i want to run

Re: mysqldump : Character set '#33' is not a compiled character set

Hello. What version of MySQL do you use? Complete support for utf8 exists only in 4.1.xx and 5.x versions. Gu Lei [EMAIL PROTECTED] wrote: [-- text/plain, encoding 7bit, charset: us-ascii, 23 lines --] Hi It's my first time using mysqldump. [EMAIL PROTECTED] mysql]$

Re: Illegal mix of collations for operation IN

Hello. Usually debugging of such kind of problems starts with examination of the output of: show variables like '%char%'; show variables like '%colla%'; Send the output of: show create table your_table; Hello, I have problem which I don't understand. if I send command

Re: server and my client in different time zone

Hello. This link might be helpful: http://dev.mysql.com/doc/mysql/en/time-zone-support.html Scott Haneda [EMAIL PROTECTED] wrote: Is there a way to tell NOW() in mysql to be based on a time in the future? Bascially, I am in PST, and they are in EST, I have a ton of reports that

Re: mysql shutsdown immediately after password input

Hello. See: http://dev.mysql.com/doc/mysql/en/gone-away.html Michael Bujokas [EMAIL PROTECTED] wrote: I have never got mysql to start because each time I input my password, the window closes (I am using Windows XP). The error is something like: ERROR 2013: Lost connection to

Re: Replication problem

Hello. I suggest you to check what query was written to the master binary log and then report a bug. Please include all information you've found in the report. Weicheng Pan [EMAIL PROTECTED] wrote: Dear Gleb: The problem has occured again, and I grab some output. This box run

Re: table full on mysql-cluster

Hello. There are some tips at: http://dev.mysql.com/doc/mysql/en/mysql-cluster-faq.html See also: http://dev.mysql.com/doc/mysql/en/mysql-cluster-db-definition.html We have the following problem. Cluster means table 'TABLENAME' is full We have 11076890 rows in this table.

Re: How to get the name of the last failed FK constraint

[EMAIL PROTECTED] wrote: Hi, Status; gives your own session id. To be combined to show innodb status (ksh or perl). Mathias I'm not sure I understand. Are you saying that SHOW INNODB STATUS shows only the information of the current session or that I can supply a session id to the call?

Re: Import dump (4.0 4.1) and collation problem

Hi, I don't understand very well, what should I do... Does anyone has a step-by-step instructions on how to import a ver. 4.0 DB dump into a 4.1 version ? Thanks for any help Roberto Jobet look at automatic character set conversion

Problems importing dump 4.0 4.1

Hi, I'm trying to import a db dump made on ver. 4.0, on a new 4.1 version. All accented characters (french, spanish) are replaced by a '?' What it's the right way to import it ? Thanks in advance Roberto Jobet Navighi a 4 MEGA

Re: Mysqldump

Hi, try stop server, cold copy to dev server, start on dev. mathias Selon ManojW [EMAIL PROTECTED]: Greetings, I took a dump of (pretty chunk) database, the output is close to 45G. I am trying to reload this dump file onto a development server but it's taking long time to load the

Re: Mysqldump

you might also try --opt as an argument to mysqldump such as: mysqldump -u root --opt --add-drop-table db_name output.dmp On Thu, 2005-06-02 at 08:46 +0200, [EMAIL PROTECTED] wrote: Hi, try stop server, cold copy to dev server, start on dev. mathias Selon ManojW [EMAIL PROTECTED]:

AUTO_INC lock

Hi, Can somebody tell me what the AUOT_INC lock is doing. When my db is experiencing high load I see a lot of these in the INNODB status monitor. I'm doing a lot of inserts, and from time to time I need to generate some reports that are based on a large amount of data, and then the MySQL server

Re: Replication problem

Dear Gleb: I forgot to give the master's bin log dump data, The data writen in master log is correct: [EMAIL PROTECTED] [ /home/mysql ] mysqlbinlog db0-bin.56 | grep ( 'lty0105', '8', 2p) INSERT LOW_PRIORITY INTO `statistics`.`search` ( `userid` , `id` , `func` ) VALUES ( 'lty0105',

Need help in basic query

Hi mysql-ers, I need help in a basic query: I have this table: select * from isr2_aud_log where id_secr_rqst IN ('TASK23C6054B9D416C08:1284FD4:103FB047DF1:-7ECF') --and name_rec_type = 'Assignment' order by id_secr_rqst, dt_aud_rec

View

Does Mysql 4 supports views? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Need help in basic query

OK - I have found the cause of the inconsistency - Whenever I have more than one record which has name_rec_type as 'Assignment' I do not get any results (I get an empty result) But if I have only one Assignment record then it returns the correct row. Question is: How can I overcome this - I

SELECT problem

I'm having a really hard time selecting rows from a table in one SELECT statement. I can do it in two SELECTS, but it seems I should be able to do it in one. TRIPS id dateperson_id cost

Re: View

Am 02.06.2005 um 20:31 schrieb Jerry Swanson: Does Mysql 4 supports views? No. Regards, A. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: View

I believe 5.0 does. -Original Message- From: Andreas Ahlenstorf [mailto:[EMAIL PROTECTED] Sent: Thursday, June 02, 2005 2:55 PM To: Jerry Swanson Cc: mysql@lists.mysql.com Subject: Re: View Am 02.06.2005 um 20:31 schrieb Jerry Swanson: Does Mysql 4 supports views? No. Regards, A.

Re: View

Jerry Swanson [EMAIL PROTECTED] wrote on 06/02/2005 02:31:06 PM: Does Mysql 4 supports views? There were at least two other ways you could have found this information: RTFM: http://dev.mysql.com/doc/mysql/en/ansi-diff-views.html Search this list's archives: http://lists.mysql.com/mysql This

Re: SELECT problem

René Fournier [EMAIL PROTECTED] wrote on 06/02/2005 02:53:51 PM: I'm having a really hard time selecting rows from a table in one SELECT statement. I can do it in two SELECTS, but it seems I should be able to do it in one. TRIPS id date person_id cost

Re: LEFT JOIN changes order of results

hi, mls_num is not in a key, have you tried index creation on (zip,price desc,mls_num) ? mathias Selon Scott Gifford [EMAIL PROTECTED]: Johan Höök [EMAIL PROTECTED] writes: Hi Scott, I think you've been lucky so far... As you're only ordering on listdate, which is the same for both

Re: LEFT JOIN changes order of results

[EMAIL PROTECTED] writes: hi, mls_num is not in a key, have you tried index creation on (zip,price desc,mls_num) ? Hi mathias, mls_num is the primary key, so it does have its own index. I could create a multi-column index covering (zip,price,mls_num), but that was really just one example of

Re: Need help in basic query

SOLVED: I changed my query to include max(t1.dt_aud_rec) instead of t1.dt_aud_rec. I had guessed that it required just a tweak here and there... Does anybody have any other suggestions apart from this?? Thanks, Anoop On 6/2/05, Anoop kumar V [EMAIL PROTECTED] wrote: OK - I have found the

Re: Problems importing dump 4.0 4.1

Hello. Specify the right character set with --default-character-set command line option for mysql (if you're using it for reading dump). Chapter 10 of the manual could be helpful. See: http://dev.mysql.com/doc/mysql/en/charset.html [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: Hi,

Re: Need help in basic query

Hi, Try just : SELECT id_secr_rqst task_id, MAX(dt_aud_rec) AS latest FROM isr2_aud_log WHERE name_rec_type = 'Assignment' AND id_secr_rqst ='TASK23C6054B9D416C08:1284FD4:103FB047DF1:-7ECF' GROUP BY id_secr_rqst ; ++-+ | task_id

Re: View

NO Selon Jerry Swanson [EMAIL PROTECTED]: Does Mysql 4 supports views? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives:

Re: SELECT problem

Hi René, thsi can be a solution, many others are possible : mysql select distinct the_date, person_id, cost, name - from trips,persons - where person_id=persons.id - and the_date in(select max(the_date) from trips a - where a.person_id=person_id - group by person_id) -

Re: LEFT JOIN changes order of results

you can also try to increase the value of the tmp_table_size variable. A+ Selon [EMAIL PROTECTED]: You have a sort because you did an order by. If you had an index with the desired order by, it may be used. Try as you usage of covering indexes. you certainly know that one multi-column

Re: How to get the name of the last failed FK constraint

I say this : Enter password: *** Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 1 to server version: 4.1.11-nt-max-log Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql status -- mysql Ver 14.7 Distrib 4.1.11, for Win32

Unauthenticated User (lots of connections problem)

There's very few solutions on this problem in my research. I recently discovered a connection issue I cannot debug for the life of me. I don't know if it's related to a network/dns problem, if its the client, or the db server. My slave client, MySQL 4.0.23a (tried upgrading to 4.1.10, no change)

Re: LEFT JOIN changes order of results

You have a sort because you did an order by. If you had an index with the desired order by, it may be used. Try as you usage of covering indexes. you certainly know that one multi-column index is similar to a lot of multi-column others when desired columns are in the right position of columns

Re: Cannot start mysql due to possibly a bug

Privet! file: './mysql/host.frm' (errno: 13) perror 13 OS error code 13: Permission denied Change the owner of /var/lib/mysql to 'mysql' user. Please next time post your messages to the list, the probability of helpful answers increases in several times :) On Tue, 31 May

How to find random records in a subset?

I am using a routine to find 50 random records in a large MySQL database (about a million records) where I generate a list of 50 random unique ID's, and then use MySQL's in command to find them. I can't use order by rand() due to its performance hit. But I have to take it one more step: I

Re: How to find random records in a subset?

Brian Dunning wrote: But I have to take it one more step: I want to first limit my found set to those matching a different search criteria, and then find 50 of those. SELECT id FROM bla WHERE whatever That gets you a list of IDs that match the criteria. Then select 50 IDs, and issue the

RE: How to find random records in a subset?

Brian, I've done this using a huge array before, trust me avoid it like the plague. It will eat up more memory than you might expect. I've done the following with success, but it depends on your table setup. ? $cres=mysql_query(SELECT id FROM tablename ORDER BY id DESC LIMIT 1);

Re: SELECT problem and QUESTION OF SPEED

Thanks for the solution. It looks like it would work, but I don't have MySQL 4.1 (which I believe is required for this to work, since this is SUBSELECT, isn't it?). Assuming I have to use two selects, which would you say is faster, creating a temporary table in MySQL, or extracting the data

RE: Unauthenticated User (lots of connections problem)

BLOCKED::http://www.xamo.com:61519 is not actually part of the output from SHOW PROCESSLIST correct? Have you tried starting MySQL with --skip-name-resolve ? If this is the issue I'm thinking it is, would you be able to run tcpdump through grep for DNS traffic and see if anything is going on.

Re: mysqldump : Character set '#33' is not a compiled character set

Hello Gleb Paharenko Version is 4.1.10-max Regards Gu Lei Gleb Paharenko : Hello. What version of MySQL do you use? Complete support for utf8 exists only in 4.1.xx and 5.x versions. Gu Lei [EMAIL PROTECTED] wrote: [-- text/plain, encoding 7bit, charset: us-ascii, 23 lines --] Hi It's

Re: mysqldump : Character set '#33' is not a compiled character set

[EMAIL PROTECTED] : hi, look at : usr/bin/mysqldump --defaults-extra-file=/.../backup-credentials.cnf in http://dev.mysql.com/doc/mysql/en/mysqldump.html add the port, protocol,password mathias Selon Gu Lei [EMAIL PROTECTED]: Hi It's my first time using mysqldump. [EMAIL

Re: mysqldump : Character set '#33' is not a compiled character set

Gu Lei ??: [EMAIL PROTECTED] ??: hi, look at : usr/bin/mysqldump --defaults-extra-file=/.../backup-credentials.cnf in http://dev.mysql.com/doc/mysql/en/mysqldump.html add the port, protocol,password mathias Selon Gu Lei [EMAIL PROTECTED]: Hi It's my first time using mysqldump.

Re: mysqldump : Character set '#33' is not a compiled character set

Gu Lei : Hello Gleb Paharenko Version is 4.1.10-max Regards Gu Lei Gleb Paharenko : Hello. What version of MySQL do you use? Complete support for utf8 exists only in 4.1.xx and 5.x versions. Gu Lei [EMAIL PROTECTED] wrote: [-- text/plain, encoding 7bit, charset: us-ascii, 23

Re: View

Views are supported, however, starting with MySQL version 5.0.1. See this page of the on-line documentation to read more about it: http://dev.mysql.com/doc/mysql/en/views.html On Thu, 2005-06-02 at 14:31 -0400, Jerry Swanson wrote: Does Mysql 4 supports views? -- MySQL General Mailing List

Re: Design of a Client-side MySQL Java Load Balancer

[EMAIL PROTECTED] wrote: Hi, i think that client load-balacer are more Dispatchers than real load balancer. load balancing in the database side takes care to number of connections, but also node load. So thisis more real. But this issue is difficult. No... you're making assumptions. With