Thanks for your reply.
I think on this machine MySQL was installed from an RPM distribution... All the
settings are default...
I seem to have an unisual setup as far as the logfiles are concerned. There are no
localhost.log and localhost.err files on this machine, nor any .log or .err files in
Terry,
thank you for reporting this. Since the cardinality reported by SHOW TABLE
STATUS is just an estimate, this is not strictly a bug, but it is best to
correct this anyway.
I modified the cardinality estimation algorithm to 4.0 in March 2004, but
forgot the case where the index B-tree just c
Mauricio,
have you used upper case letters in table names? What does mysqld print to
the .err log?
Please observe the following:
http://dev.mysql.com/doc/mysql/en/Moving.html
"
On Windows, InnoDB internally always stores database and table names in
lowercase. To move databases in a binary format
Sergei,
please run CHECK TABLE on the tables, and check if it prints something to
the .err log.
Also, resolve the stack trace printed by the crashing mysqld, as explained
in the manual.
Best regards,
Heikki Tuuri
Innobase Oy
Foreign keys, transactions, and row level locking for MySQL
InnoDB Hot
Greetings All,
I see some files in the data dir with names like #sql-85d_4.MYI. Some of these are
pretty old. Are these the temp tables that didn't get deleted properly? Is it OK to
shut down the server and delete them?
Thanks,
Sergei
Okay, so what I did to solve this was:
ln -s /var/lib/mysql/mysql.sock /tmp/mysql.sock
That seems like a bit of a hack though. The my.cnf file has this line:
socket=/var/lib/mysql/mysql.sock
Anyone know why it's looking in /etc ?
On Jul 14, 2004, at 4:53 PM, Jough P wrote:
Greetings all,
I recentl
Hello,
Probably this mail should go to the internals list :)
I was looking into MySQL Client libaray and I could
figure out the DATA are kept as linked list of
MYSQL_ROW structure i.e. in MYSQL_ROWS being one node.
Now MYSQL_ROW is typedefed as char** that is array of
strings.
Looking into the
What type of select is this? Is the application and the database on the same
machine? Is this query build a large temp table?
-Original Message-
From: John Nairn
To: [EMAIL PROTECTED]
Sent: 7/14/04 7:11 PM
Subject: Any select with a large result set locks all other threads until it
complet
The correct way to deal with this is to edit /etc/my.cnf and, in the
mysqld section set the location of the socket.
[mysqld]
socket = /tmp/mysql.sock
if there are other systems expecting it to be at the new location, a
simple end run might be to create a link at /tmp/mysql.sock ->
/var/lib/mysq
I recently started experimenting with the text field.
It generally works OK, but I have a question about
pasting in the text.
It seems a little awkward in phpMyAdmin, and I
generally wind up with everything mushed together like
this:
Vermont
is nicknamed the “Green Mountain
State.”It is a beautif
I'm using SqlPassthrough In VFP 8.0
I"ve got a Sql statement that looks like this.
This following fails:
Update User
Set Active = True
Where UserId = ?pnUserId
pnUserId is 222 in this instance.
The following works fine:
Update User
Set Active =
Hi,
I am testing mysql on a large database (10GB). When I post a large
select request via myodbc all other process threads lock until that
thread completes. I am not locking any tables.
How do I stop a read only select statement with a large result set from
locking all the other threads until i
Hello All,
I hope someone can shed some light on this problem...
This concerns large InnoDB tables (having on the order of millions of rows).
When I run ALTER TABLE (for example, to change the default column value) or UPDATE or
DELETE queries that affect many rows, mysqld-max crashes and app
Greetings all,
I recently upgraded from mysql 3.23 to 4.0 on a Fedora box. I moved
the old installation to a directory called old_mysql in my home
directory. I can start the new installation using mysqld_safe &.
Now, when I try to do something like:
/new/install/mysqladmin -u root -p version
i
In the last episode (Jul 14), J S said:
> Thanks for your reply. Can I just check my syntax is right for
> creating the key?
>
> CREATE INDEX urlindex ON internet_usage (time);
>
> I ran this before but got an error 27 (eventhough the filesize ulimit
> was set to unlimited). So just wondered if I
Hi,
I have a quick question about how programs linked against the mysql C
libraries handle the following:
-assume three mysql hosts, say 10.0.0.2, 10.0.0.3, and 10.0.0.4
-assume a dns name "db.example.com" that returns the following:
[EMAIL PROTECTED] host db.example.com
db.example.com has addr
I don't see how hold_tracker coordinates a student with a coordinator (is
the coordinator the "user_Id" ?)
What is this "#1 position" you speak of? I don't see anything like a
"priority" or "ranking" field in the table you posted. Maybe if you posted
your entire data structure, things would m
Indexes can generate vast amounts of random i/o.
Because of rotational latency, random i/o can really
slow you down, especially if you are using IDE or SATA
disks because they can't do tagged queueing like SCSI
disks can.
If you have the budget for it, I would consider
getting some solid state di
In the last episode (Jul 14), John Larsen said:
> Hmmw your syntax should ork. Possibly try CREATE INDEX urlindex ON
> internet_usage (time(8)); W 8hich will only use the first charaters
> of your time field, it should make the index significantly smaller in
> size.
A timestamp field is only 4 byt
Hi,
I am currently working on a hold system. The system will allow
Coordinators to hold international students to place them with American
Host Families. I am having a hard time coming up with a good MySQL
table design for this process.
I have a table now that looks something like:
CREATE TA
[EMAIL PROTECTED] wrote:
You may want more indexes but you might be getting killed because you already have too
many.
To test - try loading into a table without indexes and see if it makes a difference.
At the very least - check to see if the primary index which starts with 'dic' can make
your sp
Egor Egorov wrote:
Are you running this under Microsoft Windows?
Yes, windows 2k and 2003, mysql-nt 4.0.16
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Lopez David E-r9374c wrote:
matt
1) inserts using this format is much faster:
INSERT INTO table (col1, col2) VALUES (val1,val2), (val3,val4)
is much faster then single row insert. My experience is
2.5 hrs vs.. 36 hrs.
2) The PACK_KEYS=1 may be hurting you. I've never used it.
3) There may
Hmmw your syntax should ork. Possibly try
CREATE INDEX urlindex ON internet_usage (time(8));
W 8hich will only use the first charaters of your time field, it should
make the index significantly smaller in size.
Though I'm not completly sure shorting time field this way is legal, but
you can alway
At 11:04 AM 7/14/2004, you wrote:
My question in brief is why wouldn't the physical mysql files change in size
if a substantial percentage of the records are deleted from a given table???
Why would it? If you delete 1 row from the middle of the table, it leaves a
hole. This space is recovered when
If all you need from your query is one column, then ask for just that one
column. Don't overuse SELECT *. You wind up filling your data transfer
channels with unnecessary and unused data.
(sorry about that, one of my pet peeves)
You can store the results of your fulltext search in a tempora
In the last episode (Jul 14), J S said:
> Thanks for your reply. Can I just check my syntax is right for
> creating the key?
>
> CREATE INDEX urlindex ON internet_usage (time);
>
> I ran this before but got an error 27 (eventhough the filesize ulimit
> was set to unlimited). So just wondered if I
hi
when ppl paste from MS Word to a text field in a form,
characters like apostrophe before s (e.g. It's) in
docs looks like (it looks like a comma but at the
top). in a mysqldump, i can see that it's stored as
’. i tried editing the in a text box and when i
reprint it, it's looks like it did.
Thanks for your reply. Can I just check my syntax is right for creating the
key?
CREATE INDEX urlindex ON internet_usage (time);
I ran this before but got an error 27 (eventhough the filesize ulimit was
set to unlimited). So just wondered if I was using the wrong syntax?
JS.
In the last episode
You _can_ do this in SQL, it just takes several steps.
What you need to do is create a table that contains the ID values of the
records you want to get rid of. If you want to keep the "first" record in a
set of dupes try this:
CREATE TABLE DeleteMe
SELECT t.email, t.ID
FROM yourtablenamehere
Thanks OGINO San.
You are right.
I am using MySQL API. So, I need to connect thro' hostname,
databaseName, etc. only and not thro' the ODBC DSN.
-Original Message-
From: OGINO Tomonori [mailto:[EMAIL PROTECTED]
Sent: Wednesday, July 14, 2004 9:57 PM
To: [EMAIL PROTECTED]
Subject: Re: 'm
Creating a key will make that query execute very fast,
but if that is the only reason for the key you are
going to be trading quite a lot of space for the speed
of one query.
How often are you going to run this query? If you
have 324 million rows, then that index is going to
consume somewhere i
Hi!
On Jul 14, Lachlan Mulcahy wrote:
>
> Sergei, Thom..
>
> I am interested in seeing this thread followed through. As developers at my
> work have experienced similar performance issues between 3.23.x and 4. Our
> database is also of similar size and a full optimize has been run.
Could you pr
Hi!
On Jul 14, Hickey,Thom wrote:
> I was able to rerun my tests using mysqld (as opposed to safe_mysqld). I'm
> happy to report that the times now almost exactly match MySQL 3.23.58.
It's VERY strange. It cannot have any affect on the speed.
Are you sure you run the correct version of mysqld ?
In the last episode (Jul 14), J S said:
> I want to find the earliest and latest times in the time column of my
> table internet_usage:
>
> +--+--+--+-+-+---+
> | Field| Type | Null | Key | Default | Extra |
> +---
Does access_no contain actual textual data, or is it
simply a key like a category or an integer? If you
don't need to do a fulltext search against access_no
then there is no reason to include it in your fulltext
index. You should most likely have a seperate index
for access_no in that case.
The
Hi!
On Jul 13, [EMAIL PROTECTED] wrote:
> I have a query like this
>
> select hex(blob_field) as myField from table
>
> When the blob field is empty ('') it returns 'x'.
>
> i'm using ADO with Visual Basic and MyODBC 3.51.
> MySQL Version is 4.0.18 and SO is Win XP Pro (also happens on Windows
That was it! Thanks so much.
JS
JS:
When I use DATE_FORMAT(), if I have a space character between DATE_FORMAT
and the ( I get an error. Try writing it like:
SELECT DATE_FORMAT( "20040601123456", '%Y-%m-%d' );
MySQL v4.1.2-alpha-standard
Mac OS X
Wes
On Jul 14, 2004, at 12:20 PM, J S wrote:
Thanks
JS:
When I use DATE_FORMAT(), if I have a space character between
DATE_FORMAT and the ( I get an error. Try writing it like:
SELECT DATE_FORMAT( "20040601123456", '%Y-%m-%d' );
MySQL v4.1.2-alpha-standard
Mac OS X
Wes
On Jul 14, 2004, at 12:20 PM, J S wrote:
Thanks for your help. I would like to
Hi,
I want to find the earliest and latest times in the time column of my table
internet_usage:
+--+--+--+-+-+---+
| Field| Type | Null | Key | Default | Extra |
+--+--+--+-+---
In message <[EMAIL PROTECTED]>
"'mysql_real_connect' with DSN "
""Nawal Lodha" <[EMAIL PROTECTED]>" wrote:
>
> Can 'mysql_real_connect' be called using DSN name rather than giving
> hostname, database name, port no., etc ?
Are you using ODBC?
Data Source Name(DSN) is an alias of the databa
Run optimize table position_log
Marvin.
-Original Message-
From: Gil Vidals [mailto:[EMAIL PROTECTED]
Sent: 14 July 2004 17:04
To: [EMAIL PROTECTED]
Cc: robert gavina
Subject: deleting millions of records did not change the file size
My question in brief is why wouldn't the physical mys
In the last episode (Jul 14), Gil Vidals said:
> My question in brief is why wouldn't the physical mysql files change
> in size if a substantial percentage of the records are deleted from a
> given table???
Automatic filesize reduction would only be possible if the deleted
records were at the end
Thanks for your help. I would like to do it with the SQL. However I'm still
having problems with the syntax below.
Is this wrong?
mysql> SELECT DATE_FORMAT ("20040601123456",'%Y-%m-%d');
ERROR 1064: You have an error in your SQL syntax. Check the manual that
corresponds to your MySQL server ver
Match() returns a graded "relevance rating", as a floating point number
(when called as you call it) for matches. Words present in more than half
the rows are ignored, presence of a word in most rows lowers relevance,
presence of a word in just a few rows increases it, weights are then
combined to
If you have 4.1.1 or greater, you can use GET_FORMAT( timestamp, 'ISO'
).
Otherwise, I think if you just use DATE_FORMAT( timestamp, '%Y-%m-%d
%H:%i ) you will get weird values if your timestamp field doesn't
include seconds. So, either alter your field to be CONCAT( timestamp,
'00' ), or, as
My question in brief is why wouldn't the physical mysql files change in size
if a substantial percentage of the records are deleted from a given table???
I have a table which contained 13.5 million records. I then deleted 6.5
million records; however, the physical file size did not change.
The fi
While in PHP you can try something like this...
$date_added = $row['date_added'];
$date = date("M d, Y", strtotime($date_added));
echo $date;
H and i do work in PHP as well, I believe, if you want to add the hour and
seconds. Check out the 'date' function in PHP for info.
In MySQL you can do that with: DATE_FORMAT
DATE_FORMAT (column_name,'%Y-%m-%d %H:%i')
-Mensaje original-
De: J S [mailto:[EMAIL PROTECTED]
Enviado el: Miércoles, 14 de Julio de 2004 08:26 a.m.
Para: [EMAIL PROTECTED]
Asunto: sql function for timestamp
Hi,
What SQL function do I need to
"Hickey,Thom" <[EMAIL PROTECTED]> wrote:
> One thing that 4.1 is better at is speeding up repeated queries,
...thanks to query cache, introduced in 4.0.1.
> so
> for testing we're forced to run thousands of queries through the
> system to avoid speed-ups across runs.
SELECT SQL_NO_CACHE is pret
Hi All,
Can 'mysql_real_connect' be called using DSN name rather than giving
hostname, database name, port no., etc ?
Thanks,
Nawal.
All I want is to just use mysql as the backend for my application. I don't
want to implement any features from mysql. So basically, I just want the
list of files necessary to use it as a data store.
~roy~
-Original Message-
From: Reggie Burnett [mailto:[EMAIL PROTECTED]
Sent: Wednesday,
I'm sure there is some subset of files that you can include, based on what
features you want to make available to your clients.
-reggie
> -Original Message-
> From: Roy Brown [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, July 14, 2004 10:14 AM
> To: 'Reggie Burnett'; [EMAIL PROTECTED]
>
Reggie
I was hoping to perform the mysql installation myself. I was also hoping
that I don't have to install the full suite as available on the site, but a
subset of that. What I am looking for is the list of necessary files that I
need to install mysql, to package with my VB application. I will b
I was able to rerun my tests using mysqld (as opposed to safe_mysqld). I'm
happy to report that the times now almost exactly match MySQL 3.23.58.
--Th
-Original Message-
From: Hickey,Thom
Sent: Wednesday, July 14, 2004 9:12 AM
To: 'Lachlan Mulcahy'; [EMAIL PROTECTED]
Subject: RE: 4.1 p
Hi,
What SQL function do I need to convert timestamp 200406011403 into
"2004-06-01 14:03" ?
Thanks,
JS.
_
Stay in touch with absent friends - get MSN Messenger
http://www.msn.co.uk/messenger
--
MySQL General Mailing List
For list a
If you would entertain a MYSQL/PHP, hope not too off-topicIt's
probably not difficult to solve - but you would be helping me
with some SQL logic.
The only way I can think of to explain what I want to do
is to give you my working newbie MSQL/PHP code that I'm learning
MYSQL/PHP with, and at a cert
Hello List
I've recently compiled and installed the latest stable version of MySQL from
source file mysql-4.0.20.tar.gz on Red Hat Linux Advanced Server 3 (without
installing the version of MySQL contained within the Red Hat OS install),
using the standard configure, make and make install. For sec
I don't see 'caldata.resource' anywhere in the statement you posted. Are
you sure you are sending the correct string to MySQL for execution as you
didn't post what MySQL tried to execute (based on its error message) for us
to look at. This may be a "variable name typo" issue.
One very simple
You can test if you can "see" the server from your other user's machine by
trying to connect to it with telnet. On the other user's machine, open a
telnet session to the server's address on port 3306 and press ENTER a few
times. You should be able to pick the server's executable name and versi
I actually posted something yesterday, but it got bounced (HTML with long
lines?). I'm starting to wonder whether the problem is my configuration. I
just noticed yesterday that the 4.1 my sysadmin set up is running
bin/safe_mysqld. Unfortunately it will take me some time to get back to
where I w
Hi all !
Sorry for the long subject line, but I couldn't find a short one...
Here is the problem :
My database (mysql 4.1.1) consists mostly for compressed MyISAM
tables.
I wrote a script, relying on a temporary memory-based table. This
table is, of course, writable.
If try to do an update or a
What is the amout of volume? Are you reaching max connections? What does the
I/0 look like?
-Original Message-
From: [EMAIL PROTECTED]
To: s.ahmad
Cc: [EMAIL PROTECTED]
Sent: 7/14/04 7:51 AM
Subject: Re: No Response from Server
Have you checked your slow query log and your error logs
Have you checked your slow query log and your error logs? Depending on
your usage patterns, you may need to optimize some of your queries. Is
your MySQL server sharing CPU time with any other applications? How many?
Could they be the cause of your CPU usage spike?
To the list: (This may or
mysql wrote:
Hello,
I wants to copy a full database with all its information to a database on another
computer.
Is it really that simple that I just create a new db on the new system and then copy
the files from the old db directory into the newly created one?
cheers Alex
A safer solution is t
Astrum Et Securis
Kieran,
Thanks a bunch! Some very useful and handy tips...
Really appreciate it.
Dominor,
RSJ
-Original Message-
From: Kieran Kelleher [mailto:[EMAIL PROTECTED]
Sent: Wednesday, July 14, 2004 12:03 AM
To: MySQL Junkie
Cc: [EMAIL PROTECTED]
Subject: Re: mySQL on MAC
Ok. better check .err files in /usr/local/mysql/data/.err for any
errors.. It seems that there isn't any problems on slave but from my
experience there can be problem on the slave like auth. For example when
"replica" user can not login to master then 'show slave status' doesn't give
any error mess
Thanks Daniel. Finally, I am making use of the C API and the flag
'CLIENT_MULTI_RESULTS' as suggested.
It's working !! :))
-Original Message-
From: Daniel Kasak [mailto:[EMAIL PROTECTED]
Sent: Wednesday, July 14, 2004 5:07 AM
Il lun, 2004-07-12 alle 13:45, Cemal Dalar ha scritto:
> To debug the problem. Make "SHOW SLAVE STATUS" in the slave and check for
> the error number..
>
> Best Regards,
> Cemal Dalar a.k.a Jimmy
> System Administrator & Web Developer
> http://www.gittigidiyor.com & http://www.dalar.net
>
> -
In article <[EMAIL PROTECTED]>,
Justin Swanhart <[EMAIL PROTECTED]> writes:
>> Where is the implicit group? The 'order by'
>> shouldn't effect how things
>> are grouped. On MySQL 4.0.17:
> Wow. I wasn't aware. Is that expected behavior?
> Other databases (Oracle) generate an error when you
>
Hello,
I wants to copy a full database with all its information to a database on another
computer.
Is it really that simple that I just create a new db on the new system and then copy
the files from the old db directory into the newly created one?
cheers Alex
--
MySQL General Mailing List
For
On Tue, 13 Jul 2004 23:26:48 +0100, Marvin Wright
<[EMAIL PROTECTED]> wrote:
> Hi,
>
> I'm now running redhat AS 3.0 with kernel version 2.4 and have 8GB of RAM.
>
> If I set my innodb_buffer_pool to 2048M, it just will not start, I get this
> error.
>
> 040713 22:10:24 mysqld started
> 040713
72 matches
Mail list logo