very slow subselect on large innoDB table

2005-09-08 Thread mathias brandt
please help! i have a fairly large innoDB table with 800mb (index 500 mb, data 300mb) and 1.8 million data sets. the server has 8 gig ram. the statement SELECT id FROM table1 WHERE cityname = 'bla' (cityname has been indexed) takes 0.0002 seconds and returns 0 rows, which was expected.

To split or not to split columns

2005-07-08 Thread Mathias
expression? - Mathias -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Multi-Table Insert Strategy

2005-07-03 Thread Mathias
-table_current_column_value_error.html Hope that helps :o) Mathias -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Some query help

2005-07-02 Thread Mathias
help, too! Shawn Green Database Administrator Unimin Corporation - Spruce Pine Hi Matt, SELECT DISTINCT(distance) FROM fiber_config WHERE fiber_type = 2 AND bandwidth min(2200, 2200, 2200, 220) ORDER BY distance ASC Hope that helps :o) Mathias -- MySQL General Mailing List For list

Re: Some query help

2005-07-02 Thread Mathias
Selon Mathias [EMAIL PROTECTED]: Selon [EMAIL PROTECTED]: Matt Babineau [EMAIL PROTECTED] wrote on 07/01/2005 05:05:28 PM: Hi Again - I need some more help with a query. I have a list of numbers (bandwidth required)... 2200, 2200, 2200, 400, 320 My data looks like

Re: Possible to delay index writes until server is less busy?

2005-07-01 Thread Mathias
[EMAIL PROTECTED] wrote: Write to a memory table first then do a hotcopy on a scheduled basis. I'll look into that. Thanks for your reply. - Mathias - Original Message - From: Mathias [EMAIL PROTECTED] To: mysql@lists.mysql.com Sent: Thursday, June 30, 2005 9:10 AM Subject

Re: Possible to delay index writes until server is less busy?

2005-07-01 Thread Mathias
Dan Nelson wrote: In the last episode (Jun 30), Mathias said: We've been benchmarking a database that in real-life will have a huge write load (max peak load 1 inserts/second) to the same table (MyISAM). We will need about 4 indexes for that table. However, from our benchmark tests

Re: Possible to delay index writes until server is less busy?

2005-07-01 Thread Mathias
Write to a memory table first then do a hotcopy on a scheduled basis. Do you mean converting the memory table into MyISAM on a scheduled basis? (mysqlhotcopy only works on MyISAM and ISAM tables). Or is there a faster way of storing the table to disk? - Mathias We've been benchmarking

Possible to delay index writes until server is less busy?

2005-06-30 Thread Mathias
not find anything in the MySQL documentation concerning this. Any suggestions would be greatly appreciated. Kind regards, Mathias -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: A question about the select count(*) performance and the InnoDB engine

2005-06-28 Thread Mathias
for sqlserver, sybase ..., but when your RDBMs have a data dictionnary, you don't need to execute count(*) :o) WITH Updated statistics of course. With information_schema in 5.x and higher, innodb will act as it's done in all the other RDBMS. Hope that helps :o) Mathias -- MySQL General Mailing List

Re: A question about the select count(*) performance and the InnoDB engine

2005-06-28 Thread Mathias
Selon Behrang Saeedzadeh [EMAIL PROTECTED]: Mathias, Thanks a lot! I will not explain the same thing for sqlserver, sybase ..., but when your RDBMs have a data dictionnary, you don't need to execute count(*) :o) WITH Updated statistics of course. I'm a little bit confused here

Re: A question about the select count(*) performance and the InnoDB engine

2005-06-28 Thread Mathias
Selon [EMAIL PROTECTED]: Mathias [EMAIL PROTECTED] wrote on 06/28/2005 06:13:08 AM: Selon Behrang Saeedzadeh [EMAIL PROTECTED]: Mathias, Thanks a lot! I will not explain the same thing for sqlserver, sybase ..., but when your RDBMs have a data dictionnary, you don't

Re: A question about the select count(*) performance and the InnoDB engine

2005-06-28 Thread Mathias
Selon [EMAIL PROTECTED]: Mathias [EMAIL PROTECTED] wrote on 06/28/2005 01:11:59 PM: Selon [EMAIL PROTECTED]: snip Thanks Shawn, but i'm not speaking about data consistency during transaction and isolation levels. I spoke about what is seen in the data dictionary as num_rows

Re: How to edit part of a field?

