MySQL 5 + Niagara?

Hi, Does anyone know which is the best binary version of MySQL 5 to use for a SunFire T2000 (with an 8 core Niagara processor). Does the Ultra-sparc-version work? /Johan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:

Re: How to Find the Max/Min from Multiple Columns (in each row)

In article [EMAIL PROTECTED], Henry Chang [EMAIL PROTECTED] writes: Hello everyone, I have a table where measurement values are collected in mulitple columns. Table Schema == ID, measurement_01, measurement_02, measurement_03

Re: Out of Range value adjusted?

Hello. If you still want to use the decimal(3,2) data type for your table (even after excellent explanations by Shawn), check that the pure instance of MySQL doesn't use STRICT sql mode. See: http://dev.mysql.com/doc/refman/5.0/en/server-sql-mode.html Kerry Frater wrote: I am trying to test

Optimizing Tables - Trimming Data

Hi, I am trying to optimize my data and am currently looking at indexes etc. Someone has suggested the following as well: 1. Ensure that there is no whitespace at the beginning or end of entries 2. Use 1 or 0 instead of yes or no. If point 1 is true then is there a way to trim all whitespace

Re: update a Blob field using UPDATE

Hello. Have you applied mysql_real_escape_string to your BLOB variable first? See: http://dev.mysql.com/doc/refman/5.0/en/mysql-real-escape-string.html I do not see the quotes around mystring$ as well. Kerry Frater wrote: I am importing data from a non MySQL table into MySQL. In the

Re: Optimizing Tables - Trimming Data

Hello. You will get much more help from the list if you provide the current table structure, short description of the information which is stored in that fields, and the query you want to optimize (most probably it takes much more time than others). If point 1 is true then is there a way to

Re: Optimizing Tables - Trimming Data

