Shlomi Noach

less info
stack exchange network profile network profile
2,040 reputation
211
bio website openark.org
location
age
visits member for 10 months
seen 17 hours ago
stats profile views 140

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


64 Answers

newest activity votes
10
How do I swap tables in MySQL?
9
Power went out - Did query finish?
5
Which MySQL storage engine is the most similar to ARCHIVE when that is not available?
5
mysql: Show GRANTs for all users
5
Can we back up mysql databases by copying files?
5
Cannot retrieve values from LEFT JOIN (2 tables)
4
How can I copy data from one MySQL server to another based on a SELECT statement (then delete the data from the original)?
4
Algorithmic order of table indexes for table operations
4
MySQL: Delete a record from all tables in one shot
4
How to make multiple counts in one query?
4
Are JOINs on non-indexed columns faster than sub-queries?
4
Show procedure code in MySQL
3
simple query is not using indexes
3
query_cache_type = 0 vs query_cache_type = 1
3
Using MyISAM for reading and InnoDB for writing data
3
Does MySQL have a limitation of one index per query?
3
which mysql version to use - 5.1 or 5.5?
3
Fetch the newest row grouped by a column in MySQL
3
What happens to existing MySQL databases when I upgrade my Ubuntu distro?
3
What should I set max_connections to for MySQL?
3
MySQL trigger - delete data from multiple tables
3
Why restoring a large sql file via SSH seems to quit partially through the process
3
Reset MySQL root password in LAMPP server on Ubuntu
3
why/how does the number of matched columns influences the way of excecuting a query
2
Large INSERTs performance optimization
2
mysql replication successful but slave not replicating
2
Is it okay to use rsync on InnoDB database if the MySQL server is shutdown?
2
Order by on an alphanumerical column
2
MySQL Index Fragmentation
2
How to change the replicate_*_table variable without modifying my.cnf?
1 2 3