2005-06-28 Thread Mathias
Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] Hi, update TABLE set field=replace(field,'=1234','=5678'); that's it. Hope that helps :o) Mathias -- MySQL General Mailing List For list archives: http://lists.mysql.com

Re: Joining tables - restricting selected records

2005-06-28 Thread Mathias
archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] Hi , join the tables with max(purshase_date) in the select,an dof course group by customer_id Hope that helps :o) Mathias -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql

Re: Joining tables - restricting selected records

2005-06-28 Thread Mathias
Selon Michael Stassen [EMAIL PROTECTED]: Mathias wrote: Selon Russell Horn [EMAIL PROTECTED]: This must have come up before, but I've not found it using a google search. I have two tables customer and purchases customer: customerID customerName purchases: purchaseID

Re: Ordinal number within a table

2005-06-28 Thread Mathias
] as row, fields FROM tables WHERE ...'; my $sth = $conn-prepare($sql); $sth-execute(); return $sth-fetchall_arrayref( {} ); Thanks for any help. Nishi Mathias wrote: Hi, You dont need to use @row in perl, just use : $n=0; while (fetch..) { $n++; print $n

Re: ORDER by Question

2005-06-27 Thread Mathias
| ++ | | | | | | | | | The Yeti | Rigth order | Xylophone | | Zyxel | | The | | The | | The | | The | | | ++ 12 rows in set (0.00 sec) Mathias

Re: ORDER by Question

2005-06-27 Thread Mathias
in set (0.02 sec) Hope that's better Mathias Selon Hassan Schroeder [EMAIL PROTECTED]: Mathias wrote: you didn't give an alternative, but i've forgotten just a '^' : mysql SELECT * FROM names ORDER BY REPLACE(name,'^The ',''); No, sorry -- that doesn't work at all; REPLACE takes a string

Re: ORDER by Question

2005-06-27 Thread Mathias
Selon Hassan Schroeder [EMAIL PROTECTED]: Mathias wrote: This is the right structure including The in the middle : mysql SELECT * FROM names ORDER BY case when substring(name,1,3)='The' then REPLACE(name,'The ','') else name end; ? all of which produces exactly

RE: [SPAM] - Unable to install mysql - Bayesian Filter detected spam

2005-06-26 Thread Mathias
sec) have you tried an update ? mysql UPDATE mysql.user SET Password=OLD_PASSWORD('newpass') WHERE User='yannick' AND Host='localhost'; mysql FLUSH PRIVILEGES; Mathias Selon Yannick [EMAIL PROTECTED]: Mathias, I would love to do it but this is the answer : mysql SET PASSWORD

Re: CHECK constraint

2005-06-26 Thread Mathias
1062 (23000): Duplicate entry '' for key 1 Mathias Selon Michael Kruckenberg [EMAIL PROTECTED]: Hi, Use enum with a default type and let mysql do the check for you. The problem with an enum is that if you insert a value that's not in the enum, MySQL doesn't stop the insert, it leaves

RE: [SPAM] - Unable to install mysql - Bayesian Filter detected spam

2005-06-26 Thread Mathias
You are not granted access to mysql. So ask your root user to modify your password. impossible else. Mathias Selon Yannick [EMAIL PROTECTED]: Hey Mathias, See the results below. I just have 1 database called test; There is no user database. mysql mysql use mysql ERROR 1044: Access

Re: upgrade mysql 3.23.58 to 4.1

2005-06-26 Thread Mathias
, that should be the reason. just retransfer using binary mode. ELse, i can't see. have you tried an install of one of them ? Hope that helps :o) Mathias -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: [SPAM] - Unable to install mysql - Bayesian Filter detected spam

2005-06-26 Thread Mathias
to a password different from the linux root. Then create other users and databases. Mathias Selon Yannick [EMAIL PROTECTED]: Hi, I'm not sure you understand the issue. I have the root in linux but not in mysql ! All I want is to install mysql on my linux suse 9.0. Of course, I have the root

RE: [SPAM] - Unable to install mysql - Bayesian Filter detected spam

2005-06-26 Thread Mathias
Try : fujitsu:/home/yannick # mysql -u root -p Then ENTER fujitsu:/home/yannick # mysql -u root -h localhost -P 3306 -p Then ENTER Mathias Selon Yannick [EMAIL PROTECTED]: Hey, Thanks for your help till so far but I'm still with my issue ! Is there any other support possible? FYI, I just

Re: ORDER by Question

