> MyISAM performance is limited right now by a global lock in the key
> cache. However, I believe there is work going on to fix that in the
> 4.1 tree.
Really? I thought it was going to be fixed in the 5.1 tree, which will
be years away from production quality. 4.1 would be really cool, but it
se
Please excuse a relative amateur worrying a problem.
I got a nice reply from Victoria Reznichenko yesterday on a
difficulty loading data from a text file. She said 4.0.12 had a
bug and, I as understood her answer, I should therefore enable
"load local infile".
Instead I uninstalled 4.0.12 and loa
That configuration doesn't seem to work if I'm reading it right. A slave
cannot have more then one master unless mysql more then 1 mysqld process
running on different ports is used.
-->For example, if a person places an order on our site, the update is
sent
-->to
-->the master server. Can that upd
Hi All,
I am trying to use a function as a default value for a column but do not
seem to get the desired result. I want to use the NOW() function for a
last_updated column, here is my code...
CREATE TABLE test_table (
last_updated datetime NOT NULL default `NOW()`
) TYPE=MyISAM;
This gives an
Currently, I'm running 3.23.51 on Red Hat 7.1, and I'm contemplating
upgrading to MySQL 4.0, but I'm not sure what to expect. I don't know if
MySQL 4.0 is fully backwards-compatible with 3.23.x versions, or if
something is going to break if I upgrade.
What are the main advantages of upgrading to
Greetings all.
I have a bit of a problem here, a database i'm administering was somehow corrupted,
and i'm unable to recover it in any way. Is there any way at all to recover a corrupt
InnoDB database? (I read on innodb.com that it is impossible, but hope it is not)
When I run a query from any
While I don't know for sure, my guess is that it would have something to
do with 32 bit as the magic number, but also...being that this won't
become a problem until
mysql> select from_unixtime(2147483647);
+---+
| from_unixtime(2147483647) |
+---+
|
what is the command to update InnoDB table indexes?
jeff
Brent Baisley wrote:
>
> You are referring to fragmentation. In this case I'm pretty sure it's
> just a matter of updating the indexes so that MySQL makes the correct
> assumptions about the distribution of data. MySQL assumes data values
but one guy in #mysql said:
[quote]
with myisam tables if an update is running everything else is blocked,
multiple selects are allowed to run at the same time, selects and non
interfering inserts can run at the same time
[/quote]
so i ask in mailinglist
because i can't get my multiple selects r
At 14:35 +0100 8/7/03, Andy Jackman wrote:
Hi,
I'm using v 3.23.46-nt and the C API.
The manual says under 'Changes in release 3.20.17' that:
Change FROM_DAYS() and WEEKDAY() to also take a full TIMESTAMP or
DATETIME as
argument. Before they only took a number of type MMDD or YYMMDD.
I'm con
You're saying that when you try my example, it does use the composite
index? Even with an extra column in the table that isn't being searched on
(q below)?
If so, do you know of anything in version 4.0.13 that could cause this bad
behaviour? i'm using the default configuration unchanged.
On Tue,
SELECT * FROM kf_gallery WHERE gallery_id IN ( 3, 1, 2 ) ORDER BY ?
What I'm trying to do is get the results in the order specified in the "IN"
clause, i.e. (3, 2, 1). Is this possible? (I'm having trouble searching
the mail archives). Thanks!
-m
--
MySQL General Mailing List
For list a
Update:
2003年 8月 7日 木曜日 17:06、Nils Valentin さんは書きました:
> [Warning: LNG TEXT - enjoy ;-)]
>
> Hi Victoria,
>
> sorry for the misunderstanding. I just tried to reproduce the sample. While
> I have records what I did I did not write down all commands exactly as they
> are.
>
> The problem(s) occur
You are not doing "select count(*)"
You are doing "select count ( *)"
Get rid of the spaces before the "("
Fatt Shin wrote:
Hi,
I'm running MySQL 4.0.13, connecting from PowerBuilder 9 using ODCB
Connector 3.51.
I'm facing a problem where whenever I issue a SELECT COUNT(*) statement
from PowerBui
If logging is turned on, is there a way to disable it for a given query?
IE. If I query --> select AES_ENCRYPT("This is very important data",
"lessthansecretkey");
Then my key and the value I'm trying to encrypt is visible in the log
files.
KJW
I'm having trouble ordering my results before grouping them. I don't
want to go into too much detail, so my simplified query without any
grouping or ordering results in:
++---++
| jobnum | milestone | shipdate |
++---++
| 96-655 |
* nm
> Is it possible to MERGE innodb tables?
No, MERGE is for MyIsam tables only. InnoDb tables are stored in
tablespaces, the problem with file size does not apply. You simply use
multiple tablespaces when the data outgrows the OS limits.
> Can't find docs on mysql.com
hm... mysql.com seems to
Hi,
I'm running MySQL 4.0.13, connecting from PowerBuilder 9 using ODCB
Connector 3.51.
I'm facing a problem where whenever I issue a SELECT COUNT(*) statement
from PowerBuilder, I always get SQL syntax error back from MySQL. (Refer
to ODBC Trace I captured below).
metrohouse af8-b94 ENTER S
Eben Goodman wrote:
I am storing book isbn numbers in a table. isbn numbers are 10 digit
numbers and many start with 0. The data type of the field I am storing
this info in is a bigint(16) unsigned. It appears that isbns that start
with 0 are going in as 9 digit numbers, the 0 is being ignor
Mads,
please post the WHOLE .err log. Or is there sensitive information there?
If you have taken backups and the .err log does not show any crashes in
them, how is it possible that the backups are now corrupt?
How did you take the backups? I assume that you did not simply copy the
ibdata files f
You don't say what your problem is.
aaldrik groenewold wrote:
I just installed mysql 4.0 .There were many problems
with upgrading from 3.23 to 4.0 so I deleted 3.23 and
made a fresh start with 4.0. Everything works fine now
but the only problem to connect to the server is via
the /usr/local/mysql
> I am using cold fusion to make a small custom website using
> mysql to store the information a user inputs. I want it to
> be able to save japanese and unicode text, but whenever I
> enter any it comes back as garbage. Is there anything
> special I need to do to configure mysql to use unicode
On Tuesday 05 August 2003 08:58 am, Jonathan Patton wrote:
> Walt,
>
> Thanks for the suggestion. I ran myisamchk on the table and it said it was
> corrupted. So I ran myismachk on the table with the -r and it said the
> table was fixed. I then ran the update queries I was running before and
> rece
Hi list,
I've got a little bug with MySQL.
I can insert a row into my table but this row will not appear in the table
:(
Server is under linux redhat, MySQL is 3.23.56 installed from binary tar.gz
from MySQL team.
Table Description :
mysql> desc Log_Forums;
+--+--+
Ryan A wrote:
Hi,
This is my first post here so forgive me if its too simple or not right.
basically what i do is:
SELECT COUNT(*) FROM table1 where cno=3;
(and dumping it into a variable $theResult - I am using PHP)
and it gives me the result, but now i need to do this in 5 tables...
I can of cou
John Wards wrote:
I have this query:
SELECT *
FROM news_category
LEFT JOIN news_x_cat ON news_category.id = news_x_cat.cat_id
WHERE (
news_x_cat.news_id = 9 OR news_x_cat.news_id IS NULL
)
Which gives me this output:
id title perm show news_id cat_id
1 About Us 1
FYI
Note on this. Using column privs you take a performance penalty on reads
/ writes.
-->-Original Message-
-->From: Tiffany Wilkes [mailto:[EMAIL PROTECTED]
-->Sent: Tuesday, August 05, 2003 3:48 PM
-->To: mysql
-->Subject: column privilege problem--Solved
-->
--> I solved the problem-
At 22:27 -0400 8/6/03, Keith Schuster wrote:
Can someone tell me why the columns ssl_cipher, x509_issuer, x509_subject in
the user table are REQUIRED? If they are required what is the default
value?
They are used to support the SSL-related clauses of the GRANT statement
(and hence, secure connecti
>>Jonathan Hilgeman wrote:
>>
>>>Currently, I have a Celeron 1.2 Ghz server with 512 RAM, and I'm
>>>considering moving to a P4 2 Ghz with the same amount of RAM. I have
>>>a few specific tables with several million rows of data, and it
>>>takes quite a long time to process that data on my current
29 matches
Mail list logo