… run their queries. Stored Procedures – How much memory can stored procedure allocate ? say can you create 1000 variables in stored procedure and set… As MySQL does not have much of resource utilization control you can simply run heavy queries to get MySQL Server barely functional. The…
Post: SQL Injection Questions Followup
July 26, 2012 By 2 Comments
… API function mysql_real_escape_string() is aware of binary bytes, and will escape appropriately. SQL also has a builtin QUOTE() function so you can do this in SQL expressions instead of in application code. See http://dev.mysql.com/doc… query, then you should be able to store such strings safely. Another risk of storing code-like strings in the database is…
Post: When should you store serialized objects in the database?
January 21, 2010 By 47 Comments
… post explaining how they changed from storing data in MySQL columns to serializing data and just storing it inside TEXT/BLOB columns. It… clear loss in functionality. You can no longer easily perform aggregation functions on the data (MIN, MAX, AVG). You are storing the data… a standard serialization technique like JSON it’s difficult to store pieces of data like numbers or IP addresses in their…
Post: MySQL Blob Compression performance benefits
January 11, 2008 By 17 Comments
… you’re storing text of significant size in the table it often makes sense to keep it compressed. Unfortunately MySQL does not… with with console MySQL tools. Some people get best of both worlds by taking COMPRESS/UNCOMPRESS functions from the MySQL code and having…. However it works great for many standard Web application needs – storing blog posts, product descriptions, forum posts (if they are generally…
Comment: When should you store serialized objects in the database?
January 22, 2010 By 47 Comments
… it.. 
To deal with indexes (and aggregate functions etc) we index (but not store) the documents in a Solr index. This provides…-text search, aggregate functions and a search engine that is easy to extend with plugins and let mysql store and replicate the data. For our specific use case this works excellent. We now store more than 100…
Post: Full Text Search Webinar Questions Followup
August 24, 2012 By 5 Comments
… by default, adding relevance sorting to the MySQL queries would make them even slower, I’m… Since RT indexes are in volatile memory, not stored on disk, you are responsible for integrating …, and has different requirements for the FT functionality. So one solution may include advanced features …
Post: Database problems in MySQL/PHP Applications
August 11, 2006 By 13 Comments
… feellings so I decided it is worth commenting: 1. Using mysql_* functions directly This is probably bad but I do not like… MySQLi in speed. It is however bad idea to use mysql_ functions directly as well – I would go for using mysqli object… DVD Store optimization, and I’m now on my own, offering MySQL and LAMP Consuilting Services. 2. Not using auto_increment functionality This…
Post: MySQL Slow query log in the table
May 31, 2007 By 1 Comment
… MySQL 5.1 get MySQL slow query log logged in mysql.slow_log table instead of the file as you…type which is used to store query execution time and lock time does not store fractions of the second. …the most. The other handly feature would be the function which returns as as SET list of tables which…
Post: Top 5 Wishes for MySQL
June 29, 2007 By 10 Comments
… used together with MySQL is Scale Out, but to say the truth MySQL does not provide much of the functionality for scale out… of being Solid. By by being Solid I mean Solid functionally complete features which work as uses intuitively expect them to… we do not get major regressions. I’m saying about Stored Procedures which were released without proper development and debugging support…
Post: Watch out for your CRON jobs
October 14, 2009 By 19 Comments
… can prevent it from starting again) or using GET_LOCK function in MySQL. The second one is good if you want to… server etc but information about cron errors should find you. Store Historical Run Times In a lot of cases when CRON… is done internally as you can store some other metrics as well. For example you can store something like script took 40…
