June 19, 2013

Post: How Web Services world affect LAMP Stack

…. Such requests are also might be treated with idle priority – batch processing often can be done during the night when real time… you might need only few “workers” – actively working web server processes, if you do not have to wait for slow clients… might want to cache data on Disk – in files or MySQL tables. There are multiple solutions available out where. In addition…

Comment: Should we proclaim MySQL Community Edition Dead ?

MySQL 5.0.51a and MySQL 5.0.51b security fixes were released …considered proper releases.’ Why? :) They went through the same process as every other binary package set that is released…interest in those features has to be our first priority (imho). Including patches that are potentially unstable or …

Post: Onsite and Remote - getting best of both worlds

…consulting visit is arranged it is usually the top priority for some of the staff members which …, implementation (writing queries), hands on setting up MySQL, Replication, Monitoring, High Availability with MMM or …has other tasks to do while such long processes are running. If you’re spending time …

Comment: Linux schedulers in tpcc like benchmark

…) only apply for data moved from logs to data file (MySQL can probably order this well already), and also because schedulers… no per request priorities yet as far as I know (not even per posix thread yet, but just per process, which indeed is way more pratical to use for PostgreSQL than it is for MySQL right now, but…

Post: Concurrent inserts on MyISAM and the binary log

… with SELECT statements; they were blocking and the process list was filling up with queries in Locked status… result in a different order of execution. The MySQL manual actually says this, but not in the … on the table like this: Locked – read Low priority read lock But on INSERT…SELECT, you’ll …

Post: Wishes for mysqldump

… you’ve got to load many tables which have different priority for your application. Safe Dump Dumping corrupted Innodb tables you… process. It would be great for load script to record in the logs such table was not dumped successfully, wait for MySQL

Post: Innodb Fuzzy checkpointing woes

…, and again in very short period of time so process repeats itself. There is one more related bug which … to constant.  However the shared drive at shared MySQL virtual hosting and powerful RAID system may have very … Real word use case reports are best way to boost priority of such performance bugs.