Doubt about query optimization

2005-07-27 Thread Ronan Lucio
Hello, I´m using MySQL-4.1.7, and I have a query that seems, even using where clause, an specific table isn´t being optimized properly: I have four tables: real_state: cod, name, city, ag_cod, sell agency: cod, name, ag_status front: cod, rs_cod, ag_cod photo: cod, rs_cod These table have the

Re: Doubt about query optimization

2005-07-28 Thread Ronan Lucio
Eric, Can you send us the actual show indexes from table and explain output that isn't shortend? Thank you for answer my question. Actually, the real query and tables are much more complex than the data in the previous message. A just tryed to optimize the information for you better understan

Re: general question

2005-07-28 Thread Ronan Lucio
Octavian, I am using a MySQL database on a web site, and I would like to know what happends if someone searches in the database using a form, but after a few seconds MySQL starts the query, that user hit the "Stop" button of the browser. Will MySQL continue its searching and also create the cach

UDF

2005-11-21 Thread Ronan Lucio
Hello, I´m using MySQL-4.1.7 and I need to create a UDF. For all I have understood, I need to create it in C/C++ sintaxe. My doubt is: Is it the only way to have UDF server-side in MySQL(4.1.x)? Do I need to learn C/C++ to have a UDF? Thanks, Ronan -- MySQL General Mailing List For list ar

Re: Tips for better performance

2005-11-22 Thread Ronan Lucio
Marko, I have a table with 5,000,000 records that takes about 1 second to show the results. Perhaps your queries aren´t optimized properly. Ronan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Tips for better performance

2005-11-22 Thread Ronan Lucio
Martijn, I have a table with 5,000,000 records that takes about 1 second to show the results. All rows? No. The queries return an average of 30 rows. I just wanted to say that the problem isn´t the table size, but the query X indexes used. Ronan -- MySQL General Mailing List For list ar

Re: Tips for better performance

2005-11-23 Thread Ronan Lucio
Marko, Do you have an index "deleted + name" on the accounts table? How many rows have "deleted=0"? Can you apply any more filter in the users table (like date)? You are requesting all rows. How many rows do you have in the users table? Ronan -- MySQL General Mailing List For list archives:

Re: Tips for better performance

2005-11-23 Thread Ronan Lucio
that depends because SugarCRM doesn't delete anything from DB just marks item as deleted using this field. Do you have an index for deleted column? It should help. Can you apply any more filter in the users table (like date)? You are requesting all rows. no, because purpose of this query is

Re: How to compose index?

2005-11-24 Thread Ronan Lucio
I have following query: SELECT SQL_NO_CACHE users.user_name assigned_user_name, accounts.* FROM accounts LEFT JOIN users ON accounts.assigned_user_id=users.id where (accounts.assigned_user_id='1') AND accounts.deleted=0 ORDER BY phone_office asc LIMIT 620300,20 In your opinion, what group

JDBC Compatibility

2008-11-14 Thread Ronan Lucio
Hi, Suppose a simple query: SELECT client_name as name FROM clients WHERE client_id = $client_id Using JDBC 5.0.8 it returns column name as "name", that it's the expected for me. Using JDBC 5.1.7 it returns column name as "client_name", although I have asked for an alias. Is it ri

Error on MySQL-5.0

2008-11-20 Thread Ronan Lucio
Hi, I installed MySQL-5.0.67_1. When I execute "CHECK TABLE information_schema.COLUMNS FOR UPGRADE" I get the message: ++---+--++ | Table | Op| M

MySQL Cluster

2008-11-20 Thread Ronan Lucio
Hi, Does anybody has a tip to install a MySQL Cluster in a Linux CentOS-5? Is it better from source or can it be from yum? I do prefer yum because it's easier for upgrades, but I don't know if the available package was compiled for that. Thank you, Ronan -- MySQL General Mailing List For list

Re: Error on MySQL-5.0

2008-11-21 Thread Ronan Lucio
Moon's Moon's Father escreveu: You may execute mysql_fix_privileges_table script to upgrade all of your mysqld. I did it, but the problem persists... :-/ +-+---+--++

How to generate efficient backups?

