On 20/06/2012 11:45, Christian Koetteritzsch wrote:
Hi guys,
As the title says I'm trying to index 40 billion entries with two indexes on a
server with 16 cores and 128GB RAM. The table is the one below and it is a
myisam table. The *.myd file is about 640GB
Hiya
I am unable to help. But
+---+
| Variable_name | Value |
+---+---+
| Uptime| 18492 |
| Uptime_since_flush_status | 18492 |
+---+---+
> What is Apache's MaxClients?
MaxClients 1000
Thank you again.
Brent
>
>
> On 3/27/12 6
running Debian Squeeze 64bit.
I have attached the full crash message.
If anyone can help, I would be *most* grateful (If you are in South Africa,
I will buy you a meal, let alone a beer :)
Kindest Regards
Brent Clark
--
MySQL General Mailing List
For list arch
a, I
will buy you a meal, let alone a beer :)
Kindest Regards
Brent Clark
*** glibc detected *** /usr/sbin/mysqld: double free or corruption (!prev):
0x7f5e38003b60 ***
=== Backtrace: =
/lib/libc.so.6(+0x71bd6)[0x7f5e4575dbd6]
/lib/libc.so.6(cfree+0x6c)[0x7f5e4
[ERROR] 1 client is using or
hasn't closed the table properly
Would anyone know what is causing this, and how I can go about fixing it.
Do you think the problem could be on node 1?
Kind Regards
Brent Clark
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysq
Hiya
I was wondering. Is there anyway Mysql can be monitored for when you need to
run mysqladmin flush-hosts?
Kind Regards
Brent Clark
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
ative solution. I could reply, write better queries, but
somehow I dont think the client would be to happy with that.
Kind Regards
Brent Clark
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
y the developer.
Thank you again.
Brent
On 17/08/2011 15:42, Johnny Withers wrote:
Change the definer to one of your registered root accounts. Root@127
or root@localhost.
On Aug 17, 2011 8:39 AM, "Brent Clark" <mailto:brentgclarkl...@gmail.com>> wrote:
Hiya
Ill be up
ils are:
mysql> select user, host from user WHERE user = 'root';
+--+-+
| user | host|
+--+-+
| root | 127.0.0.1 |
| root | localhost |
+--+-+
If someone can share their opinion, thoughts or share the same concerns
it would be appreciated.
Kind Regards
Brent Clark
Hiya
I think I read somewhere that Mysql 5.5 is defaulting on Innodb as its
default storage engine.
The question I would like to ask is. For those still running Mysql 5.0 /
5.1. Have any of you set the mysql default variable to be / use Innodb?
Regards
Brent Clark
--
MySQL General Mailing
_files
Value: 300
1 row in set (0.00 sec)
Could the other option to look at be 'open_files_limit'?
The database is a mixture of innodb and Myiasm.
I really need to get replication working, if someone could help my
understand this issue, it would be appreciated.
Regards
Brent Cla
On 20/04/2011 10:10, Suresh Kuna wrote:
It will, try it out.
Thanks for replying.
My Colleague and I, we tried a different route.
We retried innodb_force_recovery.
But this time we started at 1 and progressed to 6.
At 6 we were able to able to start working.
So for our recovery procedure w
Sorry
Would you be so kind as to explain your thinking.
How would upgrading Mysql fix the issue?
Regards
Brent Clark
On 20/04/2011 06:23, Suresh Kuna wrote:
Install the latest version of mysql on top of the current version and
start the database.
On Tue, Apr 19, 2011 at 9:34 PM, Brent
Thanks for replying
5.1.55
On 19/04/2011 13:55, Suresh Kuna wrote:
What is the version of MYSQL you are using currently ?
On Tue, Apr 19, 2011 at 3:46 PM, Brent Clark
mailto:brentgclarkl...@gmail.com>> wrote:
Ive added
innodb_force_recovery=4
Still
Ive added
innodb_force_recovery=4
Still no go.
Original Message
Subject:Mysql issue / crashing
Date: Tue, 19 Apr 2011 12:15:30 +0200
From: Brent Clark
To: mysql@lists.mysql.com
Hiya
Im getting the following
I ran myisamchk --silent --force */*.MYI
But
Hiya
Im getting the following
I ran myisamchk --silent --force */*.MYI
But still I get the following.
I cant see how I can bring Mysql up.
# mysqld
110419 12:13:22 [Warning] 'for replication startup options' is
deprecated and will be removed in a future release. Please use ''CHANGE
MASTER''
Hiya
Im wondering if someone could help me understand this. If you look at my
two queries below. By the ORDER BY one is using ` and the other ', as a
result, if you do an explain you will see that the top query does a
filesort, while the other does not.
Would anyone know why.
mysql> explain
s
there a role back procedure, or can I just change the binlog format back
to STATEMENT.
If anyone can help me understand this, it would greatly be appreciated.
Kind Regards
Brent Clark
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscrib
Hiya
I just found that I can run
mysql db -e 'source exporteddbdata.sql'
The question I would like to ask is. Is there a speed difference between
mysql db < exporteddbdata.sql
and
mysql db -e 'source exporteddbdata.sql'
(using source)
Reason im asking is, I got a exported 5.4GB database file,
Lenny box?
If anyone could help / answer, it would be appreciated.
Kind Regards
Brent Clark
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
On 27/12/2010 19:14, Wagner Bianchi wrote:
*You have no guarantee the data on the slave matches the master 100%.*
*
*
Try it with *semi-synchronous* replication.
Best regards.
--
Wagner Bianchi
Hiya
Thats why you nagios monitor replication of your slaves (I do master
master replication moni
But the real reason is that the first clients machine is under heavy
load and we are trying to see what can be improved.
Kind Regards
Brent Clark
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
then the forums was up
to date again.
Has anyone seeing this type of issue with MySQL. I promise you that both
slaves are up and synced. I actually nagios monitor it.
If anyone could share some thought on MySQL's going on's or anything,
it would be appreciated.
Kind Regards
B
--database newdb /tmp/dump
My question is, is my logic and understanding correct, and would it be
ok to do it like this.
Kind Regards
Brent Clark
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
share some thought or opinion on this. Or whats the correct
practice.
Kind Regards
Brent Clark
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
s do you use to help debuging and testing.
Kind Regards
Brent Clark
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
BLE?
Kind Regards
Brent Clark
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
your reply.
Kind Regards
Brent Clark
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
ance under load.
If anyone can share their failures, successors or even just thoughts and
opinions on mysql-proxy (even SQL load balancing in general), I would be most
grateful.
Kind Regards
Brent Clark
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To
issue if you are actually
replaying those logs (ie. either for replication or for media recovery).
I think I was reading the MySQL 5.1 manual - so maybe this is different
with 5.0?
Kind Regards
Brent Clark
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysq
On 15/01/2010 11:54, Krishna Chandra Prajapati wrote:
Hi Brent,
I believe you missed log_slave_updates component on 2 and 1. You have
to enable binary logs + log_slave_updates on 2 and 1.
http://dev.mysql.com/doc/refman/5.1/en/replication-options-slave.html#option_mysqld_log-slave-updates
Th
Hiya
I have four servers.
1 < - > 2
||
4 5
I have master - master replication working flawlessly between server id
1 and 2.
Server id 4 is a slave of 1.
Server id 2 is a slave of 2.
For the slaves replications it works great, but ... I just realised ...
if I cr
On 17/12/2009 17:46, mos wrote:
"Load Data ..." is still going to be much faster.
Mike
Hiya
If you using on Linux and using LVM, look at mylvmbackup.
HTH
Brent Clark
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists
MySQL
database common files
ii mysql-server-5.0 5.0.51a-24+lenny1MySQL
database server binaries
ii php5-mysql 5.2.6.dfsg.1-1+lenny3MySQL
module for php5
Kind Regards
Brent Clark
--
MySQL General Mailing List
For list
sure 100% of their uselessness.
Cheers
Claudio Nanni
Thanks for your reply and feedback.
Regards
Brent Clark
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Hiya
I just inherited a project, and before I get started, Id like to do a
little clean up.
There a * load of unused and empty tables in the db. My question
is, does this in any way affect the performance of mysql in anyway and
if so how?
Kind Regards
Brent Clark
--
MySQL General
36 matches
Mail list logo
