Ki,
mysqld-max-nt.exe is the same as mysqld-max.exe, except that you can also
use named pipes as the client communication channel in mysqld-max-nt.exe.
There should be no difference in stability.
There are some small bug fixes in 3.23.51 which were not yet in .49.
Best regards,
Heikki Tuuri
In
Dear Michal,
I am not sure, but I think you can create an user will all the rights in
"mysql - user" (database - table) - this will solve your problem with full
access to all databases.
And then you can use other tables in database "mysql" to define rights of
this user to table "user".
Have a l
What error? What schema?
Try TIMESTAMP(14)
Pat...
- Original Message -
From: "Todd Cary" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, July 14, 2002 11:31 PM
Subject: ODBC and TimeStamp
> I have a MySQL TimeStamp in my table. If I try to do a query via ODBC, I
get an
> erro
Hi Heikki,
Thanks for the help.
What do you mean by "small bugs"? Do you mind naming the few that caused the most
problems?
cheers,
Ki Mien
-Original Message-
From: "Heikki Tuuri" <[EMAIL PROTECTED]>
Sent: Monday, July 15, 2002 4:46 PM
To: "[EMAIL PROTECTED]" <[EMAIL PROTECTE
Jan Kudrman wrote:
> Dear Michal,
>
> I am not sure, but I think you can create an user will all the rights in
> "mysql - user" (database - table) - this will solve your problem with full
> access to all databases.
I think that the better choice is to use GRAND command:
grant all on *.* to 'new
MySQL doesn't support sub-selects...You must use joins and temporary
tables. Check:
http://www.mysql.com/doc/A/N/ANSI_diff_Sub-selects.html
it gives some info about it.
On Fri, 2002-07-12 at 16:37, Narcis GRATIANU wrote:
>
>
> When I try this:
>
> SELECT article, dealer, price
> FROM shop
Thanks a lot. I've fixed my problems with this.
Best regards.
- Original Message -
From: Gerald Clark <[EMAIL PROTECTED]>
To: Santiago Alba <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Friday, July 12, 2002 3:53 PM
Subject: Re: Replication problems
Did you copy the master.info fil
Chris,
Sunday, July 14, 2002, 5:44:49 AM, you wrote:
CB> I'm new to the list.
CB> I'm writing because I've been having trouble with table corruption. I'm
CB> using isam tables and i've been using myisamchk under linux to check them.
CB> alot of the time it just reports that some of the tables wer
I've read the Adding New Users Section and the initial and post setup
t> section of the manual, but I still need some clarification:
t> After an install and a working MySQL I see it like this (Mac OS XS):
t> there are 3 users:
t> mysql - created manually after installing MySQL and has a password
Thank you, I hope this is the right place to be asking these questions. If
t> there is a more "newbie" place please let me know. Here's more output I
t> need help with, I think it's self-explanatory except that I don't how to
t> rectify it. The following is a continuation my original message a
Charitha,
Monday, July 15, 2002, 8:54:03 AM, you wrote:
C> Is there any way in mysql to restore the data back after flushing off
C> all the data already present using a single command.
C> I am having backup of the db and i want to restore the data back in the
C> database by flushing off all the d
jan,
Monday, July 15, 2002, 10:01:04 AM, you wrote:
>>Description:
ja> The command "mysqladmin -h host -u user -ppass flush-logs" does rotate the
logs of mysql but not the errorlog.
>>How-To-Repeat:
ja> Self compiled mysql on debian.
>>Fix:
ja> Not a real solution but an
Michal,
Monday, July 15, 2002, 8:40:58 AM, you wrote:
MD> is possible to create user which will be not able to create other
MD> users and will have full access to all existing databases and
MD> databases which will be created in future?
No. If you set up all privileges for your user on *.*, user
On Mon, 15 Jul 2002 11:58:33 +0200
Jarek Jarzebowski <[EMAIL PROTECTED]> wrote:
> Jan Kudrman wrote:
> > Dear Michal,
> >
> > I am not sure, but I think you can create an user will all the rights in
> > "mysql - user" (database - table) - this will solve your problem with full
> > access to all
I have been using mysql for a while and I am now building two new
servers to provide web/database services.
I have had a number of problems with the mysql installation.
BINARY DISTRIBUTION
I have had very mixed success with the binary distribution. It assumes
/tmp/mysql.sock for the socket
Hi,
That wasn't the problem. The problem was in master.info file.
Thanks a lot.
- Original Message -
From: Ralf Narozny <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, July 12, 2002 4:39 PM
Subject: Re: Replication problems
Hello!
You will get problems when you set the 2nd
>Description:
Every 60 seconds, the replication slave gets an error 1159 from
the master server. Thirty seconds later, it reconnects to the master.
Then the cycle starts all over again. I have master-connect-retry=30 in
the config file.
Here is an extract of the replication slave's error
dear all,
Does Mysql support stored procedures ?
best regards
Menrit
-
Before posti
Ki,
please consult the manuals
http://www.mysql.com/doc/N/e/News-3.23.x.html
and
http://www.innodb.com/ibman.html#InnoDB_history.
Regards,
Heikki
- Original Message -
From: "Ki Mien" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>; "Heikki Tuuri" <[EMAIL PROTECTED]>
Sent: Monday, July 1
No.
http://www.mysql.com/doc/N/u/Nutshell_4.1_development_release.html
*
* Cal Evans
* The Virtual CIO
* http://www.calevans.com
*
-Original Message-
From: root [mailto:[EMAIL PROTECTED]]
Sent: Monday, July 15, 2002 10:06 AM
To: [EMAIL PROTECTED]
Subject: Stored Procedures
dear all,
HI
Lately I tried to connect MSQL with new Autocad 2002.
In earlier version of Autocad it was impossible.
In fact Autocad 2002 also doesn't support Mysql , but
when I try to connect Mysql with Autocad2002 by MYODBC
it works.The problem is that always when try to look on the table
when I connect
Hi all,
has anybody ever seen this? And knows what it means?
thx.
You have an error in your SQL syntax near 's self-supporting ribbed form was
probably not strong enough to render the desig' at line 1
regards Wilbert
mysql error / query
-
Pas de Deux
Van Mierisstr
[snip]
has anybody ever seen this? And knows what it means?
thx.
You have an error in your SQL syntax near 's self-supporting ribbed form was
probably not strong enough to render the desig' at line 1
[/snip]
Ye, we have all seen this. It means that there is something wrong with your
query. Howev
Yes, it simply means that you have single quotes inside the string you try
to save, and you need to escape them.
Alain Fontaine
Consultant & developer
VAlain S.A.
http://www.valain.lu/
-Message d'origine-
De : W. Enserink [mailto:[EMAIL PROTECTED]]
Envoyé : lundi 15 juillet 2002 15:07
À
Hola listeros :)
acabo de construir e instalar una nueva funcion (muy
simple) en MySQL, la ucwords() de PHP. (Hacer
mayuscula la primera letra de cada palabra de un texto;
funciona solamente con datos char y varchar, es decir
hasta 255 characteres).
Si les interesa (solamante para linux), les
Patrick -
I have the following Sql SELECT statement:
SELECT FirstName, LastName, ChangeTime FROM Members;
If I execute the statement using ADO (uses a ODBC connection), the result set is
empty. When the ChangeTime is removed, I get a result set.
Todd
--
Todd Cary
Ariste Software
2200 D Stree
Hi,
Sorry but MySQL does not support subqueries yet.
Bye and Good Luck!
--- Narcis GRATIANU <[EMAIL PROTECTED]>
wrote:
>
>
> When I try this:
>
> SELECT article, dealer, price
> FROM shop s1
> WHERE price=(SELECT MAX(s2.price)
> FROM shop s2
> WHERE s1.article
I did a select * as such:
mysql> select * from Sqs;
+-+-++
| RecordState | Sqs | SqsKey |
+-+-++
| L | unknown | 1 |
+-+-++
1 row in set (0.00 sec)
Then, look at the message that delete from gi
Can someone plz send me the posting from mysqlab concerning the beta
training , I deleted it accidentally...
Thanks
sql,query
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.
Hi,
Since subqueries are not allowed in MySQL, this is
what I would do:
Create a temporary table with the id's containing
multiple dates.
Inner join your table with the temporary table.
Even if MySQL allowed subqueries, this is what will
probably happen behind the scene.
Bye and Good Luck!
---
[snip]
I have the following Sql SELECT statement:
SELECT FirstName, LastName, ChangeTime FROM Members;
If I execute the statement using ADO (uses a ODBC connection), the result
set is
empty. When the ChangeTime is removed, I get a result set.
[/snip]
Can you show us a DESCRIBE TABLE for Member
Hello!
Whenever deleting without a WHERE clause, there's always this '0 rows
affected' message. I consider that a bug.
Greetings
Ralf
Bhavin Vyas wrote:
>I did a select * as such:
>
>mysql> select * from Sqs;
>+-+-++
>| RecordState | Sqs | SqsKey |
>+-
Hello!
Francisco Reinaldo wrote:
>Hi,
>
>Since subqueries are not allowed in MySQL, this is
>what I would do:
>
>Create a temporary table with the id's containing
>multiple dates.
>Inner join your table with the temporary table.
>
>Even if MySQL allowed subqueries, this is what will
>probably ha
That syntax will always report zero rows affected, but it is very fast. If
you want to know how many rows were deleted, use something like "DELETE *
FROM Sqs WHERE 1=1".
The latter query will be much slower, as it examines each record.
Nick
> -Original Message-
> From: Bhavin Vyas [mai
I have a 3.23.51 server with InnoDB tables. I want to replicate
one of the databases over to some 3.23.49 servers with MyISAM tables.
The tables do have some auto-increment columns. I expect that only
valid data is going to be written to the binlog, so the
Hi all,
I am looking for a way to count the number of a character occurrences in a
string with MySQL. For example, I have this string "1;333;72227;00;19;1;1;"
and I would like to return the number of ";" found in this string. Is this
possible?
Also, I wanted to return fields that contain EXACTLY 2
This is a known "problem", not a bug in mysql.
You can get the affected rows by entering this sql statement: "delete
from Sqs where 1>0"
Greetings, Richard
-Ursprüngliche Nachricht-
Von: Ralf Narozny [mailto:[EMAIL PROTECTED]]
Gesendet: Montag, 15. Juli 2002 16:16
An: Bhavin Vyas
Cc:
i have the same probem since i ugraded my slave from 3.23.50 to 3.23.51
Pierre
- Original Message -
From: "David Harper" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, July 15, 2002 1:26 PM
Subject: Replication slave repeatedly gets error 1159 from master
> >Description:
>
- Original Message -
From: "Ralf Narozny" <[EMAIL PROTECTED]>
To: "Bhavin Vyas" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Monday, July 15, 2002 9:16 AM
Subject: Re: Interesting
> Bhavin Vyas wrote:
[snip]
> Hello!
>
> Whenever deleting without a WHERE clause, there's always thi
I've built a whole program with vb6 and mysql database back end. Never had
any problems. I used the mysql odbc for windows to access the database. What
are you using?
Matthew Scarrow
ComIT Solutions Inc.
www.comit.ca
Phone: 519-442-0100
Fax: 519-442-0429
-Original Message-
From: Carlo
http://www.mysql.com/doc/D/E/DELETE.html
"In MySQL 3.23, DELETE without a WHERE clause will return zero as the number
of affected records."
Alain Fontaine
Consultant & developer
VAlain S.A.
http://www.valain.lu/
-Message d'origine-
De : Bhavin Vyas [mailto:[EMAIL PROTECTED]]
Envoyé : lu
Hello all,
I'm new to this list and MySQL, so I hope this question isn't too
rudimentary.
In SQL Server I was able to create a datetime field that used the default
getdate() function so that I woudl get timestamps on all created rows
automatically, like:
create table mytable (
createddate
I'm using version 3.23.53 on Win 2k.
The same things happens to me.
I've also noticed that if you don't specify a WHERE clause and you have a
Auto-incrementing ID field, it is reset to zero and the next record you
create starts at 1 again.
Surely this is wrong as well? In Other RDBMS's after DE
> I have been trying to use the LOAD data command to load the data
instead of using the sql insert into table. It works fine but I have
got some warnings, how can I see these warnings, is there a log for
it, how can I see these warnings, is there a log for it?
---
Hello!
The regexp to match only 2 occurences of ';' would be:
regexp '^[^;]*;[^;]*;[^;]*$'
to find the number of ';' I only have an idea for something complicated:
length() - length(replace(,';',''))
StephanieTan wrote:
>Hi all,
>I am looking for a way to count the number of a character occu
On Monday, 15. July 2002 15:28, Daniel BI wrote:
> Hola listeros :)
Hola!
please write in english, or use the spanish mailing list
([EMAIL PROTECTED])
Thx
Georg
-
Before posting, please check:
http://www.mysql.com/manual.
Yes, I have a cluster installed with 3.23.49 and I have any problem. Now, I
am installing a new cluster with 3.23.51 version and it's appearing these
problems.
Could anybody help us?
Thanks in advance.
Santiago.
- Original Message -
From: Pierre Baridon <[EMAIL PROTECTED]>
To: David Ha
Not wanting to reinvent the wheel here, I wonder if anyone else has ever
done a rating system.
There'll be two columns: title_id for the title of the movie being rated and
then a rating from one to ten.
What would be the most efficient SQL statement to find a title's weighted
average?
Many than
Haany,
Sunday, July 14, 2002, 6:16:30 AM, you wrote:
HB> i am just installing the new mysql 3.23.51 for my
HB> linux 7.3.
HB> The problem is after unzipping the tar.gz file and
HB> running the mysql_install_db (which runs perfectly),
HB> when i tried to run the safe_mysql &, the mysqld is
HB>
Roman,
Monday, July 15, 2002, 8:07:07 AM, you wrote:
RV> When mysqld-max-nt.exe is started with options
RV> --console --standalone
RV> and after issuing "mysqladmin -u root shutdown"
RV> mysqld reports a shutdown, but does not exit.
RV> mysqld-max don't have this problem.
RV> OS Windows 2000.
root,
Monday, July 15, 2002, 6:05:54 PM, you wrote:
r> Does Mysql support stored procedures ?
No, MySQL doesn't yet support stored procedures.
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensit
Sameh,
Sunday, July 14, 2002, 3:09:53 PM, you wrote:
SA> Can anybody help me figuring how to control granting users
SA> permissions to created functions in MySQL like we do for SELECT, INSERT,
SA> ...etc or it is not possible and every one logged in to MySQL could
SA> simply use them like a
Bhavin,
Monday, July 15, 2002, 7:39:52 PM, you wrote:
BV> I did a select * as such:
BV> mysql> select * from Sqs;
BV> +-+-++
BV> | RecordState | Sqs | SqsKey |
BV> +-+-++
BV> | L | unknown | 1 |
BV> +-+---
Shawn,
Monday, July 15, 2002, 5:51:01 PM, you wrote:
SP> I'm new to this list and MySQL, so I hope this question isn't too
SP> rudimentary.
SP> In SQL Server I was able to create a datetime field that used the default
SP> getdate() function so that I woudl get timestamps on all created rows
S
On Monday, 15. July 2002 16:51, Shawn Poulson wrote:
Hi,
> I'm having trouble doing this in MySQL, but it keeps complaining. All I
> have to work on is:
> create table mytable (
>createddate datetime not null default now()
> )
>
Just use timestamp instead datetime.
Regards
Georg
mysql,q
Thanks for the response! Actually, we did notice the on delete null issue,
and we even found another. Basically, we have been using PostgreSQL
(yikes!), and it just wasn't as 'smart' as MySQL w/ InnoDB. We could
actually create foreign keys on tables that didn't even exist yet! But!
MySQL to the r
At 04:26 AM 7/15/2002, David Harper wrote:
> >Description:
> Every 60 seconds, the replication slave gets an error 1159 from
>the master server. Thirty seconds later, it reconnects to the master.
>Then the cycle starts all over again. I have master-connect-retry=30 in
>the config file.
>
>
But timestamp type will change on every update. I only want the default
value to be the current time/date when the row is inserted and then not
change.
>From: Georg Richter <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: [EMAIL PROTECTED], "Shawn Poulson" <[EMAIL PROTECTED]>,
>[EMAIL PR
Check the list. This question has been asked before many time.
You can set net_read_timeout variable to bigger value to avoid this
problem.
Still no one knows (or answered) impact of net_read_timeout and
wait_timeout. which one takes precedence.
Nilesh
-Original Message-
From: Santia
[snip]
Not wanting to reinvent the wheel here, I wonder if anyone else has ever
done a rating system.
There'll be two columns: title_id for the title of the movie being rated and
then a rating from one to ten.
What would be the most efficient SQL statement to find a title's weighted
average?
[/s
For the life of me I can not figure out why I can not create or change
my tables from MyISAM to InnoDB.
I create the table with InnoDB and MySQL creates the table as MyISAM.
I am using MySQL-max-nt. Any ideas how I can change the tables or even
create them as InnoDB for that matter?
Thanks in
On Fri, 2002-07-12 at 22:41, Richard Clarke wrote:
> So this works as expected,
>
> mysql> create table test_1 (id int,value char);
> Query OK, 0 rows affected (0.00 sec)
>
> mysql> create table test_2 (id int,val char);
> Query OK, 0 rows affected (0.00 sec)
>
> mysql> insert into test_1 value
Philip,
- Original Message -
From: "Philip Molter" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.mysql
Sent: Monday, July 15, 2002 5:55 PM
Subject: Replication from InnoDB -> MyISAM
> I have a 3.23.51 server with InnoDB tables. I want to replicate
> one of the databases over to some
Hello,
I ve got mysql 4.0.1
I don't understand what happen.
I use to make replace other than insert in order to avoid error in php
scripts.
I have a table with on primary key :
CREATE TABLE `nlconfig` (
`id` tinyint(4) NOT NULL auto_increment,
`nomnews` varchar(255) NOT NULL default '',
`
Have any of you guys come across this,
http://www.firstworks.com/sqlrelay.html, as a way of managing fault
tolerance from clients accessing mysql databases?
Richard
-
Before posting, please check:
http://www.mysql.com/manu
Hi
I want to write sql query to duplicate a row. It has a PRI key called ID.
The MySQL database looks like
IDNameAddress
345 Aman42, sb
346
347...
I want to duplicate the ID=345.
Any suggestions ?
Thanks in advance.
Aman
__
On Sun, 2002-07-14 at 03:59, karl wrote:
> Hello,
> I need help. I am trying to insert into TABLEA records from TABLEB where the
>records do not exist in TABLEA (the primary key in TABLEA works fine). I am trying
>to limit the result set each time (as an example to 10 records from TABLEB).
> T
The problem with this limit, is that the search will occur from many
different sources, each of these will not be privy to the last limit set.
-Original Message-
From: Diana Soares [mailto:[EMAIL PROTECTED]]
Sent: Monday, July 15, 2002 10:52 AM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
I am looking into using the mysqlhotcopy.pl script to back-up my
databases. When I try to run it, I get the following error:
The getpwuid function is unimplemented at
C:\mysql\scripts\mysqlhotcopy.pl line 79.
I'm not familiar enough with perl to even begin debugging the script
myself.. Does a
Jay -
Here is the table structure. If I include the MEM_Code field, the ODBC SELECT
throws and exception, but I can understand that since CHAR is usually a one
character field. The MEM_Change_Date field is another story. When it is
included, the result is empty. Strange?!?
Todd
#
# Table st
Trying to count weeks! I am doing a personal accounting system in
php/mysql. I have a report section that groups and calculates expenses into
running totals, so that I can see total amount spent in each category. I
would like to add a break down to this that will show me the average weekly
amou
Hi,
Thanks for all the help. Appreciate it.
cheers,
Ki Mien
-Original Message-
From: "Heikki Tuuri" <[EMAIL PROTECTED]>
Sent: Monday, July 15, 2002 8:24 PM
To: "Ki Mien" <[EMAIL PROTECTED]>, "[EMAIL PROTECTED]"
<[EMAIL PROTECTED]>
Subject:Re: Innodb
Ki,
please consult
How does transaction works in this scenario?. Is rollbacked transaction
written into bin-log files?.
Nilesh
-Original Message-
From: Heikki Tuuri [mailto:[EMAIL PROTECTED]]
Sent: Monday, July 15, 2002 1:30 PM
To: Philip Molter; [EMAIL PROTECTED]
Subject: Re: Replication from InnoDB -> My
On Mon, Jul 15, 2002 at 02:40:14PM -0400, Nilesh Shah wrote:
: How does transaction works in this scenario?. Is rollbacked transaction
: written into bin-log files?.
To quote Heikki from below:
MySQL only writes committed transactions to the binlog, and consequently
only replicates committed
Alternatives for creating InnoDB tables:
1) When you start mysql, you can pass a parameter to set
default-table-type=InnoDB; Then, when you create tables, InnoDB type table
is the default type, or
2) In order to create InnoDB type table, you need to create the table in the
following way:
CREATE
When dealing with a considerable number of records
(10s of thousands) in a particular table, which is better
to use? Currently we are using MyISAM and the
queries on those tables are kind of slow. I've set the
most frequently used (in a query) columns as keys and
that isn't speeding it up any.
I am sorry. I should have paid more attention to Heikki email.
Nilesh
-Original Message-
From: Philip Molter [mailto:[EMAIL PROTECTED]]
Sent: Monday, July 15, 2002 2:43 PM
To: Nilesh Shah
Cc: [EMAIL PROTECTED]
Subject: Re: Replication from InnoDB -> MyISAM
On Mon, Jul 15, 2002 at 02:40
Is there an upper limit on the number of indexes in InnoDB tables in MySQL?
I can't find anything about it in their documentation at www.innodb.com
I am designing a database where one table has around 70 keys so far.
yes, it's normal, and all of those keys are commonly searched on.
thanks
sean p
Hello,
I have noticed that MySQL server almost hangs up the system while
processing a big table (perl script using fetchrow).
I didn't experienced this before - may be it's because of LinuxThreads?
MySQL launches 38 running processes, but shows only 10 mysql query
threads (they are all sleeping
Hi all,
I tried to use mm.mysql (2.0.14) to access the tables in mysql
(3.23.51). I can't retrieve metadata like tables' comment through the
following code:
// get connection
conn=ds.getConnection();
// get metadata
dbmd=conn.getMetaData();
//get resultset for all tables metadata
rs = dbm
Hi,
anybody have any presentation showing about mysql.
For example topics: History, Phisical structure, Logic
structure, etc.
I need to make a presentation about mysql.
If somebody could help me. I would appreciate
Alexander
sql, query
___
how to retrieve the 2 last char of a string stored in db ? :
SELECT LENGTH(db) as len , SUBSTRING(db from len-2 ) from nlconfig;
NOT WORK .!
In php by example, there is a substr with a negative pos that give char at
end ! no in mysql !
I've compiled fltk and fl_editor successfully. But I can't find edfile.o to compile
mysqlgui.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list arch
Hi!
Thank you for your test case, thanks to which a bug was fixed when
--bind-address option is used.
Fix will be implemented in next MySQL versions, but this is a patch
that fixes it:
= mysqld.cc 1.321 vs edited =
*** /tmp/mysqld.cc-1.321-14677 Mon Jul 1 11:38:44 2002
--- edited/mys
[snip]
What do you mean by weighted? Taking into account the number of votes for
each and then weighting them against each other?
[/snip]
Yes, essentially each individual movie will show its raw average (people
think this movie is a 7/10) while an overall top rated list will take into
affect that
[snip]
I created a dummy table for this and used your select statement:
mysql> SELECT titleid, (AVG(rating) / COUNT(titleid)) AS weighted
-> FROM movieratings
-> GROUP BY titleid;
+-+--+
| titleid | weighted |
+-+--+
| 1 | 0.288000 |
| 9 | 0.0727
switching to InnoDB won't help. Take a look at optimizing your queries. Are
you using LIKE? have you looked at the output of EXPLAIN?
=C=
*
* Cal Evans
* The Virtual CIO
* http://www.calevans.com
*
-Original Message-
From: Chris Boget [mailto:[EMAIL PROTECTED]]
Sent: Monday, July 15,
we are considering moving to a 4-way system as the load average on our
2-way system is at 2.
Does anyone have recommendations? Is the larger 1MB cache on some xeon
chips worth the extra $$$?
I'm thinking of 2 raid1 arrays, one for the os and logs, the other for
the db. The data is relatively s
On Mon, Jul 15, 2002 at 01:52:46PM -0500, Chris Boget wrote:
>
> When dealing with a considerable number of records (10s of
> thousands) in a particular table, which is better to use? Currently
> we are using MyISAM and the queries on those tables are kind of
> slow.
Really? That's not a lot of
>> When dealing with a considerable number of records (10s of
>> thousands) in a particular table, which is better to use? Currently
>> we are using MyISAM and the queries on those tables are kind of
>> slow.
> Really? That's not a lot of data. Can you provide examples?
Of the data? Or of the
>> When dealing with a considerable number of records (10s of
>> thousands) in a particular table, which is better to use? Currently
>> we are using MyISAM and the queries on those tables are kind of
>> slow.
> Really? That's not a lot of data. Can you provide examples?
Of the data? Or of the
> switching to InnoDB won't help. Take a look at optimizing your
> queries. Are you using LIKE?
In some queries, not all.
> have you looked at the output of EXPLAIN?
Yes, but I don't understand much of what it really means.
Chris
MySQL
---
Your /tmp directory is only accessible by root? What distribution are you
using? /tmp is normally world readable/writeable. I would think you'd have
problems with other software, too, if this wasn't setup correctly.
--jeff
- Original Message -
From: "Rob Lambden" <[EMAIL PROTECTED]>
To:
I believe the timestamp field needs to be nullable, but you shouldn't have
any issue selecting a char. Can you run the query from mysql interface? If
you can, than I would suspect that ADO is the culprit, try using straight
ODBC instead.
I hope this helps...
Pat...
- Original Message
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Tam, Michael wrote:
| Hi all,
|
| I tried to use mm.mysql (2.0.14) to access the tables in mysql
| (3.23.51). I can't retrieve metadata like tables' comment through the
| following code:
|
| // get connection
| conn=ds.getConnection();
|
| // get
On Monday, 15. July 2002 20:28, Paul W. Reilly wrote:
Hello Paul,
maybe http://www.mysql.com/doc/D/a/Date_and_time_functions.html could answer
your question (Function week() )
Regards Georg
> Trying to count weeks! I am doing a personal accounting system in
> php/mysql. I have a report sect
Hello,
Here's what I'd like to do...
* Create a new user in mysql.
* Let them login and create a new database.
* I want this database to be only viewable by the
user that created it and also the mysql administrator.
* I would like that user to be able to create users as
well but they can
Hi Mark,
Thank you for your speedy response. I'd appreciate if you can put this
feature the request list. Many thanks.
By the way, is there a way I can access this metadata through sql ??
Best regards,
Michael
-Original Message-
From: Mark Matthews [mailto:[EMAIL PROTECTED]]
Se
On Sun, Jul 14, 2002 at 07:21:59PM +0200, Raymond Hamaker wrote:
> Hi all,
>
> When i use MS access 2000 with odbc to fill my MySQL db(running on linux)
> auto_increment seems not to work .
"Does not seem to work" doesn't help us help you.
What did you try to do?
What did you expect to happen?
Hi Otoniel,
I am running w2k as well. Check if your mysql startup properly. One
thing you may want to check is whether you have specify the log_dir and
data_dir for Innodb in your my.ini file, and that you've made those dirs in
the file system.
Hope this help.
Cheers,
Michael
-O
1 - 100 of 134 matches
Mail list logo