2007-02-13 Thread Ronan Lucio
Hi, Yesterday I had a problem in a InnoDB table that I needed to DROP and reimport the table. When I tryed to reimport the table, most of the data was lost. So, I´ve tryed to reimport the data from the backups (created via mysqldump) and these datas were still corrupted. So, it brings to my min

Re: mysqldump on Freebsd 5 -- out of memory error

2007-02-13 Thread Ronan Lucio
Graham, /usr/local/bin/mysqldump: Error 5: Out of memory (Needed 14154840 bytes) when dumping table `Attachments` at row: 24285 Did you changed the values of MAXDSIZ in the kernel file? I use this: options MAXDSIZ=(1536UL*1024*1024) for MySLQ can you up to 1,5 Gb of RAM memory. I r

Re: mysqldump on Freebsd 5 -- out of memory error

2007-02-13 Thread Ronan Lucio
Graham, I was under the impression that in FreeBSD 5, you didn't need to change the kernel, just the entry in /boot/loader.conf... Even if you use kern_securelevel="1"? Ronan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.c

Help with query

2005-05-16 Thread Ronan Lucio
Hello, I have a table where is saved all site´s access: access id year month day weekday hour minute ip Any column has multiple lines, and I have the follow query that returns the amount of access per day of month: SELECT year, month, day, COUNT(*) AS access FROM access WHERE year = 2005 AND

Re: Help with query

2005-05-16 Thread Ronan Lucio
Mathias, Hi, look at group by ... with rollup at : http://dev.mysql.com/doc/mysql/en/group-by-modifiers.html Thank you very much for your help. My needs aren´t this, exactly. GROUP BY WITH ROLLUP, returns me several lines of the same day (one per IP), plus the total. I need that every year-month-da

Re: Help with query

2005-05-16 Thread Ronan Lucio
Mathias, To drop multiple IP, you can use distinct : mysql> SELECT year, month, day, group_concat(distinct ip),count(*) AS access -> FROM access -> WHERE year = 2005 -> AND month = 5 -> GROUP BY year, month,day -> ORDER BY year, month, day; +--+---+--+---

Performance Problem

2004-01-30 Thread Ronan Lucio
Hi, I´m having a serious performance problem with my MySQL. The CPU is most of time with a load of 60%-95%. I´m using MySQL-4.0.14 on a FreeBSD-5.1 box. It´s a Celeron-2.0 Ghz - 512 Mb RAM - 40 Gb of Hard Disk. I think the main problem the queries struct wrongly build, but at this time I need to

Re: Performance Problem

2004-02-02 Thread Ronan Lucio
Mike, > Ronan, > You haven't given us much to go on. I´m sorry. > Is this application running on a web server? Yes, but in a diferent machine connecting via TCP/IP. > 1) How many rows are your queries returning? (on average) and how long does > it take? Hmmm... Most of the queries are l

Re: Performance Problem

2004-02-02 Thread Ronan Lucio
Mike, > Ronan, > If your queries are only returning fewer than a hundred rows, and > if every join is indexed, I would have expected it to take only a second or > two at most. I´m sorry, but I´m not so good in SQL queries, rather joins. If my queries are taking about 15 seconds instead

Admin Question

2004-02-09 Thread Ronan Lucio
Hello, We have an MySQL-4.0.14 Server installed and sometimes the it takes 90% from CPU. So, my question is: Is there a way to know what is taking so many CPU process? What query is causing such problem? Thanks Ronan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mys

Troubles in MySQL migration

2004-02-10 Thread Ronan Lucio
Hello, I tried to migrate a database from a MySQL-4.0.14 to another one hardware with MySQL-4.0.17 installed. The database has InnoDB tables and I just executed a: # mysqldump -A --user root --password=my_password > dump_db.txt in the old server (MySQL-4.0.14) and # mysql -u root -p < dump_db.

Re: Sql control centre - How to view all the records for a table?

2004-02-10 Thread Ronan Lucio
> Hi, Hi, > Can anyone help me that i want to view all the record from a table, but in mysql control centre, i only can view the first 1000 records, can anybody teach me how to make it can view for all the rest of the records? Click with the right button in the table´s name -> "Open table" -

Another Question About Replication

