Shlomi Noach

2,050 reputation

211

bio	website	openark.org
	location
	age
visits	member for	10 months
	seen	7 hours ago
stats	profile views	141

Software engineer, DBA & instructor. I develop mostly sever-side and backend, but also web apps and client side.

I'm a MySQL community member. I've won Oracle ACE, Oracle Technologist of the Year 2011 & MySQL Community Member of the Year 2009 awards.

Author of common_schema , openark-kit and mycheckpoint open source tools.

I blog at openark.org

	2,050 reputation	bio	website	openark.org	visits	member for	10 months
211 badges		location			seen	7 hours ago

summary answers questions tags badges favorites bounties reputation activity

154 Actions

suggestions reviews revisions comments badges posts accepts all

14h	comment	MySQL binary log failed to generate a new one When you say "cannot", do you mean you get an error message (in the error log?) or do you just see that it "does not"? I would next check for path permissions (probably on "/var/log/mysql")
1d	comment	Large INSERTs performance optimization number 2) sound like an anti-optimization to me. And how do you mean you've dropped all indexes while writing? Do you mean you're `ALTER`ing the table before and after the `INSERT`? If so - don't do it.
2d	comment	mysql replication successful but slave not replicating 2-no ?? Weirder by the minute. I'm very unsure that your slave is actually connected to the right master.
2d	answered	Large INSERTs performance optimization
May 13	comment	Large INSERTs performance optimization Please present the `SHOW CREATE TABLE your_table` output. In particular, is there an `AUTO_INCREMENT` column? Which `PRIMARY KEY`? What is the order by which rows are inserted?
May 13	answered	mysql replication successful but slave not replicating
May 13	comment	mysql replication successful but slave not replicating Do not follow advice in this answer, as you don't need to tell database which schema to replicate (defaults to all schemas), and this would very possibly break your replication, and most probably not what you are looking for. You want (99.999%) to replicate all schemas.
May 7	answered	Is it okay to use rsync on InnoDB database if the MySQL server is shutdown?
Apr 18	comment	MySQL statement-based replication and stored procedure So in the case of a function that modifies data, what replicates is the CALL to the function, not the function itself. But if same function does not modify data, then the CALL does not replicate.
Apr 18	comment	MySQL statement-based replication and stored procedure Sorry, that wasn't a quote. This is the quote: "Stored functions that change data are logged as function invocations, not as the DML events that occur inside each function.".
Apr 18	comment	MySQL statement-based replication and stored procedure +1, but as the docs say, for stored functions there COULD be a `call`.
Apr 18	answered	What data type should I use: ENUM, TINYINT, or CHAR?
Apr 17	answered	Order by on an alphanumerical column
Apr 17	answered	MySQL and window functions
Apr 15	comment	do MYSQL views occupy physical space? +1, but wish to stress on the `TEMPTABLE` algorithm: yes, when using `TEMPTABLE` you will temporarily consume space (memory or disk); but this does not take up on "view space", but rather on "query space", or, to be more specific, connection memory. So this memory has to do with number and type of queries rather than number or type of views.
Apr 15	comment	How can I search for a name in two columns in MySQL? Please present data from your table
Feb 18	answered	simple query is not using indexes
Feb 12	comment	In Mysql 5.5, why is the upper bound of a character range not inclusive? ypercube's comment is worth repeating: just think how it would look like in a dictionary. This really answers your initial question.
Feb 11	comment	MySQL Index Fragmentation Yes, you are correct. I should have noticed that.
Feb 11	comment	mysql fine tuning: open_tables, opened_tables The calculator is not realistic. It assumes all buffers are always allocated - which is not the case.