Heh. The parser is pointing out a simple syntax oversight, yes. The correct
syntax for that is select ... from (subselect) aliasname;
- Original Message -
> From: "Mimi Cafe"
> To: "Johan De Meersman" , "Guido Schlenke"
>
> Cc: mysql@lists.my
Hmm. Simply replacing the field list with count(*) should work, too. If you
only need the count after having executed the select, I'm pretty sure there's
something in the API that gives you that without a second query, although I'll
be buggered if I can remember right now.
- Original Messag
- Original Message -
> From: "Reindl Harald"
>
> so put the wgole mysqld and its data on a server in the network
> for this mysql was built and not for borking the dadadir somewhere
> else
Hmm. The way I interpret what he's saying, is that he wants multiple instances
accessing the same
- Original Message -
> From: "Reindl Harald"
>
> first: please post log-outputs instead of "don't work"
>
> i guess: you changed only the path in my.cnf
> have you oved th existing datadir to the new location?
> if not the server will not start because it is missing
> the database "mys
- Original Message -
> From: "Dan Nelson"
>
> I doubt that mysql calls anything other than gethostbyname() or
> getaddrinfo(), so your behaviour is probably dependant on whatever OS
> you are running and how often its local resolver re-checks resolv.conf.
> Usually that's only once when a
- Original Message -
> From: "Claudio Nanni"
> Consider also the DNS TTL.
That should be irrelevant when changing DNS servers :-)
> If you flush hosts in MySQL it'll ask again the OS to resolve a name
> , but if that is still in the DNS cache it could return that 'old'
> value instead
- Original Message -
> From: "Suresh Kuna"
>
> Try to take a tab separated dump, so you can restore what ever you
> want in terms of tables or databases.
Uhh. I'm a bit fuzzy today, but I really don't see how a tab-separated dump
will help split off tables or databases :-)
To answer t
Just encountered an interesting issue.
I use DNS names instead of IPs in mysql grants. Yes, I'm aware of the
performance impact, that's not an issue.
I just found out through failing logins that a server was still connecting to
an old DNS server, and properly updated the resolv.conf. Commandl
If you're asking what I think you're asking, then yes, both NULL and 0 will
trigger an autoincrement field to put in the next value.
- Original Message -
> From: "Grega Leskovšek"
> To: mysql@lists.mysql.com
> Sent: Monday, 16 May, 2011 4:49:43 PM
> Subject: [setting value when INSERT fo
- Original Message -
> From: "Gavin Towey"
>
> The server will disconnect idle connections after a while. The
> wait_timeout variable controls how many seconds it will wait. You
> can set it for your connection when you connect by issuing a query
> like:
>
> SET SESSION wait_timeout=NN
Zmanda ZRM backup, although the fancy webinterface is only available in the
commercial version. Backups are stored on the host that runs the server, and of
course it serves multiple MySQL machines.
Webinterface is annoyingly slow, though :-)
- Original Message -
> From: "Michael Heaney
- Original Message -
> From: "Jerry Schwartz"
>
> I'm not sure that I could easily build a dictionary of non-junk
> words, since
The traditional way is to build a database of junk words. The list tends to be
shorter :-)
Think and/or/it/the/with/like/...
Percentages of mutual and non-
rom: "Jerry Schwartz"
> To: "Johan De Meersman"
> Cc: "Jim McNeely" , "mysql mailing list"
>
> Sent: Monday, 2 May, 2011 4:09:36 PM
> Subject: RE: Join based upon LIKE
>
> [JS] I've thought about using soundex(), but I'm not q
- Original Message -
> From: "Jerry Schwartz"
>
> I shove those modified titles into a table and do a JOIN ON
> `prod_title` LIKE
> `wild_title`.
Roughly what I meant with the shadow fields, yes - keep your own set of data
around :-)
I have little more to offer, then, I'm afraid. The
- Original Message -
> From: "Jerry Schwartz"
>
> [JS] This isn't the only place I have to deal with fuzzy data. :-(
> Discretion prohibits further comment.
Heh. What you *really* need, is a LART. Preferably one of the spiked variety.
> A full-text index would work if I were only looki
- Original Message -
> From: "Jerry Schwartz"
>
> No takers?
Not willingly, no :-p
This is a pretty complex problem, as SQL itself isn't particularly
well-equipped to deal with fuzzy data. One approach that might work is using a
fulltext indexing engine (MySQL's built-in ft indices,
Hey there,
- Original Message -
> From: "Rocio Gomez Escribano"
> Hi!! Is it possible to create a left join consult with 2 tables??
> I mean:
> SELECT * FROM table1 LEFT JOIN (table2, table3) on table1.ID =
> table2.subID and table1.ID= table3.subID
Pretty close already. Might I sugg
At which point I used google translate to ask the switch to english :-p
- Original Message -
> From: "Andre Polykanine"
> To: "Johan De Meersman"
> Cc: "Виктор Ефимович" , mysql@lists.mysql.com
> Sent: Thursday, 28 April, 2011 12:58:1
Я предлагаю более отчетливо английски применения :-p
- Original Message -
> From: "Andre Polykanine"
> To: "Виктор Ефимович"
> Cc: mysql@lists.mysql.com
> Sent: Thursday, 28 April, 2011 12:04:01 PM
> Subject: Re: Запрос
>
> Hello Виктор,
>
> Из какого приложения?)
>
--
Bier met gren
- Original Message -
> From: "walter harms"
>
> maybe but what is mysql 11.4 ?
A parsing error :-)
> the release of (PHP Generator for MySQL) 11.4
That should make more sense, I think.
--
Bier met grenadyn
Is als mosterd by den wyn
Sy die't drinkt, is eene kwezel
Hy die't drinkt, i
300 is pretty low - MySQL counts every instance of a table in any query as an
"open file". A query that uses the same table twice (with an alias, for
example) thus counts for two open files.
This may also be outside of MySQL, the ulimit for the user running the daemon
may have open files restr
- Original Message -
> From: "Steve Staples"
>
> Doesn't the '?-1-1' mean that it's a joined key? so the 3
That's what I tought, but I *can* see the characters he's typed, and the last
of what you see as ? is definitely different.
--
Bier met grenadyn
Is als mosterd by den wyn
- Original Message -
> From: "赵琦"
>
> it is strange, the primary key field is not the same, but i get this
> error.
I'm entirely unsure how MySQL handles non-roman, so I'll start off with a
stupid question: are you sure there was no previous entry in the table with
that value for a ?
The smoothest way to avoid deadlocks, is to ensure that all your sessions lock
their tables in exactly the same order. From your explanation, that might not
be as easy as one would expect, though.
If you can't create triggers, is it acceptable to have delayed updates on the
totals? Your idea wa
- Original Message -
> From: "Gary"
>
> I'm not sure I undertand this, could you explain a little further for
> me.
This is what they're talking about:
http://dev.mysql.com/doc/refman/5.0/en/information-functions.html#function_last-insert-id
--
Bier met grenadyn
Is als mosterd by den
- Original Message -
> From: "Reindl Harald"
>
> even if you have enough memory why will you throw it away for a
> unusual connection count instead use the RAm for innodb-buffer-pool,
> query-cache, key-buffers?
Maybe the application doesn't have support for connection pooling and can't
- Original Message -
> From: "Daevid Vincent"
>
> It only seems to do the lines for InnoDB tables, not MyISAM... I
> mean, it not only won't auto-connect them, it won't even allow ME to connect
> them. :(
Probably because it wants to adhere to the engine capabilities, and MyISAM
doesn't
- Original Message -
> From: "mos"
>
> The IN() clause is very inefficient because MySQL will NOT use the
> index.
> It will have to traverse the entire table looking for these values.
Has that still not been remedied ?
> It will get the information from the index and not have to acce
- Original Message -
> From: "Gregory Magarshak"
> I am guessing that the MySQL indexes map indexed fields (fb_uid) to the
> primary key (id) so I wouldn't have to touch the disk. Am I right
> about that?
Correct for InnoDB, but MyISAM maps every index straight onto records. That's
why
Might it not be easier to use something like "show create procedure" instead?
Given that the purpose is debugging, I would assume you want the exact text
used to create the procedure, not the one with version-specifics removed.
You can still pump that into a file by using "mysql -e 'show create
You are assuming that the database is one table of 5.000 gigabyte, and not
5.000 tables of one gigabyte; and that the backup needs to be consistent :-p
- Original Message -
> From: "Reindl Harald"
> To: mysql@lists.mysql.com
> Sent: Monday, 21 March, 2011 12:44:08 PM
> Subject: Re: Que
- Original Message -
> From: "Chao Zhu"
>
>One Q: Can mysql binlog use raw device on Linux?
Mmm, good question. Don't really know; but I'm not convinced you'll get huge
benefits from it, either. Modern filesystems tend to perform pretty close to
raw throughput.
>From a just-thinki
- Original Message -
> From: "Adarsh Sharma"
> Johan De Meersman wrote:
> A Heartiest Thanks from my heart for explaining all these things in a
> fantastic manner. I agreed with your suggestions but one thing which
> isn't explained from your side , as you
- Original Message -
> From: "Brent Clark"
>
> 'Statement may not be safe to log'
Heh. Some of those statements weren't particularly safe in previous versions,
either, but they didn't whine :-p
Roughly, what it comes down to is that statements that contain things that may
be differe
> From: "Adarsh Sharma"
>
> Johan De Meersman wrote:
> > Interesting, but why like this instead of simply larger disks or raidsets ?
>
> It's the IT-Admin Issue , I can't question that and we have only disks of
> 300GB ( SAS ).
Your admin is s
- Original Message -
> From: "Adarsh Sharma"
>
> Dear all,
>
> I have doubt regarding the storage structure for Innodb files :
>
> Our database server has the following paths :
>
> /dev/sda5 69G 35G 32G52% /hdd1-1
> /dev/sdb1 274G 225G 36G 87% /hdd2
- Original Message -
> From: "Sándor Halász"
>
> Yes, but Access s "IIF", of the same use, evaluates all three, and
> the documentation explicitly says so. MySQL s, that I have seen,
> says neither. Assuming the worst is safer, and then one uses CASE
> ..., but if not,
Well, they n
- Original Message -
> From: "Krishna Chandra Prajapati"
>
> incremental backup using zamanda.
I'm running Zmanda on about two dozen hosts, and it comes well-recommended. It
doesn't do anything that you can't do yourself, but it's easy to set up,
reports well and backs up in what are b
- Original Message -
> From: "Adarsh Sharma"
>
> Please check the attachment for the script & output.
Thanks for your password :-)
> Now I just want to mail the output of my script to some persons
> e-mail-ID
Assuming you run this from crontab, just set MAILTO=per...@domain.ext right
- Original Message -
> From: "Adarsh Sharma"
> I am able to fetch the output individually, but I try that I access
> all information through one command :
> mysql> SELECT table_schema 'database',table_name 'Table', concat(
> round( sum( data_length + index_length ) / ( 1024*1024*1024) ,
Probably not the cause, but you should know that and binds more tightly than
or, so what you've written is actually
WHERE (table_name = 'hc_categories')
OR (table_name = 'hc_master')
OR (table_name = 'hc_web' AND table_schema = 'pdc_crawler')
What you probably mean is
WHERE (table_name = 'h
- Original Message -
> From: "Sándor Halász"
>
> Does the _function_ 'IF' always evaluate its arguments? or only the
> two that it is needful to evaluate?
I'm afraid I'm not authoritative on this, but it seems to me that it would be
very very bad if the third, unused expression were to
> From: "Vikram A"
> Thank you for info. Now we enabled the logs. The DB administrator
> itself made a mistake that he restored the back up
This may be obvious, but keep your logs on separate disks if you can - full
query logs take quite a bit of I/O away, so if you have them on the same disks
- Original Message -
> From: "Vikram A"
>
> say that it is done intentionally but could not point anyone because
> we did not enable the logging feature in MySQL.
You already said it yourself: you don't have logging enabled, so that data is
not available.
If you have binary logs, you
Just like that, not advisable. There's upgrade scripts in the packages that
should handle 5.0 to 5.1; but your safest bet is still going to be a clean
mysqldump and import.
- Original Message -
> From: "Brent Clark"
> To: mysql@lists.mysql.com
> Sent: Thursday, 10 March, 2011 2:07:11 PM
Umm... I'm no crypto guru, but I've never heard of MD5 having variants, let
alone a salt. MD5 is MD5 is MD5. APR, incidentally, is the Apache Runtime,
afaik - part of the build kit for apache modules.
I strongly suspect your problem is on another level.
- Original Message -
> From: "Ed
Other people have answered with pros and cons of virtualisation, but I would
rather ask another question: why do you feel it necessary to split up the
database?
If it's only used for QC, it's probably not in intensive use. Why would you go
through the bother of splitting it up? You're staying
Is it possible that someone did an alter table disable keys at some point,
maybe for a bulk load, and forgot to re-enable them ?
- Original Message -
> From: "Rodrigo Ferreira"
> To: mysql@lists.mysql.com
> Sent: Wednesday, 2 March, 2011 3:04:31 PM
> Subject: Two Identical Values on Pr
- Original Message -
> From: "Hervey Liu"
>
> CREATE TABLE logins (
>success
> enum('Y','N[banned]','N[password]','N[panic]','N[activation]','N[authorization]')
> DEFAULT 'Y' NOT NULL,
>when datetime DEFAULT '-00-00 00:00:00' NOT NULL,
This is going to be an issu
On Thu, Feb 24, 2011 at 12:06 PM, Dave M G wrote:
> Should I never use the word "group" for column names? Seems a little
> silly. Is there a way to protect column names to that there is no
> confusion?
>
As several people already pointed out, simply use backticks. Simple quotes
have started to w
On Wed, Feb 23, 2011 at 7:53 AM, Machiel Richards wrote:
>I tried to find info on the net and on the mysql website, but thus
> far I haven't been able to find proper documentation on how to set
> everything up.
>
Uhh... the documentation on the mysql site is very complete, afaik.
>If s
On Wed, Feb 16, 2011 at 12:23 PM, Carl wrote:
> 110216 5:15:20 [ERROR] Error reading packet from server: log event entry
> exceeded max_allowed_packet; Increase
> max_allowed_packet on master ( server_errno=1236)
>
This seems to be the major player, here. I would make sure to increase the
setti
On Wed, Feb 16, 2011 at 10:23 AM, Machiel Richards wrote:
> Due to differences within the 2 versions, we had to exclude the
> mysql database from the backup and restore.
>
Yep :-)
>When setting up the replication, should we still
> exclude the mysql database from the
Mostly correct - save for pointer sizes and such, but it's pretty hard to
reach those.
SQL vs NoSQL is not a matter of data size - plenty of fud is being spread
about NoSQL, for some reason - but a matter of access patterns.
Without knowing what you need and how you design, that question can't be
What particular overhead is growing ? :-)
On Tue, Feb 15, 2011 at 10:11 AM, Geoff Galitz wrote:
>
> Hello.
>
> We have a table using the memory engine and we notice in PMA that the
> overhead continues grow over time. Normally we'd optimize with such an
> issue but that is not applicable to mem
I can't speak for the MySQL people, but in my view your "workaround" is the
correct way of implementing this. It is not the database's job to keep track
of which user wants to keep what session open, and HTTP is stateless by
design. Keeping transactions open for relatively long periods of time woul
How about the square root of the number of jobs, or some other root if you
want another coefficient? That doesn't have the limiting behaviour a
logarithmic function offers, though.
On Fri, Feb 11, 2011 at 2:08 PM, Richard Reina wrote:
> Hi Travis,
>
> This is very helpful thank you. Howev
On Thu, Feb 10, 2011 at 2:15 PM, Santiago Soares
wrote:
> With a show global status I see a strange behavior:
> | Open_files| 286 |
> | Opened_files | 1050743 |
>
> At this time the database has just started (about 10 minutes).
>
That's quite a
Hmm, I haven't seen the mail from Singer, yet.
On Thu, Feb 10, 2011 at 9:33 AM, Ananda Kumar wrote:
> On Thu, Feb 10, 2011 at 1:58 PM, Singer X.J. Wang wrote:
>
>> mysqldump -u[user] -p[pass] --where="db=`whatyouwant` and
>> name=`whatyouwant`" mysql proc
>>
>
Yes, I thought of that, too; but th
On Thu, Feb 10, 2011 at 7:43 AM, Adarsh Sharma wrote:
> I am researching all the ways to backup in mysql and donot able to find a
> command that take individual backup of only one procedure in mysql.
>
Have a look at the SHOW CREATE PROCEDURE syntax. It's not mysqldump, but it
will yield a statem
I can't help but wonder, if you send a string, does that mean you're putting
text in a blob ? Blobs are binary, and thus don't get encoded in the sense
of UTF8 vs Unicode. For a string, you may want a TEXT type column.
On the other hand, if you're indeed trying to insert binary data, it is not
the
On Wed, Feb 9, 2011 at 7:42 PM, Jerry Schwartz wrote:
> *[JS] I don’t have any data at the moment. I know that I tried outsmarting
> Access with pass-through queries, with little luck.*
>
Hmm. I seem to remember those working, but that was in access itself, I
think. It's been many years since I
On Wed, Feb 9, 2011 at 7:02 PM, Jerry Schwartz wrote:
> [JS] Actually, I've done a lot of tracing recently (to solve my own
> performance problems), and Access 2007 is very clever at pulling parts of a
> dataset and a number of other things. For example, when you are browsing a
> dataset Access w
On Wed, Feb 9, 2011 at 7:55 AM, David Brian Chait wrote:
> To borrow your line of reasoning, translators can be rather slow and
> unreliable. Adding the extra overhead and complexity is certainly not worth
> the potential gains.
>
I daresay that's up to the user to decide, no? OP never specified
On Wed, Feb 9, 2011 at 7:18 AM, Reindl Harald wrote:
> Am 09.02.2011 06:36, schrieb Y z:
> >
> > I have a windows app that wants to talk to either a) an access database,
> b) a MS
> > Sql Express database, or c) a MS Sql 2008 database.
> >
> > Can anyone please point me in the direction of configu
No way to do that directly; however, using the MySQL ODBC connector you can
get at least a) and c) to play passthrough. Performance will likely suffer,
though; especially Access' Jet Engine has a tendency to pull in full remote
datasets instead of passing through the query.
On Wed, Feb 9, 2011 at
Do you delete data from the table ?
MyISAM will only grant a write lock when there are no locks on the table -
including implicit read locks. That may be your problem.
There is a single situation when concurrent reads and writes are possible on
MyISAM, however: when your table has no holes in the
InnoDB definitely has some parameters you can play with, but I've never
actually done so myself.
On Fri, Feb 4, 2011 at 8:09 PM, Vinubalaji Gopal wrote:
> Hi all,
> I wanted to know if Mysql allows me to configure it such that the
> writes to disk happen at a configurable time or after the buff
On Fri, Feb 4, 2011 at 8:03 AM, Angela liu wrote:
> Is MySQL Administrator still available for MySQL 5.1 and 5.5?
>
I believe that line of applications has been superceded by the MySQL
Workbench.
If you must use MySQL administrator for some reason, they will undoubtedly
connect to 5.1 and 5.5,
2011/2/4 Yannis Haralambous
> SELECT * FROM wasfoundin WHERE yakoright LIKE '%geography%'
>
That won't use a regular index. Have a look at fulltext indexing.
For the phpmyadmin, I personally feel it's an abomination, not to mention a
disaster waiting to happen; but if you really want to keep us
On Wed, Feb 2, 2011 at 11:30 AM, viraj wrote:
> dear list,
> where can i find a list of map polygons for united states cities? any
> open database? or tool to obtain correct coordinates?
>
A bit offtopic here, but I suspect that most such databases will be
proprietary and thus payable through th
On Thu, Jan 27, 2011 at 10:40 AM, Nagaraj S wrote:
> **On Slave Server I replicate database *A alone* and my replication not
> working due to data fetching happen on B database.
>
Well, yes. Statement-based replication does what it says on the box: it
executes the exact same statement on the sla
On Wed, Jan 26, 2011 at 6:58 AM, Robinson, Eric wrote:
> > > You need to quiesce the InnoDb background threads. One technique is
> > > mentioned here:
> > > http://dev.mysql.com/doc/refman/5.5/en/innodb-multiple-tablesp
> > aces.html
> > >
> > > Look for the section talking about "clean" backups.
> jesus christ nobody cares if they are binary replica as long
> as the data is consistent and ident
>
Actually, I can see this being an issue if you're using LVM snapshot backups
or another similar technique - if the datafiles aren't all identical you
won't be able to restore to any machine from
On Tue, Jan 25, 2011 at 3:00 PM, Robinson, Eric wrote:
> > your whole solution is crippled because why in the world are
> > you killing your salves and reinit them without any reason daily?
>
> There is a very good reason: it is the phenomenon of row drift. The
>
Interesting. I never heard of tha
I suspect the same trick might work with InnoDB (with pretty much the same
caveats), but you'd be best off setting innodb-file-per-table - I'm sure
you've already seen that the large datafiles are a hindrance to smooth
rsyncing :-)
Make sure to test extensively, though.
On Tue, Jan 25, 2011 at 5
If the bracketed stuff really can be anything, you're better off doing it
externally, I guess. If you can be reasonably sure that there'll not be any
square brackets in there, you can fluff about with instr() and substr().
On Sat, Jan 22, 2011 at 6:18 PM, Eric Bergen wrote:
> There isn't a buil
I have to say, something similar was my first thought, too - you never
mention uuid in your original post. As already stated, uuid() should be a
Universal Unique IDentifier. It's afaik a random 128-bit number; given the
space to choose from it should be rather unique. I have to admit that I'm
not e
On Tue, Jan 18, 2011 at 6:24 AM, sushant chawla wrote:
> Make sure the following things:
>
>
> - /tmp folder is having 1777 permissions
> - mysql folder is having the ownership from which it is running. Refer
> /etc/my.cnf
> - Make sure you have space on your MySQL partition
>
Also, make
On Sat, Jan 15, 2011 at 8:07 AM, Jørn Dahl-Stamnes
wrote:
> On Saturday 15 January 2011 00:28, Johnny Withers wrote:
> > The result of your query without the join
> > probably exceeded your tmp_table_size variable. When this
> > occurs, MySQL quit writing the temp table to disk thus producing an
>
Check your free diskspace on your temp location.
On Fri, Jan 14, 2011 at 1:31 PM, Jørn Dahl-Stamnes
wrote:
> Hello,
>
> While doing a select query I got the following error in the error-log
> file:
>
>Incorrect key feil for table '/tmp/#sql_5f8_0.MYI'; try to repair it
>
> It seem rather mea
The problem is that you're using a function on your indexed field, which
prevents the index from being used (I'm assuming you have an index on
stamp).
Store stamp directly as unixtime (use a time field) or if that's not an
option, add a column that does - if you want you can autofill it with a
tri
On Fri, Dec 24, 2010 at 6:37 AM, Adarsh Sharma wrote:
> Or I am going to install through rpm which is the easiest way. But which is
> best for our Production Servers.
>
Unless you have very specific needs, it's always best to use official
packages for production. That also makes it easier to get
Probably one for the guys with the compilers, but have you tried running it
with dtrace and seeing where it explodes ?
On Thu, Dec 23, 2010 at 1:38 PM, Adarsh Sharma wrote:
> Dear all,
>
> I am able o successfully build Mysql 5.5.8 from its source code on CentOS
> but when I issued the following
Glad to hear I'm not the only one annoyed :-) I've plonked him in the
meantime.
2010/12/23 Jorg W Young
>
> This guy has been saying nothing meaningful on this list, but
> advertise his blog everywhere.
> Just be shame. He should be kicked out from the list.
>
> Jorg.
>
> 2010/12/23 杨涛涛 :
> > Th
On Sun, Dec 19, 2010 at 3:19 AM, Feris Thia <
milis.datab...@phi-integration.com> wrote:
> Hi Everyone,
>
> Is there a way to query values stored in our index instead of using "group
> by" selection which will produce same results ?
>
You can't query the index directly, but if you select only fie
Change password statements should show up in the binary logs, too, in some
form or other.
On Thu, Dec 16, 2010 at 9:58 PM, Alejandro Bednarik wrote:
> SQL injection? Check Apache or whatever log files.
>
> On Thu, Dec 16, 2010 at 4:17 PM, Gary wrote:
>
> > I recieved a call from a client saying
Hmm, interesting. What does this do, exactly ? Can something similar be
applied to non-jdbc connections, too ?
On Thu, Dec 16, 2010 at 8:34 AM, Feris Thia <
milis.datab...@phi-integration.com> wrote:
> Hi Mark,
>
> On Thu, Dec 16, 2010 at 4:50 AM, Mark Matthews
> wrote:
>
> > Feris,
> >
> > I d
On Wed, Dec 15, 2010 at 10:08 AM, Per Jessen wrote:
> Per Jessen wrote:
>
> > Is there a way of limiting that? Alternatively, is there a way of
> > doing "replication-on-demand", perhaps triggered by cron?
>
> Ignore this, problem solved. I'll let the slaves query the master
> regularly and jus
On Thu, Dec 9, 2010 at 3:33 PM, gvim wrote:
> I have a typical contact database which caters for multiple email addresses
> with a distinct Email table keyed to a foreign key inside the Contact table,
> ie. a 1-to-many relationship. However, I want to prioritise these Email
> entries for a given
On Thu, Dec 9, 2010 at 1:46 PM, Machiel Richards wrote:
>Does anybody know if there is a mysql mailing list where we can
> post for a position we have open in terms of MySQL dba.
>
Here might work, I'm not aware of a specific list for MySQL jobs.
--
Bier met grenadyn
Is als mosterd by
On Wed, Dec 8, 2010 at 11:05 AM, Machiel Richards wrote:
> Hi Johan
>
> Would the server require a restart after this or not?
>
You can restart to check that the credentials in file and database match, to
avoid surprises later, but the server operation itself is not impacted by
this.
That u
That's a very Debian-specific issue. The credentials for the
debian-sys-maint user are randomly generated at install, and stored in
/etc/mysql/debian.cnf. Either copy the file from the old to the new machine,
or update the user's password on the new machine to the one in the file.
On Wed, Dec 8,
Are you saying that mass inserts go much slower now that you've set up
replication? In that case, I suspect you have your binlogs on the same disk
as your data.
Put the binary logs on separate disks, and you'll notice a dramatic increase
in performance.
On Mon, Dec 6, 2010 at 7:17 AM, Sairam Kri
On Thu, Dec 2, 2010 at 4:05 PM, bars0 bars0 wrote:
> Yes, something is certailny wrong, because even when I added in MySQL user
> 'krzysztof', wchich is similar to regular user of my linux machine, I can't
>
MySQL users have nothing to see with OS users. As root, do "su -c /bin/bash
- mysql" and
On Thu, Dec 2, 2010 at 10:06 AM, bars0 bars0 wrote:
> I try o send an output of a query in debian lenny, using: SELECTINTO
> OUTFILE '/my_path/my_file' FROM...but I get an error: ERROR 1 (HY000):
> Can't
> create/write to file... (Errcode 13).
> What's the problem?
>
The file is not written a
enchmark to know the performance relation of a INSERT and compress data
>> into Archive Storage Engine or the insertion data into a partitioned table.
>>
>> Best regards.
>> --
>> WB
>>
>>
>> 2010/11/30 Johan De Meersman
>>
>> I would assum
I suspect you need to have the new version running instead of the old one,
for the mysql_upgrade script to work.
On Tue, Nov 30, 2010 at 11:23 AM, Machiel Richards wrote:
> HI Guys
>
> I found some info regarding a method to upgrade mysql databases.
>
>Currently the version is at mys
that INSERT DELAYED is slower than a normal INSERT if the table is
> not
> otherwise in use." What's the definition of "in use"? Does a logging
> table
> do that given that it's pretty much append-only/write-only?
>
> Waynn
>
> On Mon, Nov 29, 20
On Tue, Nov 30, 2010 at 7:26 AM, Jorg W Young
> wrote:
> 2010/11/30 Johan De Meersman :
> > Yep, it's definitely an apparmor issue. Are you using your distribution's
> > packages ? I would say this is more a thing for their support - I for one
> > keep
401 - 500 of 809 matches
Mail list logo