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
, 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)[0x7f5e4576294c]
/usr/sbin/mysqld
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 archives: http
|
+---+---+
| Uptime| 18492 |
| Uptime_since_flush_status | 18492 |
+---+---+
What is Apache's MaxClients?
MaxClients 1000
Thank you again.
Brent
On 3/27/12 6:25 AM, Brent Clark wrote:
Good day KarthiK.P.R
Other than
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/mysql
To unsubscribe:http
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
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
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
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 brentgclarkl...@gmail.com
mailto:brentgclarkl...@gmail.com wrote:
Hiya
Ill be up front my saying my knowledge of store
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
)
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 Clark
--
MySQL General Mailing List
For list archives: http
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
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
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
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 brentgclarkl...@gmail.com
To: mysql@lists.mysql.com
Hiya
Im getting the following
I ran myisamchk
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
brentgclarkl...@gmail.com mailto:brentgclarkl...@gmail.com wrote:
Ive added
innodb_force_recovery=4
Still
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
. Is
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 unsubscribe:http
the 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
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,
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
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
and 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
Brent Clark
--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
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
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
Check_time: 2010-02-21 05:17:27
Collation: latin1_swedish_ci
Checksum: NULL
Create_options:
Comment:
1 row in set (0.01 sec)
Question I would like to ask is, what is an acceptable threshhold or
amount of freespace before I must run OPTIMIZE TABLE?
Kind Regards
Brent
.
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 unsubscribe:http
for 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
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/mysql
To unsubscribe:http
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
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
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.com
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
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
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
36 matches
Mail list logo