mo...@fastmail.fm (mos) writes:
At 08:06 PM 7/12/2009, Morten wrote:
If you can get rid of the DateTime and switch to just Date it may
speed up the indexes.
While not as pretty it's more compact to convert timestamp values into
an bigint. For example: seconds since epoch. If you know the
g...@primeexalia.com (Gary Smith) writes:
...
In database G we have 150+ stored procedures.
150k stored procedures? Sounds rather large. Do you really need this?
What's the best approach to fix this problem? Is it as simple as adding the
appropriate USE statement inside of the stored
mo...@fastmail.fm (mos) writes:
At 12:37 AM 6/25/2009, you wrote:
...
my.cnf based on my-huge.cnf, expanding key_buffer to 8G,
myisam_sort_buffer_size to 256M, and putting tmpdir on the fiber channel
disk.
You mean key_buffer_size don't you and not key_buffer? If you
are using
This is in 5.0.68 and 5.1.34.
I'm trying to cleanup some old data in a table which looks like the following:
CREATE TABLE `transaction_history` (
`customer_id` int(10) unsigned NOT NULL default '0',
`transaction_id` int(10) unsigned NOT NULL default '0',
`first_timestamp` datetime NOT NULL
per...@elem.com (Perrin Harkins) writes:
On Wed, May 27, 2009 at 6:43 AM, Simon J Mudd sjm...@pobox.com wrote:
So is the format of the DELETE FROM .. WHERE ... IN ( ... ) clause I
propose valid and SHOULD the optimiser recognise this and be expected
to just find the 2 rows by searching
On Thu, May 14, 2009 at 04:45:44PM -0700, Scott Haneda wrote:
It's true that initial mysql replication setup is a bit fiddly, but
once you've done it once or twice it's not so hard.
I have it set up and working in test. I will redo it again once I get
a better handle on it. I am still
On Fri, May 15, 2009 at 12:48:18AM -0700, Scott Haneda wrote:
Also, how do I set the slave to be read only? I set read-only in
my.cnf and it made all databases read only.
SET GLOBAL read_only = true;
and as you've done in the my.cnf file.
Unless the user has SUPER rights he can't change
talkli...@newgeo.com (Scott Haneda) writes:
Hello, I am confused about repliction setup. Reading a config file,
and the docs, leads me to believe this is an either code choice, pick
#1 or #2. If that is the case, why would I want to use #1 over #2?
My confusion comes from several online
replying only to the list...
On Wed, May 13, 2009 at 10:19:21AM -0700, Scott Haneda wrote:
3. Configure on the slave the replication (which databases need to
be replicated)
This is where I need a little clarification, is the only thing I need
to do is adjust my.cnf to have in the
kimky...@fhda.edu (Kyong Kim) writes:
I was wondering about a scale out problem.
Lets say you have a large table with 3 cols and 500+ million rows.
Would there be much benefit in splitting the columns into different tables
based on INT type primary keys across the tables?
To answer your
compu...@videotron.ca (michel) writes:
I set up MySQL and when I try to start it it fails telling me that I
need to run 'mysql_upgrade'.
Show us the full error output and provide information on the version
of MySQL you are using.
When I run 'mysql_upgrade' it runs
'mysqlcheck' which is
compu...@videotron.ca (michel) writes:
I might have it fixed! I tried /home/qsys/mysql-5.1.32/libexec/mysqld
and I would get
/home/qsys/mysql-5.1.32/libexec/mysqld: Table 'mysql.plugin' doesn't exist
090510 0:19:54 [ERROR] Can't open the mysql.plugin table. Please run
mysql_upgrade to
kimky...@fhda.edu (Kyong Kim) writes:
I don't have all the details of the schema and workload. Just an
interesting idea that was presented to me.
I think the idea is to split a lengthy secondary key lookup into 2 primary
key lookups and reduce the cost of clustering secondary key with primary
nik...@doppelganger.com (Nikita Tovstoles) writes:
We have a java-based webapp that talks to MySQL 5.1 INNODB in READ_COMMITTED.
We use Hibernate and optimistic concurrency, so periodically concurrent write
attempts cause app-level Exceptions that trigger rollbacks (and then we retry
tx).
abhishek@gmail.com (Abhishek Pratap) writes:
I am kind of stuck with this query , cant expand my thinking. May this is a
limitation. Here it is
I have a database with many cols two of which are start and end position for
an event.
Now I have a list of event time stamps, I want to
prajapat...@gmail.com (Krishna Chandra Prajapati) writes:
You are running three mysql instance on single server. You can have three
my.cnf say my.cnf, my1.cnf, my2.cnf with different port and socket and other
information in them. In this way you can set the prompt for different
instance.
[EMAIL PROTECTED] (Shain Miley) writes:
I am trying to plan we in advance our methods for backup and recovery
of our new MySQL replication cluster. After doing some research it
looks like a lot of people are using LVM snapshots as their backup
solution. We currently have two MySQL servers
[EMAIL PROTECTED] (Shain Miley) writes:
I am looking into the idea of setting up 10 - 15 virtualized instances
of MySQL. The reason for this is as follows...we are going to be
setting up a 3 to 4 node MySQL replication cluster (1 master-rw and 2
slaves-ro)...each having 16 to 32 GB of RAM.
[EMAIL PROTECTED] (Shain Miley) writes:
Hello all,
I was wondering if anyone had any good insight into running the 32
bit and 64 bit versions of MySQL? We are going to be using a
replication setup within my organization very shortly. We intend to a
have at least one master (writable) DB
[EMAIL PROTECTED] (hezjing) writes:
When and why we create tables in different storage engines within a same
database?
Take for example a normal inventory application that provides CRUD operation
to
- USER table (e.g. create new user)
- STOCK table (e.g. when there is new stock arrives)
[EMAIL PROTECTED] (Carl) writes:
I am running 5.0.24a on Slackware Linux. I would like to set up a
master-master replication process so that I can use both servers as master as
add/delete/update records on both servers from different application servers
(Tomcat.) I suspect the inserts
[EMAIL PROTECTED] (Mike Aubury) writes:
I'm probably being a bit stupid - but I'm trying to determine (in code) the
length of the string in the schema for a given table.
So - for example :
create table a (
blah char(20)
)
I want to return '20', but I'm
[EMAIL PROTECTED] (Database System) writes:
There were no any error message on console or in error log.
The symptoms are
1) the binary log file goes to /data/mysql/data/ dir, not as defined in
/data/mysql/log/
2) the binary log files name start with mysql-bin, not as I defined in
my.cnf
[EMAIL PROTECTED] (Josh Miller) writes:
I have recently become responsible for a LAMP site which has a decent
MySQL install (v5.0.24a). The database is around 40GB with a single
master to single slave replication scheme, although all activity goes
to the master at this time, with the
[EMAIL PROTECTED] (Pawel Eljasz) writes:
there is a user with following grants:
GRANT USAGE ON *.* TO 'ff'@'localhost' IDENTIFIED BY PASSWORD
'x'
is it possible to:
revoke all on *.* from $above_user OR revoke usage on *.* from $above_user
?
DROP USER [EMAIL PROTECTED];
Simon
--
the
problem. thanks for the help.
Regards,
Simon
--
Simon J Mudd, Madrid SPAIN. email: [EMAIL PROTECTED]
Tel: +34-91-408 4878, Mobile: +34-605-085 219
-
Before posting, please check:
http://www.mysql.com/manual.php
|
+---+
| negatives |
+---+
[sjmudd@phoenix sjmudd]$
Looks like I was affected by the bug in .36.
Thanks very much for your help with this.
Regards,
Simon
--
Simon J Mudd, Madrid SPAIN Tel: +34-91-408 4878
email: [EMAIL PROTECTED] Mobile: +34-605-085 219
On Sat, 1 Sep 2001, Sinisa Milivojevic wrote:
Simon J Mudd writes:
I've not been using mysql for some time but did have it running for a
couple of small databases I use at home. It doesn't appear to work now,
the most obvious sympton being that msyqlshow shows a list of blank table
shows no errors.
I'm sure that I'm doing something wrong which is in a FAQ but can't find
the answer at the moment. Any suggestions are greatly appreciated.
Thanks in advance.
Simon
--
Simon J Mudd, Madrid SPAIN. email: [EMAIL PROTECTED]
Tel: +34-91-408 4878, Mobile: +34-605-085 219
29 matches
Mail list logo