- Original Message -
From: Reindl Harald h.rei...@thelounge.net
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
- Original Message -
From: Reindl Harald h.rei...@thelounge.net
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
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
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 mimic...@googlemail.com
To: Johan De Meersman vegiv...@tuxera.be, Guido Schlenke
galer...@gmx.de
Cc: mysql
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.
- Original Message -
From: Suresh Kuna sureshkumar...@gmail.com
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
- Original Message -
From: Claudio Nanni claudio.na...@gmail.com
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
- Original Message -
From: Dan Nelson dnel...@allantgroup.com
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
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 legr...@gmail.com
To: mysql@lists.mysql.com
Sent: Monday, 16 May, 2011 4:49:43 PM
Subject: [setting value
- Original Message -
From: Gavin Towey gto...@ffn.com
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
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
...@gii.co.jp
To: Johan De Meersman vegiv...@tuxera.be
Cc: Jim McNeely j...@newcenturydata.com, mysql mailing list
mysql@lists.mysql.com
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 quite sure how.
I didn't pursue it much
- Original Message -
From: Jerry Schwartz je...@gii.co.jp
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
- Original Message -
From: Jerry Schwartz je...@gii.co.jp
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
- Original Message -
From: Jerry Schwartz je...@gii.co.jp
[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
Я предлагаю более отчетливо английски применения :-p
- Original Message -
From: Andre Polykanine an...@oire.org
To: Виктор Ефимович mr.victor-tutun...@yandex.ru
Cc: mysql@lists.mysql.com
Sent: Thursday, 28 April, 2011 12:04:01 PM
Subject: Re: Запрос
Hello Виктор,
Из какого
At which point I used google translate to ask the switch to english :-p
- Original Message -
From: Andre Polykanine an...@oire.org
To: Johan De Meersman vegiv...@tuxera.be
Cc: Виктор Ефимович mr.victor-tutun...@yandex.ru, mysql@lists.mysql.com
Sent: Thursday, 28 April, 2011 12:58:18
Hey there,
- Original Message -
From: Rocio Gomez Escribano r.go...@ingenia-soluciones.com
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
- Original Message -
From: Jerry Schwartz je...@gii.co.jp
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
- Original Message -
From: walter harms wha...@bfs.de
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
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
- Original Message -
From: 赵琦 tyzha...@gmail.com
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
- Original Message -
From: Steve Staples sstap...@mnsi.net
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
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
- Original Message -
From: Gary gp...@paulgdesigns.com
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
- Original Message -
From: Reindl Harald h.rei...@thelounge.net
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
- Original Message -
From: Daevid Vincent dae...@daevid.com
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
- Original Message -
From: Gregory Magarshak g...@qbix.com
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.
- Original Message -
From: mos mo...@fastmail.fm
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
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 h.rei...@thelounge.net
To: mysql@lists.mysql.com
Sent: Monday, 21 March, 2011 12:44:08 PM
- Original Message -
From: Chao Zhu zhuc...@gmail.com
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
- Original Message -
From: Adarsh Sharma adarsh.sha...@orkash.com
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
From: Adarsh Sharma adarsh.sha...@orkash.com
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 supposed to provide services
- Original Message -
From: Brent Clark brentgclarkl...@gmail.com
'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
- Original Message -
From: Adarsh Sharma adarsh.sha...@orkash.com
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 go deeper
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 =
- Original Message -
From: Adarsh Sharma adarsh.sha...@orkash.com
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 ) / (
- Original Message -
From: Adarsh Sharma adarsh.sha...@orkash.com
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
- Original Message -
From: Krishna Chandra Prajapati prajapat...@gmail.com
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
- Original Message -
From: Sándor Halász h...@tbbs.net
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
- Original Message -
From: Sándor Halász h...@tbbs.net
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
From: Vikram A vikkiatb...@yahoo.in
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
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 brentgclarkl...@gmail.com
To: mysql@lists.mysql.com
Sent: Thursday, 10
- Original Message -
From: Vikram A vikkiatb...@yahoo.in
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
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:
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 rodrigof_si...@yahoo.com
To: mysql@lists.mysql.com
Sent: Wednesday, 2 March, 2011 3:04:31 PM
Subject: Two
- Original Message -
From: Hervey Liu herve...@buffalo.edu
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
On Thu, Feb 24, 2011 at 12:06 PM, Dave M G d...@articlass.org 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
On Wed, Feb 23, 2011 at 7:53 AM, Machiel Richards machi...@rdc.co.zawrote:
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,
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
On Wed, Feb 16, 2011 at 10:23 AM, Machiel Richards machi...@rdc.co.zawrote:
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
On Wed, Feb 16, 2011 at 12:23 PM, Carl c...@etrak-plus.com 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
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 would
What particular overhead is growing ? :-)
On Tue, Feb 15, 2011 at 10:11 AM, Geoff Galitz ge...@galitz.org 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
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 gatorre...@gmail.com wrote:
Hi Travis,
This is very helpful
Hmm, I haven't seen the mail from Singer, yet.
On Thu, Feb 10, 2011 at 9:33 AM, Ananda Kumar anan...@gmail.com wrote:
On Thu, Feb 10, 2011 at 1:58 PM, Singer X.J. Wang w...@singerwang.comwrote:
mysqldump -u[user] -p[pass] --where=db=`whatyouwant` and
name=`whatyouwant` mysql proc
Yes, I
On Thu, Feb 10, 2011 at 2:15 PM, Santiago Soares
santiagosoa...@gmail.comwrote:
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
On Wed, Feb 9, 2011 at 7:02 PM, Jerry Schwartz je...@gii.co.jp 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
On Wed, Feb 9, 2011 at 7:42 PM, Jerry Schwartz je...@gii.co.jp 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
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
On Thu, Feb 10, 2011 at 7:43 AM, Adarsh Sharma adarsh.sha...@orkash.comwrote:
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
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
On Wed, Feb 9, 2011 at 7:18 AM, Reindl Harald h.rei...@thelounge.netwrote:
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
On Wed, Feb 9, 2011 at 7:55 AM, David Brian Chait dch...@invenda.comwrote:
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
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 vinubal...@gmail.comwrote:
Hi all,
I wanted to know if Mysql allows me to configure it such that the
writes to disk happen at a configurable time
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
2011/2/4 Yannis Haralambous yannis.haralamb...@telecom-bretagne.eu
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
On Fri, Feb 4, 2011 at 8:03 AM, Angela liu yyll2...@yahoo.com 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
On Wed, Feb 2, 2011 at 11:30 AM, viraj kali...@gmail.com 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
On Thu, Jan 27, 2011 at 10:40 AM, Nagaraj S nagaraj@gmail.com 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
On Wed, Jan 26, 2011 at 6:58 AM, Robinson, Eric eric.robin...@psmnv.comwrote:
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
On Tue, Jan 25, 2011 at 3:00 PM, Robinson, Eric eric.robin...@psmnv.comwrote:
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
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 a
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 eric.ber...@gmail.com wrote:
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
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
On Tue, Jan 18, 2011 at 6:24 AM, sushant chawla sushantchawla2...@gmail.com
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
On Sat, Jan 15, 2011 at 8:07 AM, Jørn Dahl-Stamnes
sq...@dahl-stamnes.netwrote:
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
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
Check your free diskspace on your temp location.
On Fri, Jan 14, 2011 at 1:31 PM, Jørn Dahl-Stamnes
sq...@dahl-stamnes.netwrote:
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
On Fri, Dec 24, 2010 at 6:37 AM, Adarsh Sharma adarsh.sha...@orkash.comwrote:
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
Glad to hear I'm not the only one annoyed :-) I've plonked him in the
meantime.
2010/12/23 Jorg W Young jorgwyoung...@gmail.com jorgwyoung%2...@gmail.com
This guy has been saying nothing meaningful on this list, but
advertise his blog everywhere.
Just be shame. He should be kicked out from
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 adarsh.sha...@orkash.comwrote:
Dear all,
I am able o successfully build Mysql 5.5.8 from its source code on CentOS
but when I
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 fields that
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 alejand...@olx.comwrote:
SQL injection? Check Apache or whatever log files.
On Thu, Dec 16, 2010 at 4:17 PM, Gary gp...@paulgdesigns.com wrote:
I
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 mark.matth...@oracle.com
wrote:
On Wed, Dec 15, 2010 at 10:08 AM, Per Jessen p...@computer.org 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
On Thu, Dec 9, 2010 at 1:46 PM, Machiel Richards machi...@rdc.co.za 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
On Thu, Dec 9, 2010 at 3:33 PM, gvim gvi...@gmail.com 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
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
On Wed, Dec 8, 2010 at 11:05 AM, Machiel Richards machi...@rdc.co.zawrote:
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
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
On Thu, Dec 2, 2010 at 10:06 AM, bars0 bars0 bars0.bars0.ba...@gmail.comwrote:
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
On Thu, Dec 2, 2010 at 4:05 PM, bars0 bars0 bars0.bars0.ba...@gmail.comwrote:
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
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, 2010 at 10:19 PM, Johan De Meersman vegiv...@tuxera.be
wrote:
No, I think it's a good idea to do INSERT
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 machi...@rdc.co.zawrote:
HI Guys
I found some info regarding a method to upgrade mysql databases.
Currently the
and compress data
into Archive Storage Engine or the insertion data into a partitioned table.
Best regards.
--
WB
2010/11/30 Johan De Meersman vegiv...@tuxera.be
I would assume that it's slower because it gets put on the delay thread
anyway, and thus executes only whenever that thread gets
with this you can also write a script to kill those process (mysql process)
which are in sleep mode for more than certain time..
hope this will helpful..
On Wed, Nov 24, 2010 at 6:41 PM, Johan De Meersman vegiv...@tuxera.be
wrote:
On Wed, Nov 24, 2010 at 1:13 PM, Nigel Wood nw...@plus.net wrote
401 - 500 of 809 matches
Mail list logo