2004-02-16 Thread Ronan Lucio
Hi All, A short question: If I have a slave MySQL Server (updating via logs). Supposing the master MySQL (for any reason) goes down. The users start using (and updating) the slave database. When the master MySQL goes up. Does it will update it´s data from the slave database? Thank´s Ronan --

SHOW PROCESSLIST

2004-02-18 Thread Ronan Lucio
Hi All, I executed a SHOW PROCCESSLIST command and it returned me 39 rows which 21 of than show "Sleep" in the column "Command". What does this tell me? Thank´s, Ronan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMA

Re: SHOW PROCESSLIST

2004-02-18 Thread Ronan Lucio
Jeremy, > On Wed, Feb 18, 2004 at 04:01:57PM -0300, Ronan Lucio wrote: > > Hi All, > > > > I executed a SHOW PROCCESSLIST command and > > it returned me 39 rows which 21 of than show "Sleep" > > in the column "Command". > > > >

Re: SHOW PROCESSLIST

2004-02-18 Thread Ronan Lucio
Martijn, > > > 21 threads are idle. > > > > But, what could make so many threads get idle? > > Connecting, but don't doing anything. > > > Shouldn´t the queries just be executed, return the results and > > be closed? > > If you don't close your connection, what do you expect? > > > Does this mean

my.cnf on MySQL-Server-4.0.17

2004-02-19 Thread Ronan Lucio
Hi All, I´m trying to do some customization in a MySQL-Server-4.0.17 to gain a better performance. We have a Intel P4-2.4 Ghz with 1 Gb RAM and 40 Gb HD on a FreeBSD-5.2.1 box dedicated for MySQL. My trouble is when I create the my.cnf file and start MySQL. MySQL don´t stat. the /usr/local/mysq

my.cnf in MySQL-Server-4.0.17

2004-02-19 Thread Ronan Lucio
Hi All, I´m trying to do some customization in a MySQL-Server-4.0.17 to gain a better performance. We have a Intel P4-2.4 Ghz with 1 Gb RAM and 40 Gb HD on a FreeBSD-5.2.1 box dedicated for MySQL. My trouble is when I create the my.cnf file and start MySQL. MySQL don´t stat. the /usr/local/mysq

Access denied

2003-06-13 Thread Ronan Lucio
Hi All, I created a user "dfn" and I granted access to only the database "dfn". Now, if I log as dfn user query for "SHOW DATABASES", mysql returns me the error: ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) Would anybody know what could be wrong? Thank's Ronan

Re: Access denied

2003-06-13 Thread Ronan Lucio
Mike, On Fri, 13 Jun 2003 08:38:32 -0600 "Mike Hillyer" <[EMAIL PROTECTED]> wrote: > Did you GRANT SHOW DATABASES to the user? If not then they will not be > able to use the command. The SHOW DATABASES GRANT clause is a new > addition. I'm sorry but I don't have experience with MySQL. Actually,

Re: Access denied

