Hello,
is it a bug or a feature that if building mysql 5.5.8 from source with the
options 'cmake . -DDEFAULT_CHARSET=utf8 -DDEFAULT_COLLATION=utf8_general_ci'
the charset in include/config.h remains latin1:
#define MYSQL_DEFAULT_CHARSET_NAME latin1
#define MYSQL_DEFAULT_COLLATION_NAME
)
On Wed, 29 Jun 2005, Gleb Paharenko wrote:
Privet.
As I know, PHP usually takes the character set from the server.
Please send part of your configuration file related to character sets.
Varshavchick Alexander [EMAIL PROTECTED] wrote:
Hi,
I have mysql 4.1.12 started with the default charset
Hi,
I have mysql 4.1.12 started with the default charset 'koi8r' and I have
the following problem: when connecting from PHP, the default
results and connection charsets become latin1, so all not-latin characters
get lost (they are displayed as ?). Of cause, if I explicitely set these
Hello,
did anybody make any tests to check the speed of 4.1 version comparing
with 4.0.*? Does the peformance of 4.1 depend in which client libraries
are used - 4.0 or 4.1? As the docs say, the new client/server protocol
with support for prepared statements has to be faster, and it would be
Hello,
After upgrating mysql 4.0.7 to 4.0.18/FreeBSD 4.6.2, the mysqld restarts
each time it receives a remote connect from another client machine. Here
is what is written into the log:
040415 08:51:00 mysqld started
040415 8:51:00 Warning: setrlimit returned ok, but didn't change limits.
Max
Hi,
I have a 4.0.7 mysql server which services requests from several virtual
web sites. Most of the times all works well but periodically the mysql
server suddently gets loaded to impossibly high values - load average up
to several hundred. During such periods the server sleeps and is not
Hi Heikki,
here is a snip from the original posting which you probably have
overlooked:
The first strange thing is that MAXDSIZ and DFLDSIZ in kernel config are
setted to 1536M
Regards
Alexander Varshavchick, Metrocom Joint Stock Company
Phone: (812)118-3322, 118-3115(fax)
On Mon,
Hello,
If it's a documented feature which I've missed - please excuse, but after
upgrading from 4.0.2 to 4.0.7 the following sql statement started to
behave differently then before:
select Sections.ReportName, Creatives.Name,
from HourlyStats natural left join Sections
left join
On Tue, 4 Feb 2003, Kees Hoekzema wrote:
I had the same problem, it went on until I had 44G of InnoDB space, with only
4G free. After getting tired of having to increase the number of files every
week, I decided to dump all data with mysqldump, remove the files+ logs and
recreate them. After
Hello,
If it's a documented feature which I've missed - please excuse, but after
upgrading from 4.0.2 to 4.0.7 the following sql statement started to
behave differently then before:
select Sections.ReportName, Creatives.Name,
from HourlyStats natural left join Sections
left join
Hello,
If it's a documented feature which I've missed - please excuse, but after
upgrading from 4.0.2 to 4.0.7 the following sql statement started to
behave differently then before:
select Sections.ReportName, Creatives.Name,
from HourlyStats natural left join Sections
left join
: Tommy F. Eriksen [EMAIL PROTECTED]
To: Varshavchick Alexander [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: RE: Using more than one CPU on FreeBSD?
Okay.
By the way, sorry about sending you the reply directly before.
However, I've run into a new problem new. Tried to compile mysql-4.0.9
Hi,
First of all, we can presume you're using SMP kernel. Then I'd suggest
using Linuxthreads despite your dislike for them - by my experience, they
work far better for mysql/FreeBSD than native threads. May be you try it
again - compile mysql from the ports (WITH_LINUXTHREADS=yes), and it
should
Hi people,
I have a problem running mysql 4.0.4 using mostly innodb tables: mysql
starts without any problems, then after about a half-hour it returns
queries with errors that databases are not found. And indeed, show
databases command shows the single database with a name vi.recover. The
system
Hi people,
what is the status of version 3.23.55? It's already available for download
from www.mysql.com, but the links on the official download page all points
to 3.23.54a...
regards
Alexander Varshavchick, Metrocom Joint Stock Company
Phone: (812)118-3322, 118-3115(fax)
Hi people,
Why such a message appears at random times when connecting to mysql:
ERROR 1135: Can't create a new thread (errno 35). If you are not out of
available memory, you can consult the manual for a possible OS-dependent
bug
The system is FreeBSD 4.5 with mysql 4.0.2, and there is a lot of
]
To: 'Varshavchick Alexander' [EMAIL PROTECTED], [EMAIL PROTECTED]
Subject: RE: Can't create a new thread error
Sets number of connectons per user/host
set-variable= max_user_connections = 100
Sets total number of connections.
set-variable= max_connections = 500
Also see number of threads for FreeBSD
Hi Andrew,
Did you try switching into InnoDB tables, or which table type are you
using?
Alexander Varshavchick, Metrocom Joint Stock Company
Phone: (812)118-3322, 118-3115(fax)
On Tue, 24 Sep 2002, Andrew Maltsev wrote:
Date: Tue, 24 Sep 2002 20:21:36 -0700
From: Andrew Maltsev [EMAIL
Hi people,
Is there any way I can see how much space each database is using from the
innodb data file? Something showing how the space is divided among
the databases. Thanks.
sql,query
Alexander Varshavchick, Metrocom Joint Stock Company
Phone: (812)118-3322, 118-3115(fax)
Hi Heikki,
one more question please about innodb_flush_log_at_trx_commit: if there
was some way of increasing the delay between log flushes more than 1 sec,
can you estimate will it bring any real effect in performance? I know
it'll raise the risk of losing some last transactions if something
value for innodb_flush_method can be optimal?
Thanks
Alexander Varshavchick, Metrocom Joint Stock Company
Phone: (812)118-3322, 118-3115(fax)
On Fri, 6 Sep 2002, Heikki Tuuri wrote:
Date: Fri, 6 Sep 2002 10:27:03 +0300
From: Heikki Tuuri [EMAIL PROTECTED]
To: Varshavchick Alexander [EMAIL
Heikki, one little question - is it a mistype, or can a flush log interval
duration be controlled by this option? The value should only be 0 or 1 as
the documentation says...
On Thu, 5 Sep 2002, Heikki Tuuri wrote:
You can try setting
innodb_flush_log_at_trx_commit=2
if you can afford
Hi,
why innodb queries work MUCH slower (100 times) than if the table was of
myisam type? It's mysql 4.0.3 on FreeBSD 4.5 server. The innodb monitor
outputs many messages like the following, why are they there and what do
they mean?
Purge done for trx's n:o 0 782 undo n:o 0 0
Total number of
.
Regards
Alexander Varshavchick, Metrocom Joint Stock Company
Phone: (812)118-3322, 118-3115(fax)
On Tue, 3 Sep 2002, Ken Menzel wrote:
Date: Tue, 3 Sep 2002 10:34:06 -0400
From: Ken Menzel [EMAIL PROTECTED]
To: Varshavchick Alexander [EMAIL PROTECTED], [EMAIL PROTECTED]
Subject: Re
: Steven Roussey [EMAIL PROTECTED]
To: Mysql [EMAIL PROTECTED]
Cc: 'Varshavchick Alexander' [EMAIL PROTECTED]
Subject: Re: upgrade 3.23 - 4.0.3 question
-
The real cause for the question lays in the problem which occured after
I
upgraded to 4.0.3 WITHOUT recompiling DBI module: the new
problems in communicating with DBI module which was left unchanged.
So again we're returning to the questuin should DBI be reinstalled or no?
regards
Alexander Varshavchick, Metrocom Joint Stock Company
Phone: (812)118-3322, 118-3115(fax)
On Mon, 2 Sep 2002, Varshavchick Alexander wrote:
Date
On Thu, 29 Aug 2002, Dan Nelson wrote:
Please don't hijack threads; you replied to a message titled
performance tunning 4.x.
sorry, my fault...
In the last episode (Aug 29), Varshavchick Alexander said:
I have a FreeBSD server where I installed mysql 3.23 with linux
threads from
Hi,
It seems that the instructuons on
http://www.mysql.com/doc/en/Upgrading-from-3.23.html are contradicting
themselves, or I'm mistaken:
*** first snap ***
Ensure that you don't have any MySQL clients that uses shared libraries
(like the perl Msql-Mysql-modules). If you have, you should
Hi people,
I have a FreeBSD server where I installed mysql 3.23 with linux threads
from a port collection, the procedure was simple enough
(WITH_LINUXTHREADS=yes make). All my attempts then to build it from
sources were unsuccessfull, however it was not important consdering
that it could be
Hello,
How can I increase the size of the tablespace for innodb tables? Can you
say if this is a correct procedure:
1. Dumping the database;
2. Stopping it;
3. Deleting innodb log files (ib_logfile0, ...) and innodb data file
specified in innodb_data_file_path;
4. Changing size of data file in
Varshavchick, Metrocom Joint Stock Company
Phone: (812)118-3322, 118-3115(fax)
On Tue, 19 Feb 2002, Ken Menzel wrote:
Date: Tue, 19 Feb 2002 15:14:39 -0500
From: Ken Menzel [EMAIL PROTECTED]
To: Varshavchick Alexander [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: Re: Mysql performance
Hi people,
May be anybody can advice from the personal experience tweeking which
options both in the mysql configuration and server hardware can help in
increasing mysql performance speed? As it is now, mysql is configured to
occupy about 600M RAM, and queries per second avg goes up to about
Varshavchick, Metrocom Joint Stock Company
Phone: (812)118-3322, 118-3115(fax)
On Tue, 19 Feb 2002, Simon Green wrote:
Date: Tue, 19 Feb 2002 13:22:04 -
From: Simon Green [EMAIL PROTECTED]
To: 'Varshavchick Alexander' [EMAIL PROTECTED], [EMAIL PROTECTED]
Subject: RE: Mysql performance
[EMAIL PROTECTED]
To: Varshavchick Alexander [EMAIL PROTECTED],
Simon Green [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: Re: Mysql performance question
Hi Simon,
A couple of things, unless you have compiled WITH_LINUX_THREADS
from the /usr/ports/databases then adding more processors
See mysqldump utility, it does exactly what you ask.
Alexander Varshavchick, Metrocom Joint Stock Company
Phone: (812)118-3322, 118-3115(fax)
On Tue, 19 Feb 2002, Sterling J. Anderson wrote:
Date: Tue, 19 Feb 2002 11:14:11 -0600
From: Sterling J. Anderson [EMAIL PROTECTED]
To: [EMAIL
35 matches
Mail list logo