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.
t
expression?
- Mathias
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
980
http://archives.neohapsis.com/archives/mysql/2004-q3/3604.html
http://forums.devshed.com/archive/t-51965/Insert-Into
http://lists.nyphp.org/pipermail/talk/2003-September/005768.html
http://dev.mysql.com/doc/mysql/en/innodb-multi-versioning.html
http://www.issociate.de/board/post/26176/Ref:_WCL302_Subject:_UPDATE_multi-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]
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
ists. What would I need
> to compare to come up with the correct choices?
>
> Make sure you respond to the list so that everyone else can 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 archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 benchma
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 test
[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:
Sent: Thursday, June 30, 2005 9:10 AM
could 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]
nection specific. Are you making the mistake of
> opening and closing a connection for each query? That's unneccessary, and it
> adds a lot of overhead.
>
> > How can I execute both (a) and (b) in my perl script?
>
> The same way you would execute any two statements, o
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 hav
of their last purchase?
>
> Thanks!
>
> Russell.
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
>
>
Hi ,
join the tables with max(purshase_date) in the sel
o the entire table with a single SQL
> statement If so I have no idea how to create it. Any help
> appreciated. :)
>
> - Brian
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
Selon [EMAIL PROTECTED]:
> Mathias <[EMAIL PROTECTED]> wrote on 06/28/2005 01:11:59 PM:
>
> > Selon [EMAIL PROTECTED]:
> >
>
> >
> > Thanks Shawn, but i'm not speaking about data consistency during
> > transaction and
> > isolation levels.
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 e
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
> > Upd
35 0 1 1 - 1575 0 -
100 ---
LOOK At the column CARD.
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.
With informa
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 |
| |
+----+
13 rows 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 '^' :
>
he |
| |
++
12 rows in set (0.00 sec)
Mathias
Selon Sergey Spivak <[EMAIL PROTECTED]>:
> Hi
>
> > this,among other answers, can be done :
> >
> > mysql> select * from names;
> > +--+
> > | name |
> >
ysqli 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.c
Australia 2060
> T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989
> email: [EMAIL 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]
lect * from names order by replace(name,'The ','');
+--+
| name |
+------+
| |
| The |
| |
| |
| 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]
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 su
;
password 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
ks,
> >>MT
> >>
> >>
> >>--
> >>MySQL General Mailing List
> >>For list archives: http://lists.mysql.com/mysql
> >>To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
> >>
> >>
> >>
> >>
> >
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.
>
>
in set (0.00 sec)
mysql> INSERT INTO enum_test VALUES (1,'test3');
ERROR 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.
>
>
ow in set (0.00 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
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
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
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 ,
&
at Apr 2 08:57:10 UTC 2005
> > i686
> > i686 i386 GNU/Linux
> > Architecture: i686
> >
> > Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc
> > /usr/bin/cc
> > GCC: Lecture des spécification à partir de
> > /usr/lib/gcc-lib/i586-suse-l
IL PROTECTED]
> >
>
> Mike Kruckenberg
> [EMAIL PROTECTED]
> "ProMySQL" Author
> http://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 General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
FIND_IN_SET(gid,ugid) |
+--+-+---+
|1 | 1,2,3,4 | 1 |
|2 | 1,2,3,4 | 2 |
| 3 | 1,2,3,4 | 3 |
|2 | 2,5,6 | 1 |
|3 | 3,4,5 | 1 |
|9 | 7,4,9 | 3 |
+--+-+---+
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]
see innobackup which can do online backup since it can manage
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 L
ysql-real-connect.html
and http://dev.mysql.com/doc/mysql/en/c-api-functions.html
Mathias
Selon mm <[EMAIL PROTECTED]>:
> Dear friends,
> This is my first cpp module working with mySQL.
> It looks like the error is located in
> MYSQL *m=mysql_real_connect(myDB, host, user, passwd,
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
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 Postgr
ome 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]
S
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 PROT
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
e 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 my
Hook |
+--+--+
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:
nage total 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 Locki
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
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: &
---
+
2 rows in set (0.00 sec)
mysql> select * from toto;
+--+--+
| 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 su
7 | 2 |
+---++
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';
--++
| 00122 | 1 |
| 00123 | 1 |
| 00123 | 2 |
| 00123 | 3 |
| 00336 | 1 |
| 00346 | 1 |
| 00349 | 1 |
| 00427 | 1 |
| 00427 | 2 |
| 00427 | 3 |
+---++
10 rows in set (0.00 sec)
--
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 PROT
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
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
---
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
-----
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
sage, machine) 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 h
",
Sum(IF (insumo_or = "Animal4", cantidad_or, 0) ) AS "Animal4",
Sum(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_p
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
your sensitivity, but we are not speaking
about the same thing.
And please 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
gards
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 w
| NULL |NULL |
NULL |0 | Using temporary; Using filesort |
++-++--+---+--+-+---
---+--+-+
One or two table scans ?
Best Regards
----
Mathias FATENE
Hope that helps
*This not an offic
all RDMBS, 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: &#
rows in set (0.00 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 [m
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 a
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
'
Union
SELECT field_name FROM meta WHERE id ='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: Adria
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.c
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
?
Best Regards
--------
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 s
79 | | |
+---+--+--+--+
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
*This
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
). 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
_dir | C:\Program Files\MySQL\MySQL Server
4.1\share\charsets/ |
+--+--------
-+
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: s
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:\Mysql>mysql -u mathias world -X -e "desc country"
Code
ces/articles/mysql-set-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 faten
rchar
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/
sec)
if you 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
lot 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: my
I may 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 a
k using 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: &quo
Preferably one that is for begginers to medium and thats covers both mySQL and PHP
Thanks
bc3.lib
> c. myodbc3_install.log
> d. myodbc3d.dll
>
> 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 ser
mpdir#=
#port=3306
#set-variable=key_buffer=16M
[WinMySQLadmin]
Server=C:/mysql/bin/mysqld-nt.exe
user=**
password=*
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 form
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.
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
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 f
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 Be
the 'embedded'?
Sorry 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://ww
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
Hi,
Does anyone got information regarding my question
about calculating a HEAP table size in MySQL?:
http://lists.mysql.com/cgi-ez/ezmlm-cgi?1:mss:98013
Thank you,
Mathias
___
Spara filer på nätet. Lagra upp till 500 Mb på Passagen
http
,
nrMEDIUMINT 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://webbdr
92 matches
Mail list logo