2005-06-26 Thread Mathias
| | The | +--+ 5 rows in set (0.00 sec) Hope that helps :o) Mathias -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: 4.1.x with php-4.3.x

2005-06-26 Thread Mathias
PROTECTED] website: http://www.nusconsulting.com.au -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] haven't try WAMP5 ? http://www.wampserver.com/en/ Hope that helps :o) Mathias -- MySQL General Mailing

Re: 4.1.x with php-4.3.x

2005-06-26 Thread Mathias
extension, which is more secure and provides a much better API. http://fr.php.net/mysql I hope someone else gives you an url for such dll. Mathias Selon Daniel Kasak [EMAIL PROTECTED]: Mathias wrote: haven't try WAMP5 ? http://www.wampserver.com/en/ I didn't know of this site, no. I'm new

Re: How do you think about PostgreSQL and mysql?

2005-06-25 Thread Mathias
Hi Stone, if you ask me which is bettet your car or mine, i'll answer mine. Your question can't be answered here because it's not technical but political. Better close this thread. Mathias Selon stone.wang [EMAIL PROTECTED]: How do you think about PostgreSQL and mysql? want to know which

Re: problem with mysqldump when there is a merge table

2005-06-25 Thread Mathias
Hi, Have you tried '\\' ? Mathias Selon nyem [EMAIL PROTECTED]: Hello, I have a database (on Win2k) with merge table. Mysqldump output includes some path information on the merged tables such as DATA DIRECTORY and INDEX DIRECTORY DROP TABLE IF EXISTS `rptpricing1996`; CREATE TABLE

Re: why donn't work mysql_real_connect

2005-06-25 Thread Mathias
to database: Error: %s\n, mysql_error(mysql)); } They give port, unix_socket, client_flag the values 0,NULL,0. Try this. All the rest is at http://dev.mysql.com/doc/mysql/en/mysql-real-connect.html and http://dev.mysql.com/doc/mysql/en/c-api-functions.html Mathias Selon mm

Re: Backup and Maintenance Strategies

2005-06-25 Thread Mathias
transactions during backup operation. If your data are not crtical (as you say), the database availability is not also. You can stop it and take an offline filesystem backup. Hope that helps :o) Mathias -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

Re: Searching IN a comma separated list

2005-06-25 Thread Mathias
| +--+-+---+ 6 rows in set (0.00 sec) Et voilà. Hope that helps :o) Mathias -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: CHECK constraint

2005-06-25 Thread Mathias
://www.amazon.com/exec/obidos/ASIN/159059505X -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] Hi, Use enum with a default type and let mysql do the check for you. Hope that helps :o) Mathias -- MySQL

RE: [SPAM] - Unable to install mysql - Bayesian Filter detected spam

2005-06-25 Thread Mathias
://lists.mysql.com/[EMAIL PROTECTED] Hope that helps :o) Mathias -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: [SPAM] - Unable to install mysql - Bayesian Filter detected spam

2005-06-25 Thread Mathias
Another thing : fujitsu:/home/yannick # mysql ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) fujitsu:/home/yannick # is normal: try fujitsu:/home/yannick # mysql -u yannick -p Mathias Selon Mathias [EMAIL PROTECTED]: Hi , You did a confusion between root

RE: [SPAM] - Unable to install mysql - Bayesian Filter detected spam

2005-06-25 Thread Mathias
Since you can connect as yannick without password, just set it after login : mysql SET PASSWORD FOR 'yannick'@'localhost' = PASSWORD('newpass'); see http://dev.mysql.com/doc/mysql/en/set-password.html for more details. I advice to set it to another password than your yannick linux one. Mathias

Re: Searching IN a comma separated list

2005-06-25 Thread Mathias
Vous être le bienvenue :o) Selon W Luke [EMAIL PROTECTED]: On 25/06/05, Mathias [EMAIL PROTECTED] wrote: I then write you this query which should give you the idea, and i think the solution : mysql select gid,ugid,FIND_IN_SET(gid,ugid) from groups,groupsList - where FIND_IN_SET

RE: Prevalidating queries?

