[EMAIL PROTECTED] wrote:
From: Jerry Schwartz [mailto:[EMAIL PROTECTED]
What is going slower, INSERT / UPDATES or SELECTS?
Complex SELECTs
CHAR should make for quite efficient processing, since to a
large degree nobody cares what's in there: it just slams the
data in, or does a simple byte
> From: Jerry Schwartz [mailto:[EMAIL PROTECTED]
>
> What is going slower, INSERT / UPDATES or SELECTS?
Complex SELECTs
> CHAR should make for quite efficient processing, since to a
> large degree nobody cares what's in there: it just slams the
> data in, or does a simple byte-by-byte compari
In the last episode (Oct 27), wolverine my said:
> Given the commands like ANALYZE, OPTIMIZE and CHECK, what is the
> preference order to execute these commands?
OPTIMIZE calculates statistics as it rebuilds the table, so there's no
need to run an ANALYZE pass after it. You shouldn't ever need to
Hi!
Given the commands like ANALYZE, OPTIMIZE and CHECK, what is the
preference order to execute these commands?
We would like to schedule and execute these commands every month...
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysq
Since installing MySQL 5.0.24 on Windows XP, once or twice a week I'll get
an error message "Can't connect to MySQL server on 'localhost' (10061)
Socket error on connect. WSAGetLastError return 10061". Does anyone know
what could be causing it?
This didn't happen when I ways using MySQL 4.1
M
Bill, there's a note here:
http://dev.mysql.com/doc/refman/5.0/en/flush.html
that says:
"You can start mysqld with --max_connect_errors=9 to avoid
this error message."
Now, it's not clear whether that
1) disables just the error message but still blocks hosts
2) disables the host blocking
In response to Bill Moran <[EMAIL PROTECTED]>:
> In response to "Dan Buettner" <[EMAIL PROTECTED]>:
>
> > Bill, you can up the value of 'max_connect_errors' (default is 10 it
> > appears) to make this problem appear less frequently while you
> > troubleshoot.
>
> Thanks for the thought, Dan. Be
I have a table with no primary key. I'd like to
make one of the table columns as the primary key.
Is it possible do it with ALTER? Is there any other way?
ALTER TABLE tblname ADD PRIMARY KEY (colname);
PB
--
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.
Hi
I have a table with no primary key. I'd like to make one of the table columns
as the primary key. Is it possible do it with ALTER? Is there any other way?
Many thanks for your help.
Murthy
__
Do You Yahoo!?
Tired of spam? Yahoo! Mail
>Haven't read your issue in its entirety, but UTF-8 can definitely
>handle these characters.
>The prob is either in the DB, the app, or the tomcat config.
>
>1. The DB: Make absolutely sure that the content in the db is in fact UTF-8.
>
>One thing I've done in the past to verify this exact issue, i
Hi,
I thought my utf8 settings on my database and tomcat were effective, but I am
still getting ? characters instead of the real thing, even for simple things
like latin extended-A, and even some latin-1 characters are broken. Any ideas?
Here is some text as entered, and as returned by my Java
What is going slower, INSERT / UPDATES or SELECTS?
CHAR should make for quite efficient processing, since to a large degree
nobody cares what's in there: it just slams the data in, or does a simple
byte-by-byte comparison. There is probably hardware support for that kind of
operation. Decimal arit
On Thu, 2006-10-26 at 08:44 -0500, Dan Buettner wrote:
> I'm sure there are people who would find it useful! Post it on MySQL
> Forge - http://forge.mysql.com !
Will take a look at the site
>
> Dan
>
> On 10/26/06, Ow Mun Heng <[EMAIL PROTECTED]> wrote:
> > Hi All,
> >
> > just wondering if an
Did you leave your queries searching on ASCII instead of decimal? Depending on how you structured your queries, MySQL may actually
be converting the fields to ASCII in order to do the comparison. Which would probably take 3x longer since it's not using an index.
- Original Message -
Fro
I'm sure there are people who would find it useful! Post it on MySQL
Forge - http://forge.mysql.com !
Dan
On 10/26/06, Ow Mun Heng <[EMAIL PROTECTED]> wrote:
Hi All,
just wondering if anyone here is interested in a (bash)script that does
DB replication/synchronisation between a MSSQL server t
At 11:45 +0300 10/21/06, Ahmad Al-Twaijiry wrote:
Hi everyone
is it possible in Mysql 5.0.1 to set the timezone for a user ?
PS: I don't have root access to mysql, so I'm looking for away to do
it as a normal user.
Time zone support is described here:
http://dev.mysql.com/doc/refman/5.0/en/t
Hi All,
just wondering if anyone here is interested in a (bash)script that does
DB replication/synchronisation between a MSSQL server to a MySQL server
running in Linux.
I just completed writing it and it seems to be working well, although
there are 1 or 2 more features which I would like to add.
I have a database with several tables that can have up to 100 000 rows
there is ~100 updates every seconds and ~100 select query on the same
table with locks.
The update is always on the same field a varchar(15), I believe it will
be recommended to change it to char(15) to improve performance o
RV Tec wrote:
Folks,
A few months ago, I came here asking for directions on how I could
improve performance of MySQL. Back then, I was using OpenBSD on a dual
Opteron 248 with 2GB, LSI MegaRAID 320-1, 15k RPM SCSI discs, MySQL was
(still is) 4.0.27, the database is MyISAM, reaching 50GB.
Af
Hi,
I was hoping to speed up my database operations a bit by changing some
colums in my database from CHAR(15) ASCII to DEC(15) UNSIGNED ZEROFILL. I
was expecting a speedup as DEC(15) is more compact, and this columns are
also part of InnoDB indices. In contrary to my expectations, running my
t
20 matches
Mail list logo
