l releases, but
3.23.41 should be fine. Im using .42 and having no more problems.
dpk
- Original Message -
From: <[EMAIL PROTECTED]>
To: "'Dana Powers'" <[EMAIL PROTECTED]>
Cc: "mysql mailing list (E-Mail)" <[EMAIL PROTECTED]>
Sent: T
What is the query you are running + what version of mysql are you using?
dpk
- Original Message -
From: <[EMAIL PROTECTED]>
To: "mysql mailing list (E-Mail)" <[EMAIL PROTECTED]>
Sent: Wednesday, September 19, 2001 2:12 AM
Subject: BDB table : different results on adjacent queries
> hi a
Search the manual, check the archives, blah blah blah. This question was
answered yesterday. See forwarded message below.
dpk
- Original Message -
From: "Paul DuBois" <[EMAIL PROTECTED]>
To: "Jay Fesco" <[EMAIL PROTECTED]>; "Paul Reilly" <[EMAIL PROTECTED]>;
<[EMAIL PROTECTED]>
Sent: Mond
You will not get 3.22 to recognize MyISAM format tables.
You need to either:
1. Upgrade your server to 3.23
or
2. Find a running 3.23 server, copy your table files to that server, ALTER
TABLE xxx TYPE=ISAM; on all your tables to convert back to older ISAM
format, and copy your table files back
And my question is, if you've defined your column to have (10,2) precision,
why would you try to insert a higher precision number?
dpk
- Original Message -
From: "Jim Dickenson" <[EMAIL PROTECTED]>
To: "Dana Powers" <[EMAIL PROTECTED]>
Cc: <[EMAIL
I believe the MyISAM format is so fast on simple SELECT count(*) FROM table;
because it actually keeps the current number of rows as a table statistic -
so it doesnt have to look at the data at all. Using a WHERE clause, however,
will force MyISAM to actually select all the rows and count how many
I assume you've done the slow-query-log review thing... making sure all your
queries are fast, yes?
dpk
- Original Message -
From: <[EMAIL PROTECTED]>
To: "Stefan Pinkert" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Tuesday, September 18, 2001 11:22 AM
Subject: Re: AW: MySQL is hogg
> The problem is that a number that is in the
> MySQL database might be a magnitude of 10 times larger than a number that
is
> in the PostgreSQL database.
Could you explain this?
dpk
-
Before posting, please check:
http://
The quickest way to get this in front of developers is to provide a
reproducible test case. I know they like to use the new mysql-test stuff,
but its not heavily documented, so bash scripts or perl scripts are probably
fine too. This may also help other people confirm the problems that you are
see
Agreed. Definitely odd that it doesnt behave exactly as documented, but it
does provide (9,2) precision, non? The fact that you can squeeze (10,2) into
the column in certain cases doesnt bother me.
Of course, if you came up with a patch to fix it, I dont think anyone would
complain.
dpk
- Or
First, there is no need to reinstall.
For future reference, if you forget your password - check the manual for an
easy way to fix: http://www.mysql.com/doc/R/e/Resetting_permissions.html
For a mysql that wont start, check the error log and isolate what the
problem is ( it probably isnt that hard
The error logs seem to indicate that the pid file you've specified is not
writable and that the system database tables are not installed properly.
1. make sure that you ran mysql_install_db. If you did, make sure that you
didnt change the my.cnf datadir setting without moving your system files or
It appears that your change to debian was also a change from the current
3.23 mysql version to the old 3.22 version ( major releases ). The old
version, 3.22, does not support MyISAM tables, so you'll need to upgrade to
the new version. Debian stable, aka potato, uses 3.22, but both woody + sid
(
Some people like to use MS Access as a frontend using MyODBC to 'link
tables'. If you have access, you'll need to install myodbc ( available in
the downloads section of www.mysql.com ), configure a datasource connection
with a valid username + password etc, and then in access:
File -> Get Externa
and that seems so
cumbersome given that the solution is the same in every case.
dpk
- Original Message -
From: "Michael Widenius" <[EMAIL PROTECTED]>
To: "Dana Powers" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: M
Certainly I understand how the deadlock can occur, but the question is why
is this acceptable behaviour? Is the application developer expected to
handle this case? If so, how? and shouldnt this be included in the manual
under BDB problems? If Im supposed to wrap _every_ sql call I make to a BDB
ta
based on the primary key.
update row to set unique char string.
commit | rollback
Could it be that bdb needs to grab a page lock on the index as well? hmm,
that might explain it.
dpk
- Original Message -
From: "Christian Sage" <[EMAIL PROTECTED]>
To: "Dana Powers&qu
es.
dpk
- Original Message -
From: "Dana Powers" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Saturday, September 15, 2001 1:52 PM
Subject: BDB table error
> Im getting this error from attempted inserts into a BDB table using
> my
Im getting this error from attempted inserts into a BDB table using
mysql-3.23.42 ( same error but more often in 3.23.38 ):
Could not insert new row into SESSION_DATA: Got error -30996 from table
handler
First - I have not been able to find what this error means in either the
source code, online
d00d. manual. search it.
http://www.mysql.com/doc/S/o/Sorting_rows.html
ORDER BY VOTES DESC
dpk
- Original Message -
From: "Russ" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, September 14, 2001 3:27 PM
Subject: mySQL: ORDER
> how do i sort my results by reverse order ?? s
Try this:
SELECT news.NEWSID, news.DATETIME, authors.AUTHOR, count(comments.CID) as
NUMCOMS from news LEFT JOIN authors ON news.AUTHORID=authors.AUTHORID LEFT
JOIN comments ON news.NEWSID=comments.NEWSID GROUP BY news.NEWSID ORDER BY
news.DATETIME;
I havent tested this, and you may have to add n
> - The Perl "stored procedures" (myperl project) in not a good idea
>at all, but, even if called "poor man's stored procedure", I
>think that this project don't add, actually, stored procedure in
>the precise meamning of term. It add only a binding with Perl via UDF.
>It's a nice
> Depending on the way you define things, MIN and MAX are essentially
> stored procedures that were programmed into MySQL. Why not let us make
> our own?
This is already possible with Aggregate UDF 's. Check the manual here:
http://www.mysql.com/doc/A/d/Adding_functions.html
dpk
-
It might be easier to see what is happening if you do something like this:
echo "select name from pairings where fid=0 and pid=1 and name != 'One';" |
mysql -u... -p... yourdatabase | hexdump -c
this will show you exactly what data is being returned. Chances are there is
a funky character in the
Or the perl way:
my %row;
@row{'f_handle','a_handle'} = $sth->fetchrow_array();
$row{f_handle} or $row{a_handle}are now set properly.
( if you really want a reference, you can say 'my $row = {};
@{$row}{'f_handle. )
dpk
- Original Message -
From: "Jeremy Zawodny" <[EMAIL PROTECTED
Add 'HAVING Tot>0' to your query.
dpk
- Original Message -
From: "Lorang Jacques" <[EMAIL PROTECTED]>
To: "Mysql" <[EMAIL PROTECTED]>
Sent: Friday, September 07, 2001 10:12 AM
Subject: Limit query to a value
> Hello,
> How can I limit the query to those rows where "SUM(value) as Tot > 0
>Claudio Cicali ([EMAIL PROTECTED]) writes:
> - where I work, we have a HUGE database-driven web-application. A lot of
>our businness logic is implemented via stored procedures, that
>act as black boxes for the web-designers.
>Think of enterprise java beans.
>They are not "nonsense
> SELECT COUNT(*) as count, hostname FROM host_list GROUP BY hostname ORDER
BY
> count DESC
>
>
> here is my current output
> 283 host1
> 210 host2
> 200 host10
> 110 host 3
> .
> 1 host941
>
>
> what I would like to do is list say just the hosts that have greater then
> I know these are pathetic questions to most of you so please have patience
> with a Windows user...
Hehe, welcome to the world of the command line...
> what is "shell>"?
In windows world, this is the 'MS-DOS Prompt'. Will probably look like this
to you:
C:\>
In unix, it is typically something l
I have been having consistent problems with index corruption using BDB
tables in the 3.23.38 source version. Looking at the Change Log entries for
3.23.40, i think upgrading may help me out. Does anyone have a more detailed
explanation of the bugs addressed by these two fixes:
Changes in release
LAST_INSERT_ID() is similar. It will give you the value for autoincrement
fields. Note that this is connection dependent ( so your last_insert_id() is
not the same as my last_insert_id() ). You would do something like this:
INSERT INTO tablex ( columnx ) VALUES ( 'valuex' );
INSERT INTO tabley (
o remember to set your root password! Check the manual for this as well.
dpk
- Original Message -
From: "Sheena Sidhu" <[EMAIL PROTECTED]>
To: "Dana Powers" <[EMAIL PROTECTED]>; "Sheena Sidhu"
<[EMAIL PROTECTED]>; "Mysql (E-mail)"
The way mysql access tables work, if it cant find a user named 'user2', it
will default to the blank user ( '' ).
dpk
- Original Message -
From: "Pierre-Yves" <[EMAIL PROTECTED]>
To: "Dana Powers" <[EMAIL PROTECTED]>
Cc: <[EMAIL PRO
> ERROR 1044: Access denied for user: '@localhost' to database 'hello'
This says that you are connected as user '' ( blank ) from localhost. Make
sure you're logging on correctly and try again.
dpk
-
Before posting, please check
This is covered in the mysql manual here:
http://www.mysql.com/doc/P/o/Post-installation.html
First, you need to install the default databases ( installs
mysql/host.frm ):
bash> mysql_install_db
Then tell mysql not to use InnoDB:
put this in your /etc/my.cnf file:
[mysqld]
skip-innodb
linking tables via MyODBC + MS Access works great for me.
dpk
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, August 28, 2001 12:06 AM
Subject: reports? from MySQL
> hello.
>
> with a lot of help from many of you and some very nice folks, i have
> b
Every mail on this list has the following header:
List-ID:
I use maildrop with the following filter:
if ( /^List-ID\: \/)
{
to "Maildir/.mysql"
}
hope this helps,
dpk
- Original Message -
From: "Glyndower" <[EMAIL PROTECTED]>
To: "George Pitcher" <[EMAIL PROTECTED]>; <[EMAIL PROTEC
37 matches
Mail list logo