2005-06-13 Thread mathias fatene
back to myisam. This is simplier. But you can also decide to take intermadiate backups when upgrading. Best Regards Mathias FATENE Hope that helps *This not an official mysql support answer -Original Message- From: Andy Pieters [mailto:[EMAIL PROTECTED] Sent: mardi

RE: using if in select statement

2005-04-29 Thread mathias fatene
Hi, you can continue playing. It's a true game :o) Best Regards Mathias FATENE Hope that helps *This not an official mysql support answer -Original Message- From: James Black [mailto:[EMAIL PROTECTED] Sent: vendredi 29 avril 2005 02:20 To: 'mysql

RE: order by version number

2005-04-29 Thread mathias fatene
Hi, select a from versions order by substring_index(a,'.',-2); Best Regards Mathias FATENE Hope that helps *This not an official mysql support answer -Original Message- From: Stano Paska [mailto:[EMAIL PROTECTED] Sent: vendredi 29 avril 2005 08:21 To: mysql

RE: Pessimistic Record Locking

2005-04-29 Thread mathias fatene
number of users. Best Regards Mathias FATENE Hope that helps *This not an official mysql support answer -Original Message- From: Scott Klarenbach [mailto:[EMAIL PROTECTED] Sent: vendredi 29 avril 2005 20:28 To: My SQL Subject: Pessimistic Record Locking Hello

RE: IN giving me a fit

2005-04-29 Thread mathias fatene
| +--+--+ 1 row in set (0.01 sec) Joisn are better than subqueries. Best Regards Mathias FATENE Hope that helps *This not an official mysql support answer -Original Message- From: Scott Purcell [mailto:[EMAIL PROTECTED] Sent: vendredi 29 avril 2005 20:14 To: mysql

RE: ONLY_FULL_GROUP_BY too strict on MySQL 4.1.11

2005-04-29 Thread mathias fatene
the directory where the UNIX socket file is to be located if the directory does not exist. T... [ read more about MySQL ] http://www.softpedia.com/progDownload/MySQL-for-Windows-Download-2668.ht ml Best Regards Mathias FATENE Hope that helps *This not an official mysql support answer

RE: Seeking advice on currency type

2005-04-29 Thread mathias fatene
Here are datatypes and sizes. The problem can be storage. http://dev.mysql.com/doc/mysql/en/storage-requirements.html Best Regards Mathias FATENE Hope that helps *This not an official mysql support answer -Original Message- From: Hassan Schroeder [mailto

RE: Newbie Q - Re: Copying databases

2005-04-29 Thread mathias fatene
http://dev.mysql.com/doc/mysql/en/backup.html It's better to backup with tools. You will be sure that tables are FULL-locked. Best Regards Mathias FATENE Hope that helps *This not an official mysql support answer -Original Message- From: [EMAIL PROTECTED

RE: Does anyone have experience?

2005-04-28 Thread mathias fatene
Hi, Had you read http://dev.mysql.com/doc/mysql/en/odbc-connector.html One can't see the mysql ODBC driver in your snapshot. Best Regards Mathias FATENE Hope that helps *This not an official mysql support answer -Original Message- From: [EMAIL PROTECTED

RE: mysql top 2 rows for each group

2005-04-28 Thread mathias fatene
| | 00427 | 1 | | 00427 | 2 | | 00427 | 3 | +---++ 10 rows in set (0.00 sec) - I like this type of auto_increment Best Regards Mathias FATENE Hope that helps *This not an official mysql support answer

RE: mysql top 2 rows for each group

2005-04-28 Thread mathias fatene
| +---++ 8 rows in set (0.00 sec) Best Regards Mathias FATENE Hope that helps *This not an official mysql support answer -Original Message- From: mathias fatene [mailto:[EMAIL PROTECTED] Sent: jeudi 28 avril 2005 22:52 To: 'Jay Blanchard'; 'Vivian Wang'; mysql

RE: No error / warning when data is truncated on insertion into mysql

2005-04-28 Thread mathias fatene
; +--+--+ | a| b| +--+--+ | 127 | Long | my 500 is also truncated +--+--+ 1 row in set (0.00 sec) Best Regards Mathias FATENE Hope that helps *This not an official mysql support answer -Original Message- From: Anoop kumar V [mailto

RE: query question

2005-04-27 Thread mathias fatene
Hi, If i understand : select month(entryDate) as monthPart, if (amount is nul,'',day(entryDate) ) as dayPart, amount from raindata order by dayPart, monthPart Best Regards Mathias FATENE Hope that helps *This not an official mysql support answer -Original

RE: host info

2005-04-27 Thread mathias fatene
That's it:o) Best Regards Mathias FATENE Hope that helps *This not an official mysql support answer -Original Message- From: Stanton, Brian [mailto:[EMAIL PROTECTED] Sent: mercredi 27 avril 2005 23:12 To: 'mysql@lists.mysql.com' Subject: RE: host info

RE: Python related MySQL question

2005-04-26 Thread mathias fatene
Look at db.use_result() and db.store_result() here : http://www.birgerblixt.com/doc/packages/python-mysql/MySQLdb-2.html#ss2. 2 Best Regards Mathias FATENE Hope that helps *This not an official mysql support answer -Original Message- From: Smelly Socks [mailto

RE: Query question

2005-04-26 Thread mathias fatene
Yes ten years and forgot mysql certified. I can offer i-am-a-dummy to you if you lack. I've never imagined find so bad people on the list. But i'll write to the moderator to see who is on. But i'm pleased to help people wihout naz mentality than yours. Best Regards Mathias

RE: Replication - is there a server lag?

2005-04-25 Thread mathias fatene
| | | +---+--+--+--+ 1 row in set (0.02 sec) And show slave status; When reading from slave, data can be not synchronized. If you configured log-bin, you can use mysqlbinlog to read it. Best Regards Mathias FATENE Hope that helps

RE: joining six tables by mutual column

2005-04-25 Thread mathias fatene
Mathias FATENE Hope that helps *This not an official mysql support answer -Original Message- From: Schalk Neethling [mailto:[EMAIL PROTECTED] Sent: lundi 25 avril 2005 00:52 To: mysql@lists.mysql.com Subject: joining six tables by mutual column Greetings everyone. Hope someone can give

RE: libCstd.so.1 not found while running mysql_install_db

2005-04-25 Thread mathias fatene
Do you have /cnem/server/bin/mysqld file ? Is it exec (6xx)? Best Regards Mathias FATENE Hope that helps *This not an official mysql support answer -Original Message- From: Anirban Karmakar [mailto:[EMAIL PROTECTED] Sent: lundi 25 avril 2005 09:12 To: mysql

RE: libCstd.so.1 not found while running mysql_install_db

2005-04-25 Thread mathias fatene
Read 7xx Best Regards Mathias FATENE Hope that helps *This not an official mysql support answer -Original Message- From: mathias fatene [mailto:[EMAIL PROTECTED] Sent: lundi 25 avril 2005 10:18 To: 'Anirban Karmakar'; 'mysql@lists.mysql.com' Subject: RE

RE: Ordering rows whit a select from where in ( exp )

2005-04-25 Thread mathias fatene
='10' Union SELECT field_name FROM meta WHERE id ='12' Mathias Best Regards Mathias FATENE Hope that helps *This not an official mysql support answer -Original Message- From: Adrian [mailto:[EMAIL PROTECTED] Sent: lundi 25 avril 2005 10:06 To: mysql

RE: Converting to InnoDB?

2005-04-25 Thread mathias fatene
Yes, but your myIsam Tables stay myisam ones. After restarting, you must change them to innodb by : Alter table toto storage=innodb. For new tables, they will have innodb storage. Best Regards Mathias FATENE Hope that helps *This not an official mysql support answer

RE: Converting to InnoDB?

2005-04-25 Thread mathias fatene
Sorry, Alter table toto ENGINE=innodb. You don't must, you can. You can also have differents storage ENGINES in the same mysql database. With innodb, you will earn ROW level locking. Best Regards Mathias FATENE Hope that helps *This not an official mysql support answer

RE: Query question

2005-04-25 Thread mathias fatene
sec) The max will be used with your datetime column. The son table can not be used, or joined to the mother. Best Regards Mathias FATENE Hope that helps *This not an official mysql support answer -Original Message- From: Jeff McKeon [mailto:[EMAIL PROTECTED

RE: Query question

2005-04-25 Thread mathias fatene
, especially with mysql (DBMS till now). Best Regards Mathias FATENE Hope that helps *This not an official mysql support answer -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: lundi 25 avril 2005 21:44 To: mathias fatene Cc: 'Jeff McKeon

RE: Query question

2005-04-25 Thread mathias fatene
|NULL | NULL |0 | Using temporary; Using filesort | ++-++--+---+--+-+--- ---+--+-+ One or two table scans ? Best Regards Mathias FATENE Hope that helps *This not an official mysql

RE: Query question

2005-04-25 Thread mathias fatene
Mathias FATENE Hope that helps *This not an official mysql support answer -Original Message- From: Peter Brawley [mailto:[EMAIL PROTECTED] Sent: lundi 25 avril 2005 22:17 To: Jeff McKeon Cc: mysql@lists.mysql.com Subject: Re: Query question Jeff, Then do it with 2

RE: Query question

2005-04-25 Thread mathias fatene
if you have to criticize or complete an answer, it's your right. The list is for that. If you want to speak to me as your student, this is enough. I never did it when i was teacher 11 years ago. Best Regards Mathias FATENE Hope that helps *This not an official mysql support

RE: database migration puzzle.

2005-04-25 Thread mathias fatene
Hi, I hope that this link will help http://dev.mysql.com/doc/mysql/en/upgrading-from-4-0.html Best Regards Mathias FATENE Hope that helps *This not an official mysql support answer -Original Message- From: Kenneth Wagner [mailto:[EMAIL PROTECTED] Sent: mardi 26

RE: Crosstab in Mysql

2005-04-25 Thread mathias fatene
(IF (insumo_or = Animal5, cantidad_or, 0) ) AS Animal5, Sum(IF (insumo_or = Animal6, cantidad_or, 0) ) AS Animal6 FROM tbl_ISv2CROriginal Group by FK_partic ? Best Regards Mathias FATENE Hope that helps *This not an official mysql support answer -Original Message- From

RE: Index help ?

2005-04-25 Thread mathias fatene
) sould be sufficient. Best Regards Mathias FATENE Hope that helps *This not an official mysql support answer -Original Message- From: Michael Gale [mailto:[EMAIL PROTECTED] Sent: mardi 26 avril 2005 05:49 To: mysql@lists.mysql.com Subject: Index help ? Hello

RE: Performance issues when deleting and reading on large table

2005-04-24 Thread mathias fatene
or not of internal temporary tables, ... Mathias -Original Message- From: Jigal van Hemert [mailto:[EMAIL PROTECTED] Sent: dimanche 24 avril 2005 17:05 To: Almar van Pel; mysql@lists.mysql.com Subject: Re: Performance issues when deleting and reading on large table From: Almar van Pel

RE: mysql_performance

2005-04-24 Thread mathias fatene
help you to execute your query in less than 20mn. Question : count(*) from EMP = ? Mathias -Original Message- From: Peter Brawley [mailto:[EMAIL PROTECTED] Sent: dimanche 24 avril 2005 17:39 To: [EMAIL PROTECTED] Cc: mysql@lists.mysql.com Subject: Re: mysql_performance Moemen, You assign

RE: Performance issues when deleting and reading on large table

2005-04-24 Thread mathias fatene
of selects (using indexes), spool results to files, delete rows, and load data from files. It took 1.5 hour to finish a 650Mo data with all the checking operations. Mathias -Original Message- From: Almar van Pel [mailto:[EMAIL PROTECTED] Sent: dimanche 24 avril 2005 18:44 To: mysql

RE: Table handler errors

2005-04-24 Thread mathias fatene
redefine it, it may work better in memory. Else use temporary tables. Mathias -Original Message- From: Jigal van Hemert [mailto:[EMAIL PROTECTED] Sent: dimanche 24 avril 2005 17:08 To: [EMAIL PROTECTED] Cc: MySQL List Subject: Re: Table handler errors Yes, I've going through the docs

RE: Multi condition/table select

2005-04-24 Thread mathias fatene
Products: id=int 11 primary key name=varchar catid int 11 The query will then be evident. Mathias -Original Message- From: Andy Pieters [mailto:[EMAIL PROTECTED] Sent: dimanche 24 avril 2005 19:35 To: mysql@lists.mysql.com Subject: Multi condition/table

RE: Performance issues when deleting and reading on large table

2005-04-24 Thread mathias fatene
-datatype.html. Massive load is better without indexes, which are only good for selects. Mathias -Original Message- From: Jigal van Hemert [mailto:[EMAIL PROTECTED] Sent: dimanche 24 avril 2005 19:46 To: Almar van Pel; mysql@lists.mysql.com Cc: 'mathias fatene' Subject: Re: Performance issues

RE: MYSQL to XML

2005-04-24 Thread mathias fatene
Hi Mikel, There are a lot of possibilities including commercial (:o)) products. I suggest you those solutions. The output should be reparsed for your needs : 1. the -X on client : C:\Mysqlmysql -u mathias world -X -e desc country ?xml version=1.0? resultset statement=desc country

RE: setting character sets permanently

2005-04-24 Thread mathias fatene
/ | +--+ -+ That's all. Mathias -Original Message- From: Fagyal Csongor [mailto:[EMAIL PROTECTED] Sent: dimanche 24 avril 2005 22:33 To: mysql@lists.mysql.com Subject: setting character sets permanently HI, I am using MySQL 4.1.11 on FC3, and I have

RE: setting character sets permanently

2005-04-24 Thread mathias fatene
). Export/import should be a good trick. But Latin2 seems more general that latin1. Best Regards Mathias FATENE Hope that helps *This not an official mysql support answer -Original Message- From: mathias fatene [mailto:[EMAIL PROTECTED] Sent: dimanche 24 avril 2005 22

RE: setting character sets permanently

2005-04-24 Thread mathias fatene
2 other things : 1. what is your character set when you install the mysql server ? 2. what characater set you see with show create database ? Best Regards Mathias FATENE Hope that helps *This not an official mysql support answer -Original Message- From

need reference for a good book

2004-03-28 Thread A Mathias
Preferably one that is for begginers to medium and thats covers both mySQL and PHP Thanks

local installation on XP

2004-03-21 Thread A Mathias
#= #port=3306 #set-variable=key_buffer=16M [WinMySQLadmin] Server=C:/mysql/bin/mysqld-nt.exe user=** password=* A Mathias

RE: local installation on XP

2004-03-21 Thread A Mathias
Open a command prompt and attempt to start the service by navigating to the mysql\bin directory and typing mysqld --console - this runs some INNODB commands mysqld --install - this starts the mysql service hth -Original Message- From: A Mathias [mailto:[EMAIL PROTECTED] Sent

this newbies project :-)

2003-12-13 Thread A Mathias
Hey everyone :-) This is my first post to the list and I would like to thank everyone for this great resource. I'm relatively new to mySQL and a novice at PHP, but here is a description of what I am trying to do. My objective is to create a database that will provide variables for a series of

MATCH / AGAINST fatal bug

2003-03-11 Thread Mathias Berchtold
MATCH / AGAINST fatal bug MySQL version: 4.0.11-gamma OS : Windows 2000 SP3 RAM: 1GB Apacer Free Disk Space: 32GB HD Write Back Cache: Disabled Under some circumstances the following query does never terminate. The win32 service cannot be stopped either = FATAL.

MATCH / AGAINST bug/problem

2003-03-07 Thread Mathias Berchtold
MATCH / AGAINST problem/bug MySQL version: 4.0.11-gamma OS : Windows 2000 SP3 Under some circumstances this query does never terminate. The win32 service cannot be stopped either. SELECT f.id as id, fs.name as name, MATCH (f.title,f.body) AGAINST ('550') AS score FROM

RE: MATCH / AGAINST bug/problem

2003-03-07 Thread Mathias Berchtold
Hi .. Free disk space: 32GB Thats not the problem I guess. -Mat -Original Message- From: gerald_clark [mailto:[EMAIL PROTECTED] Sent: Freitag, 7. März 2003 22:03 To: Mathias Berchtold Cc: [EMAIL PROTECTED] Subject: Re: MATCH / AGAINST bug/problem I you run low on temp filesystem

MySQL embedded?

2002-07-18 Thread Mathias Bertelsen
if it's a stupid question but i am really not used to making regular applications... :) and i didn't find an answer on mysql.com... /Mathias - Before posting, please check: http://www.mysql.com/manual.php (the manual) http

Re: MySQL embedded?

2002-07-18 Thread Mathias Bertelsen
if it complicates the code having these two options available for the user? Do the database have the same interface and features available (eg. transactions) in both these two options? /Mathias - Original Message - From: Jan Peuker [EMAIL PROTECTED] To: Mathias Bertelsen [EMAIL PROTECTED] Sent

MySQL security

2002-07-16 Thread Mathias Bertelsen
enough to keep peoples bookkeeping in? is it safe enough to use without risk of losing important data? Is it necessary to do anything to make it secure? (eg. use of transactions/backup/power failure security) Any comments are welcome :) /Mathias

HEAP table size

2002-01-30 Thread Mathias Johansson
MEDIUMINT NOT NULL, PRIMARY KEY(id) ) TYPE = HEAP; How would I calculate the memory used for 1 row? Thank you, Mathias ___ Spara filer på nätet. Lagra upp till 500 Mb på Passagen http://webbdrive.passagen.se