From: Kelvin Wu
1, If I created table 'newtest' using InnoDB type, inserting 50k
records took me 20min! If I use MyISAM type, inserting took me less
then 1 min. I don't know much about InnoDB but how come the
performance is dropped down so much?
Do read everything in the MySQL manual and on
What should I do about this?
/etc/cron.daily/logrotate:
/usr/bin/mysqladmin: Symbol `sql_protocol_typelib' has different size in
shared object, consider re-linking
/etc/cron.daily/mysql-server:
mysqladmin: Symbol `sql_protocol_typelib' has different size in shared
object, consider re-linking
Richard Whitney mailto:[EMAIL PROTECTED] wrote on Tuesday, January 04, 2005
6:16
PM:
I think I'm bringing this up again but with different errors.
This: $sql = LOAD DATA INFILE '$file'
REPLACE INTO TABLE `jobs` FIELDS
TERMINATED BY '\\t' OPTIONALLY ENCLOSED BY '\' ESCAPED
Hello list and happy new year.
Recently I've install mysql 4.1 on win 2000 with IIS 5 and works
perfect. My problem is that when i'm trying to make a connection with
myodbc (latest release) as localhost I got the following message:
Client does not support authentication protocol requestet by
Have a look at:
http://dev.mysql.com/doc/mysql/en/Old_client.html
Marc.
-Message d'origine-
De : nikos [mailto:[EMAIL PROTECTED]
Envoyé : mercredi 5 janvier 2005 10:09
À : mysql@lists.mysql.com
Objet : MyODBC 3.5.9 and MySQL 4.1.8
Hello list and happy new year.
Recently I've
Dear ladies and gentlemen,
Upscene Productions is happy to announce a new version of
the database developer tool:
Advanced Data Generator (version 1.2.6)
A fast test-data generator tool that comes with a library
of real-life data, many filling options, presets and more.
This new release
Hello.
The actual tables are there
I assume that 'there' is a dump file. One more question, can you
select the Avatars data using SQL queries? For example:
SELECT 'Avatar_field' from 'avatar_table' limit 1;
Does your application work after upgrade?
[EMAIL PROTECTED] wrote:
Hello.
See:
http://dev.mysql.com/doc/mysql/en/Charset.html
Andrew Mull [EMAIL PROTECTED] wrote:
That is what I was wondering, but not sure how to check/set the proper
character set.
Thanks.
-Andy
Quoting Gleb Paharenko [EMAIL PROTECTED]:
Hello.
You can write
Hello.
Basic support for read-only server side cursors was added in 5.x and released
in alpha snapshot 5.0.2. See:
http://dev.mysql.com/doc/mysql/en/News-5.0.2.html
I downloaded and installed MySQL 5.0. But I could not run declare cursor
features in 5.0.
Is the cursor
Hello.
Similar problems are described at:
http://dev.mysql.com/doc/mysql/en/Connection_access.html
Richard Whitney [EMAIL PROTECTED] wrote:
I think I'm bringing this up again but with different errors.
This: $sql = LOAD DATA INFILE '$file' REPLACE INTO TABLE
Fredrik,
I haven't read all of the earlier messages, but it looks like your problem
is that a query such as the following takes more than a minute to return 11
rows.
Select A.id, A.parent
from art A inner join art B using (id)
where A.id=560685 or B.parent=560685;
Why? Well, your explain
Very new to MySQL and this list. Thanks in advance for your patience with
elementary questions. I'm in process of converting a current web site to a
mysql database. As this database will eventually contain millions of records, I
want to set it up properly.
The database will contain
Kentucky Families wrote:
Very new to MySQL and this list. Thanks in advance for your patience with
elementary questions. I'm in process of converting a current web site to a
mysql database. As this database will eventually contain millions of records, I
want to set it up properly.
The database
Hi,
My original query was a UNION query :) and that one is really fast.
The problem i had was that every 8-12 day mysql sad that all of my
max_connections was in use. I think i will stick with my UNION query it
seems faster.
// Fredrik.
Bill Easton wrote:
Fredrik,
I haven't read all of
On Wed, 05 Jan 2005 12:22:18 +
Stephen Moretti [EMAIL PROTECTED] wrote:
Kentucky Families wrote:
... If I use a VARCHAR or TINYEXT field to enter these values and
I want to be able to retrieve all records where the surname field
contains the whole word Stotts, how would I enter these
Hello,
From the MySQL docs:
http://dev.mysql.com/doc/mysql/en/FLUSH.html
What does FLUSH MASTER and FLUSH SLAVES does? Its not
documented?
Also, from which version of MySQL LOCAL and
NO_WRITE_TO_BINLOG options supported?
Regards,
Karam
__
Do
Dear Heikki
Many thanks for your reply.
On Mon, 3 Jan 2005 20:41:22 +0200
Heikki Tuuri [EMAIL PROTECTED] wrote:
are you sure that you copied the complete ibdata1 file to the new
place? It is strange how 7 MB can be missing from the file end.
I have just checked the tar file I used to do the
Ian Grant wrote:
On Wed, 05 Jan 2005 12:22:18 +
Stephen Moretti [EMAIL PROTECTED] wrote:
Kentucky Families wrote:
... If I use a VARCHAR or TINYEXT field to enter these values and
I want to be able to retrieve all records where the surname field
contains the whole word Stotts, how
Stephen Moretti [EMAIL PROTECTED] wrote on 01/05/2005 07:22:18 AM:
Kentucky Families wrote:
Very new to MySQL and this list. Thanks in advance for your
patience with elementary questions. I'm in process of converting a
current web site to a mysql database. As this database will
Right, three is a true dump file, and I can restore the database, everything
'seems' to be there, I can browse the table all day long, and I can see the
binary files in the database, but the length of the tables are different.
mysql@lists.mysql.com
In a message dated 1/5/2005 3:50:39 AM Eastern
Thanks to everyone who has responded to this. I still don't have an answer that
will work, so here is a bit more information:
1) The name fields are divided into 4 parts:
Prefix, GivenNames, Surname, Suffix
3) The GivenNames field already has more than one word in many instances.
Sample
Hi there,
Does anyone know how views are implemented in MySQL? Is the view query
executed each time the view is interacted with (ie. query modification) or
is there some sort of caching involved (i.e. view materialization).
thanks
Hi,
I'm attempting to improve MySQL speed/performance by adding key_buffer=50M
to my my.cnf file for [mysqld].
Upon stopping and then restarting MySQL,
I'm getting a 0 DB_ERROR_NOT_CONNECTED error when visiting
my php-MySQL web application via http. When I delete the server variable
in my.cnf
prova
_
Scarica gratuitamente MSN Toolbar! http://toolbar.msn.it/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
prova1
_
Personalizza MSN Messenger con sfondi e fotografie!
http://www.ilovemessenger.msn.it/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
What's the default fill factor on MyISAM B-Tree
indexes? I know it's 15/16 by default for InnoDB, but
nothing is mentioned about MyISAM.
For example, if I'm going to create read-only tables
and index them, I'd like the fill factor to be 100%
since there won't be updates and therefore I'm not
My O.S in Win Xp Pro SP2.
My web server is Apache 5.0
While I am trying to install MySql Server 4.1, I have the following error
and I cannot install the Server:
Cannot create Windows service for MySql. Error: 0
Can someone help me to install without error?
Thanks
Eugenia Mariani
You could also leave the password blank if you don't
want to force MySQL to revert to the old password
encryption on start-up. This should be fine if your
server is in the DMZ and you control all the processes
that have access to the server.
Unfortunately, 4.2.x breaks backward compatibility
with
I had this problem once. My fix was to delete the innodb files from the
mysql datadir (log and data files), then run mysqld-nt from a command
prompt. After it starts normally, you can stop it and then install it as a
service. I don't know if this will work for you, but it did for me.
---
Tom
Try MyODBC 3.51.10. It supports 4.1 auth. Here is a link to a mirror that
has it:
http://mysql.netvisao.pt/downloads/connector/odbc/3.51.html
---
Tom Crimmins
Interface Specialist
Pottawattamie County, Iowa
-Original Message-
From: nikos
Sent: Wednesday, January 05, 2005 3:09 AM
To:
Tom, this is awesome! It must have been fresh out of
dev because I downloaded 3.51.09 a couple of days ago.
I just downloaded it and it works fine with 4.1
authentication.
Thanks!
--- Tom Crimmins [EMAIL PROTECTED] wrote:
Try MyODBC 3.51.10. It supports 4.1 auth. Here is a
link to a mirror
Normally, when you type the first few letters of a table name and press
tab, the mysql client does not auto complete anymore. Can this be
enabled with a my.cnf setting or something since it is no longer the
default behaviour on my machine?
Regards, Kieran
We are using a pear
abstraction class written by Mohammed J. Kabir Problem is its out of date for
error reporting. Does anyone know where a current version of this
is. Hopefully one that would be a plug in exchange for the one we have so
that we don't have to rewrite the software.
Hello,
I am trying to upgrade from MYSQL 3.23.58 to MYSQL 4.0.23 on a Tru64 alpha
server. However, I am getting the error below at compile time. any ideas?
Thanks in advance -teresa.
Platform: Alpha Tru64 OSF 4.0F
Configuration parameters:
CC=cc -pthread \
CXX=cxx -pthread -O \
Please ignore
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Please ignore
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi list,
I have many databases on my MySQL server such as:
dbexample
dbexample_clients_abc
dbexample_clients_def
dbexample_clients_ghi
dbexample_local_abc
dbexample_local_def
dbexample_local_ghi
Is it possible to grant all these databases in just one GRANT instruction
such as:
GRANT
[snip]
Is it possible to grant all these databases in just one GRANT instruction
such as:
GRANT SELECT,INSERT,UPDATE,DELETE ON dbexample*.* TO 'user'@'localhost' BY
'password';
[/snip]
GRANT [privs] ON `dbexample%`.* TO 'user'@'localhost' IDENTIFIED BY
'password';
---
Tom Crimmins
Interface
Hi list,
How can I traverse the recordset moret than once?
For example, the recordset $sth is returned from executing the sql
statement.
The following statement is writen with the for loop for retrieving
each record from the recordset.
$aref = $sth-fetchrow_arrayref
However when the for loop is
At 08:11 PM 1/5/2005, you wrote:
Hi list,
How can I traverse the recordset moret than once?
For example, the recordset $sth is returned from executing the sql statement.
The following statement is writen with the for loop for retrieving each
record from the recordset.
$aref =
At 08:11 PM 1/5/2005, you wrote:
Hi list,
How can I traverse the recordset moret than once?
For example, the recordset $sth is returned from executing the sql statement.
The following statement is writen with the for loop for retrieving each
record from the recordset.
$aref =
Steve Buehler wrote:
At 08:11 PM 1/5/2005, you wrote:
Hi list,
How can I traverse the recordset moret than once?
For example, the recordset $sth is returned from executing the sql
statement.
The following statement is writen with the for loop for retrieving
each record from the recordset.
$aref
Steve Buehler wrote:
At 08:11 PM 1/5/2005, you wrote:
Hi list,
How can I traverse the recordset moret than once?
For example, the recordset $sth is returned from executing the sql
statement.
The following statement is writen with the for loop for retrieving
each record from the recordset.
$aref
Hi Sam,
Remember you are only dealing with an array of references. Not the
actual record. This shouldn't take much time to do a copy and you will
only be keeping pointers in memory not much else.
Regards
David Logan
Database Administrator
HP Managed Services
148 Frome Street,
Adelaide 5000
I Agree I did downloaded from dev.x MyODBC 3.5.10-x86-win-32bit.exe and
it works with MySQL 4xx
Thanks
Love and regards
Prasad
- Original Message -
From: Homam S.A. [EMAIL PROTECTED]
To: Tom Crimmins [EMAIL PROTECTED]; nikos [EMAIL PROTECTED]
Cc: mysql@lists.mysql.com
Sent: Thursday,
On Thu, 6 Jan 2005, sam wun wrote:
Steve Buehler wrote:
At 08:11 PM 1/5/2005, you wrote:
Hi list,
How can I traverse the recordset moret than once?
For example, the recordset $sth is returned from executing the sql
statement.
The following statement is writen with the for
Hi, list
i'd like to know about that merge table type.
what i get to the best benefits, when i use this engine type?
thank you.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
hello,
the questn may be simple.but i m still in learning stage so please dont
get angry.
thank you
how to redirect every single error cmg in program with database connection
to other place than standard error log.
my error log is growing so fast so want to avoid error log for any type of
Example a (GivenNames): Mary Elizabeth or Marg Elizabeth
Example b (GivenNames): J. W. or I. W.
Example c (Surname): Stotts, Statts or Stutts
I need to be able to retrieve the following based upon the examples:
For Example a:
Return Mary Elizabeth where GivenNames begins with M;
Return
49 matches
Mail list logo
