RE: Multi-Table Query Problem...
Why don't you use Fulltext indexes, they are very fast and you use several columns. http://dev.mysql.com/doc/mysql/en/fulltext-search.html Best regards Alejandro -Mensaje original- De: nick [mailto:[EMAIL PROTECTED] Enviado el: Lunes, 14 de Marzo de 2005 05:59 p.m. Para: Mysql List Asunto: Re: Multi-Table Query Problem... On Mon, 14 Mar 2005 15:12:18 -0800, Scott Klarenbach wrote > Because, with the '%keyword%' operator, you're going to match any of > those columns that contain the keyword inside of it. This can be a > little confusing as 'ef' will return true on 'abcdefghijk'? Instead, > you might try 'keyword%' so that 'apple' returns true for 'apples', > 'apple juice', 'apple cider', BUT returns false for 'ple'. > > But, without seeing the results and what you'd hoped them to be, it's > tough to narrow down the problem. > > sk Yes, I understand, but that's not what I'm getting. I'm getting rows returned where "apples" is not present in any of the columns in any way. I think it's a syntax mistake in my query, but I can't see it. Nick -- 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: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Error on View
Hi, I installed the mysql 5.0.2 alpha for linux and i got an error after created a view and try to select * from the view. ERROR 2013: Lost connection to MySQL server during query Does anyone knows what is happening? Best Regards Alejandro
RE: Increasing the InnoDB log file size
Hello, I had the same issue myself, i read the manual and there says that you have to stop mysql, then change the parameter in my.cnf, then i moved to another directory the log file just to be cautious, and then restarted mysql. Everything went right. Best regards Alejandro -Mensaje original- De: Ronan Lucio [mailto:[EMAIL PROTECTED] Enviado el: Viernes, 10 de Diciembre de 2004 11:38 a.m. Para: [EMAIL PROTECTED] Asunto: Increasing the InnoDB log file size 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 file 0 134217728 bytes! 041210 13:27:40 [ERROR] Can't init databases 041210 13:27:40 [ERROR] Aborting 041210 13:27:40 [Note] /usr/local/libexec/mysqld: Shutdown complete 041210 13:27:40 mysqld ended Does anybody knows how can I do it? Thanks, Ronan -- 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: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RV: Innodb log file
Hi, How can i increase the size of the log file and log buffer size? i tried to change it on my.cnf file but it return this error message: InnoDB: Error: log file ./ib_logfile0 is of different size 0 5242880 bytes InnoDB: than specified in the .cnf file 0 67108864 bytes! 041028 0:10:49 Can't init databases 041028 0:10:49 Aborting thanks in advance Alejandro
Innodb log file
Hi, How can i increase the size of the log file and log buffer size? i tried to change it on my.cnf file but it return this error message: InnoDB: Error: log file ./ib_logfile0 is of different size 0 5242880 bytes InnoDB: than specified in the .cnf file 0 67108864 bytes! 041028 0:10:49 Can't init databases 041028 0:10:49 Aborting thanks in advance Alejandro
Weird behavior on varchar fields
Hi, I have one table that is presenting strange behaviour, we set the varchar field for not allow nulls so, on 5% of the records the application is inserting blanks but when we select the value and we set the condition ="" it returns the same as " " and " ". Even, we tried to set the field into the primary key to try to correct this, but is the same. We double check on the application and we have a lot of validation code to avoid this problem. Does anyone have any clue about it? Best Regards Alejandro
RE: help tuning a DB installation
Hi Jim, First of all, you should assingn a greater value for the key_buffer_size variable than 16k. This should help to reduce the readings on your hd. You should consider to set up the query cache. Best regards Alejandro -Mensaje original- De: Jim [mailto:[EMAIL PROTECTED] Enviado el: Martes, 03 de Agosto de 2004 01:36 p.m. Para: [EMAIL PROTECTED] Asunto: help tuning a DB installation Hi. I'm wondering if anyone can help me tune this database so it runs better on my hardware. I've made some attempts, but either they've made it worse or not changed anything. Changing the database design itself has shown the most improvement, but I'd still like to know how to tune things on the db side. I understand from the manual that "he two most important variables to configure are key_buffer_size and table_cache", but HOW to do this is another question. The machine is a 1.2 GHz Celeron, with 512 MB of RAM and an IDE disk. The database typically has about 40-50 open connections, most of them in state "Sleep", but with a few reads and writes, and two slaves replicating from it. Top looks like this: PID USER PRI NI SIZE RSS SHARE STAT %CPU %MEM TIME CPU COMMAND 15899 mysql 26 10 45004 12M 3864 S N 35.1 2.4 98:58 0 mysqld There is typically about 32M of swap being used by mysql. I can see that the HD light is almost always on. Here, finally, is the salient bit of the my.cnf file: [mysqld] port= 3306 socket = /tmp/mysql.sock skip-locking key_buffer = 16K max_allowed_packet = 1M table_cache= 4 sort_buffer_size = 128K net_buffer_length = 2K thread_stack = 64K set-variable = max_connections=750 set-variable = default-character-set=cp1251 log-bin server-id = 4 Thanks in advance for any advice. -- 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: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Index problem
Below are the answers Best Regards -Mensaje original- De: David Griffiths [mailto:[EMAIL PROTECTED] Enviado el: Miércoles, 30 de Junio de 2004 01:29 p.m. Para: [EMAIL PROTECTED] Asunto: Re: Index problem What's the definition of the table? IE are you indexing an INT, VARCHAR, etc? 3 fields Folio, Vacante, int Folio2 char(10) What's the definition of the index? Is it unique, composite, etc? Nonunique, single column (folio2) What's the storage engine in use? InnoDB? MyISAM? Myisam Can you show the relevant parts of your my.cnf file? I have the standard My-huge.cnf What operating system are you using? Redhat Linux 7.3 David Oropeza Querejeta, Alejandro wrote: >Hi, i'm trying to create an index on a table with 199 million records. >The problem is that is taking too long (8 hours and is not yet >finnished). > >does anyone have any idea? > >the server is 2Xeon 2.8 gigs with 6 Gb of ram. > >Best regards > >Alejandro > > > -- 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: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Index problem
Hi, i'm trying to create an index on a table with 199 million records. The problem is that is taking too long (8 hours and is not yet finnished). does anyone have any idea? the server is 2Xeon 2.8 gigs with 6 Gb of ram. Best regards Alejandro
RV: Select data from two different databases
Hi, two questions: Is it possible to select data from different Databases on the same server? Is it possible to select data from different Databases on Different servers across the network? I searched for information on how to do it, but i haven't found any. thanks in advance Alejandro
Select data from two different databases
Hi, two questions: Is it possible to select data from different Databases on the same server? Is it possible to select data from different Databases on Different servers across the network? I searched for information on how to do it, but i haven't found any. Best Regards Alejandro