Hello Steve,
To what list should I post with a post-installation config and startup
question?
This list, the MySQL General Mailing List, is the right place if the
question is about MySQL!
Cheers
--
Claudio
Hi Johan,
I wanted to love mysql-proxy for so many years, so I understand you :)
I have two main questions:
* am I remembering right that MySQL Proxy provides transparent failover ?
You need to use/create a lua failover script, I've never seen or tried one.
What kept me from investing too
Hi,
Can anybody explain me the difference between using index, using index
condition and using where in the EXTRA column information of EXPLAIN
query?
using index:
the columns selected are part of an index that is used to return the
results, there is no need then to read the full table record
Hi
| | ericomtxmacbookpro.local |
*E85DC00A0137C6171923BE35EDD809573FB3AB4F |
mysql DELETE FROM mysql.user WHERE user='';
mysql FLUSH PRIVILEGES;
maybe helps?
Cheers
--
Claudio
Hi Jopoy,
Try this:
SELECT username,sum(acctoutputoctets) AS total_usage FROM radacct WHERE
EXTRACT(YEAR_MONTH FROM acctstarttime) = EXTRACT(YEAR_MONTH FROM
CURRENT_DATE)and EXTRACT(YEAR_MONTH FROM acctstarttime)
EXTRACT(YEAR_MONTH FROM CURRENT_DATE + INTERVAL 1 MONTH) GROUP BY username
HAVING
Hi,
I wold expect this NOT to match.
This should be because the fields you are comparing are utf8_general_ci,
this collation groups characters in 'classes' so that all variants of what
are considered to belong to the same character type, are put in that class.
Equality comparison is done
Hi,
# mysql -P 5045
Add -h127.0.0.1
# mysql -P5045 -h127.0.0.1
Cheers
--
Claudio
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
Avoid FreeBSD,
Unless they did some real big magic on the scheduler of 9.
Claudio
On Jun 28, 2013 6:12 PM, Andy Wallace awall...@ihouseweb.com wrote:
Nope, it was locked on a single value for about 36 hours, until we
restarted the
engine last night. Now it's running fine, and we're setting up
Hi,
On 06/27/2013 08:19 PM, Andy Wallace wrote:
Benjamin -
Unfortunately:
mysql show global variables like 'timestamp';
+---++
| Variable_name | Value |
+---++
| timestamp | 1372238834 |
+---++
1 row in set (0.00
Hi,
I seem to understand this is the check on the innodb main tablespace.
Sounds like an overflow in munin check that builds the graph,
due to the type of check (MySQL InnoDB free tablespace) I would not
mind too much(There's no such critical thing like too much free space!),
apart from
Hi Nick,
It seems it is fixed already in MariaDB:
http://bugs.mysql.com/bug.php?id=68999
[9 Jun 9:34] Michael Widenius
This was fixed in MariaDB 5.5 in May 2013 as part of our merge of
MySQL 5.5 to MariaDB 5.5.
Cheers
Claudio
2013/6/9 Nick Edwards nick.z.edwa...@gmail.com
This was
Hi,
First of all I discourage you to use --processlist, I don't think it is
enough an accurate method to analyse queries.
You can dynamically enable the Slow Query Log with long_query_time=0 and
get a way better data.
Check the syntax for SET GLOBAL variables.
Remember to disable it afterwards.
Miguel,
Probably your non-root user is connecting as the anonymous account.
Try this:
Connect as your (problematic) non-root account and do this:
mysql SELECT USER();
mysql SELECT CURRENT_USER();
What do you see?
If it's as I imagine you should see different values and so just delete the
Hi Miguel,
I'm confused. Where should I issue those commands?
Yes from the MySQL Administrator.
From what you say it seems that you end up being authenticated as the
''@'localhost' user.
Connect again with the MySQL Administrator and the non-root account and
issue:
mysql SHOW GRANTS;
Hi Rafal,
I am trying to set the best value for innodb_buffer_pool_size. My system
has 6GB of ram.
My question: how to tell if my innodb_buffer_pool_size is ok?
If this is a MySQL dedicated server,
In your case I would set it to 2GB-3GB.
You will have the whole data in RAM now and for some time.
On 11/22/2012 04:10 PM, Ben Mildren wrote:
SELECT id FROM mytable WHERE type IN(x,y,z) GROUP BY id;
Ben you were almost there ;)
SELECT id FROM mytable WHERE type IN(x,y,z) GROUP BY id HAVING COUNT(id)=num of
params
The only bad is the hardcoded parameter in the HAVING, may be it might be
On 11/19/2012 10:27 AM, walter harms wrote:
hi List,
i get occasionally the following error:
ERROR 2013 (HY000): Lost connection to MySQL server at 'sending authentication
information', system error: 32
$ perror 32
OS error code 32: Broken pipe
Just to start.
If you want help you should
Hi,
If things are still as before,
you get MEM only if you have a support contract with Oracle,
so it would make more sense to ask Oracle.
They make that product, they know better how it works, they can help you
better, and you are entitled to get that help.
Consider that the users of the
Gary,
It is always a good practice to test the whole solution backup/restore.
So nothing is better than testing a restore, actually it should be a
periodic procedure.
As for the validity of the file usually is delegated to the operating
system.
If you want to check it yourself you may create an
http://www.percona.com/doc/percona-xtrabackup/
Cheers
Claudio
2012/10/23 Sabika M sabika.makhd...@gmail.com
hi!
I am trying to work with percona's extra backup. Has anyone found any
simple instructions how to install it? We are using innodb file per table
Thanks!
Sabika
--
Claudio
Take a look at TRIGGERS
C.
PS: I am curious to know why you would do that anyway
2012/10/17 W. D. w...@us-webmasters.com
When creating a record, the first field (KeyField)...
KeyFieldBIGINT UNSIGNED NOT NULL AUTO_INCREMENT
...is it possible to copy this auto-generated value into
Hi,
2012/10/4 Reindl Harald h.rei...@thelounge.net
Am 04.10.2012 17:28, schrieb Aastha:
I want to find the last time the given list of users logged in.
Is there any mysql table from where i can retrieve the data or any
specific sql
no - because this would mean a WRITE QUERY in the
Hi,
you might have hit: http://bugs.mysql.com/bug.php?id=58081
Cheers
Claudio
2012/7/5 Halász Sándor h...@tbbs.net
Here is something queer:
select ifnull(email, round(1 * rand(), 1)) as ux, count(*) from nam
group by ux;
ERROR 1062 (23000): Duplicate entry '2514.0' for key
+1
2012/6/30 Govinda govinda.webdnat...@gmail.com
That was nice of oracle to announce this wasn't it ...(/sarcasm)
I am not aligned with any side.. and I am also not
known/qualified/respected in this group enough to make much of a
statement... but:
IMHO, In almost all matters,
2012/6/13 Johan De Meersman vegiv...@tuxera.be
- Original Message -
From: Claudio Nanni claudio.na...@gmail.com
@Johan, you say I'm having trouble with clients aborting, but for
some reason they don't get logged.
Ah, it *did* start logging, now, and they come from multiple
Johan,
Print out warnings such as Aborted connection... to the error log.
the dots are not telling if they comprise Aborted clients as well.
I find the MySQL error log extremely poor, as far as I know it is one of
the MySQL features (like authentication) stuck to the dawn of MySQL times.
Very
Joey,
I can not afford any downtime and the data is realtime.
This is a very good reason for asking help to consultants.
If you ask What is the best method for this setup? master-master or
master-slave?
then the simple answer is master-slave, for any mysql setup, that is the
only safe mysql
Howard,
a client can be blacklisted, but in that case is Aborted connection to
be increased since the connection request is refused upfront.
@Johan, you say I'm having trouble with clients aborting, but for some
reason they don't get logged.
could you please tell which exactly is the
2012/6/8 Simon Walter si...@gikaku.com
On 06/08/2012 01:55 AM, Claudio Nanni wrote:
Hi,
you guys don't like the official API?
http://dev.mysql.com/**downloads/connector/c/http://dev.mysql.com/downloads/connector/c/
That's C isn't it? I think there is also a C++ connector. I'm
Hi,
you guys don't like the official API?
http://dev.mysql.com/downloads/connector/c/
Cheers
Claudio
2012/6/7 Lars Nilsson chamael...@gmail.com
On Thu, Jun 7, 2012 at 3:08 AM, Simon Walter si...@gikaku.com wrote:
On 06/07/2012 12:29 PM, Lars Nilsson wrote:
I've been happy using SQLAPI++
Joey,
from what I can see from your email you lack of a lot of basics and I
suggest you to read some documentation before proceeding.
Maatkit is now Percona Toolkit and contains some of the best tools for
MySQL.
Cheers
Claudio
2012/6/5 Joey L mjh2...@gmail.com
Hi -
I have setup mysql mult
PM, Claudio Nanni claudio.na...@gmail.com
wrote:
Joey,
from what I can see from your email you lack of a lot of basics and I
suggest you to read some documentation before proceeding.
Maatkit is now Percona Toolkit and contains some of the best tools for
MySQL.
Cheers
Welcome to Hopper!
Claudio
2012/5/25 Martijn Tonies m.ton...@upscene.com
Dear ladies and gentlemen,
Upscene Productions is happy to announce the launch of a new
database-developer tool:
Hopper (public beta 1)
Hopper is a Stored Routine Debugger, the first beta for MySQL
is now
Kishore,
No, as already explained, it is not possible, Innodb datafiles *never*
shrink.
Cheers
Claudio
On May 22, 2012 10:05 AM, Kishore Vaishnav kish...@railsfactory.org
wrote:
Hi,
I understand that if I set the innodb_file_per_table then once the table
is drop the datafile will also be
22, 2012 at 1:40 PM, Claudio Nanni claudio.na...@gmail.comwrote:
Kishore,
No, as already explained, it is not possible, Innodb datafiles *never*
shrink.
Cheers
Claudio
On May 22, 2012 10:05 AM, Kishore Vaishnav kish...@railsfactory.org
wrote:
Hi,
I understand that if I set
Jan,
that's not common wisdom, Innodb datafiles ***never*** shrink,
that in the blog from 22th of May is a workaround, one of the many.
If you ask my my favourite is to use a stand by instance and work on that.
Claudio
2012/5/22 Jan Steinman j...@bytesmiths.com
From: Claudio Nanni claudio.na
Manivannan,
There is no way to reduce the InnoDB main tablespace.
You can get rid (=regain disk space) of InnoDB tablespaces only if you have
innodb_file_per_table setting,
which allows you to get disk space back if you drop the table.
The best option you have to free your current shared
Hi Charles,
it is very easy to run multiple mysql instances and of different versions
as well on the same server, including windows.
You just have to download the .zip version, NOT the installer.
The archive you get is basically a separate independent mysql instance that
can live fully in its
In my experience if you have a poor designed code that run the same query
for hundreds or thousands of times in a very short timespan (like some
programmers do in for-loop instead of using a IN for example) you can put
mysql on its knees, in some cases it may be the practical implementation of
, and please anyone
correct me if I am wrong.
Claudio
2012/5/14 Andrés Tello mr.crip...@gmail.com
Claudio, would you please extend the example to the use of in?
On Mon, May 14, 2012 at 10:08 AM, Claudio Nanni
claudio.na...@gmail.comwrote:
In my experience if you have a poor designed code
Hello Andrés
did you notice that both transactions are trying to update records with
same *accountid='3235296' *
and that they lock the same index page? *space id 5806 page no 69100 n bits
176 index*
Cheers
Claudio
2012/5/11 Andrés Tello mr.crip...@gmail.com
Ok, so I had a deadlock...
But
would need to
wait to the first transaccion to finish...
That is why I'm confuse if I have a Deadlock o a wait lock...
That is why I'm
On Fri, May 11, 2012 at 1:36 PM, Claudio Nanni claudio.na...@gmail.comwrote:
Hello Andrés
did you notice that both transactions are trying to update records
Yes indeed,
but I think we are talking about MySQL level deadlocks,
that can happen only with row level locking and transactions.
If the deadlock is generated at application level then you can have it on
anything, also blackhole :-)
Claudio
2012/5/9 Johan De Meersman vegiv...@tuxera.be
-
This thread is going on and on and on and on,
does anyone have time to actually measure I/O?
Let's make numbers talk.
Claudio
2012/5/9 Rick James rja...@yahoo-inc.com
A BTree that is small enough to be cached in RAM can be quickly
maintained. Even the “block splits” are not too costly
.
** **
*From:* Claudio Nanni [mailto:claudio.na...@gmail.com]
*Sent:* Wednesday, May 09, 2012 8:34 AM
*To:* Rick James
*Cc:* Zhangzhigang; mysql@lists.mysql.com
*Subject:* Re: 回复： Why is creating indexes faster after inserting massive
data rows?
** **
This thread is going
Not really.
If its a deadlock , they all are victims. (E.g. mutex wait)
Or a long running query (sending data) might be the guy.
Claudio
On May 8, 2012 7:31 PM, Rick James rja...@yahoo-inc.com wrote:
Also,... If it happens again, do SHOW FULL PROCESSLIST while it is
happening. Usually the
Right,
Technically not a deadlock,
Practically yes if hundreds of threads are waiting on the same mutex,
Like key cache one or query cache or any other mutex.
Claudio
On May 8, 2012 7:51 PM, nixofortune nixofort...@gmail.com wrote:
Few more things. You can't have a deadlock on Mylsam table. You
Creating the index in one time is one macro-sort operation,
updating the index at every row is doing the operation on and on again.
If you do not understand the difference I recommend you to read some basics
about sorting algorithms,
very interesting read anyway.
Claudio
2012/5/7 Zhangzhigang
too nice not to share it!
http://www.youtube.com/watch?v=INHF_5RIxTE
2012/5/7 Zhangzhigang zzgang_2...@yahoo.com.cn
Thanks, i thought about this answer in the past, and i appreciate your
reply.
发件人： Alex Schaft al...@quicksoftware.co.za
收件人：
Thanks Baron!
Very much valuable! Looking forward for it!
Claudio
2012/5/4 Baron Schwartz ba...@xaprb.com
I'll present a free webinar today about troubleshooting intermittent
MySQL problems. These are often hard to pin down because they happen
when you're not looking, so you can't reliably
I recommend to use the 'wild' modifier, if you have a default db and you
specify the schema in the query like update
schemanotreplicated.mytable. you will miss that.
Claudio
2012/5/2 Rick James rja...@yahoo-inc.com
Yes, doable. In my.cnf on master:
Binlog-do-database = dbname1
be trademarks of their respective
owners.
** **
Type 'help;' or '\h' for help. Type '\c' to clear the current input
statement.
** **
mysql
** **
** **
** **
** **
*From:* Claudio Nanni [mailto:claudio.na...@gmail.com]
*Sent:* Saturday, April 28, 2012 2:48 PM
*To:* Brown
Cluster are they any more relevant.
** **
Best regards,
** **
** **
** **
*From:* Claudio Nanni [mailto:claudio.na...@gmail.com]
*Sent:* Sunday, April 29, 2012 4:29 AM
*To:* Brown, Charles
*Cc:* mysql@lists.mysql.com
*Subject:* Re: engine is now innoDB instead
Charles,
first, my opinion is that if you are paying Oracle you should get answers
from them about this, and then of course is good to have a second opinion
here.
Related to your specific question you should specify what you mean with
'clustering' which is a generic term,
if with it you mean
Hi Halasz,
This happens quite often.
It can be because more meaningful commands, or more compliant to the
standard are found,
or commands more consistent with the rest of the syntax.
for instance look at slow query log parameter change
Red carpet for you Using shared memory! last one was Monty while
developing MySQL 3.x!!!
Sorry Siva,
A bit of fun about MySQL on windows shared-memory protocol :)
I have no experience on Shared Memory protocol and as me I think 99.999% of
MySQL users.
I think it would be way more appropriate
Thanks Baron!
very much appreciated!
Claudio
2012/4/13 Baron Schwartz ba...@xaprb.com
If you were not at the Percona Live MySQL Conference over the last few
days, the keynote videos are recorded for your convenience. You can
see them at http://www.percona.tv/
Presentations will be posted
Hi
you have to see the reason in the mysql log file,
that is a file either in the datadir with .err extension or in the /var/log
directory.
tail the last 30 lines you will see the reason why it failed to start.
Claudio
2012/4/11 Prabhat Kumar aim.prab...@gmail.com
did you check permission of
And in europe we cannot watch all the american TV Series online :(
2012/4/11 Paul Vallee val...@pythian.com
If you own the code, you can license it under multiple licenses.
Kind of like if you own a TV Show, you can license it in the US under one
contract, and in other geographies under
+1
2012/4/9 Noel Butler noel.but...@ausics.net
**
People, most of you are/should be professionals.
It is about time your mail servers were configured to never send out of
office bullshit replies in response to mailing list messages.
I realise this is difficult here and is oracles fault for
Wes,
Thanks for these questions about this 'ghost' of the MySQL world, it seems
more a legend than a real thing!
I am sorry I do not have the answers but I would love to hear some.
All I can say is that MySQL Proxy is currently (still) in Alpha
http://dev.mysql.com/downloads/mysql-proxy/
Hi,
1. FLUSH PRIVILEGES is not needed, the SQL commands to manage user and
grants reload automatically the grant tables,
that was used in the very past when people use to tinker directly the grant
tables.
2. you did not specify the @ part of the 'someone' : GRANT ALL ON
somedb.* TO
you probably have the anonymous user account taking over: ''@'localhost'
when you specify the host with -h you are actually forcing MySQL to use
TCP/IP so it will authenticate you using your ip address (127.0.0.1)
login as root and:
mysql drop user ''@'localhost';
and try again
Cheers
If you want to verify it is very easy:
$ mysql --user=someone somedb (without -p)
mysql select user(); select current_user();
cheers
Claudio
2012/3/16 Claudio Nanni claudio.na...@gmail.com
you probably have the anonymous user account taking over: ''@'localhost'
when you specify
Hi Clemens,
my pleasure!
I forgot, you had to use also -P3306, so using both -h and -P which deny
the lookup for users at localhost,
forcing TCP-IP. and so IPs.
this is also good when the socket file is not in the standard location, you
will have the same problem logging in locally,
using -h
Gr!
Too far, too busy!
Good stuff!
Claudio
On Mar 15, 2012 2:52 AM, Baron Schwartz ba...@xaprb.com wrote:
If you want to go to this year's MySQL conference like all the cool
kids, now's your chance. Percona is giving away free tickets (and free
books)! Details here:
Matthew, Baron,
I am actually a bit confused,* what has the SELECT to do with the UPDATE?*
SELECT ProductSku, COUNT(ProductSku) _import_products FROM
_import_products GROUP BY ProductSku;
I think the problem is simply that you are using two relations (tables)
that are effectively the same and
Hi,
Nobody answers because this is a very wide question about software
engineering,
Trust me, It seems like a simple question but it is not.
The only advice I can give you is to try to imagine all possible
scenarios/use-cases before starting the design.
Cheers
Claudio
2012/2/20 Jan Steinman
Micheal,
I have the feeling that no one on this planet uses raw devices with mysql,
I might be wrong but I think InnoDB is kind of 'optimized' to leverage the
filesystem facilities,
but I would really like an InnoDB expert opinion here.
Claudio
2012/2/7 Michael Dykman mdyk...@gmail.com
In the
Tim,
are you designing a client/server application or a web based one?
Claudio
2012/1/18 Michael Dykman mdyk...@gmail.com
Mysql is a backend service and has no such application-level tools.
You can, however, use MS-Access (or any other such tool) and use MySL
as a backend via an ODBC
ask all this because your question is very vague and so the answer could
be anything,
Visual Basic, Jboss, Zend Studio, Adobe Flex just as an idea.
Cheers
Claudio
2012/1/19 Tim Johnson t...@akwebsoft.com
* Claudio Nanni claudio.na...@gmail.com [120118 14:15]:
Tim,
are you designing a client
I wouldn't recommend 'playing' with the grant tables instead use the
designated commands.
Anyway keep in mind that if you modify the grant tables manually you have
to force the reload of the privileges in memory by using the 'flush
privileges'.
Not needed if you use GRANT/REVOKE etc.
Cheers
Just adding an extra note to the already good Shawn response.
Theoretically this is just as any booking system that needs to be run in
transactions (db or not).
What you are doing is not trivial if that makes you feel better.
The problem is basically that the web interface is asynchronous so you
Hi Jan,
I am not sure to understand what your question is,
what do you mean with inserting updating 2-3 tables?
I guess treat the 3-tables join as one single 'object' ?
Since you have the referential integrity constraint on the [addresses]
and [phones] table you need to follow this basic
.
On 4 Jan 12, at 16:48, Claudio Nanni wrote:
Hi Jan,
I am not sure to understand what your question is,
what do you mean with inserting updating 2-3 tables?
I guess treat the 3-tables join as one single 'object' ?
Since you have the referential integrity constraint on the [addresses
INSERT IGNORE is 'the' SQL solution,
as you know and mention.
I dont know Rails but this is not MySQL / SQL / Database issue but more a
specific framework one so the solution depends on it.
You can also make some higher level programming workaround.
Claudio
On Jan 4, 2012 6:46 AM, KK Everest
my 0,02
I think I used standard path only the first installation of MySQL in 2002,
after that I always I had my custom way of installing it which lead me
to be able to have *any* number of instances of any independent
version.
After some years I saw Giuseppe Maxia's Sandbox which is a nice
yeah... I also don't understand why all these guys are bothering with
virtualization just use chroot
welcome to stone age if you think that everything has been done before ;)
2012/1/1 Johan De Meersman vegiv...@tuxera.be:
Reinventing chroots, then?
Welcome to 2012, when everything has
for
[cn] jumping to conclusion here?
hopefully your job has nothing to do with IT
Am 01.01.2012 22:12, schrieb Claudio Nanni:
yeah... I also don't understand why all these guys are bothering with
virtualization just use chroot
welcome to stone age if you think that everything has been done
Ryan,
My opinion here.
Any write to memory can go wrong,
OS , MySQL , Storage engines, client library and so on.
Innodb has some advanced mechanism for ACID compliance like the double
write buffer but these are mostly to assure durability. Memory failure
although not so frequent can still, in my
Hi Jim happy holidays to you!
actually you just need to add the --routines trigger
mysqldump --all-databases --*routines* fulldump.sql
with this you get all databases including the system one with privileges
(mysql), triggers is on by default, you enable routines with the flag --*
routines*
*
Handler_xxx status variables.
Does anyone know what engine this is? I can't seem to find any info via
google. If I could live with the choice of engine, I could make this work
with no extra programming at all.
Thanks,
Jim McNeely
On Dec 18, 2011, at 11:26 AM, Claudio Nanni wrote:
Only if you can
Only if you can change the application you could use INSERTON DUPLICATE
KEY UPDATE instead of REPLACE.
Check Peter's post here: http://kae.li/iiigi
Cheers
Claudio
2011/12/17 Jim McNeely j...@newcenturydata.com
Here is a fun one!
I have a set of tables that get populated and changed a
commands.
You cannot rely on the knowledge you have of the underlying implementation
which can change anytime , while the privileges command are standard.
*Cheers*
Claudio Nanni
DROP USER is the only SINGLE COMMAND
as long as you do not use table/column-privileges there are exactly
two relevant
Sure you can, and you should.
but in case you also update/delete rows from the first table you have to
set up trigger to log changes.
if you are lucky (only inserts) then its easier.
Cheers
Claudio
2011/12/1 Angela liu yyll2...@yahoo.com
Hi, folks:
I have a situation:
A large innodb
This is not to say that MySQL could not have more of the file management
features. For example, the ability to add or remove datafiles on the fly
and the
ability to detach tablespaces as collections of tables.
That's where MySQL(read InnoDB) got stuck actually, it never introduced a
Halasz,
Have you tried to 'browse' the information schema?
Whats in there?
Claudio
On Nov 25, 2011 6:20 PM, Halász Sándor h...@tbbs.net wrote:
The following always is the outcome of the command show create trigger:
mysql show create trigger memberchange;
ERROR 1602 (HY000): Corrupted TRG
Also,
since MySQL 5.1 MyISAM has an algorythm to detect if you are going to
delete a row without ever reading it,
so when you insert it, it will use the blackhole storage engine instead.
:O (NB: it is a joke)
Claudio
2011/11/23 Johan De Meersman vegiv...@tuxera.be
- Original Message
All the previous hints are correct.
I would also add: the arithmetic is only good for command line settings,
something like:
max_allowed_packet = 16*1024*1024
is not valid in the my.cnf
max_allowed_packet = 16M
is the way to go in the my.cnf
Cheers
Claudio
2011/11/3 Michael Dykman
, Claudio Nanni claudio.na...@gmail.comwrote:
All the previous hints are correct.
I would also add: the arithmetic is only good for command line settings,
something like:
max_allowed_packet = 16*1024*1024
is not valid in the my.cnf
max_allowed_packet = 16M
is the way to go in the my.cnf
Kay,
There's no way to regain InnoDB space.
I can suggest some techniques but no magic.
1. dump the whole database and reimport
2. setup a brand new slave ,sync and switch to it
Cheers
Claudio
2011/11/1 Rozeboom, Kay [DAS] kay.rozeb...@iowa.gov
We are running MySQL 5.0.77, and
Luis,
Very hard to tackle.
In my experience, excluding external(to mysql) bottlenecks, like hardware,
o.s. etc, 'suspects' are the shared resources 'guarded' by unique mutexes,
like on the query cache or key cache.
Since you do not use MySQL it cannot be the key cache. Since you use percona
the
mysql -utim
Then
mysql SELECT USER(),CURRENT_USER();
Login as root and:
delete from mysql.user where user='';
And try again with tim with password.
Thanks
Claudio
On Oct 19, 2011 7:47 AM, Johan De Meersman vegiv...@tuxera.be wrote:
Try not passing the password and typing it at the prompt. If
FLUSH PRIVILEGES is not needed when you use GRANT/REVOKE/CREATE USER
etc,
Usually this problem comes when you have the anonymous user in the grant
tables (''),
MySQL has a tricky way of processing the grant tables.
Sometimes you can be surprised by what you read issuing:
SELECT
2011/10/9 Reindl Harald h.rei...@thelounge.net
Am 09.10.2011 17:33, schrieb Peng Yu:
Hi,
I'm not able to connect to downloads.mysql.com. Is it down?
what stupid question?
if you have internet access, can open other websites and write
mails and you fail only to connect to one server
There is no difference.
It's just a marketing thing.
Enterprise is mainly Support + Enterprise monitor,
the source code is exactly the same, the binaries are just (as they say)
with more optimized compilation,
more often patches are released if you are an Enterprise subscriber.
The only extra
Hi,
Just quick reading your email, forgive me if I'm mistaken
what about serializing using *concat(old.f1,'|||',old.f2,'|||',old.f3)
('|||' = any separator that works for you)*
and deserialize inside the function?
does this make any sense to you?
Cheers
Claudio
2011/9/13 Chris Tate-Davies
You have 2 options: use tcp/ip or find the right .sock file
use this:
mysql -uUSER -p -h127.0.0.1 -P3306
or check in the my.cnf where the server creates the .sock file
you have to use the same with the local client.
Ciao Mad!
Claudio
2011/8/23 Andrew Moore eroomy...@gmail.com
That's too
Any mysql instance can replicate from any other as long as binary logging is
enabled on the designated master.
Two instances can replicate from one another yes, but precautions must be
taken especially in the case of active-active configuration.
Cheers,
Claudio
On Aug 3, 2011 7:19 AM, Jon Siebert
Hi Doug,
1.FILE is GLOBAL because it refers to the ability of the user to read/write
files on the server host filesystem (where the filesystem permissions
allow).
2.
1) user@localhost OK, not recommended
2) 'user@localhost' WRONG
3) 'user'@'localhost' OK, BEST
single quotes prevent any
1 - 100 of 320 matches
Mail list logo