Sorry guys, here is a table description, query and result: SHOW CREATE TABLE Properties; Properties |CREATE TABLE `Properties` ( `Property_ID` int(11) NOT NULL auto_increment, `Insertion_Date` date default NULL, `Status` varchar(20) default NULL, `Uploader_ID` int(11) default NULL,

Character set problem

Hy I have a table datas like that : name Mester József Job György Czibere Lajos If I create : select name from dolgozok where name like '%jó%' ; then all data will be shown. But I wolud like see datas which really contain ó character (only Mester József). Joe

mysqld got signal 11

Hello developers of MySql. It is my problem: --- mysqld got signal 11; This could be because you hit a bug. It is also possible that this binary or one of the libraries it was linked against is corrupt, improperly built, or misconfigured. This error can also

Primary Key Generator as auto_increment replacement

Anybody has idea about primary key generator to replace auto_increment as primary key? I found this problem too (http://bugs.mysql.com/bug.php?id=16979) since huge insert/update/select count(*) work parallel frequently, . i got deadlock :( Thx -- MySQL General Mailing List For list

[Fwd: Primary Key Generator as auto_increment replacement]

Anybody has idea about primary key generator to replace auto_increment as primary key? I found this problem too (http://bugs.mysql.com/bug.php?id=16979) since huge insert/update/select count(*) work parallel frequently, . i got deadlock :( Thx -- MySQL General Mailing List

Creating REGEXP patterns with use of subquery

Is there any way to build a REGEXP pattern set by using a subquery? I have a set of rows in table table, with the column value being target for my query. That column's content is a bracket separated list of values, like this: [118][Word][Integer][Stuff]... [67][Another word][Another

Re: Character set problem

Hello. Perhaps it is an issue of your collation: mysql select a from ts where a like '%ó%' collate utf8_bin ; ++ | a | ++ | Mester József | ++ 1 row in set (0.00 sec) mysql select a from ts where a like binary '%ó%';

Re: mysqld got signal 11

Privet! key_buffer_size + (read_buffer_size + sort_buffer_size)*max_connections = 441967 K Check that you have enough virtual memory for MySQL processes. Have a look at: http://dev.mysql.com/doc/refman/5.0/en/freebsd.html http://dev.mysql.com/doc/refman/5.0/en/crashing.html What version

Re: Creating REGEXP patterns with use of subquery

Hello. This looks like a task for prepared statements. You can dynamically form the string from the query using GROUP_CONCAT, assign the created string to the variable. Then just prepare a right statement and invoke it using that variable. See: http://dev.mysql.com/doc/refman/5.0/en/sqlps.html

Re: MySQL LEFT JOIN Optimization Using LIMIT CLAUSE

Scott Klarenbach [EMAIL PROTECTED] wrote on 02/02/2006 02:01:11 PM: I have a table `requirement` which is left joining to a table `inventory` based on a matching `partNumber` column. The inventory table has millions of records, the requirement table has tens of thousands. I'm noticing

Re: Creating REGEXP patterns with use of subquery

Kim Christensen wrote: Is there any way to build a REGEXP pattern set by using a subquery? I have a set of rows in table table, with the column value being target for my query. That column's content is a bracket separated list of values, like this: [118][Word][Integer][Stuff]... [67][Another

auto_increment

Hi All, I'm trying to restore a database where the first column is set to auto_increment. When I apply the inserts created from the mysqldump I get errors about the auto_increment column. Is there a may to turn it off while I run the inserts or do I have to modify the table? Thanks, Scott

Re: MySQL Connection Problem

Casey, in a Terminal window, type ps -ef | grep -i mysql and see if there is a mysqld process actually running and not a zombie (defunct). See if you can connect on the localhost. See if the socket exists. I'd bet that one of those three will find your problem. Please let us know if this

problem with excluded days in date range query.

I have the following query: select count(*) as cnt, date(timestamp) as day from table where date_sub(curdate(),interval 14 day) = timestamp group by day; If there are no data for a particular day, it is not included. Is there a way to include all days even if the result is 0? I saw an example

Visual database design system

I am looking for a tool to integrate with mysql...I have tried DBDesigner and would like to get my hands on software that is equivalent or better than DBDesigner...any suggestions? FYI: I have had some problems with importing, printing etc with DBDesigner... Thanks in advance...

RE: Visual database design system

Hello, Might want to check out ERStudio from Embarcadero Technologies. http://www.embarcadero.com/products/erstudio/ Jimmy Guerrero, Senior Product Manager MySQL Inc, www.mysql.com Houston, TX USA -Original Message- From: Adi [mailto:[EMAIL PROTECTED] Sent: Friday, February 03,

Re: problem with excluded days in date range query.

Database software is not a calendar. The data you put in is the data you get out. If the day is never put in, you'll never get it out. You need to have some data source that has all the days in it, like an external table, if you want to be able to retrieve that data. Otherwise, you could do it

Re: Unclear about key_len in EXPLAIN output

The manual is large and vast, I couldn't find the text you quoted on the page I sent. What page did you find that text on? As well, if the key that EXPLAIN uses is multi-part, you would know from the length of the fields. You have to use some deductive reasoning, but I don't think it's really

Re: auto_increment

Hello. Please, could add more details of your actions. Are you inserting in the table which already has data? Please, provide exact error message. I'm not a telepathist, but in case of duplicate key errors a brute solution is to perform a dump with --insert-ignore option. Scott Johnson wrote:

Re: auto_increment

You can change the table definition to not have the auto_increment column, and then ALTER TABLE MODIFY COLUMN after that. However, if you post your errors here, perhaps you'll get the answer that actually solves the problem, instead of working around it to possibly leave bad data for you to

Last access time of a table

Hi everyone, Does anyone know if there is a way to get the last access time from a mysql table through mysql commands/queries? I don't want to go to the filesystem to get this info. I understand that this could be tricky especially as we have query caching turned on and serve quite a few sql

Re: problem with excluded days in date range query.

Paul, If there are no data for a particular day, it is not included. Is there a way to include all days even if the result is 0? I saw an example that included another table with all dates and an inner join but that seems a little clunky. In SQL, enumerating data you don't have requires some

Re: Visual database design system

Adi, We use Dezign from Datanamic. Not free, not expensive either. PB - Adi wrote: I am looking for a tool to integrate with mysql...I have tried DBDesigner and would like to get my hands on software that is equivalent or better than DBDesigner...any suggestions? FYI: I have had

Re: Visual database design system

Looked good, but does not suport MySQL 5 :( - cost is not really an issue On 2/3/06, Peter Brawley [EMAIL PROTECTED] wrote: Adi, We use Dezign from Datanamic. Not free, not expensive either. PB - Adi wrote: I am looking for a tool to integrate with mysql...I have tried

Re: Visual database design system

Hey Jimmy...when I reverse engineer a DB, the software does not seem to make the relationship connections between the tables...all the keys are listed, but does not illustrate them on the diagram...any tips? Cant find anything in their soft help section... Thanks... On 2/3/06, Jimmy Guerrero

Re: Unclear about key_len in EXPLAIN output

At 11:09 am -0500 3/2/06, sheeri kritzer wrote: The manual is large and vast, I couldn't find the text you quoted on the page I sent. What page did you find that text on? It's the latter part of the second sentence from the same paragraph that you quoted in your e-mail. As well, if the key that

Re: Query Speed

Dear all, Thanks for your replies. The main table for me is traffic_log. I use combination of recipient_id and mobile_retry fields to uniquely identify each row in the traffic_log and use the same combination on status_log as my foreign key to traffic_log. Each message is saved as a row in

Re: MySQL LEFT JOIN Optimization Using LIMIT CLAUSE

Thanks a lot Shawn. As always, your advice has been very helpful. On 2/3/06, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: Scott Klarenbach [EMAIL PROTECTED] wrote on 02/02/2006 02:01:11 PM: I have a table `requirement` which is left joining to a table `inventory` based on a matching

MySQL 5.0 probleam with show table status

I have a serius probleam , my backup system see the FK's with show table status like 'tablename' , and read the Comment column... in mysql 4.x works fine... but em 5.x the FK's has cuted ex: | apresentante | InnoDB | 9 | Redundant | 44 |372 | 1 6384 |

Re: MySQL 5.0 probleam with show table status

Hi, I have a serius probleam , my backup system see the FK's with show table status like 'tablename' , and read the Comment column... in mysql 4.x works fine... but em 5.x the FK's has cuted This didn't work fine in 4.x at all. The comments columns was being misused to report FKs. Even

Re: Visual database design system

At 10:52 AM -0500 2/3/06, Adi wrote: I am looking for a tool to integrate with mysql...I have tried DBDesigner and would like to get my hands on software that is equivalent or better than DBDesigner...any suggestions? FYI: I have had some problems with importing, printing etc with DBDesigner...

Re: Last access time of a table

On 2/3/06, Andrew Braithwaite [EMAIL PROTECTED] wrote: Hi everyone, Does anyone know if there is a way to get the last access time from a mysql table through mysql commands/queries? I don't want to go to the filesystem to get this info. I understand that this could be tricky especially as