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.
expression?
- Mathias
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
-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]
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
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
[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
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
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
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]
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
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
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
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
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
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
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
] 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
|
++
| |
| |
| |
| |
| The Yeti | Rigth order
| Xylophone |
| Zyxel |
| The |
| The |
| The |
| The |
| |
++
12 rows in set (0.00 sec)
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
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
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
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
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
, 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]
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
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
|
| 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]
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
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
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
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
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
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
|
+--+-+---+
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]
://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
://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]
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
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
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
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
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
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
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
|
+--+--+
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
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
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
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
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
|
| 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
|
+---++
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
;
+--+--+
| 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
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
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
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
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
| | |
+---+--+--+--+
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
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
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
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
='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
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
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
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
, 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
|NULL |
NULL |0 | Using temporary; Using filesort |
++-++--+---+--+-+---
---+--+-+
One or two table scans ?
Best Regards
Mathias FATENE
Hope that helps
*This not an official mysql
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
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
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
(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
) 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
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
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
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
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
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
-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
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
/ |
+--+
-+
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
). 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
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
Preferably one that is for begginers to medium and thats covers both mySQL and PHP
Thanks
#=
#port=3306
#set-variable=key_buffer=16M
[WinMySQLadmin]
Server=C:/mysql/bin/mysqld-nt.exe
user=**
password=*
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
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
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 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
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
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
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
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
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
91 matches
Mail list logo