2003-06-13 Thread Ronan Lucio
Mike, On Fri, 13 Jun 2003 08:59:09 -0600 "Mike Hillyer" <[EMAIL PROTECTED]> wrote: > GRANT SHOW DATABASES will allow a user to see all databases, whether the > user can access them or not. How should I securely grant SHOW DATABASES to an user? GRANT SHOW DATABASES ON mysql.db to [EMAIL PROTECTE

Re: Access denied

2003-06-13 Thread Ronan Lucio
gt; > I think the syntax is GRANT SHOW DATABASES TO dfn@"%"; > > But I personally do not use it. > > Regards, > Mike Hillyer > www.vbmysql.com > > > -Original Message- > From: Ronan Lucio [mailto:[EMAIL PROTECTED] > Sent: Friday, June 13

JOIN in the same table

2004-10-07 Thread Ronan Lucio
Hi, I have a situation like this: Table People = people_ID people_name people_friend_ID people_friends_ID is the people_ID from another record. Is there a way to make a SELECT that returns people_name and people_friend_name? Perhaps I´d get this with sub-selects but I´m using MySQL-4.0

Help with query

2004-10-27 Thread Ronan Lucio
Hi, I have two tables: TABLE_1 === - id - name TABLE_2 === - id - table1_id - name How could I make a select on table_1 that returns me only the rows that don´t have any reference in table_2? Any help would be appreciated. Thank´s, Ronan -- MySQL General Mailing List For list arch

Re: Help with query

2004-10-27 Thread Ronan Lucio
LEFT JOIN TABLE_2 t2 ON t1.id = t2.table1_id WHERE t2.id is null Shawn Green Database Administrator Unimin Corporation - Spruce Pine "Ronan Lucio" <[EMAIL PROTECTED]> wrote on 10/27/2004 10:12:42 AM: > Hi, > > I have two tables: > &g

UPDATE LOW PRIORITY

2004-11-01 Thread Ronan Lucio
Hi All, I have o little (I think) doubt: If I use a query UPDATE LOW PRIORITY and right after I execute a SELECT in the same table/column. Will I receive the correct result or only after MySQL commit the data? Any help would be appreciated, Thanks, Ronan -- MySQL General Mailing List For li

Re: UPDATE LOW PRIORITY

2004-11-01 Thread Ronan Lucio
> What is "the correct result"? The correct result is the data in the updated column after commit. For example, if I have: Table1 = - id - name INSERT INTO Table1 (id, name) VALUES (1, 'AAA') UPDATE LOW PRIORITY Table1 SET name = 'BBB' SELECT name FROM Table1 Will it return BBB? Thanks,

Re: UPDATE LOW PRIORITY

2004-11-01 Thread Ronan Lucio
Jay, > From TFM, "If you specify the LOW_PRIORITY keyword, execution of the > UPDATE is delayed until no other clients are reading from the table." Yes, I had alread read it, but it only specify when the data will be commited, not what will be returned. Let´s change the question: Before the tha

Re: UPDATE LOW PRIORITY

2004-11-01 Thread Ronan Lucio
Gleb, > So, when it returns, all updates will be commited and select statement will return the correct result. It´s exactly what I´d wanted to know. Thank you very much, Ronan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.

Strange error in DELETE query

2004-11-11 Thread Ronan Lucio
Hi, I have a MySQL-4.0.18 installed on a FreeBSD system. When I run the follow query: DELETE FROM table WHERE client_id = 1 AND row_id IN (2,5,7) only the first record is deleted. Am I doing something wrong or is it a MySQL bug? Thanks Ronan -- MySQL General Mailing List For list archives:

Re: Strange error in DELETE query

2004-11-11 Thread Ronan Lucio
Jay, > It is not a bug, just say it out loud > "AND row_id is 2 OR 5 OR 7" > > Once the OR condition is satisfied once, the query will halt. The problem is that if I use OR in the where clause, MySQL wont use the indexes in the row_id column. One important thing that I forgot to say is I ru

Re: Strange error in DELETE query

2004-11-11 Thread Ronan Lucio
Michael, > What are you talikng about? Queries don't halt on the first row matched. > For example: It´s my thought, too. But it isn´t happen in my MySQL Server. Now, doing the same tests you did I got the same results of you. Well, I´ll inspect my code again looking for some error that I didn´t

Fw: Strange error in DELETE query

2004-11-11 Thread Ronan Lucio
Hi, I think I found out what was wrong. ColfFusion has a tag that prevents SQL Injection. Probably was removing anything after comma. Without using the code works perfectly. So, I had to create a UDF to remove everything except digits and commas. Thanks in advance, Ronan -- MySQL Ge

Subqueries X Joins

2004-11-22 Thread Ronan Lucio
Hello, I wondering about Subqueries X Joins. What is the fastest technic? I´ve read the Manuals and I found some texts saying Joins are faster and other saying Subqueries are faster. Well, if both so. When Subqueries are faster and when Joins are faster? If this question has been answered befor

Re: Mysql Performance

2004-11-23 Thread Ronan Lucio
Carlos, Give us more details about our system: What are the table types you´re using? What are the configs in your my.cnf file? Ronan - Original Message - From: "Carlos Augusto" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, November 23, 2004 3:41 PM Subject: Mysql Performan

Re: Innodb corrpution. Very Urgent

2004-11-24 Thread Ronan Lucio
Carlos, > 041124 14:13:18 Innodb: fatal error: cannot allocate 2147500032 bytes of > innodb: memory with malloc! total allocated memory > innodb: by inndodb 16975556 bytes. Operating system errno: 8 > innodb: Cannot continue operation! > innodb: check if you should increase the swap file of ulimit

Re: Innodb corrpution. Very Urgent

2004-11-25 Thread Ronan Lucio
Calos, > Well i didn´t change nothing at no config file. Any suggestions? > thanks. If you didn´t change anything, it´s supposed to be time to you configure the my.cnf file. A better tunning should solve your problem. Ronan -- MySQL General Mailing List For list archives: http://lists.mysq

Tunning Problem

2004-11-25 Thread Ronan Lucio
Hi All, I´m having a trouble where my server is falling to it's knees when a certain number of connections are match. Well, in a short, I configured the my.cnf files to accept up to 120 connections. When the server receives about to 55 connections, it hangs the connections and I don´t get me even

Re: Tunning Problem

2004-11-30 Thread Ronan Lucio
Sasha, > Ronan: > > InnoDB complains it cannot allocate memory. With your configuration you are > likely to run out of memory: > > You are telling InnoDB to allocate at least 256 MB + 20 MB for the buffer pool. > On top of that, you are telling MyISAM to use 384 MB for the key buffer. So this > is

Re: MySql Hangs

2004-11-30 Thread Ronan Lucio
Ajay, Could you send the error messages (.err file in the mysql dir) and your my.cnf file? Ronan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

4.0 vs 4.1

2004-12-07 Thread Ronan Lucio
Hi, Has anyone any benchmark between 4.0 and 4.1? MySQL website says that version 4.0 has some performance improvements but I´ve heard that MySQL-4.0 is 20% faster than MySQL-4.1. Thanks, Ronan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:h

mysqldump from 4.1 to 4.0

2004-12-07 Thread Ronan Lucio
Hi, I need to import a dump from a mysql-4.1 to mysql-4.0. I have already read the MySQL Manual page but I didn´t find the answer, even importing the data with the option --default-character-set=latin1. When executed mysql < dump.sql, it happend an error because mysql-4.1 generates the dump inclu

Re: mysqldump from 4.1 to 4.0 - It´s solved

2004-12-07 Thread Ronan Lucio
Hi, Now I found this line the MySQL Manual: " If you run mysqldump without the --quick or --opt option, mysqldump will load the whole result set into memory before dumping the result. This will probably be a problem if you are dumping a big database. As of MySQL 4.1, --opt is on by default, but c

Re: MySQL 4.1.7 Network slowdown

2004-12-07 Thread Ronan Lucio
Frank, If you provide more informations like the query and how many rows it returns, it should be easier help you. Ronan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: MySQL 4.1.7 Network slowdown

2004-12-07 Thread Ronan Lucio
Hmmm... The MySQL-client is 4.1.7, too? I realy don´t know if it make some difference, but perhaps it does. Ronan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: MySQL 4.1.7 Network slowdown

2004-12-07 Thread Ronan Lucio
Frank, Wouldn´t it because the client driver (ODBC version)? Perhaps it´s faster in the local server because it uses a mysql-4.1.7 client. Ronan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Opinions: notes field ideal length?

2004-12-07 Thread Ronan Lucio
Chris, > Quick question. What's a reasonable length for a notes-type field? I > couldn't really find any guidelines on the web so I'm thinking of just > setting it to 65,535. Or is that ridiculously long? For performance reasons, the data type should be as short as possible. Ronan -- M

Re: 4.0 vs 4.1

2004-12-07 Thread Ronan Lucio
Jeff, >> Has anyone any benchmark between 4.0 and 4.1? >> >> MySQL website says that version 4.0 has some performance >> improvements but I´ve heard that MySQL-4.0 is 20% faster >> than MySQL-4.1. > > As far as what? Thats a very general statement. How do you even know that > affects you? The fol

Re: 4.0 vs 4.1

2004-12-07 Thread Ronan Lucio
>> Once I plan to run FreeBSD-5.3 + MySQL-4.1.7 in my server, it can >> affect me. > > I may have missed it, but myisam, or innodb? Both, because I have tables that have few inserts and too few updates/deletes, like states, cities and so on, but I plan transform every table in InnoDB to avoid corr

Re: 4.0 vs 4.1

2004-12-07 Thread Ronan Lucio
Jeff, >> Both, because I have tables that have few inserts and too few >> updates/deletes, >> like states, cities and so on, but I plan transform every table in InnoDB >> to avoid corruption issues. > > Nothing here has slowed down. A few innodb stuff I use, has, but thats it.. I > run linux on a

Re: 4.0 vs 4.1

2004-12-07 Thread Ronan Lucio
Greg, > Never had table corruption, though I have had index corruption in myisam > tables many times on sound hardware. Usually, this is due to an unclean > shutdown, though I have seen it happen other times when the server is > supposedly running with no problems. A repair table tablename alw

Increasing the InnoDB log file size

2004-12-10 Thread Ronan Lucio
Hi, I need to increase the innodeb_log_file_size parameter, but when I set it higher, mysql don´t starts and give the follow erro: 041210 13:27:40 mysqld started InnoDB: Error: log file ./ib_logfile0 is of different size 0 100663296 bytes InnoDB: than specified in the .cnf f

Re: Increasing the InnoDB log file size

2004-12-10 Thread Ronan Lucio
Anil, > First shutdown the mysql cleanly. > > #mysqladmin shutdown > > then drop log files in data directory. > > restart mysql. it will create new log files. Do you know if is there a risk of loosing any data? Thanks, Ronan -- MySQL General Mailing List For list archives: http://lists.mysql

Function

2004-12-16 Thread Ronan Lucio
Hello, Is there a way to create my own function on MySQL (4.0.18)? We have a site where a product can have it´s price in differents currencies, so, I need to make a query that returns the correct product´s price. Thanks, Ronan -- MySQL General Mailing List For list archives: http://lists.mys

Re: Increasing the InnoDB log file size

2004-12-10 Thread Ronan Lucio
Anil and Oropeza, > if mysql shutdowns cleanly. then there is no chance of loosing data. for > safe side take compleate database backup. Ok, thank you very much for your help. Ronan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.m

Doubt about query optimization

2004-12-14 Thread Ronan Lucio
Hello, Supposing I have 2 tables: product == - id - name price = - id - product_id - sell_price - rent_price If I want to make a SELECT for the products having the rent_price between 300,00 and 500,00, so I use the query: SELECT rent_price FROM product LEFT JOIN price ON (product.id =

Doubt about Performance

2005-01-18 Thread Ronan Lucio
Hello, Trying to keep the database and the application fast, I´d like to clearify my mind about it. 1) Is a SELECT DISTINCT over 5,000 records a weight query? (Supposing it has about 20 different option the the DISTINCT key). 2) Is SELECT ORDER BY RAND() over 1,500 records a weight q

Re: Doubt about Performance

2005-01-18 Thread Ronan Lucio
Greg, Thank you very much for your help. > An index the full size of the distinct key is probably very quick especially > if it only has 20 distinct values. OTOH, if you already know you have a > small number of distinct values, could you just store them normalized in a > different table? Actua

Re: Doubt about Performance

2005-01-18 Thread Ronan Lucio
Sasha, > I assume you mean "has serious performance impact" when you say "weight". If > this is not what you meant, please correct/clarify. Yes, you´re right. >> >> 1) Is a SELECT DISTINCT over 5,000 records a weight >> query? (Supposing it has about 20 different option the the >> DISTIN

Re: Doubt about Performance

2005-01-19 Thread Ronan Lucio
Shawn, Thank you very much for your tips. I´ll do that. Ronan - Original Message - From: <[EMAIL PROTECTED]> To: "Ronan Lucio" <[EMAIL PROTECTED]> Cc: Sent: Tuesday, January 18, 2005 6:36 PM Subject: Re: Doubt about Performance "Ronan Lucio" <[EMAIL

Query Help

2004-08-25 Thread Ronan Lucio
Hi, I sorry for I neither didn´t find the information that I need in the documentation nor found the correct words for a search in the mailing archivers. I have a query like this: SELECT cod, descr FROM table WHERE AND cod != 7 AND cod != 10 AND cod != 13 AND cod != 14

Re: huge innodb data files

2004-08-27 Thread Ronan Lucio
Mayuran, Well, I´m not a MySQL expert, but I think that a good configuration in the my.cf file can make it better. Ronan - Original Message - From: "Mayuran Yogarajah" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, August 26, 2004 5:37 PM Subject: huge innodb data files Ou

Server hanging

2004-09-01 Thread Ronan Lucio
Hello, I had a problem with our MySQL server-4.0.18 where it suddenly stoped working. Even a KILL command didn´t killed the mysqld process. I looked for any error message in the file /usr/local/mysql/hostname.err, but I couldn´t see any error message about such time. Does anyone knows what could

Re: moving data

2004-09-03 Thread Ronan Lucio
> I want to copy data from one table to another. However I need to do this > carefully because I haven't got much of space left. I was thinking of maybe > selecting data from every 10 rows of the old table, inserting it into > the new table, then deleting those rows from the old table. > > Coul

Help with query

2004-09-10 Thread Ronan Lucio
Hello, A have two tables: City: CityID CityName Client: ClientID ClienteName CityID How can I make a SELECT that returns me only the cities that have more than 30 (example) clients? Thanks, Ronan -- MySQL General Mailing List For list archives: http://lists.mysql.com/my

Re: Help with query

2004-09-10 Thread Ronan Lucio
Shawn > SELECT CityName, Count(ClientID) as ClientCount > FROM City > INNER JOIN Client > on City.CityID = Client.CityID > GROUP BY CityName > HAVING ClientCount > 30; Thank you very much, It should solve by problem... :-) Ronan -- MySQL General Mailing List For list archives: http:/

Join and Performance Question

2004-09-16 Thread Ronan Lucio
Hi, Supposing we have for tables: One master table (student) and three independent tables. There is no relationship between them. Each of the three table have a relationship with table student. City | Teacher | TestLocal | === | = city_id | teac_id | test_id cit

MySQL on Linux

2004-04-06 Thread Ronan Lucio
Hi All, I always worked with MySQL on FreeBSD systems. Now I need to install am MySQL with InnoDB and MyISAM tables in ta Linux RH system. So, do I need to care about the Linux file size limitation of 2 Mb? Or MySQL deal this situation with Linux FS? In other words, will my MySQL stop working w

Re: MySQL on Linux

2004-04-06 Thread Ronan Lucio
> Uhm, > what are you talking about?!? When I put our site on a Linux system, apache stop working when it´s logfile get major than 2 Gb. I was afraid of it´d happen with MySQL, too. > Linux has no such limitation. > you can grow files as large as you like. > right now I have an InnoDB dbase with

mysqldump

2004-04-06 Thread Ronan Lucio
Hi All, I have another question: I have a .sql file from a mysqldump did in a mysql-3.23.x Is there a way to restore it in a mysql-4.0.17? I´m trying to do it but the mysql return some errors like: # mysql -u root -p < ./dump-database.sql Enter password: ERROR 1050 at line 1923

Re: starting mysql daemon.... help me !!!

2004-04-06 Thread Ronan Lucio
The user that mysql run as, has permission to write in the /var/run/mysql dir? Ronan > muhammad alqama wrote: > > hi > > > > **(plz someone help me urgently)** > > > > i have tried the procedure mentioned below but of no avail. > > this is the exact message in .err file > > > > "can not s

Re: mysqldump

2004-04-06 Thread Ronan Lucio
Patrick, > >From your description, I assume you already have data in an existing version > 4 database that has existing table structures that are different from your > 3.23 dump. I didn´t have datas, but I had already run the mysql upgrade script. Because the original version of the MySQL in Linu

InnoDB and searchs

2004-04-12 Thread Ronan Lucio
Hi, We have a FULLTEXT search in our site. The is after we migrate the tables from MyISAM to InnoDB, this search stop working. Looking at the MySQL Documentation (http://dev.mysql.com/doc/mysql/en/Fulltext_Search.html) I´ve seen that it´s support for MyISAM tables online. So, how can I make a se

Search in Longtext fields

2004-04-16 Thread Ronan Lucio
Hi, Is it possible to make a search for a word in a longtext column from a InnoDB database? Thanks, Ronan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Process Monitoring

2004-04-20 Thread Ronan Lucio
Hi, We have a MySQL-Server-4.0.17 installed in our enterprise working fine... :-) Some times our application takes too bandwidth from the database server. So, I´m trying to figure out what (perhaps what select) is taking so manu bandwidth. SHOW FULL PROCESSLIST shows me the follow: mysql> show

Re: Process Monitoring

2004-04-20 Thread Ronan Lucio
Victor, > Are you logging slow queries? If so, have you looked in the slow query log? Yes, I am. But, it shows many of them and no one at this time. Or, it doesn´t show slow queries when the problem is occurring. I restarted the server 1 hour ago and after I did it, the server seems to be OK. I

Re: Process Monitoring

2004-04-20 Thread Ronan Lucio
Victor, > Do you have any around the approximate time? I know the time that the problem occurred. In the slow-log, it shows the line "Time". Is it line the hour the query ran? > The timestamp will be will the > query was written to the slow log and how long it took. What are the > symptoms that

Re: Process Monitoring

2004-04-20 Thread Ronan Lucio
> The timestamp is when the query was written to the log. You will have to > subtract the query time to get when the query began. Unless you have queries > that are running for long durations the timestamp and actual time should be > close. OK, so, slow query shouldn´t be my problem, because there

Re: Simple questions!!

2004-05-12 Thread Ronan Lucio
Kirti, > (1) I am going to setup a MySQL Client machine on a different Server. I > notice I can't install > a Client MySQL from Binary MySQL distro. Is it correct? I´m not sure, but I think you´ll have to install altmost the complet MySQL package on the client machine. Perhaps because the librari

Database structure

2004-05-11 Thread Ronan Lucio
Hi, I´m working in a project of a database that should be grow to more than 25,000,000 of clients. For all I´ve read in MySQL manual pages it´s too much records to place in only one table. So, my main doubt is how to divide it. I divide the client table in few tables according with the different

Inserting in a auto-inremental column

2004-05-13 Thread Ronan Lucio
Hi, Can I insert specifying the data into a auto-incremental column? Explain better: We have a database (MySQL-4.0.17) that I need to syncronize with a off-line software. If a client was inserted in the off-line software, I´ll need to import the client datas to the central database. The client

Re: Innodb + full text searching

2004-05-10 Thread Ronan Lucio
> Hi there, I am aware this isnt possible. I would like the power of Innodb, > but one of my applications also requires the boolean search within blocks of > text, how can i do this efficiently ? I know it isn´t so efficient, but you can use: SELECT * FROM yourtable WHERE text_column LIKE '%word%

Primary Key

2004-05-10 Thread Ronan Lucio
Hi, Is the Primary Key Column mandatory? Supposing: If I have two tables: Clients and Cars, and a third table Clients_R_Cars, that is a relationship between Clients and Cars. I only need to know what cars the clients have. So, I just need to two columns "CliCar_ClientsID" and "CliCar_CarsID", th

Standard of Column Names

2004-04-27 Thread Ronan Lucio
Hello, I´m doing the planing for an application that will use MySQL as database. So, I´d like to know your opinions about the standard for the column names. Supposing that I should create a table named car. Is it better to have either the column names (cod, name, description) or (car_cod, car_na

Doubt about TINYINT type

2004-04-27 Thread Ronan Lucio
Hi, If I create a column with the type TINYINT(2) UNSIGNED. Will the content can have the value minor than 510 (like a number 499), or will the content can have two values minor than 255 (like 11)? Thanks, Ronan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To

Re: Standard of Column Names

2004-04-27 Thread Ronan Lucio
Ruslan, > IMHO: > 1) Table name as prefix is unnecessary for me. It's norwegian notation > which I hate. > 2) Also I recomend look into ANSI SQL standard for reserved keywords. > I've got experience of porting DB from MySQL(allow some keywords) to > another DB, it's pain. Thank you your answer. D

Re: Doubt about TINYINT type

2004-04-27 Thread Ronan Lucio
Paul, > I don't know what "minor than" means Sorry by my english. I´d like to say "less than" (or something like this). > , but TINYINT is a single-byte > type. The range for TINYINT is -128 to 127, and the range for > TINYTINT UNSIGNED in 0 to 255. OK, I understood it, but I didn´t understand

  1   2   >