Re: How to optimize fulltext selection?

Hello Thank you so much. I Just increase the size of some buffers: # The MySQL server [mysqld] default-character-set = cp1251 port= 3306 socket = /x/xx.sock basedir = /x datadir = /x/x log-error = /x/error.log log-slow-queries = /x/slow.log pid-f

Re: How to optimize fulltext selection?

Hello GP> What state is SHOW PROCESSLIST reporting for this query? "Fulltext initialization" Sincerely, Michael, http://xoib.com/ http://3d2f.com/ http://qaix.com/ http://ryxi.com/ http://gyxe.com/ http://gyxu.com/ http://xywe.com/ http://xyqe.com/ -- MySQL General Mailing List For l

Re: How to optimize fulltext selection?

Hello GP> And MySQL uses a filesort algorithm. How to make the filesort faster? May be I have to increase size of some buffers? Sincerely, Michael, http://xoib.com/ http://3d2f.com/ http://qaix.com/ http://ryxi.com/ http://gyxe.com/ http://gyxu.com/ http://xywe.com/ http://xyqe.com/ --

Re: How to optimize fulltext selection?

Hello GP> Send to the list the output of 'SHOW VARIABLES' and 'SHOW STATUS' GP> statements, amount of RAM, most problematic queries (use mysqldumpslow GP> utility to find them) include tables' definitions (use SHOW CREATE GP> TABLE). SHOW VARIABLES; back_log50 basedir /***

How to optimize fulltext selection?

Hello, I have 200-300 kb slow log daily with fulltext queries only :-( All queries using fulltext indexes. I use huge mysql cofig (huge.cfg). What can I change in the mysql configuration for better performance? Sincerely, Michael, http://xoib.com/ http://3d2f.com/ http://qaix.com/ htt

Re: Backing Up Database and All Tables

Hello See some of this: MySQL Snap 2.1 http://3d2f.com/programs/2-075-mysql-snap-download.shtml Backup Watcher for MySQL 1.8.3 http://3d2f.com/programs/4-919-backup-watcher-for-mysql-download.shtml MySQL Dump Timer 1.2.4 http://3d2f.com/programs/12-670-mysql-dump-timer-download.shtml MySQLBackup

Re: MinGW and MySQL

Hello P> I'm using QT4.0 which works with MinGW. What is the MinGW ? Database server? Sincerely, Michael, http://xoib.com/ http://3d2f.com/ http://qaix.com/ http://ryxi.com/ http://gyxe.com/ http://gyxu.com/ http://xywe.com/ http://xyqe.com/ -- MySQL General Mailing List For list archi

Re: Mysql 5.x Trigger Examples

Hello CJS> I need a pratic examples of Triggers in Mysql 5.x Chapter 20. Triggers http://dev.mysql.com/doc/mysql/en/triggers.html Sincerely, Michael, http://xoib.com/ http://3d2f.com/ http://qaix.com/ http://ryxi.com/ http://gyxe.com/ http://gyxu.com/ http://xywe.com/ http://xyqe.com/

optimizing "not empty" selections

Hello, How to optimize != statement? SELECT * FROM table1 WHERE char_255_column != ''; How to fast select all rows, where CHAR(255) NOT NULL column not empty? Sincerely, Michael, http://xoib.com/ http://3d2f.com/ http://qaix.com/ http://ryxi.com/ http://gyxe.com/ http://gyxu.com/

Re: query on a very big table

Hello CA> The query takes ages to run (has been running for over 10 hours CA> now). Is this normal? I think, your indexes are too complicated. MySQL have to rebuild it usually after ALTER TABLE. Sincerely, Michael, http://xoib.com/ http://3d2f.com/ http://qaix.com/ http://ryxi.com/ h

Re: Questions about backups, InnoDB tables, etc.

Hello JT> Did you try that link? When I follow it, I get a search results page JT> saying <>. Too JT> bad it doesn't actually show the search results Sorry. Try this links http://solutions.mysql.com/search.php?pc=4%2C86&q=backup&level=0 http://solutions.mysql.com/software/?c=backup Since

Re: Questions about backups, InnoDB tables, etc.

Hello RS> I'm trying to get a handle on MySQL backups and hot backups using MyISAM RS> and InnoDB tables together. We plan to switch from SQL Server to MySQL RS> soon. Did you see it: http://solutions.mysql.com/search.php?pc=0%2C0&q=backup&level=0 ? Sincerely, Michael, http://xoib.com/ http

Re: random rows selection

Hello GP> Similar questions have been asked before. For example: GP> http://lists.mysql.com/mysql/184088 Thank you. I found something interesting: SELECT @rand_id:= CAST( 1 + MAX(id)*RAND() AS UNSIGNED) FROM history; SELECT * FROM history WHERE id >= @rand_id LIMIT 1; But this query can retur

random rows selection

Hello, How to select 5 random rows from big table with WHERE clause? This query very slow on 1 mln rows: SELECT col1, col2 FROM table WHERE col3=123 ORDER BY RAND() LIMIT 5 Have you a faster one? Sincerely, Michael, http://xoib.com/ http://3d2f.com/ http://qaix.com/ http://ryxi.com/ http://g

Re: Multitable selection

Hello GP> If you have faster solution (in several times) please introduce it. I've GP> seen similar issues at archives at: GP> http://lists.mysql.com/mysql I find it in docs :-) : (SELECT a FROM table_name WHERE a=10 AND B=1 ORDER BY a LIMIT 10) UNION (SELECT a FROM table_name WHERE a=11 AND B

Re: Multitable selection

Hello Now I use temporary table, but I can`t use SQL_CACHE in queries, which contain temporary table :-( In theory 90% queries can be cached. Sincerely, Michael, http://xoib.com/ http://3d2f.com/ http://qaix.com/ http://ryxi.com/ http://gyxe.com/ http://gyxu.com/ http://xywe.com/ http://xyqe.

Re: Multitable selection

Hello BM> Are you looking to compare a few last records in each table or ?? BM> Can I get a little bit more details? I have 10 similar tables. 3 years ago it was one big table. Now I split it to 10 tables. 3 years ago I could write: SELECT * from BigTable WHERE date_col>$some_date ORDER BY date

Re: Cant Get Access to My Databases

Hello I recommend you install mysql on your _home_ computer. After install last version MySQL-Front (www.mysql-front.com) and trying to connect from it. TH> I have finally gotten my MySQL server up and running. However, I am TH> having a bit of difficulty getting connected. TH> I am using D