Francisco Rodrigo Cortinas Maseda wrote:
Hi,
I have experienced similar problems to the one you have; the problem you have
is that the time gap between the failure and now is so big that you cannot
resume replication, because of the big data portion you have to replicate.
Well, that was
Hi,
Three things...
1. You need to let us know what the DB server will be doing. Many CPU
cores are only important of you have many CPU intensive MySQL
connections in parallel. Will you have a read-intensive or
write-intensive database load? Those 2950III you're considering can
take up to 8
Hi All,
I have a dictionary table like:
CREATE TABLE IF NOT EXISTS `mydictionary`
(
`EN` varchar(36) default NULL,
`DE` varchar(36) default NULL,
`ES` varchar(36) default NULL,
`FR` varchar(36) default NULL,
`IT` varchar(36) default NULL,
`NL` varchar(36) default NULL,
`PT`
Thank you all for your suggestions.
So it's very important to make primary fields be as smaller as possible,
right? I'm going to change 'isbn' from VARCHAR(100) to VARCHAR(25) and, if
possible (I might change my code), from VARCHAR to BIGINT.
By the way, which are optimal values for key_len
Hi.
I've got a table with some fields, which I created with VARCHAR(100).
I want to optimize this table, and I want to modify the length of these
fields from VARCHAR(100) to VARCHAR(maximum_length), where maximum_length
is the length of the record with the longest field.
I could create a Perl
Hi Charles,
to get max . # characters:
SELECT MAX(CHAR_LENGTH(fieldname)) AS `MaxChars`;
to get max. # bytes:
SELECT MAX(LENGTH(fieldname)) AS `MaxBytes`;
HTH, Cor
- Original Message -
From: Charles Lambach [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Sent: Tuesday, April 29, 2008
Yes, I did FLUSH PRIVILEGES and I think I only have one username/host
entry for this user.
Adam
Erik Giberti wrote:
Did you FLUSH PRIVILEGES?
I'd also check that the username and passwords are the same for each
host entry, I've had problems if passwords were different for a shared
username
On Tue, Apr 29, 2008 at 5:12 AM, C.R.Vegelin [EMAIL PROTECTED] wrote:
Hi All,
I have a dictionary table like:
CREATE TABLE IF NOT EXISTS `mydictionary`
(
`EN` varchar(36) default NULL,
`DE` varchar(36) default NULL,
`ES` varchar(36) default NULL,
`FR` varchar(36) default NULL,
On Tuesday 29 April 2008 08:21:37 Charles Lambach wrote:
Hi.
I've got a table with some fields, which I created with VARCHAR(100).
I want to optimize this table, and I want to modify the length of these
fields from VARCHAR(100) to VARCHAR(maximum_length), where maximum_length
is the length
Would you kindly supply the changes you made, for our collective education?
Thanks.
Arthur
On Mon, Apr 28, 2008 at 11:54 AM, Mark-E [EMAIL PROTECTED] wrote:
Hi Ian,
Thanks for the reply. I was specifying the new port of 3307. I actually
got it working over the weekend. Turns out I had to
- Original Message -
From: Rob Wultsch [EMAIL PROTECTED]
To: C.R.Vegelin [EMAIL PROTECTED]
Cc: mysql@lists.mysql.com
Sent: Tuesday, April 29, 2008 2:24 PM
Subject: Re: why is explain.key-len not size of key field ?
On Tue, Apr 29, 2008 at 5:12 AM, C.R.Vegelin [EMAIL PROTECTED] wrote:
On Tue, Apr 29, 2008 at 7:39 AM, C.R.Vegelin [EMAIL PROTECTED] wrote:
- Original Message - From: Rob Wultsch [EMAIL PROTECTED]
To: C.R.Vegelin [EMAIL PROTECTED]
Cc: mysql@lists.mysql.com
Sent: Tuesday, April 29, 2008 2:24 PM
Subject: Re: why is explain.key-len not size of key
- Original Message -
From: Rob Wultsch [EMAIL PROTECTED]
To: C.R.Vegelin [EMAIL PROTECTED]
Cc: mysql@lists.mysql.com
Sent: Tuesday, April 29, 2008 2:44 PM
Subject: Re: why is explain.key-len not size of key field ?
On Tue, Apr 29, 2008 at 7:39 AM, C.R.Vegelin [EMAIL PROTECTED] wrote:
On Tue, Apr 29, 2008 at 5:09 AM, Charles Lambach
[EMAIL PROTECTED] wrote:
Thank you all for your suggestions.
So it's very important to make primary fields be as smaller as possible,
right? I'm going to change 'isbn' from VARCHAR(100) to VARCHAR(25) and, if
possible (I might change my
Hi Arthur,
Sure, no problem!
This actually proved to be rather tricky because the first instance was
installed in /usr/local/mysql. It seems that by default, MySQL looks for things
in this locations so if you deviate from it, you have to be explicit with mysql
and tell it where to look for
Hello,
I faced this issues a few years ago and I'd like to give my contributions.
The easy and clean way I've found:
--
-- One installation for each mysql instance
-- On each instance you can have as many databases as you want.
Hi!
I'm using phpBB3 directly connected on my mysql-proxy:
// phpBB 3.0.x auto-generated configuration file
$dbms = 'mysqli';
$dbhost = '10.25.0.12';
#$dbport = '3306';
$dbport = '4040';
$dbname = 'phpbb';
$dbuser = 'phpbb';
$dbpasswd = 'phpbb';
$table_prefix = 'phpbb_';
$acm_type =
I am not sure if this is the appropriate place to do this kind of posting
but I thought this discussion group might be interested in hearing about
this opportunity. I am working with a client in Kansas City that is looking
for a contract to hire resource that has experience as a Mysql DBA that
Hi everybody,
I would like to discuss there hierarchical storage theory. Currently I
have came across 2 types for storing hierarchical data (yes, I´ve read
the article at mysql.com, and MANY others sites), but I would like to
know your option about the day-to-day usage... I mean I´ve only
Just correcting my self,
The hierarchical storage theory is nested set model, and not
transverse. And also I know that oracle 10g has a hierarchical
query, but I am more interested on pure SQL2 theories and solutions.
And also, SHOULD (or could) MySQL have some type or recursive query?
Bruno,
Interesting emails. You might consider talking to Arjen Lentz about
his special hierarchical-storage magic. It's still in development,
but ... well, I'll let you talk with him about it.
Best,
Baron
On Tue, Apr 29, 2008 at 2:12 PM, Bruno B B Magalhães
[EMAIL PROTECTED] wrote:
Just
I have three tables in a survey system (that I didn't design)
surveys (the instance of a user taking a survey) with survey_id and show_id
(each survey is in response to a particular show)
responses (possible responses to questions) with response_id
response_map ( survey_id, response_id )
Hi all,
I feel obliged to report on my success with migration from 32bit to
64bit platform.
Last Sunday I braced myself and migrated 3 servers (one master and two
slaves) with approximately 100GB data each by simply rsyncing the data
files. It took about 1 hour total downtime.
I'll do that, thanks. (Sorry for the long response time, I was in
Dublin this past week...).
On Mon, Apr 21, 2008 at 3:16 PM, Wm Mussatto [EMAIL PROTECTED] wrote:
On Mon, April 21, 2008 07:28, Waynn Lue wrote:
Is there any way to prevent UPDATEs on one database on one mysql
instance from
Hi,
Key_blocks_unused 952405
Key_blocks_used 395539
Key_blocks_used is increasing day by day and Key_blocks_unused is
decreasing day by day. Ater a month Key_blocks_unused will reach to 0. Does
it mean that i need to increase the key_buffer_size. Already
schizophrenic
Hi Rob,
On Wed, Apr 23, 2008 at 6:47 AM, Rob Wultsch [EMAIL PROTECTED] wrote:
On Wed, Apr 23, 2008 at 6:39 AM, Morten Primdahl [EMAIL PROTECTED] wrote:
Thanks Rob and Baron, I'd never heard of the integers table approach
before, really good stuff!
If memory serves
In the last episode (Apr 30), Krishna Chandra Prajapati said:
Key_blocks_unused 952405
Key_blocks_used395539
Key_blocks_used is increasing day by day and Key_blocks_unused is
decreasing day by day. Ater a month Key_blocks_unused will reach to
0. Does it
Hi Dan,
I am worried about Key_blocks_unused. when Key_blocks_unused reach to 0.
There will be no free blocks then how insert query will work.
Thanks
Krishna Chandra Prajapati
On Wed, Apr 30, 2008 at 10:42 AM, Dan Nelson [EMAIL PROTECTED]
wrote:
In the last episode (Apr 30), Krishna Chandra
28 matches
Mail list logo
