s,
If you can't alter the application to split reads and writes, why not
let MySQL Proxy to do it for you?
http://forge.mysql.com/wiki/MySQL_Proxy
Combine this with haproxy and you could build a multi-master environment
with each master having any number of slaves. Set MySQL Proxy to send
; > My question is: if I delete many records in a single delete statement
> > (i.e., DELETE FROM table WHERE id = 1 AND id = 5 ... AND ID = 100) how many
> > times are the foreign keys/indexes updated?
> >
> > Once for the entire DELETE operation or one time for each r
Hi Vikram,
As far as I know it's just table names: I think it's related to the fact
that the Windows file system is case-insensitive, while Linux
filesystems generally are not.
On Thu, 2010-03-18 at 15:18 +0530, Vikram A wrote:
> Hello Ian Simpson,
>
> Thank you for repl
purely from the webpage ?
>
> Cheers
> Neil
--
Ian Simpson
System Administrator
MyJobGroup
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
he INTERNET now has a personality. YOURS! See your Yahoo! Homepage.
> http://in.yahoo.com/
--
Ian Simpson
System Administrator
MyJobGroup
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
ost'. Has anyone ever removed this account? Do I need it or can
> I safely remove this account? I don't understand why it's there. I
> don't want to break MySQL even though there is no data or databases on
> this machine but I would like to keep this as clean as possib
Hi,
Thanks, I just checked and it was a memcache that was caching the output.
See I knew it was a simple solution ;)
Thanks for the effort everyone and sorry for wasting time.
Regards
Ian
2009/12/17 Aleksandar Bradaric
> Hi Ian,
>
> Why do you think something's wrong? Here i
post_id ORDER BY
views DESC LIMIT 10
Any ideas as to whats wrong. I know its something simple, I just cant put my
finger on it.
Thanks in advance,
Ian
articles eq_ref PRIMARY PRIMARY 8
database.article_views.article_id 1 Using where
No difference :/
And I used the query below so its only 1 week and not the 2-3 weeks in the
table.
Thanks anyway :)
Ian
2009/10/9 Daevid Vincent
> ALTER TABLE articles ADD INDEX date_idx (date);
>
> > -
LEFT JOIN article_views
ON article_views.article_id = articles.id WHERE ( date <= '2009-10-07' AND
date >= '2009-10-01') GROUP BY article_id
Any help would be greatly appreciated.
Thanks
Ian
n I do something like this:
>
> SELECT
> * from Projects where Project_ID = 5,
> Name from People where Projects.Boss_ID = People.ID as Boss_Name,
> Name from People where Projects.Admin_ID = People.ID as Admin_Name,
> Name from People where Projects.Assistant_ID = People.ID as
ws unless the statment include a LIMIT clause
> 3. Multiple-table SELECT statments are allowed only if MySQL will
> examine no more than 1,000,000 rows to process the query.
>
> The --i-am-a-dummy option is a synonym for --safe-updates. :)
>
> Gluck
>
> Darren
>
&g
gt; Regards
>
> John Daisley
> Mobile +44(0)7812 451238
> Email j...@butterflysystems.co.uk
>
> Certified MySQL 5 Database Administrator (CMDBA)
> Certified MySQL 5 Developer
> Cognos BI Developer
>
> -------
> Sent from HP IPAQ mobile device.
>
me unwilling to experiment with them without advice,
in case one of them disables networking or something similar.
Hoping someone can help with this.
Thanks
--
Ian Simpson
System Administrator
MyJobGroup
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsub
gt;
> >
> >
> > mysql> create database testdb;
> > ERROR 1044 (42000): Access denied for user 'user'@'localhost' to
> > database 'testdb'
> >
> > Can someone point out the error of my ways?
> >
> > Many thanks,
state.sql
> -- Connecting to 152.20.1.115...
> mysqldump: Got error: 1044: Access denied for user 'dip'@'152.20.1.%' to
> database 'dip' when doing LOCK TABLES
>
> Thanks,
> Krishna Chandra Prajapati
--
Ian Simpson
System Administrator
MyJobGroup
--
2009/3/29 Oscar :
> Hi all-
>
> I want to know what the difference between IN and OR is under the hood.
>
> select * from dummy_table where id in (2, 3, 4, 5, 6, 7);
>
> select * from dummy_table where id=2 or id=3 or id=4 or id=5 or id=6 or
> id=7;
I've have thought once the query is compiled, th
on 5.1.30, it did the same thing, 2 rows. But at least it DID update on
> 5.1.30, but not on 5.0.37.
>
--
Ian Simpson
System Administrator
MyJobGroup
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
ame foreign key three times. You should be ok as you are specifying
a name for the constraint, and it checks for unique names.
On Fri, 2009-01-02 at 06:03 -0500, Lola J. Lee Beno wrote:
> Ian Simpson wrote:
> > If you want deletes to be blocked, then you shouldn't be using ON DE
at http://www.lolajl.net/blog/
> "No greater injury can be done to any youth than to let him feel that
> because he belongs to this or that race he will be advanced in life
> regardless of his own merits or efforts." - Booker T. Washington
>
>
--
Ian Simpson
Award Winning System Administrator
MyJobGroup
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
2008/10/31 Moon's Father <[EMAIL PROTECTED]>
> *A prepared statement is also global to the connection. If you create a
> prepared statement within a stored routine, it is not deallocated when the
> stored routine ends. *
>
> Then I don't know how to deallocate the memory used by prepare statement
2008/10/21 Moon's Father <[EMAIL PROTECTED]>:
> Could you please give me an idea of how to manage the privileges inside
> mysql?
http://www.google.co.uk/search?q=mysql+grant
first hit :)
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://list
2008/10/17 Reyna.Sabina <[EMAIL PROTECTED]>:
> Hi,
>
> Running Environment:
> MySQL Server version: 5.0.45
> OS is Red-Hat 64-bit
>
> The table 'junk' doesn't have a row with id=4. Two tests to trap 'errors'
> using DELETE follows:
>
Perhaps I'm missing something - but a delete matching no
2008/10/17 Rob Wultsch <[EMAIL PROTECTED]>:
> On Fri, Oct 17, 2008 at 1:33 PM, Rene Fournier <[EMAIL PROTECTED]> wrote:
>
>> Okay, I realize that query won't work, but that's essentially want I want
>> to do:
>>
>> Add four months to the current date, then return the first day of that
>> month, e.g
2008/10/17 Brent Baisley <[EMAIL PROTECTED]>:
> Why are you creating a subquery/derived table?
>
> Just change your limit to 1,2
> ORDER BY updates.AcctSessionTime DESC LIMIT 1,2
Because then the maths in the select part isn't executed, and I don't
get the figures I need.
--
MySQL General Maili
2008/10/17 Rob Wultsch <[EMAIL PROTECTED]>:
> *How long does the second query actually take to run compared to first?
Actually, really quickly - so quickly that I also suspected that a
full table scan was not taking place. I'd like to understand how the
output of EXPLAIN can differ from the act
2008/10/16 Krishna Chandra Prajapati <[EMAIL PROTECTED]>:
> I believe that yahoo, google and other companies must be generating reports.
> How they are doing. Any Idea.
This is how google do it: http://en.wikipedia.org/wiki/MapReduce
Have you seen federated tables? Be aware of the performance on
2008/10/17 dave aptiva <[EMAIL PROTECTED]>:
>
> I tried SELECT ID_number, max( count( CU_number ) ) but this causes an error
> "# - Invalid use of group function "
# sqlite3
SQLite version 3.5.9
Enter ".help" for instructions
sqlite> create table moo (id_number, cu_number);
sqlite> insert int
it's doing a full table scan over all 29 million records.
Whilst this query appears to run fast still, surly it's not right that
a full table scan is needed?
Thanks,
Ian
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
all is disabled.If this is caused by a firewall barrier please tell me
> how to open the port in Nortan Internet Security.
>
>
> Varuna
--
Ian Simpson
System Administrator
MyJobGroup
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
On Fri, Sep 26, 2008 at 4:15 PM, Dan Nelson <[EMAIL PROTECTED]> wrote:
> In the last episode (Sep 26), Ian Monroe said:
>> On Fri, Sep 26, 2008 at 1:55 PM, Ian Monroe <[EMAIL PROTECTED]> wrote:
>> > On Fri, Sep 26, 2008 at 9:37 AM, Ian Monroe <[EMAIL PROTECTED]&g
On Fri, Sep 26, 2008 at 1:55 PM, Ian Monroe <[EMAIL PROTECTED]> wrote:
> On Fri, Sep 26, 2008 at 9:37 AM, Ian Monroe <[EMAIL PROTECTED]> wrote:
>> So we're using MySQL Embedded in Amarok, it works fine for most of us
>> that use 5.1, including myself. However the fo
On Fri, Sep 26, 2008 at 1:55 PM, Ian Monroe <[EMAIL PROTECTED]> wrote:
> On Fri, Sep 26, 2008 at 9:37 AM, Ian Monroe <[EMAIL PROTECTED]> wrote:
>> So we're using MySQL Embedded in Amarok, it works fine for most of us
>> that use 5.1, including myself. However the fo
your server groups are (usually just server, client) are incorrect
How could they be incorrect? I only vaguely get what they are for,
something about the config groups in my.cnf file.
Ian
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http:/
On Fri, Sep 26, 2008 at 9:37 AM, Ian Monroe <[EMAIL PROTECTED]> wrote:
> So we're using MySQL Embedded in Amarok, it works fine for most of us
> that use 5.1, including myself. However the following backtrace is
> from the second person to have this issue. Its repeatable,
So we're using MySQL Embedded in Amarok, it works fine for most of us
that use 5.1, including myself. However the following backtrace is
from the second person to have this issue. Its repeatable, happens at
startup.
Is there something about how their MySQL is setup on their system that
could cause
gt; I've said, we are dealing with at least 200,000 user records, probably
> 300,000-400,000 in the next year. The User table contains at least 50
> attributes, 15 of which are Foreign Keys that link to tables that will
> likely never change (the users choices for countryID, stateID
ed so I ask.
What are the rules for MyISAM and threads?
Any general thoughts on what backend to use for mysql embedded also
appreciated. We noticed that InnoDB seems to enjoy exit()ing on error
conditions (like disk full) which isn't very nice.
Ian
--
MySQL General Mailing List
For lis
Safe Data, Inc.
> > (910) 285-7200 [EMAIL PROTECTED]
> >
> >
> >
> > --
> > MySQL General Mailing List
> > For list archives: http://lists.mysql.com/mysql
> > To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
> >
> >
>
bian-sys-maint'@'localhost' IDENTIFIED BY
> PASSWORD 'LongPasswordHere' WITH GRANT OPTION
>
> To test it out, I try a mysql -u debian-sys-maint -p, type in the password
> and get the "Access denied" error again. What's going on? Why can
http://dev.mysql.com/doc/refman/5.0/en/delete.html
just search in the page for 'join' and you'll find the relevant section
On Tue, 2008-07-08 at 11:35 -0400, Jeff Mckeon wrote:
>
> > -Original Message-
> > From: Ian Simpson [mailto:[EMAIL PROTECTED]
>
the deleted
> rows..)
>
> Can't this be done in one query? Or two?
>
> Thanks,
>
> Jeff
>
>
>
>
--
Ian Simpson
System Administrator
MyJobGroup
This email may contain confidential information and is intended for the
recipient(s) only. If an addressing o
ike:
Datetypenumber
2008-06-15 1 4
2008-06-15 2 2
2008-06-16 1 2
2008-06-17 1 2
which is the data that you want in a different output format.
Thanks
On Mon, 2008-06-23 at 18:16 -0700, Grant Giddens wrote:
> Ian,
>
> Thanks for the help
e current rate?
>
> Is there any way to reset that parameter so that the data can reflect
> current without restarting the MySQL
>
> Thanks in advance
> ..venu
--
Ian Simpson
System Administrator
MyJobGroup
This email may contain confidential information and is inten
es_activity` (
> `sales_id` int(11) NOT NULL auto_increment,
> `sales_date` datetime NOT NULL default '-00-00 00:00:00',
> `sales_type` tinyint(4) NOT NULL default '0',
> PRIMARY KEY (`sales_id`)
> ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=
rcentage of the bandwidth
it's using, and then doing a calculation with those numbers to get the
100% value, but I don't know if that's valid, since there are generally
a number of other operations going on at the same time.
Thanks
--
Ian Simpson
On Fri, 2008-06-13 at 08:48 -0700, Wm Mus
go) suggest
that the older server is handling roughly the same data quantities, but
just using a much lower percentage of the drive's bandwidth.
I can't seem to find a tool which reports on exactly how much write
bandwidth a drive has; everything seems to focus on reading speed.
Thanks,
this...
Thanks for all your help
--
Ian Simpson
On Fri, 2008-06-13 at 10:40 -0400, Jerry Schwartz wrote:
> >Disk usage: the older server (the one that's running fine) is running
> >more transactions per second, but has lower blocks written and read per
> >second t
Blk_read Blk_wrtn
sda 88.47 782.20 998.77 9046888130 11551757459
The new server, which is just trying to handle replication
Device:tps Blk_read/s Blk_wrtn/s Blk_read Blk_wrtn
sda 77.83 1367.55 2914.72 358474084 764029986
Thanks
trx_commit
Value: 1
Variable_name: sync_binlog
Value: 0
Variable_name: innodb_locks_unsafe_for_binlog
Value: OFF
Thanks
--
Ian Simpson
On Fri, 2008-06-13 at 17:43 +0530, Alex Arul Lurthu wrote:
> Please check if the my.cnf configurations to be the same.
>
entical table.
The MySQL configuration of the two databases is identical, except for
the tablespace file size (the new server has a larger tablespace
defined), and the InnoDB logs (again, new server has larger logs).
Can anybody suggest an area of investigation as to the cause?
Thanks,
--
Ian Simpso
Glyn Astill wrote:
I'd back up the data directories then try and then re-install mysql (sorry, I
know little about red hat and it's package management). It shouldn't overwrite
your data if it's already present anyway.
Great. Thought that would be the case, but without sleep, I wasn't sure. :-
Decided to run up2date -u
I noticed that our website was tossing off mysql errors. Quickly
realized that mysql was down. Went to restart but it couldn't find
mysqld_safe, mysqld, mysqladmin, etc.
I used locate and it couldn't find the binaries anywhere...it appears
that up2date -u had someho
Mark,
When you try to log-in to the new instance, are you specifying the new
port number to the client? If you don't give it the new port number,
then it will connect to the default port, which is presumably your
4.0.20 instance.
Mark-E wrote:
I have a Solaris box where MySQL 4.0.20 instanc
and mysql stops working.
Thanks
Ian
On Fri, Feb 29, 2008 at 5:46 PM, Vidal Garza <[EMAIL PROTECTED]> wrote:
> Ian escribió:
> > Hi,
> >
> > Okay, I have added that and will wait and see when it happens again if
> there
> > is anything in that log. Just
Hi,
I dont know about network, but I know using php we cant access anything in
MySQL once the file is gone. When it happens again, ill be sure to check
network.
Cheers
Ian
On Fri, Feb 29, 2008 at 12:54 PM, Sebastian Mendel <[EMAIL PROTECTED]>
wrote:
> Ian schrieb:
> > Hi,
&g
.
Cheers
Ian
On Fri, Feb 29, 2008 at 12:43 PM, Sebastian Mendel <[EMAIL PROTECTED]>
wrote:
> Ian schrieb:
> > Hi,
> >
> > I am running mysql 5.0.45 on freebsd 4.11 and for some strange reason
> > /tmp/mysql.sock keeps on disappearing and we are forced to kill -9 mysq
Hi,
Okay, I have added that and will wait and see when it happens again if there
is anything in that log. Just out of interest, does that log show anything
different to the /var/db/mysql/hostnameofunit.err file ?
Cheers
Ian
On Thu, Feb 28, 2008 at 8:44 PM, Vidal Garza <[EMAIL PROTECTED]>
Hi,
No, there is nothing in there cleaning /tmp. Mind you, further investigating
there are still some temp files in there from last year - so the directory
isnt getting wiped clean.
Thanks :)
On Fri, Feb 29, 2008 at 3:36 AM, Steve Bernacki <[EMAIL PROTECTED]>
wrote:
> Does the system in questio
basedir=/usr/local
--datadir=/var/db/mysql --user=mysql --pid-file=/var/db/mysql/hostname.pid
--port=3306 --socket=/tmp/mysql.sock --myisam-recover=BACKUP,FORCE
We could try that, but why would it behave differently to the current sh
script?
Thanks
Ian
On Thu, Feb 28, 2008 at 7:43 PM, Vidal Garza
ey_buffer = 20M
sort_buffer_size = 20M
read_buffer = 2M
write_buffer = 2M
[mysqlhotcopy]
interactive-timeout
The machine in question is a dual xeon with 4gig of ram.
Any ideas?
Thanks in advance,
Ian
One of the list readers (thanks Brent!) suggested using a full text
index on the category names field. Queries dropped from 10-49 seconds
down to 0.0085
Thanks for the emails folks!
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.my
sn't use it.
Essentially the query's asking to find category numbers for categories
that contain the name, use those numbers to find the poster id's that
match those category numbers and then return the poster info.
Thanks for any insight.
--
Ian Evans
--
MySQL
d?
Hi,
An easier method may be to install mod_log_mysql on each of the Apache servers
and
log directly to the central MySQL installation.
Regards
Ian
--
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
and that you
don't want
to give too much away.
I can say one thing though, in order for the data to be indexed by MySQL , it
has to be in
an unencrypted form somewhere in the database. There is no way I know to get
around
this, but I hope someone can correct me :)
Regards
Ian
--
--
I'm trying to wrap my head around dealing with people in a table that
have multiple names or akas.
I run an entertainment news site and have to deal with people like
Pamela Anderson (who was once Pamela Lee, Pamela Anderson Lee, Pamela
Denise Anderson), Eva Longoria (who's now Eva Longoria Par
Hi All,
How do I create a mysql data dump from a slave to seed another slave?
Using --master-data with mysqldump from my existing slave sets the
master to the slave I was dumping, not the real master.
Many Thanks,
Ian
--
MySQL General Mailing List
For list archives: http://lists.mysql.com
with --low_priority_updates?
I think it is but want confirmation.
Cheers,
Ian.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
th using a query cache when using so many HANDLER ..
NEXT calls.
Again if so, is it recommended to set a small "query_cache_limit".
--
Regards,
Ian Collins
Systems Manager
KIWIPLAN Group
Tel: +64 (0)9 2727622
Mob: +64 (0)21 761144
--
MySQL General Mailing List
For list archives: ht
instead of 'Long'.
If this is the case you may have to specifically CAST it into a number type in
your SQL
statement or use one of the VBScript functions CInt(), CLng(), CDbl(), CSng()
etc.
Hope this helps
Ian
--
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
when - back
to being in sync.
Why these defaults changed on a minor mysql release update is beyond me,
however I suspect this is gentoo's fault, not MySQLs.
--
Ian P. Christian ~ http://pookey.co.uk
signature.asc
Description: OpenPGP digital signature
Ian P. Christian wrote:
> I upgraded my slave server a few weeks ago, and the slave failed, with
> an error similar to the one shown below.
I have figured out what happened here now - and I'm part of the way
though fixing it.
It turned out the defaults had changed somewhere, and
deas/suggestions welcome, reseeding the slave will literally take days.
--
Ian P. Christian ~ http://pookey.co.uk
signature.asc
Description: OpenPGP digital signature
stem?
Yes - I've been doing this for some time, works fine.
--
Ian P. Christian ~ http://pookey.co.uk
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
ve). Then "INSERT INTO newtable SELECT * FROM
> oldtable WHERE primarykey in ( your 50,000 keys )", then "DELETE FROM
> oldtable WHERE primarykey in ( your 50,000 keys )", then COMMIT, which
> will cause your insertions and deletions to be truly atomic.
Ah of cours
hange because any
new records would get included in the LIMIT.
Will it not always use the natural order of the table in
selects/deletes, and therefore return results in the order in which they
were inserted?
--
Ian P. Christian ~ http://pookey.co.uk
--
MySQL General Mailing List
For list archives:
(if I don't limit to small numbers in the LIMIT, I/O gets too high, so
I'm moving data slowly in batches)
Thanks,
--
Ian P. Christian ~ http://pookey.co.uk
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
want to check if MySQLd is running, or if a database is still
accessible?
A monitoring system is called Nagios, its worth taking a look at it (it
can do both of the above described, but could be overkill if you only
want to check a single service)
http://nagios.org/
Bye, Ian
--
MySQL General
(of course, I may be wrong). Are there any
recommendations for HPUX kernel tuning with MySQL?
--
Regards,
Ian Collins
Systems Manager
KIWIPLAN Group
Tel: +64 (0)9 2727622
Mob: +64 (0)21 761144
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi!
I would start at:
http://dev.mysql.com/doc/refman/5.1/en/mysql-cluster-replication.html
Bye,
Ian
Ananda Kumar said the following, On 16-Mar-07 11:04:
> Hi All,
> We are planing to develop and high available mysql db.
> Can anybody please point me to any good documentation. Also h
a, and remember to never store the CVV number.
--
Ian P. Christian ~ http://pookey.co.uk
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
his:
http://forums.mysql.com/read.php?30,14020,14020
which honestly, I've not read - but you might want to :)
--
Ian P. Christian ~ http://pookey.co.uk
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Neil Tompkins wrote:
I'm looking to use MD5() to encrypt credit card numbers. How do I
unencrypt this when reading the value ?
you can't.
Google for MD5, or better still look at wikipedia, I'm sure they will
have something
--
Ian P. Christian ~ http://pookey.co.uk
-
Filip Krejci wrote:
> Hi,
>
> I suppose this is really I/O problem.
>
You're right, it looks like it was just an I/O problem - your suggestion
was spot on. I've now managed to dump my master data, and can get my
slave back online!
Thanks a lot for your suggestion,
--
I
eue
2 read views open inside InnoDB
Main thread process no. 23228, id 2367634320, state: sleeping
Number of rows inserted 356882, updated 1963990, deleted 293832, read
875872021
2.05 inserts/s, 10.32 updates/s, 0.21 deletes/s, 48500.03 reads/s
Thanks again,
--
Ian P. Christian ~ http://pookey.co.uk
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
ldump --host x.x.x.x --master-data
--single-transaction > dump.sql) which cause separating writes on
another box?
I did do this under the assumption it could simply be an I/O problem -
however the problem persists. It might be because the network
connection between the two hosts is pretty fast
Marcus Bointon wrote:
Hi Marcus :)
> On 7 Mar 2007, at 08:44, Ian P. Christian wrote:
>
> --single-transaction doesn't _do_ the dump as a transaction, it simply
> wraps the dump in begin/commit statements so it's atomic when restoring.
>
> If the dump is to preserve
site
remained live, and took the site down for 15 minutes whilst the dump
ran. As I'm sure you'll understand I'm not too keen on taking the
website down again.
Any suggestions as to why my database is stopping (could be I/O related
maybe? it's on a good RAID setup
e any way that I can get it working without truncating the
data?
Thanks alot
Ian
ause after deleting all those rows,
the space isnt freed up until we run the optimize. So my other question is
can we do an optimize a different way, or is there some way that we can
insert and delete rows that would require less optimization?
Thanks in advance,
Ian
sock
I consider the latter the best option as it wont break anything else that
depends on the
socket.
Regards
Ian
--
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
)
Any ideas?
(It may sound trivial but we have automated test suites that break
because of this).
Regards,
Ian Collins.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
it.
I've also tried the mysql -u root -p < file.sql as well with no difference.
I actually got the database in by doing a "split -b 1000 dumpfile"
as I can edit a 10Mb file, but not a 10Gb one - and then joining them
back together - bit of a hack but it worked.
Strange
e on!!)
What am I missing here? Has anyone else seen this?
Regards,
Ian Collins.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
in. Is there any way of achieving this via the sql
query because the above is a hugely tedious way of doing it. I know mysql
has an if() statement, but I have no idea how to implement it using what i
want to achieve above.
Thanks in advance.
Ian
then spam the list with an advert for McAfee!
Ian
--
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
to be in /tmp whilst others expect
it to be in
the mysql directory.
I find best solution to this problem is to start mysql, then create a symbolic
link in the
/tmp directory to the socket:
ln -s /var/lib/mysql/mysql.sock /tmp/mysql.sock
This works on my systems, you may have to adjust to you
within double
quotes: $query_Recordset1 = "SELECT .. .FROM Results";
You need to escape the quotes in your statement.
Regards
Ian
--
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi,
No unfortunately not...
Cheers
Ian
> -Original Message-
> From: John Meyer [mailto:[EMAIL PROTECTED]
> Sent: 25 June 2006 05:41 PM
> To: mysql@lists.mysql.com
> Subject: Re: Re-importing a mysqldump file
>
> Ian Barnes wrote:
> > Is this possible? Or woul
, I need id to auto-increment and serverid to be set by something
that I specify depending on what file im importing.
Is this possible? Or would the best way be to import the dumped file into a
temp table and then select out of the temp table into my correct table ?
Thanks for any help!
Ian
1 - 100 of 387 matches
Mail list logo
